SUMMARY

• Over 8+ years of IT experience in Data Warehousing and ETL with emphasis on business requirements analysis, application design, data modeling, development, implementations and testing of applications.
• Over 3+ years of SFDC data integration.
• Experience with Informatica Power Center 9.X/8.x Power Exchange in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, scheduling Workflows and sessions.
• Experience with IDQ and Informatica MDM.
• Experience in all aspects of the software development life cycle (SDLC), with specific focus on Data Warehousing.
• Strong experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin.
• Strong Data Profiling and Data cleansing experience
• Strong experience with SFDC SOQL queries using master - detail relationships.
• Experienced in designing the process flow to load data efficiently using UC4 Automation Tool.
• Experienced in the Release Management work, which includes creating support documents, managing the process flow for optimal results, Etc.
• Experience in CISCO Data Virtualization Tool.
• Experienced in writing UNIX shell scripts, BTEQ scripts.
• Experience on post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Extensive experience working with the client for gathering requirements, gap analysis, design, development, Testing and Implementation of the ETL/Data warehouse project.
• Exposure to different ETL tools Talend, Pentaho, Datastage, IDQ, MDM
• Exposures to different reporting tools such as micro strategy,
• Exceptional data analysis skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9X/8x/, Power Exchange, Informatica cloud services, Talend, Pentaho, IDQ, Informatica MDM.

Data Modeling: Erwin, ER Studio, Dimensional modeling, Star/Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Reporting tools: Web Intelligence, Salesforce reporting and Micro strategy.

Databases: Oracle 11g/10g/9i, DB2, MS SQL Server 2012/2008/2005 , MS Access, Terra data

Programming/GUI: SQL, PL/SQL, SAP, ANSI SQL, Visual Basic .Net/6.0/5.0, C, C++, C #, JAVA, Unix, Siperian, Shell Scripting, XML.

Operating Systems: Windows, UNIX

Scheduling tools: Autosys, UC4,Informatica scheduling

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Lead IT Developer

Responsibilities:

• Work with the QA team to prioritize the resources and provide updates on the analysis.
• Prioritizing the ETL work from high to low depending on the business requirements.
• Standardize the ETL deployment procedure, ETL naming standards and ETL production support documentation.
• Manage and assign day to day tasks to the ETL developers and give an update to the business partners
• Designed and Developed ETL processing to integrate data from disparate systems to load to Sales Force Cloud Environment.
• Worked on Disparate Data Systems such as Oracle, Flat Files, VSAM Files.
• Worked withCISCO Data Virtualization Tool to create Database views and Procedures.
• Schedule Informatica Power center Jobs and Informatica cloud jobs using Autosys Scheduling Tool.
• Code Version Control using SVN Tortoise Version tool.
• Involved in analysis, design, development, implementation and quality assurance of DW applications and reporting system.
• The Data warehouse solution provides the reports to the claims department to generate reports.
• Load Facts and Dimension tables in the Data warehouse system.
• Extensively used Informatica ETL to load data from flat files to Oracle database and SQL server database to Oracle database.
• Detailed data analysis to determine the best way to improve the Process flow.
• Involved in Release management work, which includes creating support document, managing the process flow to achieve optimal results.

Confidential, St. Paul, MN

Lead IT Developer

Responsibilities:

• Conduct release meetings to provide an update on the status of the code movement to the business.
• Review the code fixes and the unit test documentation.
• Gather requirements from the business analysts and analyze on reusing the existing data models to able to fit in the proposed data model.
• Responsible for maintain the logical and physical data models to meet the company standards.
• Worked with the reporting to create monthly sales reports.
• Work with the QA team to prioritize the resources and provide updates on the analysis.
• Prioritizing the ETL work from high to low depending on the business requirements.
• Standardize the ETL deployment procedure, ETL naming standards and ETL production support documentation.
• Manage and assign day to day tasks to the ETL developers and give an update to the business partners
• Designed and Developed ETL processing to integrate data from disparate systems such as XML/Flat Files to load the data to Sales Force Cloud.
• Create ETL maps which call out to external web services using SOAP message over HTTP protocol that create customer quote.
• Worked extensively with Facts, Dimensions, Star schema within the data warehouse systems.
• Involved in the Data Analysis and Data profiling for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Worked on Disparate Data Systems such as SQL Server 2005/2008, DB2, Siperian MDM, Sales Force Cloud Database, Flat Files, VSAM Files and SAP BW.
• Worked withInformaticaData Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Develop Source based CDC and snapshot based CDC logic using Informatica ETL.
• Develop a simple ETL maps using Datastage ETL.
• Schedule Informatica Power center Jobs and Informatica cloud jobs using UC4 Scheduling Tool.
• Designed and developed Infomatica Cloud Jobs using Informatica cloud tool to Source from SQL server 2005 Database and Target to Sales Force Cloud Database.
• Worked with Sales Force Database SOQL queries using Master Detail relationships.
• Configure User groups in Sales Force Cloud environment.
• Involved in the Testing the data and proposing resolutions on how to maximize the results using incremental Loads.
• Involved in ETL Technical Support role for 24x7 Support for the ETL Processes as Tier 3 support.
• Involved in Automating ETL Jobs using UC4 Automation tool.
• Automate ICS (Informatica Cloud Services) error retrieval process.
• Detailed data analysis to determine the best way to improve the Process flow.
• Involved in Release management work, which includes creating support document, managing the process flow to achieve optimal results.

Confidential, Morrisville, NC

ETL Developer/Architect

Responsibilities:

• Conduct impact assessment and determine size of effort based on requirements.
• Identify, recommend and implement ETL process and architecture improvements.
• Propose estimates and the resources required to resolve defects.
• Designed and Developed Informatica mappings to Migrate data from Teradata to SAP BW.
• Create database views on Teradata
• Executing BETQ scripts in batch mode and script mode.
• Extensively involved in writing ETL Specs for Development.
• Extensively used Informatica client tools - Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Exposure to Pentaho ETL on developing ETL maps to load data to text files.
• Worked extensively on different types of transformations like Lookup Transformation, Expression, Aggregator, Router, filter, Update strategy, Sorter, and SQL Transformation.
• Involved in creating sessions, Worklets and Workflows for carrying out test loads.
• Extensively worked on Business Objects to analyze the data and make changes to the data depending on the requirement.

Confidential, Greensboro, NC

ETL Developer/Architect

Responsibilities:

• Assist and verify design of solution and production of all design phase deliverables
• Involved in creating Informatica mapping to populate staging tables and ODS (OperationalDataStore) from Flat File sources, DB2 Sources, Copy Book Files and oracle sources.
• Written Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively used Informatica client tools - Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively on different types of transformations like JAVA Transformation, Expression, Aggregator, Router, filter, Update strategy, lookup, Sorter, and SQL Transformation.
• Writing PL/SQL Stored Procedures based on the Requirements.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Coordinated with testing team in all phases of testing including end-to-end testing.

Confidential, Raleigh, NC

ETL Developer

Responsibilities:

• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Involved in creating Informatica mapping to populate staging tables and data warehouse tables from Redbrick sources and oracle sources.
• Written Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, and sequence generator.
• Creating sessions, worklets and workflows for carrying out test loads.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Analyzed software requirement documents and business requirement and assisted in high level data modeling using Erwin data modeling tool.
• Extracted data from multiple sources, which included relational sources, Flat-Files and VSAM Datasets.
• Responsible to document interface requirements and program specifications and to obtain client approval on all requirements and specifications.
• Extensively worked on ETL performance tuning, worked with DBAs for SQL query tuning etc.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings. Used Debugger to test the mapping at designer level.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Analyzed company’s website using Web Intelligence and generated simple reports using Business Objects.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.

Confidential

Oracle Developer

Responsibilities:

• Responsible for creating and modifying the PL/SQL procedure, function according to the business requirement.
• Worked with business users in analyzing the requirements and validation.
• Involved in the design of the overall database using Entity Relationship diagrams.
• Designed and developed all the tables, views for the system in Oracle.
• Developing SQL, PL/ SQL queries, stored procedures, functions, trigger for billing module.
• Worked in billing development team.
• Involved Data between billing database and Clarity database.
• Troubleshooting for end users and optimizing the database.