OBJECTIVE:

To acquire a challenging position with an athletic company utilizing the opportunity to offer proven and developing skills within the company.

PROFESSIONAL SUMMARY:

• 8+ Years of IT experience with special emphasis on System Analysis, Design, Development, Testing and implementation of Data Warehousing, Data Integration and Data Migration using IBM Info sphere Data Stage (IIS) v11.3 or 9.1 or 8.5.3 (Parallel), and its foundation tools such as Oracle 11g, PL/SQL.
• Extensive experience in developing strategies for Extraction, Transformation, loading (ETL) data from various sources into Data Warehouse and Data Marts using Accentual Data Stage client tools like Data Stage Designer, Data Stage Director and Data Stage Administrator, Quality Stage, Information server and Parallel Extender.
• Good knowledge of Maintenance, enhance, and optimizing Data Stage jobs
• Experience in Software Development Life Cycle (SDLC) including System Analysis, Design, Data Modeling, Dimensional Modeling, Requirements Gathering, Decision Support and Implementation of various applications in OLTP and Data Warehousing.
• Experienced in designing the Conceptual, Logical and Physical data modeling using ER win and ER Studio Data modeling tools.
• Experienced in writing complex SQL scripts, Stored Procedures, Views and Triggers using, PL/SQL.
• Experience with ETL design and development of Data marts /Enterprise wide Data Warehouses / Operational Data Stores.
• Experience in using Quality stage with investigate, standardize, match frequency and survive.
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), Surrogate key assignment and CDC ( Change Data Capture ).
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Practical understanding of the data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Having good experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experience in Data transformation, Data mapping from Source to Target database schemas, Data Cleansing.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.
• Expert in writing SQL queries and optimizing the queries in Oracle 10g/11g, SQL Server 2008 R2/2012/2014.
• A good expertise in Extract, Transform and Load (ETL) data from spreadsheets, database.
• Have worked with ETL tools to extract, transform and load data from relational databases and various file formats and loaded to target database.
• A very good knowledge with dealing different types of data sources such as flat files, Excel, Oracle, Sybase, and SQL Server.
• Forward Engineering the Data Models, Reverse Engineering on the existing Data Models and updates the data models.
• Having good knowledge in Unified Model Language (UML) such as Use cases, Classes, Interaction, Sequence, state Diagrams, Deployment.
• Expert in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio .
• Knowledge in NoSQL database technologies used in modern data warehouse architectures.
• Perform data analysis and profiling of source data.
• Excellent interpersonal and oral/written communication skills.

TECHNICAL SKILLS:

ETL Tools: IBM Info Sphere / Web Sphere Data Stage 8.5/8.1/ 7.5.2/7.1 (Administrator, Manager, Designer, Director, Orchestrate, Information Analyzer, Quality Stage)

OLAP Tools: Microsoft Analysis Services, Business Objects and Crystal Reports9

SQL,T: SQL,PL/SQL,HTML,XML, JAVA, C, C++, UNIX and Shell Scripting

Database Tools: Microsoft SQL Server 2008/2012/2014 , MySQL, Oracle 11g/10g/9i/8i, DB2, MS Access 2007/2010 and Teradata V2R6.1, Sybase

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

Other Tools: SAS Enterprise Guide, SAP ECC and Panorama Web Service, Code Flow/TFS

PROFESSIONAL EXPERIENCE:

Confidential, Lansing, Michigan

Sr. Data Stage Developer /Data Analyst

Responsibilities:

• Gathering business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
• Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage (Info Sphere Information Server, Web Sphere, Ascential Data Stage).
• Created conceptual & logical models, logical entities and defined their attributes, and relationships between the various data objects.
• Used different Parallel job stages like Sequential File, XML Stage, Dataset Stage, Join, Merge, Lookup, Filter, Col and Row generator, Transformer, Change Data Capture, Modify, Aggregator, Remove Dup, Source and Target Stages, Oracle and ODBC Stages etc.
• Used Information Analyzer for profiling data, check the data content and structure, analyze various source system data according to business need.
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Extensively used Infosphere Quality Stages - Investigate Stage, Standardized Stage, Match and Survive Stage for generating reports, keeping the data clean and structured according to business.
• Generated the Pattern report and Token report as requested by the Business in identifying the Data patterns and inconsistency in the source data using Infosphere Quality Stage.
• Effectively used Standardized stage in standardizing the source data by using the existed rule sets like name, address and area etc. for multiple countries and generated the valid and invalid data reports.
• Involved in the design of Match Templates suggestions made by the Business and validated the results to identify the duplicates coming from the source depending on different Match types using Match Stage - Infosphere Quality Stage.
• Updated existing models to integrate new functionality into an existing application.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Developed normalized Logical and Physical database models to design OLTP system
• Created naming convention files, co-coordinated with DBAs’ to apply the data model changes.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Involved in setting up events for proactive monitoring. Involved in Analyzing and Optimizing Query Performance .
• Have a good understanding of Optimizer and Query execution plans .
• Create and maintain Metadata, including table, column definitions.
• Synched up the models by reverse engineering, compare model and merge model from database to the original models.
• Responsible for defining the naming standards for data warehouse.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Tuned the SQL Queries by breaking down the predefined queries into smaller queries for processing, Pushed Query processing up from the client to application server level.
• Evaluated Data Profiling, Cleansing, Integration and Extraction Tools.
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.

Environment: IBM Info sphere Data Stage 7.2/7.5/8.0/8.5/9.1/11.1 (Parallel Extender), SQL, Shell Scripts, Mainframe, ESP CA Work Station 11.3, IBM Rational (Clear Quest & Clear Case), SQL Server 2014, Oracle 11g, Informix 16, MS Excel, MS Visio 2010, Requisite Pro 7.1, TOAD SQL, PL/SQL, Windows.

Confidential, Sterling, VA

Data Stage/Data Analyst Developer

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing and Documentation. Gathered Requirements and performed Business Analysis.
• Understanding the specifications for Data Warehouse ETL Processes by interacting with the client and end users for gathering business requirements.
• Designed the specifications and analyzed the data for business requirements and developed metadata mappings and detailed design documents.
• Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems (Teradata) feeds using Data Stage, and Unix Shell scripts
• Extensively used SQL for Data Analysis.
• Extensively used Data stage Designer to Develop the Parallel Jobs.
• Developed various Jobs using Designer stages like Join, Lookup, Transformer, Copy, Sort Remove duplicate, Sort, Filter, Aggregator, Funnel stages.
• Developed parameter driven ETL process to map source systems to Target data systems with Data Stage complete source system profiling.
• Developed sequencers to control the job execution of the Data stage Jobs.
• Extensively used SQL to Extract the Data from the History tables to improve the performance.
• Involved in developing the shell scripts to create indexes, Drop the indexes on the Tables, FTP Processes and enhanced the master script to run the master sequencer
• Performed the Unit Testing for Jobs Developed to ensure that it meets the Requirements.
• Involved in migration of Data stage code to the Integration and Production, participated in Integration testing.
• Moved the ETL Jobs from Integration to Production
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Extensively performed Manual Test Process.

Environment: IBM Information Server 9.1, IBM Information Analyzer 9.1, Data Stage 9.1 (Designer, Director and Administrator), Oracle 10g/11g, DB2, SQL, PL/SQL, SQL* Loader, TOAD, Autosys, Windows XP/NT/2000, SQL Server 2014, SQL, Oracle11g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro.

Confidential, Burlington, NJ

Data Modeler/Data Stage Developer

Responsibilities:

• Gathered and analyzed requirements from the end users and converted functional specifications to technical specifications documents.
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Created Data Model from scratch which involved a complete life cycle implementation that encompassed business requirement gathering, analyzing their source systems; and then building financial data mart in order to provide functionality for their reporting purposes.
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Imported and exported Repositories across Data stage projects.
• Automated the processes to reduce the manual efforts.
• Involved in data profiling and data model.
• Developed a complex SQL code to use in the common code approach to avoid writing several SQL scripts for different source table/file formats.
• Preparation of technical specification for the development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data marts.
• Worked with Data Stage server stages like OCI, ODBC, Transformer, Hash file, Sequential file, Aggregator, Sort, Merge, Link Practitioner, Link collector, IPC and other stages.
• Implemented and hardcoded high performance Data Stage routines.
• Imported the required Metadata from heterogeneous sources at the project level.
• Used Parallel stages like Lookup, Join and Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator.
• Used Parallel Extender Development/Debugging stages like Row generator, Column Generator, Head, Tail and Peek for debugging of the jobs.
• Created conceptual, logical & physical data models with Erwin and did design review meetings with other team members in order to finalize the model.
• Implemented advanced modeling concepts like Bus Matrix Architecture, Resolving Multi Valued dimensions, and Conform dimensions, Junk dimensions, Degenerate dimensions in designing multi-dimensional model.
• To maintain the consistency and quality of the data worked with Data Governance, Data Profiling and Data Quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.
• Divided model into subject areas for reflecting understandable view to business as well as data model reviewers.

Environment: Windows 2008, IBM Data stage 8.5 Server/parallel/ 8.1/8.0/7.5/7.0 (Administrator Client, Manager, Designer Client, Director Client), Parallel Extender, Information Analyzer (IA), Oracle 11g, SQL Server 2008R2, SQL, and AIX/UNIX.

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Used SSIS to migrate databases such as Excel files, flat files, Oracle Database and SQL Server database to centralized IT destination.
• Involved in requirement gathering and performed ETL Process.
• Implemented Triggers, Views, Clustered and Non-clustered indexing. Extensive work on the performance tuning of Oracle ETL process.
• Created tables needed for ETL processing and develop ETL framework.
• Implemented SSIS packages to Migrate data to staging server and then to production server
• Following Data Warehousing methodologies and concepts, including Star schemas, snowflakes, dimensional modeling.
• Data migration from old databases and different databases to main database
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data.
• Developed logical and physical data models for central model consolidation.
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Developed process methodology for the Reverse Engineering phase of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Involved in extensive data analysis on Teradata, and Oracle Systems Querying and Writing in SQL and Toad.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Worked closely with the ETL SQL Server Integration Services (SSIS) Developers to explain the Data Transformation
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.

Environment: Windows XP/NT/2000 servers, Oracle10g, SQL Server 2012,DB2, MS SQL Server 2008/2005, Microsoft TFS, SQL Server Integration Services (SSIS), SQL server Reporting Services (SSRS), Microsoft Visual Studio, Share Point, SQL Server Management Studio, MS Excel

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Generated reports using SQL from oracle database, which were used for comparison with legacy system and created Temporary Tables to store the data from Legacy system.
• Identified the Objects and relationships between the objects to develop a logical model and translated the model into physical model using Forward Engineering in ERWIN.
• Transformations including aggregation, summation construct from operational data source to data warehouse.
• Developed Data Mapping, Data Governance, and Transformation and Cleansing rules for the Master Data Management.
• Developed high quality customized tables, reports and listings using PROC TABULATE, PROC SUMMARY and PROC REPORT.
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
• Normalized the database up to 3NF to put them into the star schema of the Data warehouse.
• Developed, monitored the workflows and responsible for performance tuning of the staging and 3NF workflows.
• Analyzed the source system (JD Edwards) to understand the source data and JDE table structure along with deeper understanding of business rules and data integration checks.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Implemented the Slowly changing dimension scheme (Type II & Type I) for most of the dimensions.
• Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
• Designed Data Marts using dimensional modeling and wrote PL/SQL ETL packages with Oracle PL/SQL to extract data from relational data store transform and load into the data mart.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• I mplemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• DE normalized the database to put them into the star schema of the data warehouse.
• Conducted logical data model walkthroughs and validation.

Environment: Oracle SQL Developer, Oracle Data Modeler, SSIS, Business Objects, SQL Server 2005/2008, Windows XP, MS Excel