SUMMARY

• 8 years of progressive experience as Data Modeler / Data Architect for Data Warehouse / Data Mart Development, Data Analyst for Online Transaction Processing (OLTP) and Data warehouse (OLAP)/ Business Intelligence applications in various business domains such as Financial Institution, Health Care and Telecommunication
• Experience in SDLC, Agile Methodology, requirement gathering, testing, debugging, deployment, documentation, development and production support.
• Expert in Business Event Analysis and Modeling (BEAM).
• Experience in conceptual design, logical design and physical design of data models, Star Schema/Snowflake modeling, FACTs & Dimensions tables using Erwin (7.3.3/7.2/6.0/5.5/4.5/4.0/3.5.5 ) and ER Studio
• Hand - on experience with various grains like Transactional grain, periodic snap shot grain and accumulating snap shot grain, views, Synonyms, Indexes, Joins and Partitioning.
• Strong experience in Data cleansing and Data profiling for detecting and correcting inaccurate data from the databases and to track data quality and to assess the risk involved in integrating data for new applications.
• Expert in creating Databases, Tables, Indexes, Schema, Stored Procedures, Views, Triggers, T-SQL, using SQL Server 2005/2008/2008 R2/2012
• Excellent management skills in facilitating data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions
• Experience in Data mapping for ETL, physical naming standards, datatypes, volumetric, domain definitions, business rules definition and corporate meta-data definitions.
• Expert in Extracting, Transforming and Loading (ETL) data using SSIS from different sources to destination
• Advance experienced in business data modeling concepts like degenerate dimension, fact-less fact table, bus matrix architecture for building EDW and building strategy for late arriving fact rows
• Knowledge of process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Extensive knowledge of Dimensions and Fact Data Modeling, Star Schema Modeling, and Snow-Flake Schema Modeling.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1 and MS Visio, JMP

OLAP Tools: Microsoft Analysis Services

ETL Tools: Microsoft SSIS and Informatica 7.1.3

Operating systems: Windows (98, 2000, XP, 7, 8, 9, 10)

Database: MS SQL, Oracle, Teradata

Methodology: SDLC, Agile Scrum, BEAM

Programming Languages: SQL, T-SQL, VBA, SAS/SQL, HTML, Java

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel, New Jersey

Data Modeler/ ETL Developer

Responsibilities:

• Facilitated agile session using Business Event Analysis Modeling (BEAM) for developing fact tables, dimensions and star schema
• Translated business requirement to conceptual and logical data models
• Participate in mapping of Logical to Physical Data Models and vice versa
• Analyzed, designed, developed and implemented a data cleansing and conversion routine to support data coming from different OEM vendors
• Designed Extraction, Transformation and Load (ETL) process in SQL Server Integration Services (SSIS) to migrate data from different sources (Excel, OLEDB, ADO NET, DB2, XML and Flat files) to centralized data mart.
• Created packages which includes a variety of transformations, for example Slowly Changing Dimensions; Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Designed, developed and tested the ETL Process
• Normalized the incoming files of different sources to 3NF at the staging area before loading into facts and dimension tables

Environment: CA Erwin, MS Visio, Oracle 9i, Oracle Designer, SQL Server2000/ 2005,Informatica, Crystal Reports 9, XML, Rational Rose and SQL Server Reporting Services

Confidential, Norristown, PA

Data Modeler

Responsibilities:

• Conducted meetings with each business line and gathered reporting requirements and created reporting requirements and got the approval from the business users
• Created standard architectural document by interpreting business logic and developed appropriate data flows and data dependencies
• Evaluated other Modeler’s logical and physical data models for adherence to modeling.
• Wrote and performance-tuned ETL code to load data mart.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using ERWIN / Star Schema
• Created and maintained data dictionary
• Helped developers wrote stored procedures and triggers to automate data flow tasks
• Designed Conceptual, Logical and Physical Model based on normalization standards (Second Normal Form/Third Normal Form).
• Conducted unit testing to ensure correctness of data flow

Environment: Erwin r7.1, Informatica 7.1.3, MS SQL Server 2008R2/2012, SSIS, SSRS, SSMS 20012, MS Excel 2013, DB2, MS Excel, MS Visio, Rational Rose, Requisite Pro

Confidential

Data Architect/Data Modeler

Responsibilities:

• Participated in high-level design of the first version of the system, whose ultimate goal is to develop a single repository for all Confidential partners data worldwide, holding information loaded from disparate sources
• Redesigned the Database using Common Table Expression(CTE), View, Stored Procedures, and Indexes
• Designed physical data model and ETL process to support Confidential ’s updated Data Warehouse.
• Created Star Schema and Snow-flake Schema using dimensional modeling concepts of Conformed Dimensions and Facts, Large Dimensions, Degenerated dimension, Fact-less fact table, Aggregate fact tables in Multidimensional model.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Worked with team members to develop initial project scope and conceptual models using Oracle Fusion's Developer Studio
• Generated requirements utilizing Oracle Fusion to create the logical data models and business process diagrams.

Environment: Erwin, MS SQL Server 2008R2/2012, DB2, MS Excel, MS Visio, Rational Rose, Oracle 10g

Confidential

MS SQL Database Developer

Responsibilities:

• Collaborated with end users to gather report requirements
• Analyzed work flow decision and how they translate into report requirements
• Created Stored Procedures, Triggers, Views, User defined functions, Queries, Sub queries
• Used Crystal Report with T-SQL queries to generate transaction reports
• Developed reports templates in Crystal Report
• Prepared banks performance reports monthly using Microsoft Excel
• Created documentation for procedures and best practices

Environment: MS SQL Server 2003, SQL Query Analyzer, MS Excel, Crystal Report, Windows XP, MS Windows Server 2005, MS Access, MS Data Transformation Services