SUMMARY

• 11 years of experience in Analysis, Design, Development, Testing, Implementation and Maintenance of Data Warehousing.
• Strong in data analysis, Requirement analysis, Data Profiling,Business Use case creation, Adhoc meaningful business report creation writing complex SQL queries, understanding complex business rules,Data flow diagrams,LDM,PDM Test scenarios, Defect Management. Creation of various business supportive reports E.G.Data Control,Data Change,Edit check,Reconciliation,Validation report creation/Automation.
• Strong Knowledge in mining data from the SQL database that was used in several significant presentations.
• An in - depth grasp of SQL reporting, analytics and business intelligence desire to work in a dynamic and challenging team environment.
• Strong knowledge of Data Warehousing techniques and Concepts, including ETL processes, Data Modeling Methodologies, Architecture.
• Experience in working with various Heterogeneous Systems like DB2 UDB, Teradata, Infobright, MS SQL Server, Flat files and Legacy Systems.
• Worked on Error Handling, Implementing Business Logic, Data Transformation, Migration, De-Duplication, Reconciliation, Change Management
• Experience in writing korn shell scripts in a UNIX environment for triggering Datastage Jobs.
• Experience in scheduling and monitoring the production jobs using BMC Control M Tool.
• Experience in Agile methodologies, JIRA tool.
• Created and Executed the data models analytical systems using Power designer.
• Assisted with development and ongoing maintenance of data modeling environment.
• Created logical business models and transformed into a physical data model instances.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Experience in working with Open source ETL Talend.
• Experience in reconciliation balances, pivot reporting,vlookup in excel.
• Excellent interpersonal and communication skills, and desire to work in a dynamic and challenging team environment.
• IBM Certified Solution Developer - InfoSphere DataStage
• Teradata certified Professional
• IBM Infosphere Optim Certified

TECHNICAL SKILLS

ETL Tool: IBM Infosphere DataStage and Quality stage 7.5/ 8.0/8.1/8.5 /9.1.2/11.3 Parallel and Server Jobs, Talend,Oracle PL/SQL

RDBMS: IBM DB2 UDB 8.02/9.1/10, MS SQL Server, Teradata V2R6, Infobright, My SQl, Oracle

Platforms: Windows 98/NT/2000/2003/XP/ Windows 7, IBM AIX, UNIX. Red Hat 3.4 Linux

Scheduling Tools: BMC Control M 6.3/6.4

Data Visualization: Tableau

Data Modeling: Sybase Power Designer (R) 16.5,MySQL WorkBench

Languages: UNIX Shell Programming/Scripting

Version Control: Borland Star Team, VSS, HP Quality CenterAgile JIRA

Exposure via Training: Cognos,Big data, Python.

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst

Environment: -IBM Infosphere DataStage 8.5/11.3(Director, Designer, Administrator), Oracle PL/SQL, Windows 7, Sybase Power Designer (R) 15.9, Red Hat Linux, BMC Control M 6.4.,JIRA

Responsibilities:

• Understand various source systems/data streams that provide inputs for CCAR.
• Participate in design and development to Staging layer and Data Hubs, satellites of data Vault using Power designer.
• Conduct Business meeting to go over the current data flow and to be (future) data flow with help of various use cases of data.
• Design a process to establish lineage between exposure and property attributes of ULE associated to corporate real estate loans and merge this data with existing origination data Store-ODS
• Design and develop a process to filter out ULE where linkage between exposure and property cannot be established and share it with Business for remedial action using SQL stored procedures.
• Design and Development for De-coupling the existing tactical Oracle stored procedures solution in place and come up with strategic design using Infosphere Datastage ETL Components.
• Design ETL to load data from Data vault to CCAR Specific Databases.
• Execute and handle production support activities for tactical Oracle Stored Procedure based solution.
• Interacting with business partners on day-to day basis to carry out data consolidation and correction activities
• Verify various reports that need to be submitted to business partners on day to day basis.
• Layout testing strategy for Strategic solution which includes Data Vault, CCAR Specific and Metadata (Datastage job statistic) data models.
• Conduct SIT -System Integration testing, Plan UAT testing strategy with business partners to facilitate UAT business sign off.
• Plan and conduct defect review meetings with Business, layout a defect fix strategy to be followed that can be implemented in Agile project using JIRA tool.
• Manage and guide the team of Datastage and Oracle developers to make sure all the deliverables happen on time and are defect free
• Worked on Datastage migration from 8.5 to 11.3 of entire CCAR application that has around 700 jobs.
• Worked on reconciliation reports to balance the amounts from source and FED submitted data using excel pivot tables,vlookup.

Confidential

Data Modeller-Technical Architect

Environment: -IBM Infosphere DataStage 9.1(Director, Designer, Administrator), Sybase Power Designer (R) 16.5, DB2 LUW 10.1, Windows 7, Red Hat Linux, BMC Control M 6.4.,Tableau,Python

Responsibilities:

• Analyze source systems from TEA, USPS, USAAS by reverse engineer using Power designer.
• Design of Vocab tables, Staging Layer and Aggregate/Report layer with facts, dimensions and reference tables, User interface tables.
• Create data model using Power designer for staging layer, reporting layer.
• Create design documents for ETL team.
• Create data flow diagrams from various source systems to FAST application.
• Create user friendly reports using tableau to analyze student demographics data.
• Worked on fixes to Python code that was used for Revenue vs Demographic visualization.
• Review base layer, reporting layer design for DAAG project based on the reports required by Data Services team.
• Analyze data from Bond review board, Texas higher education coordinating board, Texas Education Agency, US census and validate data model with respect to source systems.
• Develop Datastage Standards, design, guidelines and templates for various data stage projects under pipeline.
• Create re-usable data stage jobs to speed up development.
• Test data stage installation in different environments on different servers and make sure that configurations are all same with help of Linux team.
• Worked on POC for Talend tool .

Confidential

Production support lead

Environment: -IBM Infosphere DataStage 8.5(Director, Designer, Administrator), Oracle, Windows 7, Sybase Power Designer (R) 15.9, Red Hat Linux, BMC Control M 6.4.

Responsibilities:

• Understand various source systems/data streams that provide inputs for CCAR.
• Participate in design and development to Staging layer and Hubs, satellites of data Vault using Power designer.
• Design and Develop re-usable DataStage jobs to load source data into Data Vault.
• Design and Develop re-usable DataStage jobs to capture DataStage job run statistics (Metadata) and perform reconciliation of various source systems.
• De-couple the existing tactical Oracle stored procedures solution in place and come up with design for strategic design using Infosphere Datastage.
• Design ETL to load data from Data vault to CCAR Specific Databases.
• Run production support activities for tactical solution.
• Submit Retail HELOC, FL, Address Match, COPR and CRE files to Federal reserve as and when required.
• Interacting with business partners on day-to day basis to carry out data consolidation and correction activities.
• Verify various reports that need to be submitted to business partners on day to day basis.
• Layout testing strategy for Strategic solution which includes Data Vault, CCAR Specific and Metadata (Datastage job statistic) data models.

Confidential

Solution Architect

Environment: - IBM Infosphere DataStage 8.5(Director, Designer, Administrator), Teradata, Windows XP, Red Hat Linux, Putty 0.6, BMC Control M 6.4.

Responsibilities:

• Study of various source systems that would be replaced by Customer data hub and their downstream applications.
• Validate the existing LDM (Logical data Model) and PDM (Physical Data Model) with respect to existing source system data and from ETL perspective.
• Develop complete end to end Technical Architecture that involves design of staging layer, Exception layer, Housekeeping Layer in Teradata environment.
• Design shared containers or re-usable ETL to load Customer data hub.
• Lay foundation for ETL Error and Exception processing, design Error& Exception table.
• Create layout for data access layer or service layer for downstream applications from Customer Data Hub.
• Create DFD (Data Flow Diagram) for CIM Hub, clearly indicating the flow of data with its dependencies.
• Create detailed Technical Report document of Architecture suggested detailing each step in the process.

Confidential

Senior ETL Datastage Developer and Programmer Analyst.

Environment: - IBM Infosphere DataStage 7.5/8.1(Director, Designer, Administrator), Oracle 10g, Windows XP, Red Hat 3.4 Linux, Putty 0.6, BMC Control M 6.4, Unix, IBM DB2.

Responsibilities:

• Creation of testing mechanisms to validate the application across multiple versions of DataStage and make sure that results are same.
• Implementing multiple rounds of unit testing and system testing by comparing the results from different versions of DataStage to ensure that no data is lost due to migration.
• Built multiple Control-M cycles to schedule jobs in production for daily processing of data across versions of DataStage for testing purposes.
• Maintaining versions of the code and deploying the code to Test and Production environments after testing the code.
• Reducing pain and effort by implementing cost effective methods to fix post production defects.
• Preparing daily, weekly and monthly status updates for TCS management.
• Ensuring quality deliverables by following the TCS processes of quality assurance Viz. IQA/EQA of IQMS System
• Managed the project effectively by tracking and delivering projects on time using TCS Tools like IPMS.
• Conducting Training and Knowledge sharing sessions for the maintenance teams to effect smooth transitioning.