Mar 2018 – Jun 2022 · 4 yrs 3 mos · Chennai, Tamil Nadu, India

Jan 2016 – May 2018 · 2 yrs 4 mos · Chennai, Tamil Nadu, India

Apr 2007 – Jun 2015 · 8 yrs 2 mos

• As a Business Intelligence Analyst I am involved in designing/enhancing ETL(Extract ,Transform,Load) and reporting analytics processes .

Oct 2013 – Jan 2015 · 1 yr 3 mos · United States

• CRM Email Marketing
• The scope of the project is to design and develop ETL processes to load the web analytics data into the CRM database.
• Gathered business requirements and provided support to business users on ad-hoc requests
• Did data analysis and designed the code as per the standards and strategies supported by client
• Project Environment: Oracle 10g, Unix , Informatica 9.1 , StrongMail, HIVE,HBASE, Teratdata, Netezza

Jul 2013 – Sep 2013 · 2 mos · United States

• Walmart.com is a subsidiary of Wal-Mart Stores, Inc. which is a leading retailer in USA.
• CRM Email Marketing
• As a part of CRM email Marketing “Demand Generation Team” we are responsible for maintaining the processes that feeds data for “StrongMail” and “Aprimo” applications. The scope of this project is to fulfill the ad hoc request of business users by analysing and implementing their change requests in the production system.
• Understanding the business requirements and providing support to business on Ad hoc requests
• Did data analysis and designed the code as per the standards and strategies supported by client
• Modified the existing code as per the business users request
• Project Environment: Oracle 10g, Unix , Informatica 9.1 , StrongMail

May 2013 – Jun 2013 · 1 mo · Chennai Area, India

• Informatica PowerCenter Repository Maintenance
• The scope of the project was to design and implement processes to automate Informatica power center Repository maintenance activities.
• Project Environment: Informatica PowerCenter 8/9 , MS SQL, UNIX

Sep 2012 – Feb 2013 · 5 mos

• Walmart.com is a subsidiary of Wal-Mart Stores, Inc. which is a leading retailer in USA.
• CRM Email Marketing
• As a part of CRM email Marketing “Demand Generation Team” we are responsible for maintaining the processes that feeds data for “StrongMail” and “Aprimo” applications. The scope of this project is to fulfill the ad hoc request of business users by analysing and implementing their change requests in the production system.
• Understanding the business requirements and providing support to business on Ad hoc requests
• Did data analysis and designed the code as per the standards and strategies supported by client
• Modified the existing code as per the business users request
• Project Environment: Oracle 10g, Unix , Informatica 9.1 , StrongMail , Aprimo

Feb 2012 – Aug 2012 · 6 mos

• The scope of this project is to monitor the production system and provide instant support to business users. As CPE executives, we need to work on enhancements on the production system fix any bugs on the current system and work on the process improvement plans.
• Understanding the business requirements and providing support to business on Ad hoc requests
• analyzing the data and designing the code as per the standards and strategies supported by client
• Creating process improvement plans and strategies to enhance the production system
• Automation of processes to expedite ticket resolution and Ad hoc requests
• Modified the existing code as per the change in business and users request
• Coordinating and communicating with the client regarding issues/questions/escalations
• Project Environment: Oracle 10g, Unix,Netezza,Informatica 9.1, IBM Product center 5.3.2, Netezza 4.1, Oracle PL/SQL

May 2010 – Jan 2012 · 1 yr 8 mos · Chennai Area, India

• Quarterly Enhancements
• . The scope of the project is to analyze and implement the ETL and reporting enhancements on a quarterly basis.
• Analysis and Preparation of Technical Design Documents
• Creating new ETL objects, modified BO universes ,reports
• Have Developed Stored Procedure for different ad hoc request
• Tested and deployed in the production environment
• Project Environment: BusinessObjects 6.5.1/XI, Informatica 7.1/8/9 Power Center, Oracle 9i

May 2010 – Aug 2010 · 3 mos · Chennai Area, India

• ITSC BO Customer Service
• The scope of this project was to convert the Clarify source system’s full load into incremental load and to modify Business Object’s universes to use the confirmed dimension.
• Migrated Customer service ETL jobs from Informatica 7.1 to Informatica 8.5
• Tested and validated the migrated jobs in informatica 8.5 .
• Fixed and escalated issues
• Documented the procedures and issues
• Modified BO universes, tested and validated it
• Tested reports
• Project Environment: BusinessObjects 6.5.1/XI, Informatica 7.1/8/9 Power Center, Oracle 9i

Dec 2009 – Apr 2010 · 4 mos · Chennai Area, India

• The scope of this project was to support and maintain the daily data load routines of the ETL data marts like Bookings Backlog Shipments (BBS), Customer Service, Revenue, Point of Sales (POSCI), Sales Achievement, Sales Forecast and License Management. Publisher report handling and scheduling are handled on the reporting end.
• Developed reports based on the requirements gathered from business users
• Monitored daily load and handled data issues
• Published new reports and monitored publisher
• Provided support for revenue reports during quarter ends
• Involved in BO server maintenance, maintained the service tickets with in the SLA and Interacted with source team in case of any data issues or enhancement requests
• Actively worked with Business Object Corporation for BO product related issues
• Handled universe level changes for adding new objects and Modified the existing objects
• Handled Data issues notified by the client and worked on fixing them
• Regularly coordinated with client and onsite team
• Project Environment: BusinessObjects 6.5.1, Informatica 7.1, Oracle 9i

Oct 2009 – Nov 2009 · 1 mo · Chennai Area, India

• A system that the Domestic Home Entertainment Sales team utilizes to manage and track promotions, perform sales and account planning, and manage trade funds. The Target audience includes DHE Marketing, DHE Sales and DHE Finance. The Major functionalities includes: Promotion Planning, Sales Planning and Projections, Account Planning and Trade Fund Management.
• Gathered requirement from client and business logic discussion with client
• Analyzed source data
• Created ETL Jobs
• Handled issues while loading data into the warehouse
• Quality analysis and testing
• Documented testing results, issues and procedures
• Project Environment: Oracle 9i, Informatica 8.5, Toad

Nov 2008 – Jan 2009 · 2 mos

• DW2, VMI and E1 Migration
• ETL developer November 2008 – June 2009
• The scope of the project was to migrate ETL jobs and associated scripts from Informatica 7.1 to Informatica 8.5.
• Migrated ETL jobs from Informatica 7.1 to Informatica 8.5
• Ensured the Data quality
• Quality analysis and tested ETL jobs, shell scripts and VB scripts
• Fixed and escalated issues
• Documented the procedures and issues
• Project Environment: Oracle 9i, Informatica 7.1.2/8.5, Informatica 8.6, UNIX Shell

Jun 2008 – Jun 2009 · 1 yr

• The Scope of the project is to support and enhance Enterprise1, Dw2 , VMI systems.
• Enterprise 1 - Software used across multiple Fox International Theatrical and Home Entertainment locations. This application is used to capture Finance and Accounting information across these territories.
• The Data Warehouse 2 (DW2) - DW2 is a decision support system that utilizes Microstrategy to provide international territories with solutions to their reporting needs.
• Vendor Managed Inventory (VMI) - VMI is an application that allows Fox to control the volume of stock and frequency of delivery that each VMI store receives based on Point of Sale (POS) and allocated shelf space within each VMI store.
• Ensured data loads are completed in time with out any issues
• Handled issues while loading data in data warehouse
• Business logic discussion with clients
• Adhoc ETL process enhancements
• Project Environment: Oracle 9i, Informatica 7.1.2/8.5, UNIX Shell

Apr 2008 – Jun 2009 · 1 yr 2 mos

• Twentieth Century Fox Film Corporation, also known as 20th Century Fox, or simply Fox, is one of the six major American film studios. . Category Management is a system that Fox’s Domestic Home Entertainment and the retailer utilize to collect data, report and analyze category data from various sources. The scope of the project was to support Category Management system.
• Roles and Responsibilities
• Ensured data loads are completed in time with out any issues
• Handled issues while loading data in data warehouse
• Business logic discussion with Clients
• Adhoc ETL process enhancements
• Project Environment: Informatica 7.2, Teradata, SQL Server, UNIX

Feb 2008 – Mar 2008 · 1 mo · India

• Juniper Networks, California, is a market leader in the business of manufacturing and delivering best-in-class Networking and Security products .
• The scope of this project was to support and maintain the daily data load routines of the ETL data marts like Bookings Backlog Shipments (BBS), Customer Service, Revenue, Point of Sales (POSCI), Sales Achievement, Sales Forecast and License Management. Publisher report handling and scheduling are handled on the reporting end.
• Fixed BusinessObjects related issues
• Monitored the BusinessObjects Reports
• Requirement gathering from the client
• Adhoc report enhancements
• Published and scheduled the Reports
• Fixed data issues
• Project Environment: BusinessObjects 6.5.1, Informatica 7.1, Oracle 9i

Dec 2007 – Dec 2007 · 0 mo · India

• BMHC (Building Material Holding Corporation) is a holding company providing capital, management and administrative resources to its subsidiaries, BMC West Corporation and Select Build Construction, Inc.
• This scope of the project was to develop ETL jobs to load the specific tables related to HR analytics.
• Requirement gathering from client
• Data analysis
• Business logic discussion with clients
• Created ETL Jobs
• Documented testing results, issues, procedures
• Handled issues while loading data in data warehouse
• Quality analysis and testing
• Project Environment: Informatica 7.2, Oracle 9i