SUMMARY

• Over 8+ years of experience in Information Technology with expertise in Data modeling/Data Analyst for Data Warehouse/Data Mart development, Online Transaction Processing (OLTP) and Data Warehousing (OLAP) Business Intelligence (BI) applications.
• Experienced in various databases Design of development and Production environment involving Oracle, SQL server, Netezza, MY SQL, DB2, MS Access, Teradata etc.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Experienced in Data modeling using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm (3NF), Star Schema modeling, Snowflake modeling using tools like CA Erwin, Sybase Power Designer for both forward and reverse engineering.
• Enterprise in Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball and Inmon data warehouse methodologies.
• Experienced in performing ETL / ELT operations using SQL Server Integration Services (SSIS), BCP, NZLOAD and stored procedures.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Experienced in Netezza to Oracle Shell script for loading tables which are required by QA Tools from Netezza in to the Oracle.
• Experienced in designing star schema, Snowflake schema for Data Warehouse DB2 architecture using tools like Erwin, ER/Studio, and Power Designer.
• Experienced in working with Informatica Power Center for Extract Transformation and Loading of the data from different sources to targets which includes relational source, flat files, XML's etc.
• Experienced in Teradata Utility scripts like Fast Load, Multi Load to load data from various source systems to Teradata.
• Experienced in Normalization and De - normalization techniques to optimize performance in Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Experienced in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin data modeler, E-R Studio.
• Expertise in Informatica Power Center to integrate data from Oracle, My SQL, Netezza databases and flat files.
• Experienced in MDM (Master Data management) in removing duplicates, standardizing data, and to eliminate incorrect data.
• Experienced in SQL, PL/SQL, T-SQL programming using tools such as Aginity, Toad, SQL Plus and SQL Developer.
• Experienced using MapReduce, and "Big data" work on Hadoop and other NOSQL platforms
• Experienced in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, SSRS using MS SQL Server.
• Experienced in developing Conceptual, Logical and Physical models using ERWIN, Sybase Power designer and Embarcadero E-R Studio.
• Experienced in loading data into Oracle Database using Data Loader and SQL Loader.
• Experienced in designing complex queries, stored procedures, triggers, and user defined functions using T-SQL.
• Excellent in performing data transfer activities between SAS and various databases and data file formats like XLS,CSV,DBF,MDB etc.
• Experienced in Extraction, Transformation and Loading of data from Multiple Sources (oracle, Netezza, Taradata, fixed width and delimited flat files) to ORACLE using Informatica.

TECHNICAL SKILLS

Analysis and Modeling Tools: Erwin r9.6/r9.5/r9.1/r8.x, Sybase Power Designer, Oracle Designer, BP win ER/Studio, MS Access, Star-Schema, Snowflake-Schema Modeling, and FACT and dimension tables, Pivot Tables.

OLAP Tools: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9.

Oracle: Oracle12c/11g/10g/9i/8.x, R2 database servers with RAC, ASM, Data Guard, Grid Control and Oracle Golden Gate(Oracle Enterprise Manager),Oracle Data Guard, SQL, Net, SQL Loader and SQL PLUS, AWR,ASH, ADDM, Explain Plan.

ETL Tools: SSIS, Informatica Power Center 9.7/9.6/9.5/9.1 etc.

Programming Languages: Java, Base SAS, SSIS and SAS/SQL, SQL, T-SQL, HTML/ XHTML/ HTML4.0.1/ HTML3.2, Java Script, CSS3/CSS2/CSS1, UNIX shells scripting, PL/SQL.

Database Tools: Microsoft SQL Server 2014/2012/2008/2005 , Teradata, and MS Access, Poster SQL, My SQL, Netezza, SQL Server, Oracle.

Web technologies: HTML, XHTML, DHTML, XML, JavaScript

Reporting Tools: Business Objects, Crystal Reports

Operating Systems: Microsoft Windows 9x / NT / 2000/XP / Vista/7 and UNIX Windows 95, 98, Windows NT, Windows XP, 7.

Tools: & Software: TOAD, MS Office, BTEQ, Teradata 15/14.1/14/13.1/13 , SQL Assistant

Other tools: TOAD, SQL PLUS, SQL LOADER, MS Project, MS Visio and MS Office, Have worked on C++, UNIX, PL/SQL etc.

PROFESSIONAL EXPERIENCE

Sr. Data Modeler/Analyst

Confidential, Bloomington IN

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Involved in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams with all related entities and relationship with each entity based on the rules provided by the business manager using ERWIN r9.6.
• Designed and developed ETL to load data from various sources like DB2, Oracle12c, Flat files and MS SQL Server into Taradata15, Oracle, Netezza and SQL server targets.
• Created ERD diagrams using Open Sphere Model and implemented concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension and lookup tables simultaneously from different source systems (Netezza, DB2, Oracle, Flat files).
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked in Database using Oracle, XML, DB2, Teradata14, Netezza, SQL server, Big Data and NoSQL.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Worked on Normalization and De-normalization concepts and design methodologies. Like Ralph Kimball and Bill Inmon's Data Warehouse methodology.
• Performed Database testing (Data Warehouse / ETL) on ETL applications validating the data in Sources (SAP, Oracle) Targets (EDW).
• Involved in Designing the DB2 process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Executed Hive queries on Parquet tables stored in Hive to perform data analysis to meet the business requirements and worked on importing and exporting data from Oracle and DB2 into HDFS and HIVE using Sqoop.
• Created SSIS Packages for import and export of data between MS SQL Server2014 database and others like MS Excel and Flat Files.
• Involved in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Worked closely with the SSIS Developers to explain the complex Data Transformation using Logic.
• Developed stored procedures on Netezza (NZPLSQL scripts) and SQL server for data manipulation and data warehouse population.
• Created Fast Load, Fast Export, Multi Load, Tpump, BTEQ scripts for Target Database.
• Conducted design reviews and validated data models and was involved in MDM (Master Data Management).
• Done data migration from an RDBMS to a NoSQL database, and gives the whole picture for data deployed in various data systems.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS.
• Translating business requirements into SAS code for use within internal systems and models
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle, Taradata, and DB2 database.

Environment: ERWIN r9.6, Netezza, Oracle12c, Taradata15, T-SQL, SQL Server 2014, MySQL, DB2, SSIS, SSRS, LINUX, MDM, Hadoop, Hive, Pig, HBase, SAP, Ralph Kimball and Bill Inmon's, PL/SQL, ETL, BTEQ, Informatica, PowerShell, VBScrit, Excel, SharePoint, .NET

Sr. Data Modeler/Analyst

Confidential, Chicago, IL

Responsibilities:

• Involved in developing Database Design Document including Data Model Conceptual, Logical and Physical Models using Erwin r9.5.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle11g, DB2, SQL server 2012, Netezza, Ability and Flat files and loaded into Teradata14.1.
• Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDM.
• Wrote PL/SQL Stored Procedures, Functions, Cursors, Triggers, Packages and SQL queries using join conditions in UNIX environment.
• Worked on a MapRHadoop platform to implement Bigdata solutions using Hive, Mapreduce, shell scripting and Pig.
• Involved in Data from Sybase IQ to Netezza and make Informatica Code changes for the compatibility with Netezza.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Developed DB2 process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Oracle Validation process.
• Worked with Data Warehouse built in Netezza and Teradata Familiar with MDM concepts.
• Created databases and database’s objects like tables, views for different SQL Server projects.
• Developed logical and physical model for schemas, created standard data documentation, such as ERD and Flow Diagram.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008 and Experience in configuring and deploying SSIS and SSRS reports
• Expertise in writing and debugging stored procedures, triggers, Optimizing Code and Improving efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Developed PL/SQL triggers on master tables for automatic creation of primary keys and foreign keys.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS packages Dataflow and Bulk Insert
• Designed and developed various Oracle Forms and Reports for both Oracle Applications and Custom Development.
• Involved in UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Created SQL scripts and analyzed the data in MS Access/Excel and Worked on SQL and SAS script mapping.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Developed multiple MapReduce jobs in java for Data Cleaning and pre-processing analyzing data in PIG.
• Routinely conducted database monitoring and performance tunning using tools like Diagnostic Manager, SpotLight.
• Used SAP for Data Analysis and created macros to automate the process of refreshing the data in MS Excel.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Coordinated with DBA's and generated SQL code from the data models and generated DDL scripts using ERWIN.

Environment: ERWIN r9.5, Netezza, Oracle11g, Taradata14.1, T-SQL, SQL Server 2012, DB2, SSIS, LINUX, MDM, PL/SQL, SPSS, Excel, MS Access, ETL, Hadoop, MongoDB, Hive, Power BI, Informatica, SSRS, Star-Schema Modeling, OLTP and OLAP, SAP, Snowflake Schema Modeling etc.

Sr. Data Modeler/Data Analyst

Confidential

Responsibilities:

• Extensively used TOAD and Normalization Techniques to design Logical/Physical Data Models, relational database design.
• Worked in PL/SQL programming and developed Stored Procedures and Triggers and Data Stage, DB2, UNIX, Cognos, MDM, UNIX, Hadoop, Pig.
• Responsible for the Change Control and Release of Enterprise Data Models for Data Warehouse Subject Area Data marts. Used the following tools: CA/ERWIN, Quest/TOAD; Oracle RDBMS.
• Contributed in delivering logical/physical data model (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Made changes, as required, in existing SQL functions, procedures, and packages and also wrote new code per requirements using TOAD for DB2.
• Involved in SQL queries and optimizing the queries in Oracle10g, DB2, and Netezza, Teradata.
• Explored data in a variety of ways and across multiple visualizations using Power BI and designed Power BI Data visualizations utilizing cross tabs, Maps, scatter plots, pie, bar and density charts.
• Involved in extracting and transforming data using DTS Import Export Data, DTS Packages, and SSIS and in using BCP for Bulk copy operation and Bulk Insert.
• Extensively worked on Teradata tools & utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
• Involved in Netezza Administration Activities like backup/restore, performance tuning, and Security configuration.
• Used tools such as SAS/Access and SAS/SQL to create and extract oracle tables.
• Test and analyze stored procedures and triggers using Toad, and other database tools resulting in accurate and efficient data processing.
• Worked in data from Flat files, SQL Server2008, Oracle, DB2, and Sybase and load the data into flat files, Oracle and SQL Server using Informatica Power center.
• Worked with developers on data Normalization and De-normalization, performance tuning issues, and provided assistance in stored procedures as needed.
• Involved in Data extraction/Transformation/Cleaning/Loading has been implemented using SQL Loader and PL/SQL.
• Involved in creating tasks to pull and push data from Sales force to Oracle Staging/Data Mart.
• Created VBA Macros to convert the Excel Input files in to correct format and loaded them to SQL Server.
• Developed normalized Logical and Physical database models for designing an OLTP application.
• Responsible for Performance tuning by analyzing and comparing the turnaround times between SQL.
• Used MDM to implement slowly changing Dimension to maintain historical data in Data Warehouse.

Environment: Taradata14, Netezza, Oracle10g, SSAS, T-SQL, SQL Server2008, Power BI, DB2, SSIS, LINUX, TOAD, MDM, PL/SQL, ETL, SSRS, BTEQ, SAP, Excel, VBA, MS Access, Cognos, MySQL, Sybase, Star-Schema Modeling, UNIX, Snowflake Schema Modeling etc.

Sr. Data Analyst/Modeler

Confidential

Responsibilities:

• Designed in Conceptual Data Model, Logical Data Model, and Physical Data Model using Erwin r9.1.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Netezza and Oracle9i.
• Conducted phase planning and requirements gathering session with project team, clinical staff and physicians to customize EHR system.
• Involved in Data Marts, Operational Data Store (ODS), MDM, OLAP, Taradata13.1 Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Extensively used PLSQL tables and Bulk loader programs for processing data and loading into Oracle tables. Identified entities and attributes and developed conceptual, logical and physical models using ERWIN.
• Developed stored procedures on Netezza and SQL server 2005 for data manipulation and data warehouse population.
• Used Teradata tools & utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) extensively.
• Involved in process improvement, Normalization/De-normalization, data extraction, data cleansing, data manipulation
• Completed writing and testing a complex VBA program within Excel.
• Involved in creating and maintaining SSIS Package to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Developing Mappings and Transformations for the conversion of data from client's current EMR software to company’s software.
• Used of Excel functions such as V-lookup, H-lookup, trim, search functions for formatting EXCEL files for the data processing.
• Unloaded data from Netezza into flat files, using External table functionality to load onto SQL Server to be accessed by Cognos reports
• Presented the Data Scenarios via, Erwin, logical models and Excel mockups to visualize the data better.
• Used PL/SQL to write stored procedures and Oracle Index techniques to increase the performance.
• Extensively worked in developing ETL, Taradata for supporting Data Extraction, transformations and loading using Informatica Power Center.

Environment: ERWIN r9.1, Netezza, Oracle9i, Taradata13.1, EMR, EHR, Data Modeler, T-SQL, SQL Server2005, DB2, SSIS, LINUX, MDM, PL/SQL, Excel, MS Access, VBA, Informatica, MySQL, SSRS, .Net.