SUMMARY

• Over 10 yrs. of IT experience with 6 yrs. in ETL - data warehousing with emphasis on business requirements analysis, application design, development, testing, implementation, and maintenance of client data warehouse and data mart systems.
• Experienced in all phases of the Software Development Life Cycle and data analysis.
• Hands-on experience in the ETL tool Informatica Power Center as well as various SQL editors such as Toad, SQL Plus, and Query Analyzer.
• Involved in all aspects of gathering business requirements to facilitate ETL development for reporting.
• Self-motivated and willing to "do what it takes" to get the job done.
• Detail oriented with strong analytical and problem solving skills.
• Experience with fundamental understanding of Python or Java languages
• Able and willing to pick up skills in new technologies which are part of the group's development stack
• Experience in Designing and Developing ETL Mapping, sessions and Workflows using Informatica PowerCenter tool.
• Experience on SQL Language and worked on creating ad-hoc SQL queries for Oracle and SQL Server DB.
• Experience with Unix Shell Scripting. Knowledge of Talend.
• Quick learner, Individual Contributor and flexible to work on developing a new application.

TECHNICAL SKILLS

Operating System: UNIX (IBM AIX), Windows XP/Vista

RDBMS: Oracle 8i/9i/10g, Teradata, SQL-Server

ETL: Informatica Power Center 9.0x/8.x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Monitor and Informatica Server) ETL,metadata, DataMart, FACT & Dimensions tables.

Methodologies: Star Schema, Snowflake Schema

Programming Languages: SQL, PL/SQL, TSQL, Java, Python

Other: TOAD, MS Excel, Word and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Warehouse Developer

Responsibilities:

• Involved in gathering and analyzing the client requirements and preparing business rules along with other team members.
• Created functional design documents and technical design specification documents for the ETL process based on requirements
• Designed table structures, stored procedures, and functions to implement business rules
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Designed and developed mappings for data loads and data cleansing.
• Used Mapplets for use in mappings thereby saving valuable design time and effort
• Created complex mappings using aggregator, expression, and normalizer transformations
• Worked extensively with joiner functions like full outer, master outer, and detail outer in the joiner transformation
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Performed configuration management to migrate Informatica mappings, sessions, and workflows from development to test to production environment
• Participated in design and development of processes to handle high volumes of data loading in a given load interval
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Wrote shell scripts in UNIX to execute the workflow and create workflow, worklets, and tasks to read parameters from parameter files
• Designed and implemented mappings using SCD and CDC methodologies
• Involved in determining the bottlenecks and fixing them with performance tuning
• Designed and developed the process to handle high volumes of data and large volumes of data loading in a given load window

Environment: Informatica Power Center 9.x, Oracle 12.10, UC4 10.8, Github 2.8, Agile.

Confidential, Chicago IL

Data warehouse developer

Responsibilities:

• Involved in integrating data from text files, from Clinical database system and creating a database in conformance area.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Designed and developed mappings for data loads and data cleansing.
• Involved in debugging Informatica mappings.
• Performed configuration management to migrate Informatica mappings, sessions, and workflows from development to test to production environment
• Create Informatica mappings, workflows by applying transformations and perform ETL operations using heterogneous sources like flat files, DB, xml etc.
• Participate in requirement discussions and then translating requirements into technical specifications.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Resolved technical queries raised by team members.
• Developed unit test case scenarios for testing ETL processes and shared them with testing team.
• Involved in analyzing data with the LSH tool of oracle for creating conformed data for staging.

Environment: Informatica Power Center 9.x/8.x, Oracle

Confidential

Informatica Developer

Responsibilities:

• Involved in integrating data received from source database system using stored procedures, feeding data to downstream systems. developing the stored procedures Which are feeding data to target system after implementing the transformation logic using various kind of DML queries. Used dml like inner joins, and outer joins multiple source systems like Oracle, and Flat files and loaded into Oracle.
• Tested stored procedures created for data loads and data cleansing.
• Involved in creating tables and other artifacts and maintaining their script.
• Used merge query to implement SCD type1 and type 2 dimensions data loading procedures .
• Used Git for the version management.
• Involved in running and monitoring jobs through UC4 in production support.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in analyzing data for staging.
• Worked with ILM tool for Test data Management
• Developed Informatica rules for Data Masking.
• Created relationships for creating referentially intact data subsets for testing needs.
• Looking into Tivoli error messages

Environment: Informatica Power Center 9.x/8.x, UNIX (Sun Solaris), Tivoli,AQT, toad for query analyzer, Agile

Support Analyst

Confidential, New York, NY

Responsibilities:

• Provided Level-2 support to reporting team in resolving the issues related to loading of target tables.
• Observed and monitored ETL batches to report the issues related to SLAs and ETL jobs
• Reloaded reject-data from source to target
• Involved in finding and fixing of bugs/issues in ETL mappings
• Reviewed ETL mappings and design doc created by development team
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Used mapplets for use in mappings thereby saving valuable design time and effort.
• Created complex mappings using Aggregator, Expression, Joiner transformations.
• Extensively worked with joiner functions like full outer, master outer and detail outer join in transformation.
• Designed and developed stored procedures, and functions to implement business rules.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Written shell scripts in UNIX to execute the workflow, created Workflow, Worklets and Tasks to read parameters from parameter files.
• Designed and implemented SCD and CDC methodologies in the mappings.
• Involved in the design and development of the process to handle high volumes of data and large volumes of data loading in a given load window.
• Created and scheduled UNIX scripts to control the ETL processes.

Environment: Informatica Power Center 9.1, IBM UNIX AIX 5.3, Oracle 10g, TSRM, Control M, MS SharePoint

Confidential

IT Developer

Responsibilities:

• Studied the manual process of the business and interacted with business client to gather the requirement to automate the system
• Designed the database for the system and prepared the program specifications,
• Designed various GUI screens to capture the information and save and update the user information.
• Extensively coded to build the system.
• Translated business requirements into technical requirements
• Data extraction and data Transfer from DB2 Database to Flat files with Delimited and Fixed width files vice versa. Few of the sources as .csv files.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Written migration scripts to migrate the database from MS-Access to SQL-Server

Environment: Win 2K, WinXP, ASP.net, C-Sharp, JavaScript, Visual Studio 6.0, MSSQL-Server.

ETL Developer

Confidential, Boston, MA

Responsibilities:

• Interacted with business analysts and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed mappings to extract data from COBOL files, DB2, Flat files and load into DataMart using the PowerCenter.
• Developed common routine mappings. Made use of mapping variables, mapping parameters
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to meet the requirements.
• Developed Slowly Changing Dimension for Type 1 SCD.
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Experienced working with Customer Information Data Mart for business reporting thru Reference Data
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter
• Written shell scripts to run the workflows and automated them through WLM scheduler.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Defects were tracked, reviewed and analyzed.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 8.6, IBM UNIX AIX 5.3, Control M

Confidential, New York, NY

Senior Web Application Developer

Responsibilities:

• Designed the HTML pages
• Developed forms using ASP, VBScript, JavaScript
• Constructed classes for DLL using VB6.
• Designed various GUI screens to capture the information and save and update the user information developed stored procedures, triggers using T-SQL features like exception handling and error handling
• Implemented complex programming logic in stored procedures by features like declaring variables, transaction control and row processing.
• Analyzed the reported bugs, validated and tracked them and debugged.

Environment: Win 2K, WinNT, ASP.net, C-Sharp, JavaScript, Visual Studio 6.0, MSSQL-Server

Confidential

Senior Application Developer

Responsibilities:

• Translated business requirements into technical requirements
• Designed Web Pages for the site using HTML, developed forms using ASP, VBScript, and JavaScript.
• Designed various GUI screens to capture the information and save and update the user information.
• Did extensive coding to build the system using complex controls like grid, Repeater and dropdown lists
• Co-ordinated team meeting and assigned and tracked the module completion assigned to each team member
• Daily version control in Visual Source Safe, saving and maintaining versions and documentation
• Did code reviews of programs and prepared unit test cases and tested the codes.

Environment: Win95, Win-NT, ASP, JavaScript, VBScript, WAP, VB, VC++ Tools: Nokia SDK, Visual Studio 6.0, MSSQL 7.0, Adobe Photoshop, Microsoft Server Commerce Edition, Macromedia Dreamweaver 3.0, Rational Rose 98 Enterprise edition.

Confidential

Software Application Developer

Responsibilities:

• Studied the manual process of the business and interacted with business client to gather the requirement to automate the system
• Prepared SRS document, translated business requirements into technical requirements
• Designed the database for the system and prepared the program specifications,
• Designed various GUI screens to capture the information and save and update the user information.
• Extensively coded to build the system.
• Translated business requirements into technical requirements
• Data extraction and data Transfer from DB2 Database to Flat files with Delimited and Fixed width files vice versa. Few of the sources as .csv files.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Written migration scripts to migrate the database from MS-Access to SQL-Server

Environment: VB4, VB5, VB6, MS-Access, Oracle 7.3, SQL-Server 7

Confidential

Software Application Developer

Responsibilities:

• Developed programs for back-end tasks and manipulations into database using ESQL-C writing code for shell scripts in Unix, Awk tools
• Review of program specs provided by on-site team and reporting issues if any developing reports in Ingres report-writer
• On-site communication with client for any queries and clarifications.
• Test data preparation.
• Tested and debugged COBOL programs, logging information into test incident reports.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Batch programs.

Environment: HP9000 D class server, HP-UX 9.0, CA-Open Ingress 1.2, DB2, COBOL, Oracle 7.1