CAREER OBJECTIVE:

Seeking a Tech Lead/Sr Developer/Data Analyst position within an established organization where my 12+ years of corporate IT experience will result in the contribution to the success of the company as well as personal growth.

SUMMARY:

• Around 13 years of IT experience in DW Architecture, Development, Enhancement, Maintenance, Production support, Data Modeling, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses for Finance, Insurance, Sales domains. Well Verse of Agile Methodology.
• DWH Technologies - Netezza development and design of ELT methodology spanning SDLC phases such as Requirements Analysis, Data Analysis, Application Design, Data Modeling, Application Development/support, Implementations and Production Control Phase of Data warehousing of enterprise level business applications. Conducted ETL development in the Netezza environment using standard design methodologies.
• Hands on experience using Informatica Power Center 9.5.1/8.6, Data Stage 8.1/11.3, SSIS and Extensive Knowledge in ODI (Oracle Data Integrator).
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplet, Sessions, Work let, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experience in Data Modeling using Dimensional Data modeling, Star/Snowflake Schema modeling, FACT and Dimensional tables, Physical and logical data modeling.
• Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
• Expertise in doing the RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows.
• Worked on partitioning and creating indexes on tables used in source qualifier queries. Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Expertise in designing and developing Informatica/Data Stage mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• Experience in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, VSAM, Mainframe Files, Oracle, Netezza,Teradata, SQL Server,.
• Completed the training in TC-IBM Rational Team Concert - Source Control. Well verse in using RTC Source Control & Star team.
• Expert on Siebel EIM/ETL (Informatica/Data Stage) process for Data Loading (Import, Export, Merge, and Delete process) and well verse in Siebel Data Model and Data Migration process. Strong knowledge and experience in Siebel EIM developing Configuration (IFB) files and EIM jobs with working knowledge in SQL, PL/SQL and UNIX
• Strong skills in analyzing the database design, Coding using SQL and PL/SQL, Oracle 11g/10g/9i, SQL Server, Teradata V14, SQL*Plus and Sybase database applications. Coded Stored Procedures, Packages and Triggers using PL/SQL, Netezza.
• Proficient in ETL tools like Informatica/Data Stage/SQL Loader/DTS and also in PL/SQL, Store procedures, BAT Files, FTP, Shell Scripts, UNIX. Expert Level of ability to schedule the batch jobs using CA 7 Scheduler, Autosys, JCL Packages, Gentran FTP Process.
• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• Automation, Scheduling and monitoring of jobs with scheduler AutoSys/CA/CA 7.
• Management skills include Team Management, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.
• Ability to adjust to the people, circumstances & responsibility, with a Drive for results through self-motivation & self-candor.

PROJECT DETAILS:

Confidential, Charlotte, North Carolina

Responsibilities:

• ETL design solutions, Data Modeling (Power Designer), ETL Implementation in Informatica (PDO) and Netezza, Reviewing and Migrating Informatica code as part COE, working with Business Analysts to understand requirements.
• The project is also to modularize the current system which is built in Teradata SQL scripts to be converted to Netezza using Netezza ETL scripting and Informatica ETL.
• Worked extensively on Shell Scripting for modification of the parameter data, FTP files, Zip/Unzip files, File Watcher, File count check, etc.
• Provided production support for the Daily & Monthly Batch Jobs and involved in the debugging the root cause/Resolution of the current production issue within the estimated window
• Designed ETL architecture to bring different sources( files and DB tables) into common format and create input files for calculator from then all the steps are same even the source system is different.
• Involved in writing complex reporting view SQL needed for reporting team.
• Involved in performance tuning and optimization of ETL mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.

Confidential, Charlotte, North Carolina

ETL Tech lead

Responsibilities:

• As an ETL Lead, the main responsibilities included Performance Tuning, Error Handling, and Implementation of Best Practices.
• Involved in Project Effort estimation - Prepare a breakdown of tasks involved in a project, assess complexity, parallel tasks & estimate effort involved in each of the tasks
• Developed technical specifications of the ETL process flow using Informatica as ETL in Oracle & SQL Servers. Uses SSIS for multiple service call projects
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQL Server and Oracle.
• Used Informatica Power Center 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).
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation. Worked with Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor. Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Used various tools like Informatica 9.x/8.5, Data stage 8.6/11.x, Toad and Siebel 7.8.2.3, Data Stage, Unix, OBIEE 10.1.3, Teradata V 14 and also various version control tools like RTC Eclipse Source, Star Team,.
• Interacted with the Business Requirements and the design team and prepared the Low Level Design documentation studying the High Level Design documents implementing Account, Contact and Activity management modules.
• Involved in Data Mapping for loading the Legacy data and prepared complex Oracle/Teradata SQL queries, configured and optimized configuration (.IFB) files to run EIM job for data load.
• Using SQL plus database application tool wrote complex SQL queries against other Legacy Systems to retrieve data and validate it for Siebel Import process.
• Involved in creating Unit Test case and in Preparation of Test Logs which is used for Designers to Review the Technical Implementation.
• Worked with the Production support team to resolve the issues and with the implementation teams for successful srf fixes on Test and production environments.
• Worked on Major production related Issue like Data Defects/Performance/Tuning. Provided perfective solutions for the existing ETL/EIM process to improve performance (Both OLTP & OLAP).

Confidential, Milwaukee, Wisconsin

Siebel Data Architect

Responsibilities:

• Responsible for understanding legacy data entities and functions across the Siebel Application, Legacy data migration approach, processes and conversion architecture with a specific emphasis on Informatica /SSIS ETL to migrate the data from Siebel to Dynamics CRM
• Responsible for the Design, development and implementation of ETL using Informatica and SSIS, for the upcoming releases and also the POC’s involved to demonstrate the Siebel Integration capabilities for the current Siebel Integration functionalities.
• ETL Tools - Informatica 9.x/8.x Informatica Power Exchange

Confidential, Charlotte, North Carolina

Senior Developer

Responsibilities:

• Worked on 6 different projects in the span of 4 years other in the Siebel Financial & Call Center Application and also on OBIEE on Enhancement/Support of the Reports.
• Generated many complex reports and helped business and IT teams in resolving many data related issues/inconsistencies.
• Developed the ETL (Informatica) Processes like Mappings & Maplets using various Transformations and workflows with Sessions/Tasks. Executed the workflows with Shell Scripts.
• Used various tools like Informatica 7.1.3, Informatica 8.6, Toad and Siebel 7.8.2.3, Data Stage, UNIX, OBIEE 10.1.3, Teradata and also various version control tools like RTC Eclipse Source Control, Star Team, Stat.
• Responsible for architecture and software design documents, technical design and development for new projects.
• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support
• Developed PL/SQL procedures and functions and used the same in mappings, pre and post sessions.
• Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
• Involved in designing and developing the data load process into Siebel from External Legacy system.

Confidential, Fishers, Indiana

Onshore coordinator

Responsibilities:

• Worked closely with business analysts to understand the requirements, needs and use cases for Synchronization of data.
• Involved in designing the ETL Strategy for the application. Designed and created required mappings for effective ETL procedure development and implementation
• Involved in design and development of Informatica 7 processes to bring the data from legacy Database to Siebel.
• Involved in the complete production support of the Siebel sales Application and also the enhancement changes.
• Involved in the development of the Inbound Web service and in the enhancement of the Application
• Involved in the development of Informatica mapping & workflow.

Confidential

ETL Team Leader

Responsibilities:

• Involved in the Low Level design, Mapping and Development Stage for the Business Entities.
• Responsibilities include designing and developing the EIM related deliverables and performing the conversion in the production.
• Involved in design and development of PL/SQL Interface to bring the data from legacy system to Siebel.
• Involved in loading of data of different Business Entities to the Siebel Base Table.
• Involved in the development of the BATCH files to automate the Batch load process for all the entities from different Systems which includes Import/Updated/Merged/Deleted process.
• Development of deliverables for the Integration to automate scheduled process using BAT and FTP Files.

Confidential

ETL Team Developer

Responsibilities:

• Responsibilities include designing and developing the EIM related deliverables and performing the conversion in the production.
• Involved in design and development of Informatica processes to bring the data from legacy system to Siebel.
• Involved in the Low Level design, Mapping and Development Stage for the Business Entities.
• Involved in loading of data of different Business Entities to the Siebel Base Table.
• Development of deliverables for the Integration to automate scheduled process.