OVERVIEW

• A Core ETL Developer with 7 years of experience working on Analysis, Design and Development of Extract Transform and Load methodologies in all the phases of the Data Warehousing life cycle using Data Stage IBM WebSphere Datastage 8.0.1, IBM InfoSphere Datastage 8.5 and IBM InfoSphere Datastage 8.7 and Informatica PowerCentre 8.X as an ETL Tool with an Industrial Insight into Goods, Banking, Health Care Life Sciences and Education.
• Worked on Datastage components like Designer, Director and Administrator.
• Applied principles of DW like Data marts, OLTP, OLAP and Dimensional Modeling, Fact tables, Dimension tables and Star/Snowflake schema modeling.
• Expertise in Developing highly scalable parallel processing jobs which can work on multiple node configuration files using Sort, Funnel, Merge, Pivot, Lookup, Lookup File set, Remove Duplicates, Transformer, Aggregator and many other stages.
• Experience working with Heterogeneous sources like Oracle tables, Sequential files, Datasets, XML files.
• Standardizing and cleansing of data using IBM Quality Stage.
• Experience working with schedulers like Autosys, Control M and versioning tools like SVN.
• Proficient in writing Unix Shell, Perl scripts.
• Extensive experience with Oracle 10g and writing complex SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Ref Cursors, Database Objects using PL/SQL.
• Good knowledge on BI tools like OBIEE 10g, Cognos and Business Objects to create adhoc reports and validate the data.
• Worked extensively on OBIEE Administration Tool involving all the 3 layers namely Physical Layer, BMM Layer and Presentation Layer in RPD
• Extensive experience in OBIEE/ Siebel Analytics Presentation Services including Answers, Interactive Dashboards, Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher
• Well versed at Performance Tuning of Datastage jobs using IBM Standards and at the Database level by writing high performance SQL Queries/Functions/Stored Procedures using Cursors, Materialized Views and Indexes etc.
• Experience in producing project estimations, timeline scheduling, resource forecasting, communicating key milestones to IT management and clients, Task scheduling and status tracking.
• Created ETL mappings in Informatica and supported the existing workflows to load data from various sources like Oracle tables, TXT, CSV and XML files.
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.

TECHNICAL SKILLS

Professional Experience:

Confidential

Role: Senior ETL Developer

Responsibilities:

• Develop Datastage jobs to load SCD Type1, Type2 and Hierarchical Dimensions.
• Provide estimates on development of ETL jobs and weekly status reports to Project Manager.
• Build Fact less Facts from Slowly Changing Dimensions and Hierarchical Dimensions.
• Extract data from LDAP using LDAP connectivity scripts.
• Document unit test plans, perform Systems Integration Testing and deployment steps.
• Schedule the jobs using control M.
• Migration of code from one environment to the other.
• Support the existing modules by analyzing the production issues and suggesting the fixes.

Environment: IBM Infosphere Datastage 8.5, Oracle 11g, Windows XP, UNIX, SQL Developer, Control M.

Confidential

Role: Senior ETL Developer

Responsibilities:

• Gather Business requirements and prepare Technical Specifications.
• Analyze the data to develop the Data model and worked closely with DBA's to develop dimensional model using Erwin and created the physical model using Forward Engineering.
• Develop Design documents for ETL jobs and get sign off from Client side.
• Performed Data cleansing using Quality stage. Standardized Address fields using predefined rule set.
• Build ETL jobs to load data regarding Bill of materials of a warranty claim into fixed length flat files and into Teradata tables from SQL Server Database.
• Use of XML input and XML parser stage to load XML files into Relational tables.
• Developer Incremental load designs using Audit tables.
• Used Data stage Administrator for defining environment variables and project level settings.
• Scheduled Datastage jobs using Autosys.
• Created Unix Shell Scripts to automatically notify Business Exceptions and Rejects during the Loads and file processing stages.
• Used Perl script to spool data from Database into excel files for User analysis.
• Used connector migration tool to migrate from Teradata enterprise stage to connector stage

Environment: IBM Infosphere Datastage 8.7, Teradata, DB2, Windows XP, UNIX,AIX, SQL Server studio, Autosys.

Confidential

Role: ETL Developer

Responsibilities:

• Co-ordinate with the offshore development, testing and implementation teams using implementation plans.
• Develop Inbound and Outbound ETL jobs to load data from flat files and Oracle staging tables into Target Dimensions and facts like Account Hierarchy, Products, Operating Expenses, Profit and Loss, Balance sheet etc.
• Used wait for file and looping stages in Datastage Sequence to trigger the jobs based on the availability of files in Network attached storage area.
• Simulation of test data using DML statements for unit testing of jobs.
• Systems Integration Testing walkthrough and sign off with client.
• Attend User Acceptance Testing meetings and resolve issues on the fly.
• Document steps for migration and go live activities.
• Upgradation of jobs from Datastage 8.0.1 server to Datastage 8.7
• Having considerable amount of knowledge on reporting, ran adhoc reports after the fixes to verify from front end perspective.

Environment: IBM Web sphere Datastage8.0.1, IBM Infosphere Datastage 8.7, Oracle 10g, DB2, Windows XP, UNIX,AIX, Toad 10.6

Confidential

Role: ETL Developer

Responsibilities:

• Co-ordinate and work along with client and onsite counterparts in understanding the change request, development, testing and deployment
• Developed ETL jobs to build dimensions like Sales Territory Hierarchy, Physicians, Clinics etc and facts like Gain and loss Summary Monthly/Daily , Gain and Loss Details etc.
• Calculated Key Performance Indicators KPI like on hold period , 90 day loss , Gain tally count , Loss Tally counts etc used at reporting end through ETL jobs.
• Created a factless fact using surrogate keys from dimensions like Clinics, Physicians and Sales Rep's to create a relation between all the dimensions.
• Prepared Shell scripts to count the number of columns in a file to test if it is valid and as per the expected standards.
• Created SQL Functions and Stored Procedures to handle some of the business logic like calculating the Age from Date of Birth of a Patient.
• Created User training documents and PPT's to explain KPI's and their calculation and also expected file format from users to load data into the Data ware house.
• Prepared complex SQL Queries to implement business logic and test the developed DataStage jobs. Performance tuning of Source SQL using indexes and optimizing techniques. Usage of Rank, Connect by prior and many other functions in oracle.
• SVN Check in of Datastage code to maintain versioning.
• Prepare the dependencies of the jobs and schedule using Control M

Environment: IBM Web Sphere Data Stage 8.0.1 Oracle10g, UNIX,AIX Windows XP

Confidential

Role: ETL Developer

Responsibilities:

• Handled Change requests.
• Tested existing interfaces for technical and performance issues.
• Enhanced existing interfaces to meet new requirements or to fix complex issues
• Provided support for the project by solving defects and re-testing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Created UNIX shell scripts to execute the test Queries at the back end after the loads.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Performance tuning of various jobs by following IBM tuning Standards
• Performed Code Review and involved in UTP and SIT Documentation.

Environment: IBM Web Sphere Data Stage 8.0.1, Oracle10g, UNIX, Windows XP

Confidential

Role: BI Developer

Responsibilities:

• Handled Change requests for Hyperion Reports.
• Solving Production issues as per SLA's
• Involved in Support and Maintenance activities by ensuring the servers are up and running fine.
• Giving access to users and publishing of System9 reports.
• Used the OBIEE Admin Tool to develop the three layers in the Repository RPD . Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the RPD. Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created Proactive agents iBots and configured Interactive dashboards to alert the employees as per the requirements.
• Built parameter page using image prompts that enables users to visually select the input parameters.
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Optimized and tuned existing ETL mappings using Informatica SQL and PL/SQL .
• Maintained, supported, and created ETL scripts for the inbound and outbound systems.
• Managed the load and extraction of data to over seventy internal and external systems

Environment: SYSTEM 9 and OBIEE 10g, Oracle 10g, Informatica Powercenter 8.X,Unix,SQL/PLSQL,Toad

Confidential

Role: ETL Developer

Responsibilities:

• Understanding the business functionality Analysis of business requirements.
• Extracting data from sources like oracle, flat files and transforming them using business logic and loading the data to the Data warehouse.
• Extensively used processing stages like sort, aggregator, transformer, join Stages in developing jobs.
• Performing unit testing on the jobs developed.
• Preparing the Test Case Document and capturing the test results.
• Used Sequence jobs to control the flow of DataStage jobs.
• Built SQL Queries to replicate complex ETL job by using with clause, Functions, Stored Procedures.
• Prepared Shell scripts to handle batch processing.
• Used CDC stage to implement SCD type1 and type2 Dimensions.

Environment: IBM Web Sphere Data Stage 8.0.1, Oracle10g, UNIX, Windows XP

Confidential

Role: ETL Developer and Tester

Responsibilities:

• Develop ETL jobs which serve to load data from various heterogeneous sources like .txt, .csv files, oracle tables etc.
• Develop Datastage Sequences to run Datastage jobs by using triggers one after the other
• Test the ETL jobs by writing SQL scripts which replicate the Technical Specifications.
• Perform Integration testing to make sure nothing is broken.
• Reconciliation of data from source to target.
• Raise Defects in HP Quality center and track them.

Environment: IBM Web Sphere Data Stage 8.0.1, Oracle10g, UNIX, Windows XP