SUMMARY

• Around 10 years of experience in IT Software Development Life cycle involved in Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in Manufacturing, Travel and Insurance domains.
• Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell - Scripts and SQL Loader scripts.
• Proficient in SQL using Stored Procedure, Dynamic SQL, joins, Views, Indexes, Triggers, Cursors, CTE, DML, DDL and etc.
• Very strong in SQL Query Tuning, Indexes and Stored Procedures, Review and optimize daily batch jobs.
• Expertise in conducting requirements gathering sessions, feasibility studies, Impact Analysis, Risk analysis & management and base lining the acceptance criteria.
• Provided strategic thinking and solutions while driving Architectural Recommendations specific to data warehouse applications and business intelligence tools focusing on ETL functions.
• Provided project level design, data analysis and application performance analysis.
• Expertise in managing several projects simultaneously for the whole project life cycle.
• Extensive experience in the development, implementation, deployment & integration strategies within a team oriented environment, utilizing quantitative & qualitative analytical skills.
• Strong Knowledge of SDLC and Agile (Scrum) methodology.
• Experience in using Informatica Power Center, an ETL tool to integrate data from various source systems includes flat files, XML, Relational and COBOL on UNIX and Windows platform.
• Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
• Experience in using Informatica Power Exchange to extract the data from and load the data into the salesforce application using Bulk API and Soap API concepts in Salesforce.
• Experience in integration of various Operational Data Source (ODS) s with Multiple Relational databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files of fixed width and delimited.
• Hands on expertise with SQL Server, Oracle, Teradata and DB2 Databases.
• Writing batch scripts to process source files, target files, automate the email notifications, archive the files, copy, ftp and cleanse the files to process in ETL.
• Expert level understanding of Oracle Database Capabilities and DW best practices including appropriate use of Index, Partitions, Materialized Views etc.
• Excellent in project management, communication, documentation, interpersonal and analytical skills. Strong ability to perform as part of a team.

TECHNICAL SKILLS

Business Intelligence: Informatica 10.1/9.x/8.x, Cognos

Source/Target Systems: Oracle, DB2, SQL Server, Teradata, Salesforce, SAP

Languages: SQL, PL/SQL, Shell Scripting, PostgreSQL, C, Java

Tools: SQL Developer, TOAD, Control M, Subversion

OS/Environment: Windows 9X, DOS, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Irvine, CA

Sr. Informatica Developer

Responsibilities:

• Requirements gathering and requirements analysis through coordination with business analysts and define business and functional specifications.
• Provided documentation of ETL design and technical specifications, high level and low-level design specifications.
• Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data into the data warehouse.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
• Worked on Informatica Advanced concepts & also Implementation ofInformatica PushDown Optimization and Partitioning.
• Created mapplets and reusable transformations to leverage the coding efforts and to help code maintenance.
• Used Type 2 SCD logic in Informatica to load Slowly Changing Dimension tables.
• Created complex stored procedures, functions, triggers, and tables and materialized views. Developed complex SQL code to read data from source system and in lookup transformations.
• Worked with testing team to define a robust test plan and support them during the functional testing of the application.
• Identifying & removing the bottlenecks, tuning the mappings and sessions to improve performance.
• Precise Documentation was done for all mappings and workflows.
• Developed Shell scripts to automate file manipulation and data loading procedures.
• Review and deploy the code.
• Prepare and use test data/cases to verify accuracy and completeness of ETL process.

Environment: Informatica Power Center 9.6, SQL Server, Oracle, UNIX, SAP, Control M

Confidential - Neenah, WI

Sr. Informatica Developer/Lead

Responsibilities:

• Involved in Requirement gathering and analyzing the requirements. Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and Oracle into staging area and populated onto Data warehouse. Worked on Flat Files and Oracle as sources.
• Provide documentation of ETL design and technical specifications, high level and low-level design specifications.
• Create test cases for Unit testing, Integration testing and User acceptance testing.
• Create mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and update strategy etc.
• Create mappings, sessions, workflows and run those using workflow manger and monitor jobs using workflow monitor.
• Involved in upgrading Informatica from 9.6 to 10.1
• Connecting and loading data from SAP and AZURE source systems.
• Made use ofPost-Session successandPost-Session failurebatch scripts in the Session task to execute scripts needed for cleanup and update purposes.
• Assist with task identification and effort estimates for ETL development as per Agile Development methodology.
• Documented the test plans and executed for UNIT testing and also supported for system testing, volume testing and USER testing. Also provided production support by monitoring the processes running daily.
• Created email notifications. Scheduled the loads at required frequency using Control M, generated completion messages and status reports using Workflow Manager.
• Using debugger to test the data flow and fix the mappings.
• Prepare and use test data/cases to verify accuracy and completeness of ETL process.
• Involve in Production Support and troubleshooting data quality and integrity issues.

Environment: Informatica Power Center 10.1/9.6.1, AZURE, SQL Server, Oracle, Windows, Control M

Confidential - Bloomington, IL

Sr. Informatica Designer/Developer

Responsibilities:

• Worked on multiple projects as an ETL designer and developer across Confidential . Extensively used Informatica Power center to develop mappings.
• Interact with the Business users and the requirements team to identify process metrics, various key dimensions and measures.
• Developed mapplets, reusable transformationsto use in different mappings.
• Worked extensively with Xml sources and targets.
• Worked on identifying and automating the process wherever possible resulting in extensive project cost benefit to the client.
• Designed the ETL mappings between sources to operational staging targets, then to the data warehouse using Powercenter Designer.
• Extensively used the Bulk API, the Soap API and the Metadata API concepts of Salesforce to load/read data from salesforce using Informatica.
• Used Webservice transformation and Webservice targets to call and execute functionalities in the Salesforce (WSDL).
• Extensively used the power exchange for Salesforce to read, look up and load the data.
• Design and developed ETL audit and control model components.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Worked in different POC’s across Confidential .
• Involved in defining ETL framework, Data Integration points, ETL naming standards, ETL Development-QA-Production deployment process.
• Developed Shell scripts to automate file manipulation and data loading procedures.

Environment: Informatica Power Center 9.5.0, Salesforce.com, DB2, UNIX, Control M

Confidential - Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Involved in ETL design and effort estimation.
• Assist with task identification and effort estimates for ETL development per Agile Development methodology.
• Worked with offshore team to Develop and deliver the ETL tasks.
• Developed the ETL jobs to automate the Data validation process across the systems (Web trends and in house) using Informatica and notifying the variances to stakeholders.
• Developed shell scripts to access the websites and download the CSV files using RESTUrl.
• Developed Shell scripts in UNIX to make the email notification reusable and consistent.
• Used Teradata utilities TPT, TPump, BTEQ, fastload, fastexport and multi load.
• Involved in performance tuning and optimization to handle and process large volume of data in Teradata.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations
• Worked with testing team to define a robust test plan and support them during the functional testing of the application.
• Contribute to performance tuning and volume testing of the application.
• Review and deploy the code.
• Track and Report the project status in frequent intervals.

Environment: Informatica Power Center 9.0, GreenPlum, PostgreSQL, PL/SQL, Opswise, UNIX

Confidential - Milwaukee, WI

Sr. Informatica Developer

Responsibilities:

• Design ETL Best Practice Methodology for the Creation of an Enterprise Data Warehouse (EDW) for Confidential .
• Build and promote the use of repeatable EDW processes, templates, and tools.
• Involved in Requirement gathering and analyzing the requirements.
• Responsible for holding meetings with the functional Analyst to understand the business requirements.
• Maintain account lineage.
• Reconcile the month end loan balances in Confidential ’s general ledger (GL) to the month-end loan balances in the credit risk data mart.
• Provide vintage analysis (vintage delinquency, payoff trend, charge-off curves) and HELOC (home equity line-of-credit).
• Provide probability of default (PD), loss given default (LGD), exposure at default (EAD) and dynamic cohort reporting.
• Created email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Join business discussions to attribute the business and functional requirements and qualify and quantify data requirements and project planning.
• Provide documentation of ETL design and technical specifications, high level and low-level design specifications.
• Design and build reconciliation process.
• Police code maintenance and code deployments.

Environment: Informatica PowerCenter 9.5.0, Oracle 11g, SQL Server, Windows

Confidential - Charlotte, NC

Informatica Developer

Responsibilities:

• Understand and translate the business needs into technical requirements.
• Create the low-level design and help the developers understand it.
• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex SQL code for the application.
• Assist with task identification and effort estimates for ETL development.
• Design ETL jobs to load data in the data warehouse tables.
• Review application code to ensure best standards are being followed
• Build test cases and test scripts, performing unit and integration testing.
• Responsible for the code delivery to the client and point of contact during deployment of the code and postproduction issues.
• Acted as a liaison between the offshore and onsite teams
• Used Teradata utilities TPT, TPump, BTEQ, fastload, fastexport and multi load.
• Involved in performance tuning and optimization to handle and process large volume of data in Teradata.
• Assist with data analysis and fulfill adhoc requests required for financial month end close.

Environment: Informatica Power Center 9.0, Oracle, Teradata and UNIX

Confidential

Informatica Developer

Responsibilities:

• Analyzing existing ETL Process, developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development and mentoring.
• Extensively used Informatica- Power center for extracting data from various source systems like database, flat file etc, transforming and loading into different databases.
• Designing, developing and testing Different Mappings according to Requirements.
• Wrote the shell scripts in UNIX for automating the job.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Used the Mapping Designer to map the sources and target.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
• Created Reusable mapplets and Reusable transformations to leverage the coding efforts.
• Developed Report Studio reports to fulfill reporting needs.
• Creation of complex reports using Report Studio with multiple Prompts and different type of charts and graphs
• Creation of adhoc reports using Query Studio

Environment: Informatica 7.x, Oracle, PL/SQL, UNIX