SUMMARY

• Around seven years of experience as Data Modeler with expertise in MS SQL Server, data warehouse and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Extensive knowledge in T - SQL (DDL and DML) and Designed SSIS packages for different ETL process.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Experience of SQL Server solutions, Log shipping, Replication and SQL Server Clustering.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Extensively involved in Data Profiling, Data Mapping and Data Modelling and participated in domain model analysis and preparation of logical business model using UML.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Matrix, Gauge, Drill Down, Drill Through and web reporting by customizing URL Access.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, EMBARCADERO ERStudio,ER Studio 7.1.1, ERwin 4.0/3.5.2/3. x, Power Designer.
• Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Created Management Reports through SQL Server Reporting Service on demand.
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.
• Worked closely with various Business Object teams working on different technology platforms like Crystal, Cognos and Micro strategy.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. Data Modeler

Responsibilities:

• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Designed Data Mapping documents, DDL scripts, Data Dictionary and meta data, teradata of the models and maintained them.
• Developed SQL scripts, indexes, complex queries for data analysis and extraction.
• Writing T-SQL script, dynamic SQL, complex Store procurers, function, triggers
• Responsible for creating Functions, Stored Procedures, Database Triggers and user define function.
• Used Erwin data modular to design model for tables.
• Used SSIS and T-SQL stored procedures to transfer data from source to staging area and finally load into data warehouse.
• Designed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle 11g, DB2, flat file, Text file, Teradata) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Extensively worked to load data into Teradata using Teradata.
• Used truncate load, incremental load, full load to load Netezza tables.
• Created SSIS packages to extract data from OLTP (ROLAP) and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Created, debugged and modified Informatica ETL sessions and workflows.
• Platforms included Oracle 11g, DB2 (UDB) and SQL Server Management Studio.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Implemented start schema and snowflake schema dimension model.
• Involved in Data Profiling &Data Analysis on Database sources like Oracle and flat files.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Analyze spreadsheet and review cognos making sure reports are entered correctly.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case, State, Activity, and Class and Sequence diagrams using Rational Rose.
• Used Microsoft Visio for Business Process Modeling and Data flow diagrams.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Gathered the requirements for KPI and cube calculation
• Developing (Microstrategy) OLAP cubes by identifying tables (fact and dimension), data source and data source views attributes and dimension members using SQL Server Analysis Services (SSAS).
• Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
• Developed many MDX queries for creating measures that fits business logic.

Confidential, New your City, NY

Sr. Data Modeler

Responsibilities:

• Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services.
• Designed the technical specifications document for Teradata ETL processing of data into master data ware house and strategized the integration test plan and implementation.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Created logical and physical Dimensional data models using Erwin.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating many SSIS packages.
• Designed mappings document between sources to targets, using Star Schema, Implemented logic to Slowly Changing Dimensions.
• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions Worked with different methods of logging in SSIS.
• Generated reports using Cognos and Worked on data profiling / cleaning / transforming build up validation rules for data migration.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Conducted meetings with the business owners for requirements gathering for the data quality checks on various files.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Designed reports using SQL Server Reporting Services (SSRS).
• Designed and Developed matrix, tabular (directquery) and parametric Reports in the SQL Server Reporting Services.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
• Used advanced data modeling concepts such as Family of Stars, Confirmed Dimensions, and Bus Matrix in order to handle complex situations.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Created and Maintained Logical Data Model (LDM) for the project. Includes documentation of all Entities, Attributes, Data Relationships, Primary and Foreign key Structures, Allowed Values, Codes, Business Rules, Glossary Terms, etc.

Confidential, Cincinnati, OH

Data Modeler

Responsibilities:

• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Designed and developed Data model using Erwin.
• Created refined data models pertaining to reassessed business requirements conforming to applicable data standards and successfully documenting the existing system model and changes proposed/applied to the model.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Created tables and developed Bteq scripts to load the data quality checks results into those tables.
• Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
• Extensively used Metadata & Data Dictionary Management, Data Profiling, Data Mapping.
• Proficient in data modeling and dimensional modeling techniques such as snowflake schema, star schema and normalization.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Configured complex SQL queries to meet customer requirements as needed.
• Worked on Complex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Designed the physical data models using data provisioning and consumption techniques in Oracle environment.
• Extensively used Data Modeling, Data Analysis for OLTP and OLAP systems.
• Created complex SSAS cubes with multiple fact measures groups, and multi dimension hierarchies based on the OLAP reporting needs.
• Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Worked on Requirements Traceability Matrix to trace the business requirements back to Logical Model.

Confidential, Charlotte, NC

Data Modeler

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Involved in Dimensional Modeling, identifying the Facts and Dimensions
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Maintained the consistency of data by performing Data Profiling and Data Cleansing.
• Conducted meetings with the business owners for requirements gathering for the data quality checks on various files.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into SQL Server using various transformations in SSIS requirements and design goals of data warehouse.
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Made changes, as required, in existing SQL functions, procedures, and packages and also wrote new code per requirements using TOAD for DB2.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Participated Business Intelligence (BI) team to understanding the database and generating various interactive reports.
• Responsible for Data Analysis,Data Dictionary and Metadata Management -Collaborating with Business Analysts, SMEs, ETL Developers, Data Quality Analysts and Database Administrators for design and implementation of Logical Data Model.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel.