Summary:

• Around 7 years of total IT experience in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications, Client/Server Applications, using Object Oriented Analysis, Design and Methodologies.
• Around 7 years of experience as Systems Analyst and ETL methodologies in all the phases of the Data warehousing life cycle.
• Experience in Data Quality Anaysis, documentation and SQL.
• Experience working as a Business Analyst.
• Around 7 years of experience in DataStage Server and Enterprise Edition using Components like Administrator, Manager, Designer, and Director.
• Experience in DataStage Parallel Extender Formerly known as DataStage PX for Parallel Processing to improve job performance while working with bulk data.
• Extensive experience in database design for data warehouses with strong understanding of Star and Snowflake Schemas.
• Experience in logical and physical data modeling skills with emphasis on Dimensional Data Modeling.
• Extensive experience of gathering business requirements, technical specifications, documenting them, and converting them into robust system designs.
• Knowledge of full life cycle development for building a Data Warehouse.
• Knowledge in ETL and Data warehousing and OLAP technology using DataStage, BI tools Business objects and Cognos .
• Experience in SQL, SQL PLUS, PL/SQL and developed Stored Procedures
• Expertise in using TOAD and PL/SQL Developer tools.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning, System Testing.
• Knowledge in various data bases like Oracle, MS SQL Server and DB2 .
• Proven track record in troubleshooting of DataStage Jobs and addressing production issues such as performance tuning and enhancement.
• Strong writing and documentation skills for the management, development and control of documentation.
• Excellent team player with good organizational, communicational, interpersonal analytical skills.

Technical Skills:

Professional experience:

Confidential

Data Quality Analyst

Responsibilities:

• Responsible for the analysis and implementation of RMRA Release 2.0 Commercial ERA Sandbox related project.
• Develops and oversees Sandbox improvement initiatives as they relate to RMRA and ERA operations and serves as liaison between RMRA, ERA and all other functional areas within organization in an effort to identify and resolve operational implications as they relate to RMRA Release 2.0 initiatives
• Analyze and resolve complex issues related to data provider, membership, claims, etc.
• Identify root cause and recommend solutions to RMRA Release 2.0 Commercial ERA Sandbox data issues.
• Perform data extracts to identify data discrepancies.
• Identify defects in the technical solutions for RMRA Release 2.0 Commercial ERA Sandbox projects and track resolution to defects.
• Identify enhancements to technical solutions, write up enhancements and track enhancements through the development process.
• Develop procedures/controls and provide recommendations for the ongoing improvement of the related processes
• Identify and execute process improvements in the loading and extracting of data from the Commercial ERA Sandbox
• Develop and improve workflows and business processes.
• Identify changes to policies and processes to improve quality and timeliness and decrease operational costs.
• Working closely with Business Team providing support in Analysis.
• Providing BCBSM Standard documentation for Data Models, Process Flows and Desk Levels.

Confidential

DataStage Analyst

Responsibilities:

• Created Processes using Datastage 8.5, 8.7, DB2, Oracle 11, SQL Server 2008, Fast Track.
• Involved in preparing Mapping documents, BRD and Functional Documents.
• Involved in Data Quality and Data Validation.
• Created DataStage process design documents and run book for production support.
• Created ETL jobs extracting data from different sources and loading to IBM CBI EDW Model
• Worked on improving performance of ETL jobs which extract data from Oracle and load to DB2 UDB.
• Involved in loading the source data into DB2 production tables using ODBC, Transformer, Lookup, Join, Sequential File , Sort Stage ,Modify and Remove Duplicate Stages to load and from test tables as final claims and raw claims and doing a data quality checks.
• Involved in writing implementation plans for the AR Actions Request .
• Worked in Agile Development methodology.
• Worked closely with Business Analysts to understand and analyze the business requirements.
• Worked on Test case execution initial and Delta and fixing defects.

Environment: IBM Information Server 8.7 , DB2 UDB, Oracle, IBM Fast Track, TOAD, Sql Server, Unix.

Confidential

DataStage Analyst/Developer

Responsibilities:

• Worked on creating jobs for IPA Integrated Pricing Analysis Project using Sequential file stage, Sort, DB2 connector, Aggregator, Transformer.
• created a script which will move the files to archive and removes the files from archive
• Working on process changes to current ETL jobs to improve performance.
• Worked on production support.
• Involved in supporting the DWH users in reset the passwords, deactivating and activating the user accounts.
• Performing Data quality checks before the users have the access to the data.
• Performing various daily tasks of Monitoring long running Sql Queries and helping the users in resolving the long running Sql.

Environment: IBM Information Server 8.1 , DB2 UDB, Control M, IBM Clear Case, TOAD, WINSQL, Unix.

Confidential

DataStage Developer

Responsibilities:

• Involved in redesigning the existing ETL jobs, which are delivered by people soft on HCM/EPM environment to increase the execution time.
• Involved in minimizing the hashed file stages and re writing the sql code when extracting the data from the database.
• Involved in removing the existing code and writing new sql scripts in ETL jobs to minimize the execution time.
• Minimized the number of Sequences the jobs are using for optimum performance.
• Involved in removing DRS stage and replacing with OCI stage in some of the ETL jobs.
• Troubleshoot the failing sequences overnight, redesigning the existing sequences and creating mail activity notifications.
• Created the SSIS jobs in SQLserver2005 for loading the Financial Aid data into ODS data mart for analyzing the student enrollment process.
• Created the DataStage jobs for loading the SQL server ODS data into Oracle data warehouse into People soft EPM tables.
• Used DRS stage, OCI Stage, ODBC stage, and Link Partitions stages for the process.
• Involved in redesigning, testing and implementing the delivered ETL jobs
• Involved in on call support 24/7.

Environment: Data Stage 7.5, SQL server 2000 /2005, Oracle 9i /10g, People soft 9.0, SQL Server reporting.

Confidential

DataStage Developer

Responsibilities:

• Involved in requirement gatherings and designing and modifications of tables and EDW MPM Data Mart according to the business requirements.
• Analyzing the source data and data profiling working with business analysts, team lead and project manager
• Designing logical and physical design data modeling with start schema using Erwin.
• Designed ETL jobs using designer server edition to extract and load the data by applying rules in the transformations, using hashed files, Merge, OCI stages
• Writing SQL statements to improve the performance of the jobs and tuning the SQL statements
• Designed Sequences to run the jobs and monitoring the jobs
• Involved in System Testing and Unit testing of jobs.
• Involved in writing routines to adjust the load dates and time.
• Exporting the jobs to Testing Environment from Development and then to Production.
• Used DataStage Director to schedule and monitor the performance of the jobs.
• Involved in creation of various reports which includes weekly reports, bi-weekly reports, reports by Group, reports by Product and Sub-product
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail, Slice Dice and Drill Down.

Environment: IBM WebSphere DataStage 7.5 Designer, Director, Manager, and Administrator , SQL Plus, PL/SQL, Oracle 9i, Erwin, TOAD, SQL Builder.