SUMMARY:

• Over 6 years of experience in Full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation
• Expert in all stages of Software development life cycle (SDLC) and Agile
• Enterprise Data Warehousing: Experience and Expertise in ETL process (Informatica Power Center 9.6,9.5.1,9.0.1)
• Expertise in implementing teh XML and Web Services Transformations
• Experience and Expertise in ETL process (Informatica PowerCenter ) Mappings, Mapplets,Transformations, Workflow Manager and Workflow Monitor
• Experience and Expertise in Operational Data Store (ODS) design, Data warehouse and mart design methodologies such as Star schema, Snowflake, designing slowly changing dimensions and fact tables. Also, expertise in extracting data from different source systems like Oracle, XML, Flat files and SQL Servers and loading into Data warehouse, Datamarts & ODS systems
• Extensively worked on Web services consumer transformations & Error handling methodologies
• Implemented Various Performance Tuning techniques on Mappings
• Implemented Slowly Changing Dimensions Type 1, Type 2, and Type 3 methodology for accessing teh full history of accounts and transaction information
• Good experience in maintaining teh versioning and deployment instruction documents while moving teh code to various environments
• Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts
• Expertise in Job Scheduling using Autosys and Tidal
• Good working noledge on RDBMS (Oracle, MS SQL Server)
• Good noledge on writing teh PL/SQL Scripts like Procedures, Triggers and Functions
• Involved in Unit Testing and Data Validation for Developed Informatica Mappings
• Proven ability to quickly learn and apply new technologies and has creativity, innovation, and ability to work in a paced environment
• Team player wif excellent communication and problem - solving skills
• Good Working Experience in UNIX Shell Scripting
• Also strong in communication, interpersonal skills, multi-tasking, flexible in work schedules
• Eager and keen on developing robust and reliable reports
• Built adhoc reports in Tableau for data validation

TECHNICAL SKILLS:

Reporting tools: Tableau, Looker, Cognos

ETL Tools: Informatica 9.x, OWB 10r2

Data Modeling: Lucid Charts, Dimensional Data Modeling, Star Schema, Snow Flake Modeling, Fact, Dimensions Tables

Data Warehouses: Jaros

Databases: ORACLE, SQL Server, MS Access

Scheduling Tools: Tidal, Autosys

Languages: C, SQL, PL/SQL

Operating Systems: Batch, Shell scripts

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Informatica Consultant

Environment: Informatica Power Center 9.6, Tidal, Tableau, SQL server

Responsibilities:

• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Data Warehouse
• Studied teh existing OLTP system(s) and Created facts, dimensions and star schema representation for teh data mart
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems
• Imported Source/Target Tables from teh respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a Mapplet and created new mappings using Designer module of Informatica
• Worked wif SQL Transformation and Java Transformation
• Created Tasks, Workflows, Sessions to move teh data at specific intervals on demand using Workflow Manager and Workflow Monitor
• Extensively worked on teh performance tuning of teh Mappings as well as teh sessions
• Involved in writing UNIX shell scripts for Informatics ETL tool to run teh Sessions
• Working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations
• Coordinated wif DBA for tuning sources and targets and calculating table space and growth of database
• Migrated teh code from DEV repository to QA and tan to PROD Repositories while in our monthly releases
• Prepared a technical documentation and SOP’s for teh existing system
• Involved in ETL loads (Enable/disabled) through Informatica Admin Console during all teh monthlyreleases
• Created test cases and completed unit, integration and system tests for Data Warehouse
• Involved in Production support and ON Call support
• Used Tidal to schedule jobs
• Assist wif migrating jobs into production
• Monitor Production Jobs to ensure successful execution
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues wif their applications in Tidal
• Proactive in finding issues and seeking and implementing solutions
• Perform daily Production Support recurring tasks and monitoring of teh tickets queue, assign tickets, resolve tickets, update root cause and remediation

Confidential, Phoenix, AZ

Informatica Consultant

Environment: Informatica Power Center 9.6, Autosys, SVN, Tableau, Oracle 10g

Responsibilities:

• Used Jira to track and maintain project progress
• Responsible for requirement gathering, user meetings, discussing teh issues to be resolved andtranslated teh user inputs into ETL design documents
• Extracted data from various heterogeneous sources like Oracle, Flat files
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in teh data warehouse
• Worked wif Informatica Power Center server which executes tasks based on work flows. Teh work flows can be monitored using a work flow monitor. Jobs inside teh program are designed in a mapping designer, which creates mapping between source and target.
• Mapping is a pictorial representation about flow of data from source to target
• Worked wif Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse
• Worked on several transformations such as Filter, Joiner, Sequence Generator, Aggregator, Source Qualifier, Expression, Lookup (Connected and Unconnected), Joiner, and Router, Web services, XML and Normalizer Transformations in Informatica
• Created shell script to pass database connections, parameter entries for source and target
• Involved in Production support and ON Call support
• Used Autosys to schedule jobs

Confidential, Houston, TX

Informatica Consultant

Environment: Informatica Power Center 9.1, Oracle 10g, PL/SQL, Tableau

Responsibilities:

• Built adhoc reports in Tableau for data validation
• Communicate wif business customers to discuss requirements issues and feedback
• Developed ETL components using Informatica to cater business requirements
• Used Informatica file watch events to pole teh FTP sites for teh external mainframe files
• Optimally used relational SQL wherever possible to minimize teh data transfer over teh network
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations
• Fixed teh invalid mappings and troubleshoot teh technical problems of teh database
• Performed unit testing at various levels of teh ETL and actively involved in team code reviews
• Performance tuning was done at teh functional level and map level
• TEMPEffectively worked in Informatica version based environment and used deployment groups to migrate teh objects
• Pre and post session assignment variables were used to pass teh variable values from one session to other
• Designed workflows wif many sessions wif decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs
• Created shell scripts to trigger Informatica workflows
• TEMPEffectively used Informatica parameter files for defining session, workflow, FTP connections and relational connections
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting
• Production Support has been done to resolve teh ongoing issues and troubleshoot teh problems
• Involved in enhancements and maintenance activities of teh data warehouse including tuning, modifying of stored procedures for code enhancements

Confidential

Informatica Consultant

Environment: Informatica Power Center, Repository Manager, Oracle 10g, PL/SQL.

Responsibilities:

• Worked Extensively wif ERP functional team to gather teh data mappings for ETL specifications andDocumenting ETL process design
• Used Informatica Designer to create complex mappings using different transformations, Mapplets andReusable transformations for cleansing and move data to a Data Warehouse
• Worked wif Power Center Designer tool in developing mappings to extract and loading teh data fromstage to pre load and later to data warehouse
• Responsible for monitoring all teh sessions that are scheduled, running completed and failed usingWorkflow Monitor
• Involved in debugging teh Mappings that failed using debugger to validate teh mappings and gaintroubleshooting information about data and error conditions
• Modified all teh existing Informatica Mappings by applying performance tuning techniques for betterPerformance
• Fixed bugs relating to daily load of data into Data warehouse for Business Intelligence reports
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL wif teh use of Cursors
• Migrated code/objects from teh development environment to teh QA/testing environment to facilitatethe testing of all objects developed and check their consistency end to end on teh new environment
• Performed Unit Testing and Integration Testing for both Full and Incremental Loads
• Participated in weekly end user meetings to discuss data quality, performance issues and ways toimprove data accuracy and new requirements, etc.GE Aero Kronos DWH Integration

Confidential

Environment: Informatica Power Center Designer 9.1, Informatica Repository Manager, Oracle 10g, PL/SQL, Cognos 8

Responsibilities:

• Organized multiple requirement discussion meetings wif Business Users and Source system experts and formed functional and technical specs
• Coordinating wif business users, source system experts and DBAs regarding business functionality definitions and ETL design.
• Developed ETL wif oracle pl/sql procedures and Unix shell scripts for history data migration
• Using Informatica Power Center Designer, analyzed teh source data to Extract & Transform from various source systems (oracle 10g, SQL server and flat files) by incorporating business rules using different objects and functions that teh tool supports
• Using Informatica Power Center created mappings and mapplets to transform teh data according to teh business rules
• Wrote PL/SQL stored procedures & triggers, cursors for implementing business rules andtransformations
• Monitor daily, weekly, monthly Data Warehouse load processes and other DW related processes
• TEMPEffectively used Source Designer, Target Analyzer to extract and load data from corresponding databases
• Developed Mappings, Sessions, Workflows as per designed document by using client components of Informatica Power Center
• Created ODBC connections to source and targets
• Importing teh metadata and relational data based on teh source and target systems
• Implemented slowly changing dimensions (SCD) for some of teh Tables as per user requirement
• Developed Stored Procedures and Cognos was used for reporting purposes
• Constantly interacted wif business users to discuss requirements

Confidential

Management Trainee

Environment: Cognos 8, Informatica 8.6.1, Oracle 10g, PL/SQL.

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify requiredsources and targets
• Involved in preparation of technical documentation, design transformations that are consistent wif thegoals of teh existing data warehouse, and worked wif teh development team to implement teh solution
• Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse
• Used teh Workflow Manager to create Workflows, Worklets and Tasks
• Written Minus Queries to make sure all data is loaded into target tables
• Used Cognos to report out any mismatches
• Used design and development techniques that resulted in efficient, maintainable, and high quality ETLprocesses
• Used problem solving skills and quickly understood relationships between data wif littledocumentation