SUMMARY:

• Data stage Professional with 17 years of experience across various domains (Banking, Insurance and Telecom) covering complete development lifecycle.
• Have good experience in Data modelling, Data warehouse Design, Development and Testing using Data stage 11.5/8.5/8.1/7.5.1.
• Possess good noledge on Capital Markets Banking Domain.
• Have good noledge on JIRA Project Tracking system and AGILE Methodology
• Excellent in writing JCL, SYSIN, BTEQ’s.
• Excellent in writing Oracle PL/SQL stored procedures, T - SQL.
• Possess excellent communication, interpersonal skills and Problem solving capabilities.
• Possess strong data-warehouse solution design background with excellent analytical skills
• Skilled at learning new concepts quickly, working well under pressure, and communicating ideas clearly and TEMPeffectively.
• Strong work ethic & excellent team player.

TECHNICAL SKILLS:

ETL Tools: Data stage 11.5, Data stage 8.5, Data stage 8.1, Data stage 7.5.1

Programming Language: T-SQL, PL/SQL, shell scripting, JCL, BTEQ, SYSIN

Database: Teradata, SQL Server, Oracle, Sybase, MySQL

Database productivity Tools: Teradata SQL Assistant, SQL Server Management Studio, Toad, Aqua Studio, Rapid Sql, PL SQL Developer 7.11

Job scheduling: TIDAL, Autosys, Zeke

Operating Systems: Windows 2K/XP/7, Linux, Solaris, AIX

Versioning Tools: GITHUB, VSS, SVN, NEXUS

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Data stage 11.5, Teradata, JCL, SYSINs

Responsibilities:

• Develop Jobs in Data stage 11.5 dat involves extracting data from source feeds and perform required Validations/data transformations/enrichment and load to Teradata Reporting Tables.Developed JCL’s, SYSIN’s, and BTEQ’s to load data from Teradata (source) to Reporting tables in Teradata.
• Participated in sessions with Business to gather data requirements and involved in preparation of ETL detail design document and estimation of tasks.
• Involved in Agile Methodology. Participated in Story Grooming, Sprint Planning, Sprint Demo, Retro.

Confidential

Environment: Data stage 11.5, 8.5, Data stage 7.5.1, T-Sql, LINUX, Autosys

Responsibilities:

• Participated in development work in Data stage 11.5/ Data stage 8.5 dat involves extracting data from source feeds and perform required data transformations/enrichment and to deliver to different targets(databases/files)Migrated components from Data stage 8.5 to Data stage 11.5
• Participated in sessions with Business to gather data requirements and involved in preparation of ETL detail design document and estimation of tasks.
• Experience in creating SQL stored procedures, function for extracting data from ETL.
• Providing support for DS 11.5/DS 8.5 data stage jobs during data loads in production.

Confidential

Environment: Informatica 10.1, SQL Server 2012

Responsibilities:

• Responsibilities:Developed Informatica mapping and workflows to publish Murex products (CDS, IRS) and MDSA data (Equity, bond, party, swaps) into hub.
• Created DIH publications and subscriptions to publish source files to topics and to deliver required files to consumers.
• Experience in creating SQL stored procedures, function for extracting data from ETL.
• Participated in development work in Data stage 11.5/ Data stage 8.5 dat involves extracting data from source feeds and perform required data transformations/enrichment and to deliver to different targets(databases/files)
• Migrated components from Data stage 8.5 to Data stage 11.5
• Participated in sessions with Business to gather data requirements and involved in preparation of ETL detail design document and estimation of tasks.
• Experience in creating SQL stored procedures, function for extracting data from ETL.
• Providing support for DS 11.5/DS 8.5 data stage jobs during data loads in production.

Confidential

Environment: Data stage 8.7, Data stage 7.1,Oracle 10g, COBOL, Flat/VSAM files, JCL, SYNCSORT

Responsibilities:

• Responsible for the design and development of Data Stage jobs for CIBC Visa Data warehouseResponsible for new business requirements & procedures into existing Data Mart. Duties which involved meetings with business people, business & technical documentation, walkthrough step by step developmental phases with business managers.
• Actively involved in Technical requirements team discussion & work delegation planning. Analyzing test cases & testing data requirements. Implementation plan documentation and contingency planning
• Development was performed utilizing Data stage 8.5/7.1, Oracle 10g, PLSQL Stored Procedures, Unix Scripting, SQL Loader, Windows/Unix Sync sort utility and IBM Mainframe access where 95 % of the source files are extracted from.
• Developed Mainframe programs using COBOL, Flat/VSAM files, JCL, SYNCSORT, IDCAMS, EZTrieve etc.
• Worked as project Lead for Credit Cards Decision Support Environment(DSE) with 5 team members at offshore
• Involved in providing solutions to Business Users queries and plugin new enhancements.
• Assisted in Production support activities along with Development/Requirement gathering activities in Parallel.
• Worked as project Lead with 6 team members at offshore
• Gathered requirements and provide effort estimates on-behalf of offshore team
• Designed ETL solutions in Data stage 8.5 to extract market data from 130 different sources
• Developed ETL Jobs using IBM Data stage 8.5/8.1 adhering to job design best practices.
• Automated complete SOI process to pick up the current market prices from 15 different sources and delivering it in TEMPeffective way to IPV systems.
• Conducted offshore code reviews and integration testing efforts.
• Involved in market Price Validation queries from clients.
• Assisted in Production support activities along with Development/Requirement gathering activities in Parallel.
• Worked on multiple projects in parallel under pressure.
• Involved in Data Stage Migration from DS 8.1 to DS 8.5

Confidential

Environment: Data stage 8.5, Data stage 7.5.1, T-Sql, LINUX, Autosys

Responsibilities:

• Worked as project Lead with 4 team members at offshoreParticipated in sessions with Business to gather data requirements and involved in preparation of ETL detail design document and estimation of tasks.
• Participated in development work in Data stage 8.5/7.5.1 dat involves extracting data from source feeds and perform required data transformations/enrichment and to deliver to different targets(databases/files)
• Experience in creating SQL stored procedures, function for extracting data from ETL.
• Providing requirements to offshore developers, reviewing offshore deliverables, Integration testing and providing support.
• Providing support for ETL job during data loads in production.
• Migrated components from DS 7.5 to DS 8.5
• Involved in understanding multiple user requirements from downstream systems to maintain client repository systems.
• Participated in developing detail functional specification document which includes UI details, Business and Data load process.
• Developed multiple modules with high-performance as per requirement which includes Data stage 7.5.1, Data stage 8.1 and Sybase stored procedures.
• Extensive experience in creating functions, stored procedures, views in SQL.
• Prepared test case document and unit testing of modules.
• Managed different stages of testing including user acceptance and unit testing.
• Participated in Production Implementation and supporting implemented components.
• Successfully delivered project on time and served as a point of contact for project issues.
• Involved in Data Stage Migration from DS 8.1 to DS 8.5

Confidential

Environment: Data stage 7.5.1, PL/SQL, Java

Responsibilities:

• Involved in understanding multiple user requirement to maintain client repository system which is accessed by GUI systemsParticipated in developing detail functional specification document which includes UI details, Business and Data load process.
• Developed multiple modules with high-performance as per requirement which includes Data stage 7.5.1 and Oracle stored procedures.
• Helped the team members in improving the performance of nightly batch cycle and to solve performance problems.
• Extensive experience in creating functions, stored procedures, views in SQL.
• Prepared test case document and unit testing of modules.
• Managed different stages of testing including user acceptance and unit testing.
• Participated in implementing the modules in production along with onsite-team members
• Successfully delivered project on time and served as a point of contact for project issues
• Involved in requirement gathering and coding
• Participated in developing detail functional specification document which includes UI details, Business and Data load process
• Developed Data stage 7.5.1 jobs (parallel/sequences) and T - sql stored procedures.
• Extensive experience in creating functions, stored procedures, views in SQL.
• Prepared test case document and unit testing of modules.
• Managed different stages of testing including user acceptance and unit testing.
• Participated in implementing the modules in production along with onsite-team members
• Received Scope of the Month winner from Infosys for delivering the project under tight deadlines.