SUMMARY:

Around 10 years of proven experience in the IT industry with Development and implementation of Data warehouse/Database applications using database products like Oracle, Sql Server, Netezza, Snowflake with the ETL Tools like Informatica, SSIS and Scheduling tools like BMC Control - M in UNIX Environment.

EXPERTISE:

Database: Oracle (9i,10g,11g,12c), Sql Server (2008R2,2012,2014,2016) & Netezza 6.0Snowflake

Etl Tools: Informatica (9.6,10.1.0,10.1.1) & SSIS (2014,2016)

Scripting: Unix

Programming Languages: Oracle PLSQL, Sql Server Transact-SQL

Scheduling Tools: BMC Control-M (v 7,8,9), Sql Server Job Agent

Database Utility Tools: Toad, SQL Developer, Winsql, SQL Server Management Studio 2012,2014,2017.

Data Modeling Tools: ERWIN

Data Lineage: IBM Metacenter

Build and Deploy Tools: Jenkins

Version Control Tools: GIT, Clear case, Source Tree

Unit Testing Tools: HP Quality Center

Code Scan and Optimizer Tools: Sql Profiler and Tracers

File Transfer Application/Tools: WINSCP, PuTTY

Domain Expertise: Banking, Financial & Investment

Project Methodology: Agile, Waterfall

Operating System: Windows & Unix

WORK EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• Working as Data warehouse Developer & TechLead.
• I coordinate with Client on the requirement and prepare Technical solutions.
• We prepare the data for the reporting and Metric calculations.
• We assess the performance of funds using the reports.

Confidentia

Lead Consultant

Responsibilities:

• Worked as Lead Consultant in Dataware house solutions.
• I coordinate with Client on the requirement and prepare Technical solutions.
• We supply the data for the reporting applications which assess the performance of the Confidential associates on various products that Confidential bank offers to customers.

Confidential

Technology Analyst

Responsibilities:

• Worked as Data warehouse Developer & TechLead.
• I coordinate with Client on the requirement and prepare Technical solutions.
• We prepare the data for the reporting and Metric calculations.
• We assess the performance of funds using the reports.
• Worked as onsite-offshore Coordinator.
• Worked as developer in offshore and used to lead the offshore

Confidential

Database Engineer - Specialist

Responsibilities:

• Worked as Database Developer.
• I coordinate with onsite Tech Leads on the requirement and develop the code.
• Worked on the credit card module.
• We created an end to end web application to manage credit card history and payments.