SUMMARY

• Over 12 years of IT experience in full system development life cycle (SDLC) in Planning, Analysis, Design, Implementation, Testing, Administration and Maintenance of various Data Warehouse and related ETL applications using Oracle, SQL, PL/SQL and IBM InfoSphere DataStage.
• 5+ years of extensive experience in design, implementation and supporting Data Warehouse in Mortgage, Banking and Retail Financial industries.
• Worked extensively in Waterfall methodology, agile environment projects and have participated in sprint planning, scrum meetings, retrospective meetings, story design meetings and customer demos.
• Expertise in different stages of data handling viz. requirement gathering, analyzing multiple heterogeneous data sources and targets, data cleansing, data loading.
• Extensive noledge and strong working experience in data warehouse architecture, design methodologies, RDBMS concepts and experienced in Atomic and Dimensional data modeling in Star Schema, Snow Flake Schema, Facts, Dimensions, and Slowly Changing Dimensions.
• Extensively used Data Modeling tools like IBM Infosphere data architect (IDA) and Erwin.
• Strong Experience in working wif various RDBMS like Oracle 12c/11g/10g/9i, SQL Server 2008/2005 and various XML files, flat files, .CSV and Excel files.
• Expert level noledge in Business intelligence tools like OBIEE and IBM Cognos.
• Extensive working experience in developing various Oracle PL/SQL Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Expert in writing complex SQL queries, Dynamic SQL, Arrays and Exception Handling, creating different PL/SQL objects.
• Profound experience in SQL Tuning using Explain Plan, Indexes, Statistics and various hints and fine tuning the code to improve the performance.
• Experience in Data Warehouse and Data Integration using IBM InfoSphere DataStage 11.3/9.x/8.x using components like DataStage Designer, DataStage Director, and Datastage Administrator for extracting data from heterogeneous source systems.
• Experienced in troubleshooting of DataStage jobs and dealing wif production issues like performance tuning and enhancements.
• Experience in using IBM InfoSphere Quality Stage, Information Governance Catalog (IGC Glossary and workbench), Information Analyzer and Governance Dashboard for maintaining, data quality, cleansing and Profiling of Source data and data lineage.
• Expertise in creating user accounts, setup access, monitoring server tasks, Job maintenance, hot fixes, database connections, Disaster Recovery (DR) Activities and code migration/deployment activities to production.
• Experience in generating various data feed extracts to external systems, Dashboards, KPI’s based on business needs.
• Extensive experience in Unit, Integration, regression and User Acceptance Testing Methodologies.
• Experience in 24/7 production support in fixing production issues and handled continuous enhancements requested from business users.
• Experience in writing UNIX corn and shell scripts and involved various file transfers using FTP, SFTP and SSH protocols.
• Expertise in creating the various oracle DBMS scheduler programs, jobs, chains and Queues to automate the data loads using Oracle built in DBMS scheduler. Experience in scheduling the batch jobs, DataStage jobs using IBM Tivoli, Control - M, and Autosys Scheduler.
• Extensive Hands on experience in using tools like TOAD, Export, Import and SQL*Loader utilities and SQL plus.
• Good communication, Analytical and Presentation skills and ability to provide timely solutions and work wif cross functional teams to meet the project deadlines.

TECHNICAL SKILLS

• Cobol
• RDBMS
• SQL Server 2008
• Oracle 10g 11g 12c
• Forms
• SQL
• PL/SQL
• Toad
• Teradata 13 14.10
• SQL Assistant
• Info sphere Data stage
• Info sphere Data Governance Catalog
• Orient DB
• TPT
• Fastload
• Multiload
• BTEQ
• HTML
• Info sphere Data Architect
• Note Pad++
• Ku tools
• Pu TTY
• Microsoft .Net
• Visual Studio
• Microsoft Office
• Office 365
• Outlook
• Word
• Excel
• Lync
• PowerPoint
• SharePoint
• Access
• Neo4J Desktop
• Toad
• UNIX
• Windows NT
• JavaScript
• Shell Script
• SOAP
• SAP Business Objects 4
• XI 3.1
• Web Intelligence 4 (WEBI)
• Universe Builder
• Xcelius 4.5
• BIRT Reports
• Talend - ETL Tool

PROFESSIONAL EXPERIENCE

Confidential, Troy, MI

Sr. ETL /oracle PL/SQL Programmer

Responsibilities:

• Involved in Analysis, design, development, implementation and support of the enterprise data warehouse.
• Interacted wif Business stake holders, Data Governance Team, subject matter experts and Business Analyst to gather the Requirements and Business logics and created mappings on scheduled basis.
• Worked on Agile environment, involved in Sprint planning, design and daily scrum meetings.
• Involved in source data analysis and created ETL design document along wif the enterprise architects.
• Involved in Data Modeling, Translated business requirements into conceptual, logical and physical data models. Used IDA (IBM InfoSphere data architect) to Generated the database object scripts for promotions and analyzed existing datamodels and altered them to support enhancements.
• Used Agile Model driven development and developed various ETL routines using IBM Data Stage and Oracle SQL, PL/SQL to load the data into new EDW on Sprint Basis.
• Used IBM InfoSphere DataStage 11.x/9.x as ETL tool to extract data from source systems such as Oracle, XML, Flat files, fixed width files, transform the data as per the business logic using various stages and loaded data into EDW.
• Exposure to other ETL tools Talend and Informatica transform the data as per the business logic using various stages and loaded data into EDW.
• Created Generic Validation jobs using RCP concepts and created error notifications to send out emails in case of failures.
• Used several stages like Sequential file, Aggregator, Funnel, SCD, Change Capture, Change Apply, Transformer and Lookup during the development process of the DataStage jobs.
• Applied the change data capture (SCD II) logic for all the tables before loading the type 2 dimensions into Enterprise data warehouse.
• Involved in performance tuning and optimization of DataStage jobs using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Closely worked wif Data Governance team, involved in defining implements in Collibra Data Governance application. Created views in Data Warehouse for data profiling using IBM Information Analyzer.
• Conducted performance tuning of the database dat included creating indexes, optimizing SQLs statements.
• Involved in production support, ongoing ETL changes for the existing data warehouse and CDD/SAM application database.

Environment: /Tools: Oracle 12c/11g R2, TOAD 12.x, IBM InfoSphere Information Server Suite, IBM InfoSphere Data Architect (IDA) 11.x, SQL PLUS, OBIEE 10.x, Cognos, UNIX, Linux, Windows Server, Windows 7.

Confidential, Troy, MI

Sr. ETL /oracle PL/SQL Programmer

Responsibilities:

• Involved in Analysis, design, development, implementation of CDD/SAM application for BSA team.
• Involved in all transactional source systems (MSP, DNA, AFS, ACH, WIRES) data analysis and worked wif Business stake holders, subject matter experts and Business Analyst to gather the Requirements and Business logics and created ETL mappings and data lineage mappings on scheduled basis.
• Created ETL design documents and process flow documents as per the requirement.
• Using oracle PL/SQL developed major ETL packages by implementing various business transformation logics to load the data into different stages in ACTIMIZE ERCM database.
• Designed and Developed new enhancements Data Warehouse which required for CDD/SAM application.
• Created stored procedures, Functions to facilitate the functionality for various complex modules and extensively used oracle Pipeline functions for parallel processing of data.
• Designed and Developed and maintained the complex oracle scheduler chains for the load process.
• Involved in proof of concept for Design and Implemented ETL for data load from Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2 in Talend ETL tool.
• Fulfilled source data tables using Talend ETL tool for executive dashboards.
• Involved in documentation of test requirements and involved in unit testing, integration and regression testing for various modules.
• Created the production release and migration scripts/documents, worked closely wif Data Base Administrators on production deployments.
• Supporting the production environments 24/7, fixing the defects and high priority bugs.
• Analyzed the data needs for the customized reports, identified the Mapping and generated the reports (PEP, OFAC etc.) in various formats and transmitted the files using SFTP.
• Responsible for performing code reviews and code fixing after identifying the Defects.
• Optimized and fine-tuned the SQL queries by using Explain plan and used various hints and created required indexes to improve the performance.
• Worked closely wif team members to share the work and helping them to resolve the issues.
• Played an important key role in decision making and provided valuable ideas and inputs for the success of the project.

Environment: /Tools: Oracle 11g R2, TOAD 11.x, SQL PLUS, SQL Developer, Talend 5.5, OBIEE 10.x, Oracle Scheduler, UNIX, Windows 7.

Confidential, Troy, MI

Sr. ETL /oracle PL/SQL Programmer

Responsibilities:

• Involved in Analysis, design, development, implementation of the retail banking system in data warehouse.
• Involved in DNA source data analysis and creating ETL design document along wif the data architects and data modelers.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Created stored procedures, Functions to facilitate the functionality for various complex modules.
• Extensively used oracle Pipeline functions.
• Created Oracle Virtual Private Databases (VPD) to enforce security and control data access by creating security policies on PII data elements.
• Designed and Developed and maintained the complex oracle scheduler chains for the load process.
• Involved in creating Customer Centric Master Data Management application.
• Involved in creating views which are used to load the data into application databases.
• Involved in documentation of User requirements and Testing of developed modules.
• Created the production release and migration scripts/documents, worked closely wif Data Base Administrators on production deployments.
• Supporting the production environments 24/7, fixing the defects and high priority bugs.
• Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
• Performed unit testing, integration and regression testing for various applications developed in data warehouse.
• Responsible for performing code reviews and code fixing after identifying the Defects.
• Optimized and fine-tuned the SQL queries by using Explain plan and Quest SQL optimizer.
• Involved in helping the application teams to rewrite and fine-tuned the existing applications.
• Worked closely wif team members to share the work and helping them to resolve the issues.
• Played an important key role in decision making and provided valuable ideas and inputs for the success of the project.

Environment: /Tools: Oracle 11g R2, TOAD 11.x, SQL PLUS, Oracle Scheduler, UNIX, Windows 7.

Confidential, Troy, MI

Sr. ETL /oracle PL/SQL Programmer

Responsibilities:

• Involved in the entire SDLC (System Development Life Cycle) process dat includes Implementation, testing, deployment and maintenance of enterprise data warehouse.
• Interacted wif business analyst, subject matter experts and business users to gather the requirements.
• Involved in creating technical specification/Design documents.
• Developed PL/SQL Packages, Procedures and Functions in accordance wif Business Requirements to load the data into different stages of data warehouse.
• Created huge set of external tables to load the data into landing area tables from different formats of files available in oracle directory every day.
• Extensively used oracle pipeline functions.
• Involved in creating data marts and views for the various applications.
• Created various packages to export the data in multiple formats to generate the reports for other third-party interfaces, and involved in generating the automatic reports in timely (daily, weekly, monthly) manner using the DBMS SCHEDULER utilities.
• Created and maintained huge Scheduler chains and Event Queue setup to automate the data loads on Daily, Weekly and Monthly Basis.
• Created Production ready scripts and involved in production releases by closely working wif Database administrators.
• Helped the team members to resolve the defects quickly to meet the project timelines.
• Maintained the daily batch cycle and involved in production support 24/7.
• Involved in unit testing, Integration testing and created the test case documents and uploaded them to Quality center.
• Involved in supporting and coordination wif various application teams for resolving issues, making enhancements.
• Performed SQL tuning by using Explain Plan, Hints and indexes.
• Implemented Partitions and Sub partitions widely. Utilized the gather statistics to select an optimal execution plan.
• Involved in creating and modifying the test data for testing purpose.

Environment: /Tools: Oracle 11g, Oracle 10g R2, Toad 11.x, Oracle Scheduler, Windows XP, UNIX, Oracle SQL developer, SQL*PLUS.

Confidential, Lansing, MI 

Senior Programmer/Analyst/Production Support/Unit of Work lead

Responsibilities:

• Analyzed, designed, modeled, and implemented new database schemas
• Development support, production support, and design review in a complex environment.
• Created DCR’s (Data Change Request) using MS-Access
• Monitoring Fragmentation, Row Chaining and High-water marks.
• Scripted in PL/SQL and SQL to migrate and manage databases.
• Developed PL/SQL Packages, Procedures, Cursors and Functions.
• Created different block level triggers in Oracle forms to display Case data.
• Developed PL/SQL Packages using dynamic SQL queries.
• Developed BIRT reports based on existing oracle reports.
• Perform the transformations on data according to the business requirements.
• Modified Oracle reports so as to accommodate different user requirements.
• Developed FTQ’s (fast track queries) queries for user requirement.
• Created unit and string test plans
• Production support and Database System infrastructure development.
• Participated in the technical meetings so as to provide required input to the users.

Environment: Orecle11gr2, Oracle 10g, Forms 10g, oracle reports 10g, Java, MS-access, TOAD, SQL Developer, SQL *Loader, SQL*Plus, PL/SQL, Windows XP, XML, BIRT