SUMMARY

• 11 Years of Information Technology experience in Banking,Insurance,Legal,Manufacturing & Logistics domain
• Good knowledge of Data - Warehousing and Business Intelligence concepts
• Worked on several ETL development projects for Data-Warehouse, Data-Migration and ETL tool conversion
• Experience in Hi Level & Low level ETL design, data-modeling, data migration/integration methodology, developing strategies for Extraction-Transformation-Loading (ETL) mechanism, development, unit-testing and integration testing using various ETL tools and techniques
• Good exposure to Data Validation, Data Quality Analysis and Data Cleansing activities.
• Expert in due-diligence for scoping, source system analysis, target system requirements, volume analysis, data acquisition strategy, data quality analysis, business requirements for a data warehousing and data migration projects.
• Good knowledge of database architecture and concepts; proficient in Oracle, SQL, PL/SQL Programming & UNIX Shell Scripts and PERL scripts
• Good troubleshooting/debugging, technical problem solving skills and well versed with IBM Datastage parallel extender versions 7.5.3, 8.1,8.5,8.7 & MVS edition 8.1
• Experience to work cohesively with onsite-offshore project model. Provide estimates for the design and development of requirements.
• Mentoring junior team members on best practices in ETL code design.
• Ability to come up with solutions for complex technical design problems.
• Experienced in full project life cycle and processes (Initiating, Planning, Executing, Monitoring & control and Closing)

TECHNICAL SKILLS

• DataStage PX 7.5.3, 8.1, 8.5, 8.7 & MVS edition 8.
• Datastage SAP R/3 & SAP-BW PACK
• Quality Stage v8.0, Information Analyzer 8.0.1
• Informatica Power Center 7.1.1
• OBIEE 10g, 11g
• UNIX, Linux, AIX, OS-390 Mainframe, MS-DOS, Windows XP, NT Server 4.0, 2000/98.
• Oracle PL/SQL, UNIX Shell Scripting, Perl Scripting, C,C++

PROFESSIONAL EXPERIENCE

Confidential, NEW JERSEY

Data Architect

Responsibilities:

• Participate in requirement gathering discussions with BA and Business users to finalize the functional requirement document for the project
• Design & Implementation of ETL framework utilizing IBM Data Stage 8.x, SQL and UNIX shell scripting.
• High level Designing of ETL frame work utilizing re-useable and multi-instance components ensuring optimal code design for quick delivery of the project and low maintenance
• Mentoring Confidential team members on best practices in Datastage software code design.
• Assisting project lead in project planning and work distribution among team members
• Provide estimates for the design and development of requirements.
• Work collaboratively with business users to understand requirements and interactively develop and test solutions
• Detailed knowledge and understanding of Data Warehousing concepts including Data modeling of Star schema & Snow flake schema databases
• Develop and automate ETL (Extract, Transform and Load) processes that follow best practices and include proper process controls that meet SOX standards for financial applications.
• ETL Performance Tuning and Database Query optimization for various types of databases such as Oracle, DB2 and SQL server
• Post release production support (24X7) on rotating basis with other team members. Certain critical production issues included development of insert / update / delete SQL script, testing and implementing in production environment to support business. Meeting Business SLA’s to ensure timely refresh of Datamart to enable users to perform critical reporting on time.

Environment: IBM Data Stage Enterprise Parallel Edition 7.5.3, Oracle 11g, Linux, PL/SQL Developer, Shell Scripts

Confidential

Responsibilities:

• Requirement gathering for Revenue allocation & Transportation Reporting Datamart.
• Preparing Mapping document for data elements to be populated from operational system to Datamart
• Participated in Dimensional Modeling of the Revenue Allocation Datamart
• Designing of overall approach to Extract, Transform and Load Data into Datamart
• Development of Datastage jobs as per design document to populate data in the Datamart
• Unit testing, Integration testing of Datastage jobs
• Developing shell scripts for job scheduling and report generation for balancing the operational system extract to Data loaded in the Datamart
• Designing and developing checksum and control logic to compare the extracted Dollar Amount from source system to loaded Dollar amount in the target Datamart
• Testing OBI reports developed by the end users and recommending suggestions to end users for improvement of performance of the OBI reports.
• Post implementation support for ETL and OBI RPD and Report migration

Environment: IBM Data Stage Enterprise Parallel Edition 7.5.3, Oracle 11g, Linux, PL/SQL Developer, Shell Scripts, OBIEE as reporting tool

Confidential

SENIOR CONSULTANT

Responsibilities:

• Requirement gathering and designing road map for each conversion object
• Project required understanding of the source Legacy system and develop mapping document to map the source fields to Target SAP system.
• Source system included xml data from MDM, Sybase database, JD Edwards, Sequential files and MS SQL Server.
• Writing UNIX shell scripts to automate FTP of target files from Datastage server to windows shared drive.
• Database analysis of source and target systems.
• Development of Datastage PX jobs using Datastage 8.1
• Handled XML Data in Datastage using XML input and XML output stages.
• DataStage PACK for SAP R/3 & BW used to extract and load data in SAP system.
• Handled Conversion Modules for Master Data & Transaction Data. Vendor Master, Open sales order, Pricing Condition, Open Purchase Orders, Purchase Info Records
• Unit testing and Data Integration testing.

Environment: IBM Data Stage Enterprise Parallel Edition 8.1, MSSQL Server, Sybase DB, AIX v5.x, SAP R/3, UNIX

Confidential

SENIOR CONSULTANT

Responsibilities:

• Gathering ETL specifications for Data migration solution
• Designing the Migration solution from Extraction of source data from Mainframe system to loading in staging oracle repository and then Transforming the data to map to Target Confidential system.
• Discussion with the end users for data field specifications
• Database analysis of source and target systems.
• Development of Datastage PX jobs using Datastage 8.1
• Unit testing and Data Integration testing
• Writing UNIX shell and PERL scripts to perform automation and intermediate transformation tasks.
• Handled conversion modules for Checksum, Online Banking and Migration of Customer Signature Database from Source to Target system.

Environment: IBM Data Stage Enterprise Parallel Edition 8.1, oracle 9i, DB2, SQL Developer AIX v5.x, UNIX shell scripts, PERL scripts

Confidential

SENIOR CONSULTANT

Responsibilities:

• Preparing in house development and test environment to execute the project in Confidential
• Installing Datastage v 8.0 on AIX platform
• Analysis of the Informatica Mappings
• Designing Datastage PX jobs using X-Migrator Tool.
• Development of the Datastage PX Jobs using Datastage 8.x
• Consolidation of Job Designs and Fixing Jobs as per Informatica Mappings.
• Unit Testing of the Datastage PX Jobs
• Comparing the Datastage job output to Informatica Job outputs. Recording the test results
• Delivering the Datastage job export as ‘.dsx’ file to customer for deployment on client servers.

Environment: IBM Info Sphere Information Server v8.x, IBM Data Stage Enterprise Parallel Edition 8.x, Informatica Power Center 7.1.1, Oracle 9i, Aqua Data Studio 4.5.2, AIX v5.x.

Confidential

Data Architect

Responsibilities:

• First Phase (Onsite): Participated in due-diligence for scoping, source system analysis, target system requirements, volume analysis, migration window determination, data quality analysis etc.
• Participated in Kick-off meeting to formally start the project.
• Second Phase (Onsite): Coordination of the onsite team
• Mentor junior team members technically with Datastage ETL code design.
• Development and coding of Liability Insurance Module
• Report daily task status and participate into weekly conf. call with the client and offshore coordinator
• Participate into meeting with Module leads and solution architect to discuss and resolve the issues.
• Review Hi level - Low level ETL design.
• Review and finalize design guidelines for ETL developers, design documents, processes and configuration management for the migration.
• DQA (Data Quality Assessment): Gather the requirement of profiling by Business Users and Module Leads.
• Checks dataset & matching copybooks on client’s mainframe by using FAID.
• Creates relational views of z/OS sources (IMS, Sequential dataset) by using Classic data Architect.
• Import data into Information Analyzer and associate the data to the related Module for data profiling.
• Schedule / Run the column analysis. Generate reports based on data profiling for analysis to business users.
• Third Phase (Offshore): Managed and supported offshore team technically during testing, bug-fixing & UAT phase.
• Data Quality Assessment (performed data profiling iteration-3 successfully from offshore.

Environment: IBM Information Analyzer 8.0.1, IBM DataStage MVS edition v8.0, Classic data Architect v9.1, Mainframe.