SUMMARY

• 10+ years’ experience in Data warehousing space using Informatica 7x/8x/9.x/10.x and ETL Concepts.
• Acquired and developed skills in Requirement Analysis, Design, Coding and Testing of various software applications in Informatica.
• Handled project specific s for the new Joiners in the project.
• Having worked with different clients and various teams has helped me to effectively handle critical situations with ease.
• Ability to learn new technologies with ease, implement and deliver projects efficiently.
• Quick learner and creative problem - solver.
• Solid ETL database programming and database reporting experience and Enterprise Data Warehouse environment
• Must also have significant experience using Informatica and Confidential and a strong knowledge
• Experience with all phases of SDLC and in implementing, staging, operation data stores and dimensional data modeling preferred.
• Experience researching and staying informed of industry technical/ business information security requirements and translating those requirements to the Banks information environment.
• Make recommendations and maintain appropriate working relationships with vendors ensuring access to support, product maintenance and software updates
• Document all areas of the systems, including which clients are accessing which applications, databases and system security design
• Work with the business continuity staff to create and update system disaster avoidance and recovery plans
• Strengths include ability in meeting deadlines and deliverables while achieving excellence and quality of work.
• Used Workflow manager to create and configure workflow and session task to load data; used Informatica workflow monitor to create, monitor workflow in case of process failures; performed testing as per UTC
• Implemented optimization techniques for performance tuning and wrote pre-& post session shell scripts
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance
• Involved in extensive performance tuning by determining bottlenecks in sources, mappings and sessions
• Possess strong problem-solving skills developed through variety of projects Expertise in creating Reports using SSRS.
• Experienced in interacting with customer and provide support as needed.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• 24 x 7 Production Database on Call Support.

TECHNICAL SKILLS

Methodologies: Agile, Waterfall,SDLC

RDBMS: Confidential, Server 2000/2005/2008/2008 R2/2012, Confidential Access,SOQL

ETL Tools: Informatica 8.x,9.x,10.x,Server Integration Services (SSIS) 2005/2008,Metal, Informatica MDM/IDQ,Pantheon

Reporting Tools: Server Reporting Services (SSRS) 2005/2008, Tableau

Database Tools: Server Management Studio(SSMS), Confidential Server, Query Analyzer, Workbench,NOSQL,BQ

Processing Modeling: ERWIN, MS Visio

Business Analysis: Business Requirements, Process Mapping, Root Cause Analysis, Toad

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003/2008/2008 R2, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate, Unix

PROFESSIONAL EXPERIENCE

Confidential, San Jose, USA

Responsibilities:

• Perform analysis of existing code for different source files(xml,FF) using ETL tools like Pantheon
• Understand the mapping logic's and business requirement, integrating external or new data-sets into existing data pipelines.
• Performing system analysis techniques, testing, debugging, design, and storage and understanding application development methodologies to support for different application modules in projects.
• Analyze current state of Corp Master Data pipelines and Creating visualizations and dashboards to help the company interpret and make decisions with the data.
• Track the pipelines transferring from MDS to the domain owners, continuously monitoring and testing the system to ensure optimized performance.
• Presenting the results of a technical analysis to business clients or internal teams and Optimize pipelines by eliminate deprecated logic's and sources.
• Analyzes performance metrics to evaluate user community adoption of tools and processes,
• Develop and deploy corrective action plans, monitor performance.
• Consistently communicates progress, obstacles, and growth opportunities to the stakeholders (development team, product team), and management team.
• Escalations Analyzed database, stored procedure, BQ, NOSQL queries using plx tool for optimizations and recommended enhancements

Environment: Pantheon, NOSQl, BQ, Tableau, Clarinet, UNIX, Data studio,PLX,Qualtrics

Systems Specialist II

Confidential, SFO, USA

Responsibilities:

• Perform analysis of existing code for different source file using ETL tools like Informatica to
• Understand the mapping logics and business requirement
• Performing system analysis techniques, testing, debugging, design, and storage and understanding application development methodologies to support for different application modules in projects.
• Debug the sessions by utilizing the logs of the sessions, Conducts run list reviews, code deployments and post deploy validations following standard software development lifecycle (SDLC)
• Tracking the ticket using the tracker toll using support force with GUS
• Involved in identifying the bugs in SOQL Queries using work Bench Tool to find out the RCA for Confidential data.
• Analyzed database, stored procedure, and SQLqueries for optimizations and recommended enhancements

Environment: Informatica 10.x Confidential, SQL developer, Workbench, Support Force, Tidal, UNIX, Winscp,BO, Wave analytics

Confidential, San Ramon, USA

Responsibilities:

• Perform analysis of existing code in mainframes or in ETL tools like Informatica to understand the mapping logics
• Developing the mapping documents including System of Record field names, Mapping Rules and W Target field names.
• Perform analysis of the existing data to understand the mapping rules in the current environment
• Discussion of the mapping document with Architects and mapping team to appropriately map ‘The elements to the Banking Data Warehousing (BDW) Model.
• Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
• Reviewing the BDW mapping document to produce the same data in new environment as in current W.
• Transmission of the System of Record files from UNIX to new environment.
• Coding in new environment as per the mapping documents.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Validation of the test cases using Quality Center tool of Bank.
• Defect tracking through Quality Center and SharePoint portal.

Environment: Informatica 9.x Confidential, SQL developer, Jira

Confidential, Minneapolis, USA

Responsibilities:

• Involved in preparing Technical Requirements Document, High Level Design document and Technical Design document.
• Complete Ownership of the application Project Accounting Data Ware House System.
• Participated in Deployment by adding objects into deployment group and moving the code from test to production.
• Deployment of Sources, targets, mappings, sessions and workflows and participated in deployment, to build efficient ETL components to meet the technical requirements.
• Ensuring smooth running of the application and facilitating improvisation as and when required.
• Monitor the changes carried out in the application as part of maintenance Confidential coordinating and Interacting with the offshore team and resolving the issues.
• Responsible for handling the ticket raised by business user and to provide root cause and fix the issue with in time line.
• Attended weekly status meetings and provide detailed status report to the client.
• Perform unit testing at various levels of the ETL.
• Debug the sessions by utilizing the logs of the sessions.
• Involved in writing Stored Procedures and Functions to handle database automation tasks
• Analyzed database, stored procedure, and TSQL queries for optimizations and recommended enhancements
• Created procedures, functions, sequences, constraints and triggers to maintain data integrity. Applied indexes and partitions to improve performance. Created views for monitoring and reporting.
• Designed source to target mapping strategy and performed ETL to populate databases from existing dispirit data sources (text, Excel, Access etc).
• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: Informatica 9.x Confidential, SQL Server/2008R2/2012, CA Automation tool, Clear Quest

Confidential

Technical Lead

Responsibilities:

• Reporting the consolidated daily/weekly status to the PM
• Participated in the development of new systems and upgrades and updates to existing systems, throughout the entire application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
• Generated the Reports Weekly or Monthly wise as per the Client
• Tickets committed within the SLA period without any disputes.
• Understanding the application data & business requirement.
• Responsible for developing ETL mappings to load data using Informatica Power Center 9.x
• Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and in Confidential all business requirements into all design specifications.
• Define and capture metadata and rules associated with ETL processes
• Adapt ETL processes to accommodate changes in source systems and new business user requirements
• Provide support and maintenance on ETL processes and documentation
• Involve in all Unix System Production Support by trouble shooting customers urgent requests.
• Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.
• Understanding data requirements for test and development
• Successfully improved the performance on our application through index analysis, removing unused indexes and analyzing stored procedures, functions and SQL scripts.
• One of the stored procedure tuning efforts resulted in a 2 minute duration to a few milliseconds
• Maintained database environment security for development, test and pre-production environments
• Involved in Peer review activities for Code & Testing.
• Finding the Root causes of the bugs raised
• Optimized performance by tuning the Informatica ETL code.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Used debugger to test the data flow and fix the code.
• Supporting the on call support on Quarter end and production release management deeds
• Respond to trouble shoot tickets assigned to me and fix any database issues promptly.

Environment: Informatica, SAP BO, Confidential, UNIX, Tableau,putty,winscp

Confidential

Technical Lead

Responsibilities:

• Designing, coding, benchmark testing, debugging, and documenting application features and changes
• Reviewing and assessing existing enterprise applications, to support new features, performance improvements, upgrades, and ongoing sustainment
• Proficiency with modern development toolsets including Visual Studio, SQL Server Management Studio, unit testing frameworks, source control, and task tracking such as Team Foundation Server
• Experience designing, implementing, supporting, and analyzing enterprise scale applications that perform extract/transform/load (ETL) operations with external data sources and SQL Server
• Developed and optimized SQL to implement ETL job steps using ETL tools such as Informatica, SSIS, or Metal
• Monitor, diagnose and repair all data loading and processing packages to ensure data integrity of the analysis data and also Designing & implement ETL requirements
• Involved in Peer review activities for Code & Testing, Deployment
• Reporting bugs in the Bug Tracker tool (VSTF) and following up with Business and resolving the issues by conducting meetings.
• Analyzed the performance, tuned and optimized, supported database objects to migrate to production level, executed stored procedures, index sizing
• Configured the necessary table structures in the database to collect and normalize business data
• Resolved known issues and bugs in the Confidential platform interface and back end database
• Programmed user Defined Functions, Views and TSQL Scripting for complex business logic.
• Finding the Root causes of the bugs raised
• Reporting the consolidated daily/weekly status to the PM
• Expertise in generating reports like drill down, drill through reports, parameterized reports, sub reports and different types chart reports in SSRS and tableau dash boards.
• Generated the Reports Weekly or Monthly wise as per the Client Requirements.
• Rendering the Reports in the form of PDF, EXCEL and CSV.

Environment: Informatica, SSRS, SSIS, Metal, Confidential, TSQL, SQL server 2008R2\20012

Confidential

Senior ETL Developer

Responsibilities:

• Involved in various activities like project planning and documentation.
• I have guided the team members on ETL development’s and design part.
• Coordinated with various businesses in DB to understand their requirements.
• Involved in generalized Architecture design of IRT tool.
• Involved in Functional and Technical level design.
• Involved in BRD document preparation.
• Design & implement ETL requirements
• Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.
• Perform constant file manipulation using VI Editor
• Generalized component development using various transformations
• Expertise in generating reports like drill down, drill through reports, parameterized reports, sub reports and different types chart reports in Qlik View dash boards.
• Involved in Peer review activities for Code & Testing, Deployment
• Involved in Implementation

Environment: Informatica, Qlik View, Confidential, unix

Confidential

Senior ETL Developer

Responsibilities:

• Responsible for developing ETL mappings to load data using Informatica Power Center 8.1.1
• Extensively used Informatica Client Tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Used debugger to test the data flow and fix the code.
• Optimized performance by tuning the Informatica ETL code.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Perform constant file manipulation using VI Editor and UltraEdit to insure data integrity
• Prepare UNIX applications and identify UNIX issues.
• Extensive experience of Slowly Changing Dimensions
• Good knowledge in UTC, Meta Data, QA Documents.
• Writing the Unix scripting

Environment: Informatica, Confidential, UNIX, WinSCP, putty

Confidential

Soft Engineer

Responsibilities:

• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
• Designed business rules based on client requirements and performed testing to validate successful implementation
• Supporting the on call support on Quarter end and production release management deeds
• Working on the Unix environment, debugging the issue

Environment: Informatica, Confidential, Unix, winscp, putty