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.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and extensive experience in project management methodologies, Microsoft SQL server database management, OBIEE.
• 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
• Extensive experience in enterprise Data flow analysis, data modeling and analytics (SSRS, SSAS, SSIS, ETL, MDM, Entity Data Models and data warehousing) incorporating transaction oriented business/service level data processes and metadata collection techniques to enhance informatics strategies.
• Proficient in data mart designing and identifying facts & dimensions
• Good understanding of Ralph Kimball and Bill Inmon’s modeling techniques
• Good knowledge about all phases of Software Development Life Cycle(SDLC) which includes Requirement gathering and analysis, Design, Implementation, Testing, Deployment & Maintenance
• In depth knowledge of Waterfall, Agile & XP development life cycles
• Expertise in Normalization to 3NF/ Demoralization techniques for optimum performance in relational and dimensional database environments
• Using Data Mapping, designed system test plans. Data Mapping is used in specifying of what 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 the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills
• Proficient in DataWarehousing techniques like Change DataCapture (CDC), Customer Data Integration (CDI) and Master DataManagement (MDM).
• 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,MDM

Dashboards Reporting Tools: Qlikview

ETL Tools: SSIS, Pentaho, Informatica, Power Center 6.0/7.1/8.1.1 , Power Mart 6.0.

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

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

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

Languages: SQL, PL SQL, Unix shell scripting

Reporting tools: Micro strategy, Cognos, Business Objects, Crystal Reports, OBIEE, SSRS

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/ Sr. Data Modeler

Responsibilities:

• Interacting with End user community, external vendors to understand the business requirements and in identifying data sources
• Understanding the existing Autosys jobs and scripts which relate to Business Logic and converting the same to make it work in EDW environment.
• Understanding the complex logic business transformation and implement into ETL development and design.
• Regular interaction with client to review the design.
• Analyzing the design pattern of various staging tables and Dimension and Fact tables.
• Created and maintained Metadata, including table, column definitions
• Perform performance tuning in the load level to improve the 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.
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided using SSRS.
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
• Enabled speedy reviews and first mover advantages by using Oozie to automate data loading into the Hadoop Distributed File System and PIG to pre-process the data.
• Working on a Map RHadoop platform to implementBigdatasolutions using Hive, Map reduce
• Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
• Conducted design reviews and validated data models and was involved in MDM (Master Data Management).
• Worked extensively with understanding, developing, cleansing, maintaining and entering metadata for various new as well as existing models

Environment: Oracle 11g, SQL, SSRS, XML, UNIX Shell Scripting, SQL Developer, Autosys, Erwin 9.5, Hadoop, MDM

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 the 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 the Data Marts using Ralph Kimball's approach
• Checked for all the modelling standards including naming standards, entity relationships on model and for comments in the model
• Generated customized report solutions for metadata reports
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
• Conducted design reviews and validated data models
• Analyzing query results in Excel, creating pivot table/chart reports etc. and sharing them with MDM team members.
• Designed different type of STAR schemas using ERWIN with various Dimensions like time, services, customers and FACT tables
• Reverse Engineered the existing database and based on Functional Design Specification (FDS) updated and optimized the existing star schemas to satisfy the reporting requirements
• Created Source to Target mappings and Transformations. Mapped data between Source and Targets.
• Coordinated with DBA's and generated SQL code from the 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, SSRS, 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 the 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 the business users and ETL / BI teams
• Creating or modifying the T-SQL queries as per the 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 the 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 the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the 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, MDM, 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 the business requirements by dividing them into subject areas and understood thedataflow within the organization
• Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
• Created DDL scripts for implementingDataModeling changes. Created ERWIN reports in HTML, RTF format depending upon the 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 the form of Entity Relationships and elicit more information
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and the expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
• 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 the main tool for data modeling along with MS VISIO
• Applieddatanaming standards, created thedatadictionary and documenteddatamodel translation decisions and also maintained DW metadata
• Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch and Analyzing query results.
• Used Star Schema and Snow flake schema methodologies in building and designing the logicaldata model in the dimensional Models
• Assisted developers, ETL, BI team and end users to understand thedatamodel

Environment: Microsoft SQL Server, Oracle 11g,Erwin R9, Visio, SSRS, 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 the to-be process using ERWIN r9
• Researched upstream data sources and ensured its owners attested all source data sources
• Created report specifications containing mapping to source data sources
• Worked with the developers on resolving the reported bugs and various technical issues
• Involved in preparing a simple and detailed User manual for the 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 the physical model to support the business requirements
• Developed server jobs to load thedatafrom flat files, text files, tag text files and MSSQL
• Created and scheduled the 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 the application
• Performed unit testing to check the validity of thedataat each stage
• Implemented best practices in the development environment (code standards, code migration)
• Created and ran Workflows and Worklets using Workflow Manager to load thedatainto the target database
• Performance tuning of SQL Queries, Sources, Targets and sessions

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