SUMMARY

• Over 9 years of IT experience in Data & Business Analysis with a focus on Business Intelligence, Data Modeling, ETL Development, Process management and implementation of full - lifecycle
• Expertise using of ERWIN, Embarcadero ER/Studio & Power designer for developing Conceptual, Logical & Physical models
• Experience in Database Programming SQL & PLSQL, Oracle 12c/11g/10g/9i, XML, DB2 Teradata, Database Tuning and Query Optimization
• Experience in writing UNIX shell scripts to automate batch processes. Proficient in SQL query tuning to improve performance
• Experience of Business Intelligence tools like Tableau & Qlikview for visualization of data
• Understanding of WBS, Sequence Diagram, Data Flow diagrams and requirement gathering
• Extensively worked on ERWIN tool with features like Reverse Engineering, Forward Engineering, Subject area, Domain, Naming Standards Documentation etc.
• Efficient in Extraction, Transformation and Loading (ETL) data from spread sheets, database tables using Microsoft Data Transformation Service (DTS)
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II
• Experience in Data Modeling with expertise in creating Star-Schema, Snow-Flake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling using ERWIN Tool
• Proficient in data mart designing and identifying facts & dimensions. Good understanding of Ralph Kimball and Bill Inmon’s modeling techniques
• Good noledge about all phases of Software Development Life Cycle (SDLC) which includes Requirement gathering and analysis, Design, Implementation, Testing, Deployment & Maintenance
• In depth noledge of Waterfall, Agile & XP development life cycles
• Expertise in Normalization to 3NF/Denormalization techniques for optimum performance in relational and dimensional database environments
• Using Data Mapping, designed system test plans. Data Mapping is used in specifying of wat data will be extracted from an internal warehouse, transformed and sent to external data
• Strong expertise in Data Warehousing, Operations Data Store (ODS) concepts, data marts and OLAP technologies
• Well versed with data analysis using MS Excel & SAS
• Extensive experience in teh development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flows

TECHNICAL SKILLS

Functional: Business Requirements Analysis, Process mapping

Data Modeling: Logical Model, Conceptual Model, Physical Modeling, Star-Schema Modeling, Snowflake Schema, FACT & Dimension, OLAP

Dashboards Reporting Tools: Qlikview

Requirements Management Tools: Version One, Confluence, Rational Requisite Pro, DOORS, Quality Center, ALM

Data Modeling Tools: TOAD 9.7, 10.5, ERWIN Studio, ER/ Studio, Rational Rose, MS-Visio

Change Management Tools: Rational Clear Quest, Rational Clear Case, RSA

Languages: SQL, PL SQL, Unix shell scripting

Databases: Oracle 11g,10g/ 8i/ 9i, MS SQL Server 7.0/ 2000, 2008, MS Access, Teradata

Additional skills: Microsoft SharePoint, Business Objects, Crystal reports, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Greenville, SC

Sr. Data Analyst

Responsibilities:

• Interacting with End user community, external vendors to understand teh business requirements and in identifying data sources
• Understanding teh existing Autosys jobs and scripts which relate to Business Logic and converting teh same to make it work in EDW environment.
• Understanding teh complex logic business transformation and implement into ETL development and design.
• Regular interaction with client to review teh design.
• Analyzing teh design pattern of various staging tables and Dimension and Fact tables. Created and maintained Metadata, including table, column definitions
• Perform performance tuning in teh load level to improve teh performance. Perform object deployments on versioned repositories from QA to Production.
• Involved in Indexing and Partitioning of Database. Interacted with QA team in their testing of Data warehouse
• Extensively used SQL for performance tuning
• Created and executed SQL queries (using SQL and MS Access) and scripts to validate data movement
• Worked closely with DBA's as a part of various database change requests
• Involved in documentation of Data Mapping and ETL specifications for Data warehouse.
• Worked extensively with understanding, developing, cleansing, maintaining and entering metadata for various new as well as existing models

Environment: Oracle 11g, SQL, XML, Unix Shell Scripting, SQL Developer, Autosys, Erwin 9.5

Confidential, New York, NY

Data Analyst/Sr. Data Modeler

Responsibilities:

• Identified entities and attributes and developed conceptual, logical and physical models using ERWIN
• Worked on cleansing and organizing various tables in a presentable manner to help with better understanding of already existing models
• Produced Pdfs for various models (logical and physical) to ensure communication with different teams (DA, ETL, IA, and Development)
• Worked with teh Reporting Analyst and Reporting Development Team to understand Reporting requirements
• Produced customized data definition reports for smooth coordination between various teams associated in a project
• Created documentation for custom reports using report designer in ERWIN. Designed teh Data Marts using Ralph Kimball's approach
• Checked for all teh modelling standards including naming standards, entity relationships on model and for comments in teh model
• Generated customized report solutions for metadata reports
• Conducted design reviews and validated data models
• Designed different type of STAR schemas using ERWIN with various Dimensions like time, services, customers and FACT tables
• Reverse Engineered teh existing database and based on Functional Design Specification (FDS) updated and optimized teh existing star schemas to satisfy teh reporting requirements
• Created Source to Target mappings and Transformations. Mapped data between Source and Targets.
• Coordinated with DBA's and generated SQL code from teh data models and generated DDL scripts using forward engineering in ERWIN

Environment: ERWIN 9.5, Oracle 11g, DB2, MS SQL Server 2008, SQL, XML, MS Excel, SSIS, TOAD, Crystal reports 9, SAS

Confidential, Minneapolis, MN

Sr. Data Modeler/Data Analyst

Responsibilities:

• Worked with business users to gather requirements and create data flow, process flows and functional specification documents
• Designed & Created Test Cases based on teh Business requirements. Involved in extensive Data validation using SQL queries and back-end testing
• Involved in data analysis and creating data mapping documents to capture source to target transformation rules
• Used ERWIN and MS VISIO to create 3NF and dimensional data models and published to teh business users and ETL / BI teams
• Creating or modifying teh T-SQL queries as per teh business requirements
• Worked on creating role playing dimensions, Factless Fact, snowflake and star schemas
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,datamapping, metadata management,dataquality, testing strategy and maintenance of teh model
• Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved in teh validation of teh OLAP Unit testing and System Testing of teh OLAP Report Functionality and data displayed in teh reports

Environment: Erwin 9.5, Power Center 8.1/9.1, Power Connect/ Power exchange, Oracle 11g, DB2 MS SQL Server 2008, SQL, XML, Windows NT 4.0, Unix Shell Scripting

Confidential, Chicago, IL

Data Analyst/Data Modeler

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis
• Analyzed teh business requirements by dividing them into subject areas and understood thedataflow within teh organization
• Created aDataMapping document after each assignment and wrote teh transformation rules for each field as applicable
• Created DDL scripts for implementingDataModeling changes. Created ERWIN reports in HTML, RTF format depending upon teh requirement
• PublishedDatamodel in model mart, created naming convention files, co-coordinated with DBAs to apply thedatamodel changes
• Used Model Mart of ERWIN r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Used ERWIN r9 for reverse engineering to connect to existing database and ODS to create graphical representation in teh form of Entity Relationships and elicit more information
• Helped teh BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and teh expected output for each model created
• Gained Comprehensive noledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository
• Extensively used ERWIN r9 as teh main tool for data modeling along with MS VISIO
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata
• Used Star Schema and Snow flake schema methodologies in building and designing teh logicaldata model in teh dimensional Models
• Assisted developers, ETL, BI team and end users to understand thedatamodel

Environment: Microsoft SQL Server, Oracle 11g, Erwin R9, Visio, Informatica, Business Objects, Teradata SQL Assistant, ER Studio, Linux

Confidential, Northbrook, IL

Data Analyst/Data Modeler

Responsibilities:

• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS VISIO. Performed Data Analysis and Data validation by writing complex SQL queries using T-SQL
• Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements
• Created and maintained Data Dictionary and pursued to reach consensus. Provided primary liaison between business/operations/vendors and development
• Created data models and data flow diagrams for teh to-be process using ERWIN. Researched upstream data sources and ensured its owners attested all source data sources
• Created report specifications containing mapping to source data sources. Worked with teh developers on resolving teh reported bugs and various technical issues
• Involved in preparing a simple and detailed User manual for teh application, for an intended novice user

Environment: SQL Server 2005/2008, Oracle 9i, MS Access, ERWIN r9, SQL Loader.

Confidential

Data Analyst

Responsibilities:

• Suggested various changes in teh physical model to support teh business requirements. Developed server jobs to load thedatafrom flat files, text files, tag text files and MS SQL
• Created and scheduled teh job sequences by checking job dependencies. Wrote complex SQL queries using joins, sub queries and correlated sub queries
• Wrote PL/SQL stored procedures, functions and packages and triggers to implement business rules into teh application
• Performed unit testing to check teh validity of thedataat each stage. Implemented best practices in teh development environment (code standards, code migration)
• Created and ran Workflows and Worklets using Workflow Manager to load thedatainto teh target database
• Performance tuning of SQL Queries, Sources, Targets and sessions

Environment: Oracle 9i, MS SQL Server, PL/SQL, Toad.