SUMMARY:

• 6+ years of DW - BI experience, spanning across ETL/Data Integration/DWH (Data warehouse) development, designing, analysis, performance tuning, production support, data analysis & team lead.
• Have considerable experience across testing/QA, post production support etc.
• Technical experience extents across complete SDLC cycle (Development, Testing/QA, DevOps (requirement gathering, business testing, performance tuning) Production Support, deployments/releases, data analysis, conducting DR Exercise etc.
• Roles primarily involved in development teams on ETL design, performance tuning and optimization, analysis. Have also lead efforts to set up the production environment & train the team for Informatica PowerCenter ETL tool with technical expertise for the support.
• Have considerable experience with multiple databases & in writing complex SQL/queries for ETL code, business testing, Data Analyses, user support etc.
• I also have considerable experience with Defect management experience for the complete project.
• My understanding of business in large ICM (Incentive compensation management), telecom, utilities and banking, combined with my technical skills allows me to be a strong link that can efficiently convert business needs to efficient technical solutions.
• Having the knowledge of Informatica Power Centre multiple versions, I am skilled at troubleshooting various problems occurring in various phases (Design, build etc.).

TECHNICAL SKILLS:

• Informatica PowerCenter 8.5/9.1/9.6, Ab-Initio
• Teradata, DB2, Oracle 10g, Oracle 11i, SQL Server 2008, SQL Server 2012
• NETEZZA, Exadata
• LINUX, Shell scripting, Testing, HP-Quality Centre, QTP
• ITSM BMC remedy tool (Incident/User request handling), ITOS Geneos monitoring tool, JIRA
• ESP/CA workload automation (CA WA), Autosys, Flow manager.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Informatica PowerCenter 9.6 support/setup/lead/ team

Responsibilities:

• Leading the environment set up for support team & data integration efforts, covering set up of new LINUX box, Informatica tool, connection between the upstream/downstream servers, existing SAS and new Informatica servers etc. while working with multiple required teams. the current team on Informatica power center ETL tool in understanding the failure logs, debugging the mappings etc.
• Coordinating/executing the DR Failover exercise by coordinating with multiple teams.
• Root cause analysis of any issues with ongoing ETL processes and suggesting solutions to fix them.
• The current team is providing L2 level of support. I have been working on the initiation to move the support level to L3 by bringing in more details analysis on the failures and analyzing & understanding the data.
• I have also been doing the production support role for the same team during which we monitor & analyze any failures and analyze any requests from the users.

Environment: Data warehousing, Data Integration, Informatica PowerCenter 9.6, Netezza, Exadata, Oracle, LINUX, DR Exercise.

Confidential, Charlotte, NC

Informatica PowerCenter 9.5/9.6 Developer/Team lead/DevOps

Responsibilities:

• To monitor different applications that run in production.
• Especially the critical jobs.
• To Investigate and resolve any issues encountered during the jobs running in production.
• To handle the outages so that they don't impact the data in production.
• To automate the manual tasks existing at any point of time.
• Root cause analysis for the errors encountered during Job executions.
• I have been also handling user tickets which require updating the database.
• Performance Improvement of ETLs using advance Informatica concepts.
• Participate in deployment activities of various projects.
• Creation of ESP jobs/applications and writing java scripts for them.
• Creation of ticket categorization reports for onshore & offshore teams utilized by managers.
• Enhancement of the existing code and working out on business testing of the same.
• Running Business prioritization for all open issues & delegating the work items accordingly to my off-shore team.
• Data analyst responsibilities involved working closely with the Data stewards to analyze the data & identifying issues in the data. Tracking back the issues from Data as well as ETL perspective to troubleshoot the root cause of the data & then proposing the possible solution & applying the same after finalization.
• Business prioritizing meetings to prioritize the open work items and fixing (developing, testing, business testing & deploying) them on a monthly basis.

Environment: Data warehousing, Data Integration/ETL, Data Analyst, Informatica PowerCenter 9.6, DB2, Oracle 10/11i, SQL Server 2008, SQL Server 2012, Informatica performance tuning/parallelism, ESP/CA WA (Scheduling tool), ITSM/PICASSO (Ticketing system).

Confidential

Responsibilities:

• Working in Utilities domain for a US based client.
• Processing of IVR and CRD data to the datamart.
• Role included system analysis, convert business rules into technical framework.
• Technical, functional documentation, code design, development and deployment.
• Performance optimization, migration to production, and limited post-production support.
• Co-ordinated with the client site team on a daily basis for day-to-day work transitions.
• Defect solving activity by coordinating with business for all the source systems.

Environment: Data warehousing, Data Integration/ETL, Informatica PowerCenter 9.6, Oracle 10g, Informatica performance tuning/parallelism.

Confidential

Responsibilities:

• New business rules are to be incorporated in the system as well.
• Role included impact analysis, code changes, unit testing the changes and their impacts.
• Technical, functional documentation, code design, development and deployment.
• Daily reporting to client site team for the completion of codes/modules/resolution of issues.

Environment: Data warehousing, Data Integration/ETL, Informatica PowerCenter 9.6, DB2, SQL Server 2008, Informatica performance tuning/parallelism.

Confidential

AbInitio/Teradata Tester

Responsibilities:

• Understanding Confidential ’s business including each of the front-end systems which form the source to subsequent ETL processing.
• Understanding end to end Confidential ETL and reporting architecture, data-warehouse, and data models.
• This includes pre-paid, post-paid and enterprise Confidential customers.
• Working individually on testing multiple modules individually. For ex: commissions, service charges, usage charges, downstream systems etc.
• Defect management for the team using HP-QC.
• Shell script creation to automate the mandatory processes. and mentoring 3 resources newly consigned for DW-BI testing.

Environment: Data warehousing, Data Integration/ETL, Database Testing/QA, Teradata, LINUX, AbInitio, ETL Testing/QA, defect management.

Confidential

Responsibilities:

• Understanding legacy systems and the new systems.
• Understanding end to end data flow in the backend systems.
• This includes pre-paid, post-paid and enterprise Confidential customers.
• Test scenario/cases/script creation and testing of the individual systems.
• Working individually on testing and test preparation of multiple front end systems.
• Defect management for the team using HP-QC

Environment: Client specific CRM tools, HP-QC, Application testing/QA.

Confidential

Responsibilities:

• Understanding Confidential ’s business including front-end systems to understand the availability of various recharging options.
• Team of 2 resources to test this functionality downright.
• Working individually on test preparation and testing for the project.
• Running automated test scripts using QTP.
• Defect management for the team using HP-QC.

Environment: Client specific CRM tools, HP-QC, Application testing/QA.