SUMMARY

• 7+years of professional IT experience in Data Analysis/Modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP)systems.
• Extensive working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Experience in understanding the business needs and gathering user requirements by conducting and participating in JAD sessions, interacting with end-users and training them on the applications developed for the organization.
• Experience in data analysis was responsible for collecting, preparing and cleaning data before or after it is collected in a database.
• Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects.
• Extensively worked on ERWIN tool with all features like REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams,Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.
• Efficient in Extraction, Transformation and Loading (ETL) data from spread sheets, database tables using Microsoft data transformation service (DTS).
• Experience withBusiness Process Modeling, Process Flow Modeling, Data flow modeling
• Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
• Performed extensive data cleansing, data manipulations and date transforms and data auditing.
• Experience in usingOracle, SQL*PLUS,SQL*Loader,TOAD,Win NT/2003.
• Developed database objects like PL/SQL packages, Oracle tables, stored procedures, triggers that are used for meeting the business objectives.
• Experience in carrying out the entire Software Development Life Cycle (SDLC).
• Developed Data dictionary and maintained Metadata for each model.
• Knowledge in using EXPLAIN PLANS for query optimization.
• Coordinated with other developers in tuning long running SQL queries to enhance system performance.
• Involved in debugging and developing exception-handling procedures whenever required.
• Extensive knowledge insoftware testing methodologyanddevelopingTest Plans,Test Procedures,Test Case Designand Execution, Modification Requests.
• Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.
• Good documentation skills and was involved in making functional and technical documentation.
• A strong team member with good Communication and Analytical skills.

TECHNICAL SKILLS

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, DatabaseDesign and Modeling, Data Integration and Migration, ETL Architecture and Design, Data Warehouse, OLTP, OLAP

Data Analysis: User Requirement Gathering, JAD Sessions, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Data Modeling Tools: Erwin r7.1/7.2/8.0, Power designer

Reporting Tools: Business Objects, Crystal Reports

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL

Databases: Oracle, SQL Server, MS-SQL, MS-Access

Web technologies: HTML, DHTML, XML

Operating Systems: Windows-95, 98,2000/XP/NT/Vista, Unix

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Perform Data validation and data check at the source databases ie RFID
• Check the Data mappings required to perform the transformation on Oracle database
• Data Scrubbing and Data massaging using Data cleaning techniques on SQL Server.
• Design and create the SSIS solution package on SQL server.
• Execution and scheduled tasks in SSIS to perform the data migration
• Data truncation and other validation checks are performed to ensure that all the data is loaded.
• Generation of crystals to track the daily update in the pallet information.
• Created test cases and uploaded to ALM/HP Quality Center.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Pulled the defect reports and percentage of pass/fail rate from ALM
• Analyzed the relationships between different tables and Used MS Visio to draw ER diagrams.

Environment: SQL Server 2008, SSIS, Oracle 10g, Java, SQL Queries, Crystal reports.

Confidential, Ashburn, VA

Data Analyst

Responsibilities:

• Completed verification and release of data according to SLAs, documented procedures and consumers’ needs.
• Performed reviews of data loads into FDW and ADW. Identified, investigated and resolved data quality issues and production defects/exceptions. Performed data corrections within DBs to avoid flow of wrong data to our Consumers
• Assisted in defining data reconciliation and governance procedures
• Participated in SDLC process by being involved in Analyzing phase (identified needs for the change and provided documented requirements to Tech group), UAT phase and Operational phase for 2 particular reports in FDW.
• Assisted with supporting new software releases. Participated in User Acceptance Testing (UAT) representing ADW/FDW teams and executed and reconciled data validation scripts to ensure that the new data loads are complete and accurate.
• Wrote and updated Copper procedures to ensure that they are current and meet business requirements for FDW business team
• Created Simple dashboards and variety of tables and graphs in Tableau for tracking data corrections analysis. Integrated raw data in Excel to construct summary pivotal tables.
• Used Toad and Rapid SQL to conduct DB queries for research purposes and supporting Ad hoc research requests from consumers. This included reviewing data dictionaries, developing derivation logic and blending data from multiple databases into one report by selecting primary key's from each database
• Conducted Defect Tracking and Change Control Procedures using Remedy and Clear Quest tools.
• Created and signed ebinders for FDW And ADW taking responsibility of the all the recons I worked on.
• Reviewed work of an L1 Analyst, provided suggestions to improve and signed off approving their reports as an L2 Analyst.
• Used Business Objects to set parameters and run daily and monthly reports for ADW.
• Trained new colleagues who joined the team, had shadow sessions and held reverse shadow sessions to ensure their understanding.

Environment: SQL Server 2008, SSIS, Oracle 10g, Java, SQL Queries, UAT.

Confidential, Aurora, IL

Data Modeler/Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in the redesign of the existing OLTP system.
• Acted as a Strong Data Analyst analyzing the data from low level.
• Worked with DBAs to recreate a best-fit physical data model from the logical data model. Performed logical and physical data modeling with Erwin and Model Manager.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user.
• Performed Data modeling using Erwin. Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering Erwin tool.
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Involved in the Database design and application development to support the creation and management of online business units for business users and customers usage.
• Used Erwin to transform data requirements into data models.
• Reverse Engineer the existing Stored Procedures and write Mapping Documents for them.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing
• Creating Mappings, Mapplets, Sessions and Workflows using Informatica to replace the existing Stored Procedures
• Extensively used ETL to load data from flat files (excel/access) to Oracle database.
• Also worked on Business Object ETL tool Data Integrator to create Mapping from Sybase existing data Sybase (ASE) to newly created data base Oracle 11i
• Worked on defining deadlines and helped team to meet the deadlines.
• Extensively worked on documentation of Data Model, Mapping Transformation and Scheduling jobs.
• Worked extensively with Business Objects XI Report Developers in solving critical issues of defining hierarchy, loops and Contexts.
• Designed Mapping Documents and Mapping Templates for Data Integrator ETL developer.
• Deployed naming standard to the Data Model and followed company standard for Project Documentation.
• Involved in extensive Analysis on the Teradata Systems.
• Helped in migration and conversion of data from legacy system to oracle database.
• Widely used Normalization methods and have done different normalizations (3NF).
• Good experience in data analysis querying and writing in SQL and TOAD.
• Analyzed the performance of the jobs during the project. Utilized standard techniques for enhancing the performance.
• Performed tuning of SQL Queries to improve the response time.

Confidential, Dayton, OH

Data Modeler

Responsibilities:

• Participated in all phases of project including Requirement gathering, Analysis, Design, Coding, Testing, Documentation and warranty period.
• Extensively used SQL for Data Analysis and to understand the data behavior.
• Done Reverse engineering on existing data model to understand the data flow and business flows of existing systems and to integrate the new requirements to current system.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert them to physical data model including capacity planning, object creation and aggregation strategies, partition strategies, Purging strategies as per business requirements.
• Conducted team meetings and proposed ETL strategy.
• Worked on Gap Analysis.
• Data analysis of existing data base to understand the data flow and business rule applied to different data bases by SQL
• Conducted meetings with the business and technical team to gather necessary analytical data requirements in JAD sessions.
• Partitioned tables based on the requirement and developed purging and archival rules.
• Designed and Developed strategies for Data Conversions and Data Cleansing
• Creating Mappings, Tech Design, loading strategies for ETL to load newly created or existing tables.
• Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
• Pre populate the static tables in the Data warehouse.
• Developed strategies and loading techniques for better loading and faster query performance.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Extensively used ETL to load data from flat files (excel/access) to Oracle database from different Vendors and external source systems.
• Worked on defining deadlines and helped team to meet the deadlines.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling jobs.
• Worked extensively with Micro strategy Report developers in creating data marts and develop reports
• Designed Mapping Documents and Mapping Templates for Data Stage ETL developer.
• Deployed naming standard to the Data Models at enterprise level and followed company standard for Project Documentation.

Environment: Erwin 7.2 (Data Modeling, ER Diagrams), Data stage 8.1/6.0, Micro Strategy, SAS, Oracle 11i/10G, Microsoft Outlook, AIX