Professional Profile

• 13 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Extensive experience with analysis, design, development, customizations and implementation of software applications.
• Proficient in analyzing and business requirements to technical requirements.
• Strong database and Data Warehouse skills, Programming and development knowledge
• Experience in leading and managing teams. Handled multiple roles - Team Lead, Designer, and Developer.
• Executed software projects for Healthcare, Pharmaceutical, Banking, Mutual Fund, Telecom, Retail, Manufacture and Process industry
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Strong leadership qualities, excellent motivator, very good team player

Skill Set

Tools: IIS version 9.1, 8.7, 8.5, 8.1, Data Stage Ver 9.1, 8.7, 8.5.0, 8.0.1, Information Analyzer, FastTrack, AB-Initio, Informatica, TOAD, HP Quality center, RPM, Rational - Clear Case

RDBMS: Oracle 9i/10/11 G, Oracle 8i, MS SQL Server, DB2

Languages: Pro C, C, PL/SQL, Shell, NDM

O/S: Windows 2000 Server, Windows NT Server, Windows XP, Linux 5.5 , AIX, Sun Solaris

Applications: Autosys Installation, coding and deployment , NDM, Developer 2000, Reports 6i, Forms 6i

Processes: IBM's QMS Quality Management System , QPAC level 2, BI Process

Professional Experience chronological order Project

Confidential

Role: Senior Data Warehouse and ETL Developer

Environment: IBM Information Server Version 8.1, 8.5, Oracle 11.2, Autosys, Windows NT, Linux server

Description:

• ETL requirement gathering and Software Systems design, development and documentation.
• Development of Data Stage functionality for Obama Care PPO and HMO.
• Develop the XML file for submission for the Enrolment, Claim, HIP Health Insurance Program and HIX Health Insurance Exchange program , and Risk assurance.
• Preparing Jobs and Job sequences with particular audit information with mailing facility.
• Preparing different ETL job design standards.
• Testing all the Jobs with preparing test plan and test specifications.
• Responsible for time estimates, scheduling and status tracking.
• ETL System Maintenance and Support in critical issues.
• Support existing jobs at the PROD environment.

Confidential

Role: Senior Data Warehouse Developer, Platform Support Engineer and Admin.

Environment: IBM Information Server Version 8.7, 9.1, 8.5, 8.0.1, Data Stage Version 9.1, 8.7, 8.5, 8.1.0, 8.0.1, Information Analyzer, Infosphere CDC, Infosphere Metadata Workbench Oracle, Teradata, Windows NT, Linux server

Description:

• POC and Datastage Development of DS Jobs based on the specific requirement new multiple servers.
• POC of Datastage development at Vblock Linux server.
• Datastage Jobs development for additional requirement using several PX active and passive stages.
• Support existing jobs at the PROD environment.
• Development of Datastage functionality for migrating old system data to merge with the current system.
• Testing all the Jobs with preparing test plan and test specifications for that.
• Data Analysis of old system and merged new system and perform SQL query analysis for Oracle DB.
• Data analysis of different RDBMS source and target system with the SQL query.
• Monitoring and Analysis on Source and Target Relational Databases.
• Analyze of ETL Software and Hardware Requirements
• Plan for special activities during Month end/Quarter end/Year End
• Responsible for time estimates, scheduling and status tracking
• ETL Software Systems design and documentation
• WAS installation and configuration
• Datastage server installation, admin configuration, environment setup and migration.
• LDAP and PAM Configuration after DS installation.
• ETL System Maintenance and Support in critical platform issues
• Automate the production support to maximum extent to avoid manual intervention.

Confidential

Role: Senior Data Warehouse Developer and Designer,

Environment: IBM Information Server Version 8.5, 8.0.1, Data Stage Version 8.5, 8.0.1, Information Analyzer, Teradata, Windows NT, AIX-Unix server

Description:

• Deliver high level design solution for the critical business requirements.
• Developing all kind of Data Stage Jobs and Job sequence, based on the functionality.
• Preparing test specifications and perform unit, Integration test.
• SQL data analysis of source and target system.
• Data Profiling and DQ analysis using the IIS Information analyzer.
• Helped on Business Glossary to the designated person for BG.
• Source to Target data mapping through FastTrack and maintain the same metadata in the DS.
• Different legacy source system analysis and making rule to be compatible for the data integration.
• Capturing business requirement prepare HLD and LLD documents.
• Responsible for effective communication amongst the Bank of America Clients, SMEs, project team, analyst, data modeler and the clients.
• Preparing required technical solution, that meets all expected and committed business requirement.
• Performing and ensuring other team members for unit and integrated testing.

Confidential

Role: Onshore Data Warehouse Senior Developer,

Environment: Data Stage Version 8.0.1, Oracle 10G, Windows 2000, AIX-Unix server

• Getting requirements from analyst, data modeler and the clients.
• Designing and Developing Data Stage version 8.0.1 Jobs, based on the functionality and testing.
• Reviewing the DS jobs before delivery.
• Capturing business requirement prepare HLD and LLD documents.
• Deliver high level design solution for the critical business requirements.
• Preparing required technical solution, that meets all expected and committed business requirement.
• Prepare and review the technical deliverables prepared by the team.
• Maintained required quality and standards of all deliverables that was delivered.
• Leading and coordinating the whole development team.

Confidential

Role: Onshore DWH Development,

Environment: Data Stage Version 7.2, Oracle 9i, Windows 2000

• Getting requirements from clients Business team.
• Designing and Developing Data Stage version 8.0.1 Jobs, based on the functionality and testing.
• Peer reviewing the DS jobs for final delivery.
• Responsible for lead the team technically.
• Responsible for effective communication between the project team and the clients. Provide necessary advice and direction to the offshore project development team.
• Deliver high level design solution documentation for the critical business requirements.
• Preparing the Functional Specification, Technical Specification, Test specification.
• Preparing required technical solution, that meets all expected and committed business requirement.
• Establish Quality Procedure for the team and continuously monitor to ensure team meets quality goals.

Confidential

Role: Offshore Team coordinator,

Environment: Informatica Power Center 6.2, SQL Server 2005, Windows 2000

• Responsible for coordinating the team.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Preparing the Functional Specification, Technical Specification.
• Preparing and ensuring team to deliver the technical delivery with proper quality control.
• Establish Quality Procedure for the team and continuously monitor to ensure team meets quality goals.