SUMMARY

• 10+ years of experience in IT industry working on various technologies like IBM Mainframes, ETL Datastage/Informatica/SSIS and Data Analysis and data modeling and experience in all phases of testing for client - server, web and Mainframe applications in various industries such as Retail, Health Insurance, Automobile, Banking, Stocks, Mutual Funds, Airlines and Energy Utility sectors.
• 3+ years of experience working as a data analyst and data modeler and building data warehouse from conception to production in financial industry and airlines industry.
• Experience in creating Physical and Logical data models and managing metadata information using CA Erwin.
• Experience in creating data mapping documents, DDL and scripts for Operational Data Store and Source to Confidential Mapping for legacy migration.
• Expertise in writing T-SQL, Oracle SQL and DB2 SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS )
• Experience in migrating legacy mainframe applications to SAP environment and ETL warehouse.
• Experience in designing, coding, testing and deploying ETL data stage and Informatica jobs.
• Experience in Lawson AP/GL modules, expense invoice and PO match process and GL165 reports.
• Proficient in IBM Mainframe technologies such as JCL, Cobol, PL/I, IDMS, DB2 and CICS in MVS environment.
• Job scheduling experience in BMC Control-M and CA-7.
• Build and deployment experience using implementation tools MS-TFS (Microsoft Team Foundation Server), TAD, WBSD, Endeavor and PVCS Serena Change Management.
• Extensively worked on MS Office tools (Excel, Word, Visio, Powerpoint and Access) and Mercury tools Quality Center and QTP.
• Worked on a POC to migrate legacy mainframe application to webservices using SOA and XML and executed Java batch jobs in mainframe.
• Can work on different operating systems. Communicative and cooperative. Adaptable to handle multiple projects.

TECHNICAL SKILLS

Operating Systems: IBM Mainframe, UNIX, Windows

RDBMS: DB2, IDMS, SQL Server, ORACLE, TERADATA

Database Tools: SQL Developer, TOAD, DB2 Platinum, DB2 Softech, DB2 Spufi, DB2 QMF, Ms-Access, Sql Server, Teradata SQL Assistant

ETL Tools: ETL Datastage, SSIS, Informatica Powercenter

Data Modeling Tools: CA-ER-Win, ER-Studio

Reporting Tools: Web focus, MS SQL Server Reporting Services (SSRS), Tableau

Programming Languages: JCL, Cobol, PL/I, CICS, Eztrieve, SQL, T-SQL, IEF/Coolgen, Unix, HTML, JavaScript, XML

IBM Tools: Endeavor, Xpeditor, Changeman, Fileaid

Scheduling Tools: CA-7, CONTROL-M, JOBTRAC

Build & Deploy Tools: MS-TFS, TAD

ERP Packages: Lawson AP/GL, SAP

PROFESSIONAL EXPERIENCE

Confidential, Tulsa

Senior Data Modeler / Analyst

Responsibilities:

• Create Requirement documents for bringing data from various sources to Operational and MOSAIC datawarehouse models.
• Work with business to identify the requiremetns and capture all the business definitions for all the fields that we bring to warehouse.
• Create Logical and Physical data model using ER Studio and get the design reviewed and approved by the Data Architect Manager and then publish and distribute the changed / new model to various stakeholders and teams.
• Create DDL scripts for the change and work with DBA to create the tables.
• Work with ETL on the strategy to get the data from source system to Warehouse and provide them the source to Confidential mapping documents and help them in the design of ETL datastage jobs.
• Validate the results and work for production implementation.

Confidential, Mission, Kansas

Senior Data Analyst

Responsibilities:

• Worked with Sungard’s InvestOne team to get the data extracted from mainframe to datalink XML files and identified the FOMI codes and calculations to be used for the ODS design.
• Designed and maintained Physical and Logical Data Models for Operational Data Store for InvestOne using Erwin and SQL server andbuilt different views for various business teams.
• Created, published and maintained data dictionary and metadata.Support efforts to ensure that data standards are developed and maintained.
• Extensively used SQL for Data Analysis and to understand and documenting the data behavior.
• Reversed engineered existing data bases to understand the data flow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Retrieved data, reviewed, prepared/transformed and loaded client data from various sources and datalink xml files into Invest One ODS using ETL Informatica and SSIS.
• Performed the data profiling and analysis making use ofInformatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Ensure that the uses of data through ODS consumer reports and queries are accurate.
• Gather requirements for ETL developers and document data specific process by creating data mapping documents and T-SQL queriesand work with ETL to develop the extract.
• Validate the results from ETL to match with existing mainframe reports.
• Design the solution to migrate legacy mainframe reports to SSRS reports.
• Analyze existing mainframe programs to identify business rules and create specification and mapping documents for migration.

Confidential, Maryland Heights, MO

Data Analyst

Responsibilities:

• Involved in extensive Data validation using SQL queries and back-end testing
• Used Erwin, Created Conceptual, Logical and Physical data models.
• Involved in analysis of a variety of source system data, coordination with subject matter experts, development of standardized business names and definitions, construction of a non-relational data model using Erwin modeling tool, publishing of a data dictionary, review of the model and dictionary with subject matter experts and generation of data definition language.
• Design, modify, document, and enhance reports using Microsoft Reporting Services and Cobol Eztrieve programs for Client Relationship Team and Global New Accounts.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).

Confidential, Georgetown, KY

Data Analyst / ETL Developer

Responsibilities:

• Perform data analysis and data mappings across various systems for Confidential Motor Manufacturing Plants.
• Liaise with Business users to understand their requirements and document in the form of Business Specification Requirements Documents.
• Provide analytical support by writing complex SQL queries.
• Perform data quality checks on various data elements available in the warehouse.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2005
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Participate in User Acceptance testing for enhancements done to the warehouse.
• Provide user support making sure appropriate Support tickets are created.
• Participate in weekly production support related calls to review support tickets. Provide timely user communications for any system related issues.

Confidential, ND

Data Analyst

Responsibilities:

• Developed physical database model using ERWIN.
• Used ERWIN's ForwardEngineering tool to create tables and columns.
• Generated DDL statements for the newly generated objects (tables, views, indexes and packages)
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse content.
• Perform intermediate queries using SQL, includingInner/Outer/Left Joinsand Union/Intersect for ITS Release and CoreLink Projects
• Provide regular (monthly, weekly, bi-weekly) reports for both internal and externalstakeholders.
• Createad hoc andstandardreports for supervisorsto facilitate the necessary flow of information to interested stakeholders.

Confidential, Minneapolis, MN

Assoc Technical Architect / Business Analyst

Responsibilities:

• Involved in the initial build out of Finance Controlled Test Environment (FCTE) with 80+ finance applications. FCTE is an integration testing UAT environment for Finance Development at Confidential . Responsible for maintaining integration FCTE where various finance changes are tested before implementing in production. FCTE duties included project management and consultation of multiple large complex projects in Finance in the analysis, design, development, testing in FCTE and implementation in production and integration of new systems and technologies.
• Managed a 15 member offshore team. Responsible for coordinating and allocating tasks to team members and following up on the completion of tasks allocated. Worked as a liaison between business analyst and technical project testing teams.
• Reviewed incoming project testing teams in Finance and made sure that the region is available for testing and team members assigned for testing and implementation.
• Worked closely with various project testing teams, business analysts and prepared test plans and test cases for System test, Integration test, user acceptance test and data specific test cases for the finance scenarios. Created and executed various test scenarios for End to End regression testing of Finance applications. Updated test case results in Quality Center and documented the defects.
• Reviewed functional specification documents, design documents, requirements traceability matrix and involved in developing Master Test plan document.
• Analysis, requirement gathering, coding, testing and implementation for various database extraction requests for ReconNet project using IBM ETL Data stage tool.
• Extensively involved with Business analysts to gather the requirement and to finalize the ERWIN Logical and physical data model.
• Recovered abended jobs within SLA. Co-ordinated with external teams to resolve environmental issues and processed testing team requests on Host/Lawson/ETL.
• Maintained FCTE Mainframe DB2 and Lawson Oracle database. Other responsibilities of maintaining the DB involved: Creation of database/alteration of DB2 objects, Granting access to DB2 objects, Build/Rebind of batch/online plans and packages and periodic refresh of DB2 and Oracle tables.
• Did detail analysis of 40+ Finance applications as part of the ERP Readiness Program for migration to SAP. Captured Batch Job Information, Online Screen Information, Transactional Dataset Information, Transactional Database Information, Interface Visio diagrams (to identify key inputs and outputs) and Detailed Job Flow Visio diagrams for each application. Worked extensively for migrating legacy finance applications to SAP as part of the TGT$100 releases. Modified legacy mainframe jobs to place the files in CIF using MFT. SAP AP GL jobs will pick the files in CIF and process in their environment.
• Worked on a POC to migrate legacy mainframe application to webservices using SOA and XML and executed Java batch jobs in mainframe.
• Managed Lawson AP(Accounts Payable), GL (General Ledger), AR (accounts receivable) and match process modules for Confidential Finance.
• As part of separation of duties under Finance development, a build management team was formed. I lead the build management related activities performed for various projects in Finance development area. Learnt new technologies such as MS-TFS (Microsoft Team Foundation Server) and TAD ( Confidential Application Deployment) and did successful builds for ETL, Unix, Java and web focus items for various project teams.

Confidential

Software Specialist

Responsibilities:

• Involved in Coding Mainframe Cobol CICS DB2 programs and Unit testing, preparation of Program specification documents, Loading and unloading tables for System testing.
• Worked in SQL performance tuning team where the SQL queries to be used in the programs need to be approved before implementing in production.
• Creation of test database/alteration of DB2 objects.
• Granting access to DB2 objects
• Build/Rebind of batch/online packages.

Confidential

Software Engineer

Responsibilities:

• Handled Work request which involves Analysis, specification preparation, coding and unit testing, Review, Testing co-ordination and Test documentation.
• Worked with APS Cobol, MF Cobol and Unix shell scripting.
• Participated in CMMI Level 5 Appraisal interviews.