PROFESSIONAL SUMMARY:

• 9 years of IT experience in Software Analysis, Development, Implementation of business applications for Supply Chain Management, Manufacturing, Financial, Banking, Health care, Insurance, Telecom verticals and Business Operation solutions for schools.
• 9 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Centre 10.1/9.x.
• Experience in project management for offshore and onsite team.
• Expertise in using Power Exchange9.5/8.1 plug - ins for any Legacy system.
• Expertise in using IDE for Informatica Data Integration.
• Experience in Change data capture (CDC), synchronous CDC & asynchronous CDC in DB2.
• Hands on Experience in SDLC, JAD and Agile methodologies
• Expertise at ODS, Enterprise Data warehouse(EDW) Integration and Management among MS SQL Server, My SQL, Oracle, MS Access, DB2, MDM, Sales force, Sybase, Teradata.
• Expertise in tuning the SQL Scripts and interaction process to enhance the Performance tuning.
• Extensively experienced in Data migration from Legacy to SAP R/3 and SAP R/3 to SAP R/3.
• Expertise in integration of various data sources like Oracle EBS, CLARITY, SAP R/3, Oracle, XML, Sybase, SRM, TIBCO, JMS, MQ Series, UDB DB2, SAS, people soft, SQL server and MS access into staging area.
• Extensively experienced in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• 7 years of experience using Oracle 10g/9i/8i/7.x, MS SQL Server 2008/05, Teradata, MS Access, SQL, My SQL, PL/SQL, SQL*Plus and UNIX.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large Data Management sets.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Extensively worked on understanding the business requirements and designing Cognos applications.
• Developed ETL scripts to extract and cleanse data from SQL databases for loading into Cognos.
• Experienced in SOA, Dimensional Database modeling (Erwin), Snowflake modeling, FACT tables, Dimension Tables and demoralization.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals, excellent written and verbal communication skills including experience in proposal and presentation creation.
• Expertise in using scheduling tools like Autosys and Control-M.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.x/9.x, 8.x, IDQ 9.x, Informatica Developer.

Databases: Oracle 8i/9i /10g/ 11g, PL/SQL, Teradata12 & 13, MS SQL Server 2000 & 2005, Netezza, SQL Assistant

Teradata Utilities: MultiLoad, FastLoad, FastExport, Multiloadexport, TPT, Teradata SQL Assistant

Scripting: Unix Shell Scripts, Perl Scripts, .KSH Batch Scripts.

Tools: Business Objects XI 3.1, Toad, SQL Developer, MS Visio Power Designer, SQL Navigator, Teradata SQL Assistant.

Operating Systems: UNIX, Windows XP, Windows 2000 Server, Windows 7 & 8.

Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Database Design.

Job Scheduler: CronTab 7, SQL Developer, Control-M, Autosys R11.0, UC4, Distributed Control-M job scheduler, Informatica Scheduling.

WORK EXPERIENCE:

Confidential, Bloomington, IL

Informatica Developer II

• Performed data analysis and gathered columns metadata of source systems for understanding requirement feasibility analysis.
• Created Logical Data Flow Model from the Source System study according to Business requirements on MS Visio.
• Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.
• Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams, MS Visio & Rational Rose.
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Worked closely with analysts to come up with detailed solution approach design documents.
• Provided initial capacity and growth forecast in terms of Space, CPU for the applications by gathering the details of volumes expected from Business.
• Prepared low level technical design document and participated in build/review of the BTEQ Scripts, Fast Exports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
• Provided support during the system test, Product Integration Testing and UAT.
• Verified if implementation is done as expected i.e. check the code members are applied in the correct locations, schedules are built as expected, and dependencies are set as requested.
• Done the impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in a production environment.
• Provided quick production fixes and proactively involved in fixing production support issues.
• Have strong knowledge in data mover for importing and exporting of data.
• Creating and maintaining source-target mapping documents for ETL development team.
• Providing requirement specifications and guide the Junior ETL team for development of the ETL jobs through Informatica ETL tool.
• Development of test cases and testing.
• Involved in complete software development life-cycle(SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment.
• Developed technical design documents (HLD and LLD) based on the functional requirements.
• Coordinate with Configuration management team in code deployments. Migrating IDQ objects into the Power Center.
• Effectively using the Address Validator, Exception transformations to implementing the complex business logic in IDQ (Informatica Data Quality).
• Profiling the source data by using the Informatica Analyst and IDQ to provide the better ETL solutions.
• Extracted the Salesforce data using Informatica Cloud and informatica power center to load it into Oracle Database. Implemented CDC logic to extract the data from Salesforce to Oracle database.
• Preparing and implementing the Unit Test cases.
• Creating and working on ticketing system such as General Request, Change Request (SCR), incident and meet their SLA’s.

Environment: Informatica Power Center: 9.0/10.1, Power Exchange8.5/9.0/9.5, DB2, UNIX, SQL Assistant 12.0, Business Objects, Hyperion, BTEQ, FastLoad, FastExport, Multiload, Korn Shells, MS Visio, Remedy, Kintana, Data Mover.

Confidential, Auburn Hills, MI

Sr. ETL Developer

• Performed Business Analysis and gathered requirements.
• Involved in VW assessment program
• Coded the process ETL reports. Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings.
• Interpreted logical and physical data model for business users to determine common data definitions and establish referential integrity of the system.
• Participated in the analysis of development environment of Extraction process and development architecture of ETL process.
• Coordinated with customer in finding the sources and targets for data conversion.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Worked in fixing invalid mappings using the Informatica Debugger.
• Analyzed the production Issues, and resolved them before the flow ends .
• Analysed in resolving the defect change request issued by the business support team.
• Involved in the preparation of documentation for ETL standards, Procedures and Naming conventions as per ETL standards.
• Worked on XML Parser transformation to read the XSD file and build the source definition and accordingly to read the XML source file. 
• Created new Informatica Mappings with Source qualifier, Union, Aggregator, Connected & unconnected lookups, Filter, Update Strategy, Rank, Stored Procedure, Expression, Web services Consumer, XML Parser and XML Generator Transformations and Sequence Generator transformations. while transforming the Sales/Marketing data
• Designed and developed complex Informatica mappings including Type-I, Type-II slowly changing dimensions.
• Created Reusable transformations and Mapplets for use in Multiple Mappings.
• Created multiple universes and resolved loops by creating table aliases and contexts.
• Used session partitions, Dynamic cache memory and Index caches for improving performance of Informatica server.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Responsible for documentation, version control of schema and version release.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Created Mapping Parameters and Variables.
• Performed Unit-testing by generating SQL scripts based on the pre-defined test plans.
• Involved in project planning and coordinating business, source and development teams to meet the project deadlines.
• Co-ordinate with the Product Team on creating the Business reports

Environment : Informatica Power Center: 9.x, Power Exchange8.5, Oracle, AS400, SQLServer2008, SQL/PLSQL, Oracle 10g, Windows 7, UNIX, Informatica Data Quality, SQL Loader

Confidential, Mooresville, NC

Data Warehouse ETL Developer

• Performed Business Analysis and gathered requirements.
• Used Informatica Power Center to extract, transform and load data from heterogeneous systems (Oracle EBS, Mainframe systems, flat files, SQL Server) to Staging and Data warehouse (MDM).
• Interacting with Onsite people, Taking clarifications regarding applications
• Involved in writing complex SQL queries
• Analysing the requirements and discussed with managers and leads on the functionality.
• Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2008
• Wrote the SQL queries, Stored Procedures and Views. Built data connection to the database using MS SQL Server.
• Involved in creation/update data maps in Power Exchange navigator from the VSAM environment.
• Used transformations like Lookup, Union, Normalizer, Update strategy, Expression, Filter, Aggregator, Joiner, Router, Rank and Sequence generator etc.
• Extensively used the debugger and analyzed log files, using DB Unit to test the data.
• Involved in code reviews for the ETL portion of the Team deliverables
• Used Server Manager to create sessions, set source and target options and schedule batches.
• Override SQL statements in Source Qualifier and Lookups to suit extraction of desired data from desired region.
• Created mapping variables in Informatica to handle the loading date’s logic. Created a Parameter file for grabbing various Ids that vary between environments.
• Identify the bottleneck and fine-tuned Source, Targets, Mappings, Transformations and sessions for better performance
• Done unit testing for the Informatica mappings and Warehouse data against the business requirements and preparing the Technical design documents and unit test case documents.
• Involved in on call support, to resolve the production issues.
• Involved in writing the UNIX shell scripts.

Environment : SQL Server 2008, Informatica Power Center: 8.6/8.5.1, Oracle EBS, SQL/PLSQL, Oracle 10g, Cognos8x, SSIS, IBM MQ Series Windows 7, UNIX .

Confidential

ETL Developer

• Performed Business Analysis and gathered requirements.
• Assisted the Data Modelers in designing Fact and Dimension Tables based on business requirements.
• Extensively used the debugger and analyzed log files, using DB Unit to test the data.
• Used Server Manager to create sessions, set source and target options and schedule batches.
• Override SQL statements in Source Qualifier and Lookups to suit extraction of desired data from desired region.
• Developed Advance  PL/SQL packages, procedures, triggers, functions, Indexes  and  Collections  to implement business logic using  SQL Navigator . Generated server side  PL/SQL scripts  for  data manipulation  and validation and materialized views for remote instances.
• Created management analysis reporting using  Parallel Queries, Java stored procedure, HTP Package  and  WEB . SHOW DOCUMENT . Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Involved in creating  UNIX shell Scripting . Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make  Database  Faster and easier to maintain.
• Experience in  Database Application Development, Query Optimization, Performance Tuning  and  DBA  solutions and implementation experience in  complete System Development Lifecycle .
• Used  SQL Server SSIS tool  to build high performance data integration solutions including  extraction, transformation  and  load packages  for  data warehousing.  Extracted data from the  XML  file and loaded it into the  database .
• Designed and developed  Oracle forms & reports  generating up to 60 reports.
• Performed modifications on existing  form  as per change request and maintained it.
• Used  Crystal Reports  to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Worked on  SQL*Loader  to load data from flat files obtained from various facilities every day. Used standard packages like  UTL FILE, DMBS SQL, and PL/SQL  Collections and used  BULK  Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in  ETL  code using  PL/SQL  in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target  data structures.
• Involved in the continuous enhancements and fixing of production problems.  Designed, implemented  and  tuned  interfaces and batch jobs using  PL/SQL . Involved in data replication and high availability design scenarios with  Oracle Streams . Developed  UNIX Shell scripts  to automate repetitive  database processes .
• Involved in writing the MLOAD & Fast LOAD scripts to load the data into Teradata.
• Developed UNIX Shell scripts for data extraction (Fixed length file), running the pre/post processes and PL/SQL procedures for performing different database tasks.
• Done unit testing for the Informatica mappings and Warehouse data against the business requirements and prepared unit test documents.

Environment : VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting, Windows XP, Unix.

Confidential

ETL Developer (Mid-Level)

• Actively participated in understanding business requirements, analysis and designing ETL
• Involved in the Architecture Design for Confidential D2 Supply chain management.
• Translated business-reporting requirements into data warehouse architectural design.
• Involved in creating the High level and Low Level Design Documents based on the client business requirement.
• Used Informatica PowerCenter and Power connect, ODBC drivers to extract, transform and load data from heterogeneous systems (SAP R/3, Netezza, Sybase, flat files, Oracle) to (ODS) My SQL Staging and Data warehouse.
• Creating the Target structure for system by using the warehouse designer
• Used Informatica designer to create complex mappings using different transformations to Move data to a Data Warehouse.
• Created reusable transformations and mapplets to use in multiple mappings.
• Developed extract logic mappings and configured sessions.
• Handled the performance tuning of Informatica mappings.
• Responsible to test the Informatica (mappings), PL SQL (Store procedures) and UNIX to maintain the data marts (Extract data, Transform data, and Load data).
• Well versed in editing dbconfig file in power exchange for the oracle source data change capture.
• Developed customized UNIX scripts for running the daily loading ETL workflows’. stopping a workflow when the mainframe is down.
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Developed UNIX Shell scripts for data extraction (Fixed length file), running the pre/post processes and PL/SQL procedures for performing different database tasks.
• Responsible to move mapping elements to UAT, QA &PROD by Import/export as XML files, subsequently create the migration documents for UAT.QA &PROD
• Developed schedules to automate the update processes and Informatica Sessions/Batches.
• Involved fixing the bugs which are raised by QA team
• Responsible for release and delivery preparation in various iterations during the Project.
• Team Management: Monitoring & managing task status. Tracking issues and interacting with client for issue resolutions.
• Responsible to Post production support (P3 and P4)
• Scheduling the Autosys jobs based on the Unix scripts

Environment: PowerCenter:8.1.1, Oracle9i/10G, SAP R/3, SQL/PLSQL, T-SQL, XML, SAP BI7.0, SAP LSMW, BDC, MQ Series, Netezza, J2EE, My SQL, VSS, Autosys, Trillium, Sap NetWeaver, Business Objects, Windows XP, UNIX.