SUMMARY:

• ETL Architect (Datastage,ODI and Golgengate) with strong knowledge in SQL, PL/SQL and progressive industry experience lineal to the Confidential, life science & health care domains including 7 years of Client site experience with 5 years in United States(New Jersey, Connecticut) as client site coordinator, module & project lead.
• Requirement gathering, analysis, designing, developing, test case preparation, testing, integrating, implementing and supporting end­to­end Data warehousing solutions, aligned with critical business requirements, under stringent deadlines, for ace business corporations ( Confidential, Confidential, Confidential and Confidential ).
• Quick learner who rapidly adopts to emerging technology. Demonstrated success leading and mentoring cross - functional teams in multi-facility environments in order to maximize levels of productivity.
• Excellent communicator,with emphasis on building strong client relationship, capable of making professional presentation, holds Ex-MBA degree from Symbiosis.
• Oracle, ETL(Datastage,ODI, PL/SQL), ITIL and SAS certified professional with strong expertise in UNIX Scripting.
• Started as a Trainee in Confidential client) for 2 years. Continued the venture as a developer, senior developer in Confidential for 4.5 years followed by as a module lead and solution architect in Confidential for 2.5 years totalling 7 years in Confidential .
• Worked 3 years as a Client site coordinator for multiple projects under Confidential, New Jersey (U.S) team size varying 3 to 9 persons.
• Leading a 9 member team in Confidential for 2 years from Connecticut (U.S) ensuring proper transition of work from different vendor to Offshore and also identifying solutions for multiple issues in warehouse as a solution architect.
• As a Project manager in PwC, managing over 19 member team in Confidential, designed, developed, deployed and supported for last 2 years.
• Understanding the requirement, solution proposal, estimations and hereby working on multiple proposals(RFP)
• Actively worked with Confidential recruitment team as technical panelist and imparting for Confidential Academy
• Building a framework for Data Quality check and audit control Mechanism for Confidential and Confidential warehouse
• Setting up of an entire new version controlling system for Oncology ( Confidential ). Also worked with tools like Tortoise SVN, Visual Source Safe, IBM Datastage version controlling.
• ETL analysis, designing, developing, testing, implementation and performance tuning in ETL process (IBM DataStage Enterprise Edition 7.5, 8.5, and 9.1) & Oracle Data Integrator (ODI 11g ad 12c).
• Worked on the real time replication tool (Oracle Golden Gate).
• Developing Shell scripts to run DataStage jobs, PL/SQL blocks to automate file manipulation and data loading procedures.
• Scheduling jobs in Datastage as well as other third party tools like Control M, BMC, ESP.
• Warehouse Integration with the salesforce (cloud) platform for enabling enhanced marketing solution.
• Have experience working on Dimensional and Hybrid data warehouse model from Scratch level development to enhancement.
• Reputation for strong organizational skills, excellent communication skills, dedicated teamwork, attention to details, ability to work under pressure to balance competing priorities and meet deadlines.
• Experience in credit risk management, General Ledger preparation for a leading international bank
• Preparing data Warehouse with modules like Targeting and Alignment and Incentivizing for Confidential company
• Maintenance of consumer centric data like claims, biometrics, HRA and aligning them for rewards or claims processing for a leading health care service provider.
• Provided solutions to Confidential for complex reporting like (Structural Liquidity, NPA analysis, Large borrowers) and as an architect,designed the Warehouse to provide ADF facility to RBI (Reserve Bank Of India)

TECHNICAL SKILLS:

Operating System: Windows, Unix

Database: Oracle(9i,10G,11G,12C), IBM DB2

Languages: Shell scripting, PL/SQL, SAS, Oracle Golden Gate

Technology: Datastage 7.5, 8.0.1, 8.5, 9.1 & Salesforce RJ, Apex, Oracle Data Integrator(ODI) 11g,12c, Qlikview, Crystal Report

Version Control Systems: MS Visual Source Safe (VSS), Tortoise SVN.

Job Scheduler: Control M, BMC Control M, ESP

PROFESSIONAL EXPERIENCE:

Confidential

MIS Project Manager

Responsibilities:

• Playing a role of an Architect and leading the entire team for the engagement.
• Requirement analysis and creation of data model
• Developed critical oracle procedures and ODI jobs(Term Deposit, Advance account and classification)
• Tuned multiple procedures and established proper dependencies across multiple processes to achieve optimal performance at minimal load time.
• Developed challenging reports like STL(Statutory Liquidity Ratio replacing Balm Software as a whole), IRS(Interest rate sensitivity), Crilc(report on large borrower), Interest Subvention (KCC and SHG).
• Streamlined GG(Golden Gate) extraction and replication process as well as controlling the entire flow using dynamic cron scripting.
• Post deployment managing the entire L1,L2 and L3 activities as a part of support
• Worked on the RFP for migration and followed by consulting the entire migration project to get the best setup done for the migration.
• As a project manager successfully migrated the warehouse from exadata 3.x to 7.x along with ODI and Golden Gate 11 to 12.
• Vendor management for managing contractual resources from multiple vendor.

Environment: Oracle Golden Gate (12.2), Oracle 11g, Oracle Data Integrator, Exadata 3.X, Excel, Oracle 12 C, Exadata 7.X, Crystal Report and Qlikview

Confidential

IM Project Lead

Responsibilities:

• Provide an initial root cause analysis for any incident
• Identification of solution and effort estimation.
• Prioritization of the tickets for the L3 teams
• Business process communication.
• Preparing standard operating procedure and offshored the work post transition from customers.
• Working closely with L3 to ensure the fixes are implemented in timely fashion
• Building a framework for Data quality check and audit control Mechanism

Environment: Oracle 11g, Datastage, Unix, Excel, CTRL-M

Confidential (New Jersey)

VDW Client site coordinator and Team Lead

Responsibilities:

• Requirement gathering, designing, and reviewing deliverables.
• End to end development of specific modules to fulfil customer requirement
• ITIL standard documentation.
• ETL development and process designing.
• L1, L2 and L3 activities for ensuring the production process is running without any hindrance.
• Identification of issues, proposing solutions and ensuring implementation of the fixes within proper time.
• VSS Setup for the entire accountAnalysis design and documentation
• ETL development and testing (DataStage).
• Shell scripting for functional flow.
• PL/SQL coding and SQL.
• Technical and Functional Knowledge Transfer and induction of new members.
• Scratch level development, Implementation of project and post production support

Environment: Oracle 11g, Unix, DataStage parallel (7.5, 8.5), Excel, SAS, VSS, CTRL-M

Confidential

Credit Risk Management Developer

Responsibilities:

• Analysis and documentation of existing system.
• Quality management documentation for CMMI Level 5 Implementation.
• Datastage 7.5 development and shell scripting.
• Usage of Microsoft Excel as a part of Reconciliation.
• Validating the loaded data in IBM DB2.
• Technical and Functional Knowledge Transfer and induction of new members.
• Implementation of modules in production

Environment: Unix, DataStage, Excel, IBM DB2, Datastage version Controller, SAS, CTRL-M