SUMMARY:

• In Depth Knowledge in Software Development Life Cycle (SDLC) model using Agile - SCRUM, RAD, and Waterfall.
• Excellent understanding of Data Architecture principle, Data Warehousing Concepts - Star and Snowflake schema, SCD Type1, Type2, Normalization, Dimension and Fact tables and data modeling technique.
• Experience in implementing IBM Banking Data Warehouse (Banking Data Warehouse (BDW) model.
• Proven working experience in using major data integration ETL tools, such as DataStage, Data Services, Informatica.
• Experience in designing and developing conceptual, logical and physical data model for Relational and Dimensional database using ERWIN and ER/Studio.
• In depth Understanding of data governance and master data management.
• Proficient in requirement gathering, Data Profiling.
• Excelled in writing stored Procedure, Function, Database Trigger and Package using SQL, PLSQL and Dynamic SQL.
• Well versed in performance tuning, data export/import using Oracle Data Pump, SQL Loader.

TECHNICAL SKILLS:

Software and Tools: ERWIN, E/R Studio, Designer 2000 2.1.1.3, IBM Infosphere (DataStage), Business Objects Data Services, Informatica Power Center 8.6, EPIC CLARITY

Languages: SQL, PL/SQL, TSQL, SQL *Plus, Java, Java Script, HTML, XML, Shell Scripting.

Databases: Oracle, SQL Server, TERADATA

Operating Systems: Windows NT/2000, XP, LINUX, UNIX, HP - UX 11.11, Sun Solaris 2.x/7/8

Other: VERSIONONE, UML, Web-services, Cloud computing, Oracle Forms, Reports.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, Michigan

Data Architect

Responsibilities:

• Design, develop Logical and Physical Data Model by leveraging IBM Industry Standard Banking Data Warehouse (BDW) model.
• Generate various DDL scripts, such as Create Tables, Synonyms, rollback and Grant-Privileges scripts using ERWIN.
• Store and manage source-to-target data warehousing lineage in ERWIN Data Modeler.
• Visualize source-to-target lineage via graphical impact analysis in the ERWIN Web Portal.
• Create metadata reports that include a wide range of object types - tables, columns, UDPs etc. using ERWIN Report Designer.
• Schedule and participate in code walkthrough.
• Provide Application DBA support activities including database objects creation, optimizing SQL queries, building complex SQL, dynamic SQLs, data refreshing and database objects migration across databases.
• Maintain, develop and review technical documents to ensure they are in compliance with Ally directions and security standards.

Confidential

• Design and develop Logical and physical data model. Conduct Entity Relation Diagram (ERD) walk thru session with BA and ETL developers.
• Use ERWIN Bulk Editor extensively to review and update number of model objects’ properties.
• Resolve discrepancies in data definitions and other data issues that arise while sourcing data from multiple data applications.
• Perform ERWIN complete Compare feature to generate “Alter table” scripts and to compare objects and properties at the model or database level.
• Generate various DDL scripts using ERWIN and implement in Oracle database.
• Lead interaction with end user query developers to design and improve database queries.
• As an Application DBA perform Database testing and generate reports like AWR, ADDM, etc. for database performance tuning.

Confidential

• Lead Data transition team to move data marts from offshore to in-house data center.
• Present Management team Data Marts transition road-map.
• Analyze current state of Data Marts.
• Create and maintain database objects such as procedures, functions, packages using SQL and PL/SQL.
• Perform performance tuning, performance monitoring and troubleshooting.
• Identify all obsolete database objects and perform cleansing prior the move.
• Work with System DBA and Development team to mitigate Road blocks.
• Conduct data transformation using data mapping, business rules and logic.

Hardware and Software: ERWIN 9.2.0, Oracle 11g, SQL Developer, DataStage, VersionOne, MS SharePoint. MS Project

Lead ETL Developer

Responsibilities:

• Worked with the business users to gather user requirements and ensured on time phased delivery.
• Worked with business analysts to translate requirements into pseudo code in Requirement gathering phase.
• Involved in database development creating SQL queries, stored procedures, tables, views, and table-space creation etc.
• Architecture and design of the ETL solution including changed data capture, slowly changing dimensions.
• Lead development team in defining and documenting the best practice approach to handle high volumes of data for using BODS for ETL and data migration.
• Monitor BODS performance and make recommendations to improve performance
• Conduct data analysis activities including data assessment, data profiling, data cleansing.
• Conduct data transformation using data mapping, business rules and logic.

Business Objects Data Service Upgrade Project

Responsibilities:

• Upgraded Department of State Business Objects Data Integrator 11.5 to Data Services 3.2.
• Presented stakeholders upgrade road-map.
• Performed backup of Data Integrator 11.5 Production Repository and upgrade to Data Services 3.2
• Installed Data Services (3.2) using SAP recommended upgrade approach.
• Performed Administrative task to add Job server, create Repository, and configure Repository for the job server.
• Archived all inactive jobs and cleanup repository.
• Worked with SAP support group to resolve issues and close open tickets.
• Created Upgrade instruction manual for Operation to install Data Services in Production environment.
• Help other ETL developer to resolve and tune their ETL jobs in upgraded DS 3.2

Hardware and Software: ERWIN, Oracle 10g,11g, Business Objects Data Services, MS SharePoint. MS Project.

Data Architect and Analyst

Responsibilities:

• Worked on enhancing Carlyle Group Enterprise Data Model.
• Involved in Logical and physical modeling to support an integrated environment; Design Data marts, identify dimensions, facts.
• Assisted the team on data quality and governance initiatives.
• Interact with the ETL team to define and implement data extraction and loading processes;
• Analyzed source system data to assess data-quality.

Hardware and Software: ERWIN, MS SQL Server 2008, Business Objects Data Services, MS SharePoint. MS Project.

Data Architect and Analyst

Responsibilities:

• Developed data models documented with Logical and Physical ER diagrams, and managing development, testing and production automated script releases of data models.
• Provided technical best practices for data movement, data conversion, data cleansing and other ETL-related activities.
• Worked with development and test team to ensure all bugs are removed before code is deployed in UAT
• Interact with and guide SAP Data Services developers with data transformations and data mappings.
• Analyzed source system data to assess data-quality and work with Stakeholder, business analyst to determine strategies for handling data anomalies.

ETL Developer

Responsibilities:

• Designed and developed Business Objects Data Services (Data Integrator) jobs for data extract from various sources.
• Implemented data capture jobs using Data Integrator for slowly changing Data (SCD) for Type1, Type2 and Type6.
• Involved in coding, testing, modifying, debugging, documenting and implementing DI jobs and PL SQL scripts.
• Designed and implemented ETL Control system for importing, exporting and publishing data in Enterprise Data Warehouse.
• Wrote complex PL-SQL stored procedures to support complex business rule/complex validation rule and implement within work flow in data integrator jobs.
• Created various work flows, data flows to coordinate initial data loads as well as incremental.
• Developed Complex data integrator Mappings and Reusable Transformations to facilitate Daily, Weekly and Monthly Data Load.
• Identified and developed mapping logic for handling slowly changing dimensions.
• Coordinated creation of regressive data for unit testing in development and QA environment, validated with expected results.
• Handled loads up to hundreds of millions of records each day.

Hardware and Software: Oracle 10g, MS SQL 2005, Business Objects Data Services, HP - UX 11.11, XP, SQL, PL/SQL, TOAD, Shell script, MS SharePoint. RCS. MS Visio, MS Project.

Sr. ETL Developer, Analyst and Data Modeler

Responsibilities:

• Extensively work with ETL team to extract, transform and load data from EPIC CLARITY source systems to the EDW using Informatica and PL/SQL code
• Generate/Create Mapping Design documents.
• Support many various applications used at Inova health facilities such as Epic, CareFusion and ImageCast/PACS
• Involved with implementation team to write PL/SQL ETL Code to load data from various staging to EDW ( Dimension and Fact Tables ), after validation in the Test migrated the code from Test to Prod environment.
• Involved with implementation team to implement various subject areas like ENCOUNTER, ENCOUNTER BILL SUMMARY, APPPOINTMENT SCHEDULING, INFECTION CONTROL,QUALITY, PATIENT SAFETY, TOP OF HOSPITAL, READMISSION.
• Prepared high-level design document to extract data from complex relational database tables.
• Worked on Informatica tools like Source Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Strong experience on data quality, data profiling and data cleansing in loading data.
• Loaded data from source to target using Change Data Capture (CDC) transform for CDC.
• Designed Data flows, Workflows and jobs to load data from source to target in Business Objects Data Services.

Hardware and Software: Oracle 10g, MS SQL 2000, EPIC Clarity, Informatica Power Center 9.1, PL/SQL, SQL, TOAD, SQL Server 2005, TERADATA, XML, UNIX, UNIX Shell Script.

Sr. ETL Developer

Responsibilities:

• Developed and supported the extraction, transformation and load process (ETL) for Data Warehouse from the source systems custom PL/SQL packages and procedures, or external programming/scripting languages such as shell scripting, as necessary; integrates ETL routines into production job streams..
• Performed data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Prepared technical specifications for the ETL mappings to load data into various target tables and defining ETL standards.
• Implemented and Created error handling strategy to capture errors during data movement, analyze log file.
• Extensively used TOAD to check if data is properly loaded into target systems by writing SQL Queries.

Hardware and Software: Oracle 10g/9i, SQL Server 2000, Informatica 8.6.1, SQL, TOAD, PL/SQL, Unix (Sun Solaris), Visio 2003.

Lead Database Developer

Responsibilities:

• Interacted with clients to analyze and gather requirements to meet their requirements and creates pseudo code.
• Research and investigate data for stakeholders for developing new incentives and programs.
• Participated in requirement analysis and worked with Data Architect (DA) and Database Administrator (DBA) to define Entity Relation Ship Diagram (ERD).
• Created and Maintained Unix shell and PL/SQL scripting for production support .
• Developed backend processes using SQL, PL/SQL, and dynamic SQL, to create Stored procedures, packages, and triggers.
• Profoundly worked with high-performance PL/SQL features such as REF Cursor, Composite Data Type such as Records, Collections, Bulk Collect, Autonomous Transactions.
• Created and worked on Materialized views to simplify and improve query performance.
• Wrote control file and SQL script to load data from flat files to Oracle database using SQL *Loader.
• Migrated Oracle Forms from version 5.0 to 6i and Reports from version 3.0 to 6i.
• Designed and developed E-reminders for e-marketing campaigns using HTML and Lyris list Manager.
• Troubleshoot, Optimized and tuned the SQL queries for maximum efficiency and performance.
• Provided support both as single source and within a technical team.
• Delivered various Oracle Reports with procedure and package for front-end calling.

Hardware and Software: Oracle 10g/9i/8i, OEM, Unix (Sun Solaris), Born Shell scripts, Windows 2K/XP, SQL, PL/SQL, PL/SQL developer, Net 8, SQL*Loader, Forms 6i, 5.0, Reports 6i,5.0. HTML.

Programmer

Responsibilities:

• Created several Packages, Procedures to generate Forms and Reports.
• Used Designer/2000 Web Server Generator to Design and Develop modules to generate Package specification and Package body. PL/SQL Cartridge was used to generate dynamic HTML
• Supported day-to-day processes, for the project "Green Coffee Information system".

Hardware and Software: Designer/2000 1.3, Oracle Application Server 4.03, Developer/2000 1.3,, HTML, Windows 95

Programmer

Responsibilities:

• Deployed Oracle Forms and Reports in World Wide Web using Developer/2000 Server and Oracle Web Application Server.
• Integrated software in an order fulfillment and management system that controls stock and distributed systems for defense level logistics operation, coupled with an integrated logistics system to enable Supplier's visibility to Inbound Transactions.
• Used Designer/2000 Data Schema Diagrammer (DSD), Module Data Diagrammer (MDD), and Module Structure Diagrammer (MSD) to develop several modules to create user interface screens.
• Used Developer/2000, 91 Screens and several associated stored Procedures, Triggers.

Hardware and Software: Designer/2000 2.1, 1.3, Developer/2000 2.1, 1.3, Discover/2000 3.1, Oracle 8.0, 7.3, Windows NT