Senior Datastage Consultant Resume

SUMMARY:

I am expert in End to End Business Intelligence Deliveries and Data Migration Project. 8 Years of experience in Banking Industry creating Financial Datawarehouse. A Pro - active thinker who understand the business needs and delivers which is crisp and useful for user. I am currently working as Senior Datastage Consultant in Confidential, Montreal. I am keen to pursue any data driven project.Worked on Business
Intelligence project with tools like Datastage, QlikView, Cognos, Microstrategy, Lavastorm and Microsoft Reporting Services for 11 years.
An Agile scrum master in the project running on a multiple POD Structure where POD is responsible for End-End delivery including Production Support.
Designed ETL architecture and define standards for a BI project to handle trade reconciliation process (Post Trade Utilities).
Specialist in Oracle and Unix
Implemented DevOps practice in the project where the tool workflow includes Git Hub, Jenkins, Nexus and Ansible.
Maintaining and modifying Java API based Quartz Scheduler for job scheduling.
More than 8 years of experience in working for Banks

TECHNICAL SKILLS:

Skills: ZDataStage 11.5, Qlik View, Infosphere Information Analyser, Financial Reporting, DevOps, Agile, Jira, Oracle 11g, Netezza, DB2, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior Datastage Consultant

Responsibilities:

Datastage jobs design, development and deployment
Modifying ETL architecture and standards
Preparing Initial load Pl-Sqls with optimized performance to process huge amount of records.
Automation of ETL process and continuous deployment of jobs with Jenkins. Updating Shell scripts for automation of file processing.

Confidential

Datastage Infosphere Consultant

Responsibilities:

Support and release management for Information Analyser Environment.
Monitoring Information Analyser Suit including Infosphere Metadata Asset manager and Governance catalogue.

Confidential

Lead Datastage Developer

Responsibilities:

Datastage ETL development with designing ETL architecture standards
Prepared STAR schema data model to handle trade reconciliation process (Post Trade Utilities).
Prepare mapping & technical documents.
Manage multiple streams of release & change management process. Involve release management.
Managing Offshore team for development.
Wrote PL/SQL & shell scripts for control frame work and other activities

Confidential

Business Report Developer

Responsibilities:

Working directly with HP Marketing Country managers to develop new initiates to market HP Products.
Generate MS-excel reports on Inside sales team performances. Develop and utilize key performance metrics to impact both sales team and individual sales rep performance.
Conducting market research and consumer behaviour analysis to cross sell products in existing market.

Confidential

ETL Developer

Responsibilities:

Data Mining for Digital TV Set top box to provide recommendations for users using Oracle 10g.
Developed PL-SQL reports to fetch the java reports for in-house products.

Confidential

Datastage Developer

Responsibilities:=

Developed stored procedures for populating tables in SQL Server 2008 through partition swapping of facts table. Worked on TL/SQL for data extraction and source validation from ODS to feed data to ETL transformations.
Developing Datastage Sequences to populate Data mart using Datastage Designer. This included creating multiple jobs, routines, backend scripts, Oracle procedures to validate the source files, running different data cleaning activities and supporting DATASTAGE environment for development work.