SUMMARY

• 15+ years of extensive IT experience in the areas of Data Warehousing technology and Data Integration Support Systems using IBM Information Server 7.x/8.x/11.3 IBM DataStage with various clients in several business domain such as Insurance, Telecom, Airlines, Retail, Railroad & Health Care.
• Strong experience in developing strategies for Extraction, Transformation and Loading from various data sources like Legacy Systems, Oracle, SQL Server, DB2 databases and Flat files systems into Data warehouse and Data Marts by using IBM Data Stage.
• Extensive experience in the areas of analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, BI, UNIX & OLAP.
• Rich experience in Requirement gathering, Requirement analysis, Development, Coding, System Testing, Integration Testing, Unit Testing, Validation, Defect analysis, bug fixing, documentation and suggested process improvement.
• Extensively worked on Data Stage job design, development, scheduling, execution, testing and defect fixing.
• Extensive experience in RDBMS technologies like Oracle, DB2 Informix, Teradata and Vertica
• Involved in very large scale data migration solution and Data Analysis, Data mapping, Data Quality and integration of disparate source systems.
• Expertise in Designing Parallel jobs using various stages and extensively worked on Job Sequences to control the execution of jobs flow using various activities.
• Involved in creating the logical and physical design of the Data Warehouse (Fact and Dimension tables) using Star Schema and Snow Flake schema approaches.
• Experience in interacting with Onshore/Offshore Support Model for application support as well as mentoring junior developers in offshore while developing code.
• Expert level skill in Datastage code reviews for helping in minimizing data processing flaws.
• Strong experience in debugging code, issues tracing in production, identifying root cause of defect and contributing in resolving issues.
• Experience in creating required documentation for production support hand off, training production support team on commonly encountered problems.
• Good experience in working and communicating with Project Managers in providing estimations for development efforts to meet the project milestones and deliverables.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture

TECHNICAL SKILLS

Primary Skill category: Datawarehousing, ETL, SQL, Datastage 8.x, 9.x and 11.x, Informix 4GL, Unix Shell scripting and Service Management.

Secondary Skill category: Project Management, Informix Database, Teradata Database, Splunk tool and Vertica Database

Tools: Control M, TOAD, SQL Developer, PL/SQL Developer and Teradata SQL Assistant

Domain Skills: Healthcare & Life Science, Telecom, Railroads, Retail, Airlines, Reinsurance and Insurance.

PROFESSIONAL EXPERIENCE

Confidential

ETL architect

Responsibilities:

• Gather business requirements by interacting with business analysts.
• Work with the database administrators in identifying and designing the primary and secondary indexes for each of the objects involved as we dealing with 21 million records.
• Deploying the application in the Validation environment and initiate the process of user acceptance testing.
• Gather information to determine sources, targets, define data relationships and develop data quality metrics.
• Prepare technical specification for extraction, transformation and load for each of the subject areas.
• Inspect/Review the code for the change requests.
• Conduct review of work products to ensure development standards are being met.
• Examine unit test cases and system integration test cases.
• Interact and coordinate with Operations team to immediately address production issues that may arise.

Confidential

ETL architect

Responsibilities:

• Gather business requirements by interacting with business analysts.
• Discuss business solutions to resolve existing problems and improve the application stability.
• Work with the database administrators in identifying and designing the primary and secondary indexes for each of the objects involved.
• Deploying the application in the Validation environment and initiate the process of user acceptance testing. It includes fixing of bugs and fixing technical errors that may come up during this phase.
• Gather information to determine sources, targets, define data relationships and develop data quality metrics.
• Prepare technical specification for extraction, transformation and load for each of the subject areas.
• Inspect/Review the code for the change requests.
• Conduct review of work products to ensure development standards are being met.
• Examine unit test cases and system integration test cases.
• Interact and coordinate with Operations team to immediately address production issues that may arise.

Confidential

Technical Lead

Responsibilities:

• Validate understanding of the requirements through interactions with the NS team
• Understand the existing AS - is landscape
• Clarify issues for the development team
• Interact and co-ordinate the efforts of the release team during development, design and testing
• Develop and maintain the technical low level design per the scope and maintain traceability
• Understand and validate the solution infrastructure
• Define the common libraries required for development
• Review all artifacts
• Post Deployment Support
• Allocate tasks to teams to ensure completeness and correctness of implementation
• Raise queries to, and resolve queries from NS team on technical and delivery matters

Confidential

Technical Lead

Responsibilities:

• Frequent customer Interaction with clients to determine User requirements and goals.
• Created the design and technical specifications for the ETL process of the project.
• Designed the Data warehouse, created fact and dimension table.
• Created Data Mapping documents from source to target for the ETL mappings
• Responsible for helping to capture business requirements, identifying appropriate data sources, data quality issues, business transformation rules, mapping source to target
• Developed several reusable components to reduce the development effort.
• Developed complex ETL Data stage jobs based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Involved in extensive Data validation using SQL queries and back-end testing
• Created Box, Command and File Watcher jobs to automate jobs for each subject area
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Building the SQL queries for Teradata, Oracle to fetch the data from the Database as per the business requirement and use the SQL queries in the DataStage for further processing
• Performed quality assurance reviews on all Software Development Life Cycle.
• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Creation, error log creations and log file cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written UNIX scripts for invoking data reconciliation.

Confidential

Service Lead

Responsibilities:

• Analysis of the requirements provided by the requester/business/end users Estimation, system design and authorizations/approvals -
• Project planning, work allocation, progress monitoring - Specification preparation, Coding and reviews -Testing - unit testing, system testing & integration testing; aid user testing
• Implementation, callout and production support
• Offshore coordination, issues resolution, client expectation and -Staff management.
• Frequent customer Interaction with clients to determine User requirements and goals.
• Actively participated in data analysis, bug fixing, coding, code review, and end to end integration testing as part of data Integration through DataStage.
• Actively participated in various phases of the enhancement project such as requirement gathering, designing, high level design document, low level design document development, Integration testing and deployment.
• Involved with Business users and ETL Leads from different teams to implement ETL Frame Work using DataStage Server/Parallel combination of jobs and migration of data from various sources.
• Extracted data from various sources like Oracle Database, Flat Files and CSV files and loaded to target warehouse.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup file Set, Remove Duplicates, Change Data Capture, Switch, Modify, and Aggregator.
• Involved in developing DataStage Designer Server and Parallel jobs for Extracting, Cleansing, Transforming, and Integrating/Loading Data into Enterprise Data Warehouse (EDW).
• Extensively used Datastage Director to Monitor and check the run statistics of the Jobs and to clear the job logs, job resources.
• Frequent Customer Interaction with reference to production issue resolution and business requirements.

Confidential

Project Lead

Responsibilities:

• Communicating with the Onsite Team (UK) and other team members which were based in Malaysia & India.
• Ensuring that all possible issues that may arise during the course of migration is addressed and communicated to Onsite Team.
• Tracking and ensuring that deliverables are done as per the schedule
• Attend the weekly update meeting with the client.
• Work distribution and team management
• Development - Coding, review
• Client communications