SUMMARY:

• I have over all 12+ Years in ETL, ORALCE, SQL SERVER, DATA WAREHOUSING,DATA MIGRATION
• Currently working as BAU(Business As Usual) Lead for a HR Global Reporting Data Warehousing
• Strong Experience on ETL Development, Data Warehousing and Data Integration
• Strong Experience in ETL development - INFORMATICA Power Center 9.5.1
• Developed a lot of informatica mapping, workflow, work lets
• Working experience in SSIS 2012
• Strong Oracle SQL, PLSQL writing experience
• Experience working in Microsoft SQL Server
• Have done several automation through Unix Shell Script & DOS Batch
• Strong understanding of Dimension Data Modeling in data warehouse environment such as star schema and snow flake schema
• Led the ETL team for data migration product for National Health Care services ( Confidential )
• Hands on experience in Java Programming for a LADP authentic application
• Have got theoretical knowledge & understanding on Big Data Hadoop, HDFS, Pig

TECHNICAL EXPERTISE:

ETL Traditional Tools: Informatica Power Centre 9.1.3 Designer, Repository Manager, Workflow manager, Microsoft SSIS 2012

Database Technologies: Oracle 11g SQL, PLSQL and Microsoft SQL Server 2012, Teradata 14

Scripting: Unix Shell Scripting, DOS Batch Scripting,

Reporting Tools: Job Scheduler, Tidal, Control-M,UC4

Data ware Housing: Concepts, Dimension Modeling, Dashboard design

PROFESSIONAL EXPERIENCE:

Confidential, Peapack, NJ

Professional Dataware Housing

Responsibilities:

• Working as a BAU Lead for Global Reporting Warehousing team and leading the offshore team
• Responsible to production support, development activities, cost estimation, Enhancement activities, Review the code and documents
• Written Requirement documents for Hospira integration
• Written Technical design documents for Hospira integration
• Applied the solution to restrict / include the Hospira records based on the interface requirement
• Prepared UAT cases and shown demo to client for UAT Sign off
• Conduct ETL performance tuning for UC4 Jobs
• Conduct thorough testing of ETL code changes to ensure quality of data produced
• Handling the End to End Flow of scheduling, automation, alert

Environment: Informatica power cener 9.5.6, Oracle 11g, Unix, UC4

Confidential, Jersey City, NJ

Technology: Data Warehousing, Informatica, SSIS 2012, Oracle SQL & PLSQL, MS SQL Server, Unix

Professional Dataware Housing

Responsibilities:

• POC Preparation for ETL project using Informatica & SSIS 2012
• Developed many informatica mapping development
• Automation using Tidal Scheduler
• Developing ETL packages in Informatica
• Developing the common routines like Snapshot, business routines, job log and exception logs in Oracle PLSQL
• Written complex SQL and Performance tuning
• Creating mapping solutions for each product and involving in the design changes
• Dimension Data Modeling Design Face, Dimension table design
• Conduct ETL performance tuning
• Conduct thorough testing of ETL code changes to ensure quality of data produced
• Handling the End to End Flow of scheduling, automation, alert

Environment: Informaitca 9.1.3, SSIS 2012, Oracle 11g, SQL Server 2012, DOS Batch

Confidential

Technology: SQL Server Performance Tuning

Professional Dataware Housing

Responsibilities:

• Single point of contact for Across Confidential ETL and ERP SQL server database tuning
• Supporting DWH, ETL database environments
• SQL Server Performance application tuning export for Confidential DWH, ERP and ETL applications
• Working on deadlock resolution for Financial ERP product ( Sun INFOR10)
• Working on daily blocking issues
• Working on improvement on top poor SQLs -high elapsed time, high CPU time, high logical reads
• Working on interface slowness
• Working on proactive monitoring of databases
• Supporting across Confidential SQL Server applications ( Sun Infor10, Sun HFM, Bwise, Medgate, PANDA )
• Supporting Bwise application which is BO reporting application

Environment: Informatica, DWH, SQL Server 2008

Confidential

Technology: Informatica Power Centre 9.1.3, SQL Server 2012

Informatica and SQL Developer

Responsibilities:

• Carry out functional, technical design reviews, as well as code reviews
• As a application architect, provide technical
• Implemented the many automation for manual tasks.
• Assisting the team members for ETL rules and complex problems
• Preparing the technical notes for ETL
• Performing the role of Informatica administration .
• Preparing the POC for each design changes and enhancements
• Led the team of release 1 Lorenzo Data migration to Release 1.9 Lorenzo Data migration successfully
• Extensive experience developing Informatica mappings, mapplet, workflows, tasks, SQLs

Confidential

Technology:Oracle, HP Unix, VB 6.0, VSS

Oracle PL/SQL Developer, Unix Shell Scripting, Visual Basic Programmer

Responsibilities:

• Oracle/Unix technical analyst for five individual applications
• Gathered and defined user requirements.
• Created database triggers, procedures, functions using PL/SQL.
• Extensively written UNIX Shell scripts to extract the meta data from flat files to a specific format and import into Oracle database using SQL*Loader
• Customize or automate the applications to reduce the supporting hours using Unix Shell Scripts
• Resolving all Real Time Support(RTS) issues and provides production support activities
• Resolved the Visual Basic application problem like adding engine series, number and qualifier columns into Embargo Screen which will block the data export to other system.
• Provided many solutions for Object Oriented Visual Basic application.
• Worked for a new interfaced which developed by SQL loader, Oracle and Unix Shell Scripting.
• Identifying, prioritizing of root cause of problems and resolve break and bug fixes
• Single point of contact for all the RTS issues and provide the necessary details

Confidential

Technology: Oracle, Sun Solaris Unix, Control - M, HTML, JSP, java, java script

Oracle Developer (PL/SQL programming & Unix Shell Scripting)

Responsibilities:

• Created database triggers, procedures & Functions using PL/SQL
• Design and implementation of Stored Procedures to combine complex queries and business logic there by improve performance
• Developed UNIX shell scripts/batch jobs to insert the reader data into oracle database
• Extensively written UNIX Shell scripts to extract the meta data from flat files to a specific format and import into Oracle database using UTL FILE
• Updated the dynamic Mantas Kiosk pages by using Unix Shell script
• Worked on Control-M jobs editing and enhancement
• Extensively written UNIX Shell scripts, to extract the meta data from flat files to a specific format and import into Oracle database using SQL*loader
• Involved in User acceptance testing and Unit Testing for all the release.
• Documentation of all modules for user level and system level maintenance
• Handling production support activities on severity basis
• Analysis of the existing code and preparing design documents for enhancements. Gathering requirements from the client and doing bug fixing / enhancement of the existing code as per Client’s requirement
• Handled the Mantas application tickets
• Single point of contact for token administration and dual authentication applications which is used to secure the mantas application.
• Periodically solved the actuate server issue with help of mantas team.
• Managing the token administration and Dual authentication application which developed in JSP and Java
• Automated the daily task by using Unix Shell scripting
• Applied the mantas product patches which is one of the critical task in AML.
• Provided the solution for Mantas alert problem