SUMMARY

• Overall 6 years of IT hands on experience in Data warehousing and the Analysis, Design, Development, Testing, and Implementation of business application systems for Logistics and Supply Chain Management and e - commerce Sectors. Strong Data Warehousing ETLexperience in using Informatica 10.2/9.6.1/9.5/9.1/ Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools, Informatica Server, Repository Server manager.
• Experienced in Repository Configuration using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, Teradata, and files like Flat files.
• Hands on experience in Performing tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, transformations, mappings, and sessions.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Hands on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing.
• Extensively used Oracle 11g/10g/9i/8i and for querying data using SQL, T-SQL, DB2 and BTEQ.
• Very strong in SQL and PL/SQL, extensive hands-on experience in creation of database tables, triggers, sequences, functions, procedures, packages, and SQL performance-tuning.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Have Good understanding of ETL/Informatica standards and best practices and Enterprise Data Warehouse Concepts.
• Experience in Oracle and MS SQL Server environments using Triggers, functions, SQL, T-SQL and PL/SQL.
• Extensive experience in writing UNIX shell scripts and automation of the ETLprocesses using UNIX shell scripting.
• Experience with high volume datasets from various sources like Oracle, Text Files, DB2 AS400, Mainframe Flat Files, Relational Tables, and xml targets.
• Ability to achieve project goals within project constraints such as scope, timing, and budget. Allocating work and managing the resource planning. Day to day monitoring of the deliverable and meeting the expectations of the business clients.

TECHNICAL SKILLS

Operating Systems: Windows 2000 Advance Server, Windows 2003 Server, UNIX, MS-DOS

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), SSIS

Databases: Oracle 11g/10g/9i/8i, SQL, MySQL, MS SQL Server 2008/2005, DB2 v8.1, Microsoft Access, RDBMS DB2, Teradata.

Data Modeling and Profiling tools: Microsoft Visio, (OLTP) and Dimensional (Star, Snowflake Schema)

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/, Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3

Languages: SQL, PL/SQL, UNIX, Shell scripts, C, C++

Tools: and Applications: SQL Developer, SQL * Loader, Putty, Notepad++, Toad, SQL Navigator, Teradata SQL Assistant, Snap logic, Eclipse, NetBeans.

Defect Tracking and Reporting Tools: ALM, Quality Center, IBM Cognos, Tableau 9, SSIS.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

ETL/Informatica Developer

Responsibilities:

• Responsible for designing and development, testing of processes necessary to extract data from operational databases, Transform and load it into data warehouse using Informatica Power center.
• Worked on Informatica Power Center Tools-Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in creating Informatica mappings in uploading the Data files into the Staging tables and tan finally into Data Warehouse system. Extensively used SQL for accessing and manipulating database systems.
• Developed ad-hoc analysis and reports for QI group, clinicians, and CMO group based on HEDIS measurements, population data, program data, and benchmark data.
• Developed a population retrospective analysis and statistical inference report on the AMM program, an external paper and presentation which showed all of the successful correlative factors for the antidepressant medication management HEDIS rate.
• Extracted and transformed data from various sources like Teradata and relational databases (Oracle, SQL Server).
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in workflows like sessions, events, raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Experience in writing SQL queries and optimizing the queries in SQL Server.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
• Performed data analysis and data profiling using SQL on various sources systems including SQL Server.

Environment: s: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005.

Confidential, New York, NY

ETL/Informatica Developer

Responsibilities:

• Extracted data from Oracle database transformed and loaded into Teradata database according to the business specifications.
• Used the PL/SQL Procedures for Informatica mappings for truncating the data in target tables at run time.
• Used Workflow Manager for creating, validating, testing, running the sequential, concurrent Batches and Sessions.
• Used Informatica PowerCenter to create mappings, sessions, and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Implemented modifications to improve performance of long running batch jobs with the halp of changes in SQL statements, indexes, and Explain Plans.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Developed prevalence report of current data to project future HEDIS rates
• Developed business analysis documentation for data and reporting implementations
• Managed Arizona line of business by overseeing overall file management, handle etl processes and file conversions in SQL Server SSIS and SAS, produce ad-hoc reports to support production of rates, perform quantitative and qualitative analysis of final HEDIS rates, and manage overall maintenance and production run of Quality Spectrum software for the Arizona region.
• Developed reports, data and business analysis, and tools to analyze workflow processes, HEDIS rates, STARS measures, and provider profiling.
• Participated and performed audit of policies, procedures, data sources, and maintenance of all PHI data sources. Identified gaps in workflows and consult on making the overall HEDIS processes more efficient leading to changes in quality assurance, database utilization, and other processes.
• Used various transformations like Source Qualifier, Joiner, Lookup, SQL, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• dis role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.
• Scheduled and monitored automated weekly jobs.

Environment: s: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H, Unix- SunOS, PL/SQL, SQL Developer.

Confidential

SQL Developer

Responsibilities:

• Assisted with the design and implementation of workflow applications to update and insert data.
• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Created ETL SSIS packages to move the data from Oracle toSQL Server staging Database and from Oracle to Flat files.
• Performed various ETL processes to load database from different source files.
• Involved in creating SQLstored procedures,Functions,Views, Indexes in Microsoft SQL Server using appropriate business rules, standards for better performance.
• Created packages by using multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Database.
• Documented and maintained database system specifications, diagrams, andconnectivity charts.
• Written and executedcomplex T-SQL queries using SQL Management Studio for back-end data validation testing.
• Train and manage developers, advising other groups in organization on SSIS development, SSRS reports and data warehouse development, and documenting the best practices.
• Provide on-call support to production system to resolve any issues.
• Involved in Unit Test cases preparation and performed Unit testing.

Environment: s: SQL Server 2014, Integration Services (SSIS), Reporting Services (SSRS), MS Visual Studio.NET, Excel.