SUMMARY:

• Over 8+ years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications.
• Having good noledge in Normalization and De - Normalization techniques for optimum performance in relational and dimensional database environments.
• Experience working with Agile and Waterfall data modeling methodologies.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL.
• Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Has good experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP and Datamart environments.
• Strong Experience in Entity Relationships & Dimensional Data Modeling to deliver Normalized ER & Star/Snowflake schemas.
• Experience in modeling OLAP systems using Kimball and Bill Inmon Data warehousing methodology.
• Experience in using Business intelligence tools like Tableau and Power BI for visualizing and analyzing of data.
• Experience in writing Stored Procedures, Functions, Packages, Materialized Views, Triggers.
• Good understanding of service-oriented architecture (SOA) and web services like XML and SOAP.
• Experience in object-oriented analysis and design (OOAD), used modeling language (UML) and design patterns.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) tools.
• Strong experience in Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export.
• Extensively worked with data warehousing, Business Intelligence, ETL methodologies, technologies, using Informatica
• Expertise in performing User Acceptance Testing (UAT) and conducting end user sessions.
• Experience with Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Strong experience in using Excel and MS Access to dump teh data and analyze based on business needs.
• Excellent noledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Experience designing security at both teh schema level and teh accessibility level in conjunction with teh DBAs.
• Experience in working with Excel Pivot and VBA macros for various business scenarios.
• Experience working with data modeling tools like Erwin, Power Designer and ER Studio.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin Data Modeler 9.7/9.6, Erwin Model Manager, ER Studio v17, and Power Designer.

Programming Languages: SQL, PL/SQL, HTML5, XML and VBA.

Reporting Tools: SSRS, Power BI, Tableau, SSAS, MS-Excel, SAS BI Platform.

Cloud Platforms: AWS, EC2, EC3, Redshift & MS Azure

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

Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL Server 2016/2014, DB2.

Operating System: Windows, Unix, Sun Solaris

ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Talend, and Pentaho.

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model

PROFESSIONAL EXPERIENCE

Confidential - Broadway, NY

Sr. Data Modeler

Responsibilities:

• As a Sr. Data Modeler / Data Analyst me was responsible for all data related aspects of a project.
• Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin
• Participated in design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment.
• Worked with Business users for requirements gathering, business analysis and project coordination.
• Created Logical & Physical Data Modeling on Relational (OLTP), Dimensional Data Modeling (OLAP) on Star schema for Fact & Dimension tables using Erwin.
• Worked with data compliance teams, data governance team to maintain data models, Metadata, data Dictionaries, define source fields and its definitions.
• Worked on Performance Tuning of teh database which includes indexes, optimizing SQL Statements.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Integrated various sources in to teh Staging area in Data warehouse to Integrating and Cleansing data.
• Worked in importing and cleansing of data from various sources like Teradata, flat files, SQL Server with high volume data.
• Created a Data Mapping document after each assignment and wrote teh transformation rules for each field as applicable.
• Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
• Monitored teh Data quality and integrity of data was maintained to ensure TEMPeffective functioning of department.
• Connected to AWS Redshift through Tableau to extract live data for real time analysis.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables.
• Worked with MDM systems team with respect to technical aspects and generating reports.
• Performed thorough data analysis for teh purpose of overhauling teh database using SQL Server.
• Worked closely with teh ETL SSIS Developers to explain teh complex Data Transformation using Logic.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Developed and presented Business Intelligence reports and product demos to teh team using SSRS (SQL Server Reporting Services).
• Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches.
• Created data flow, process documents and ad-hoc reports to derive requirements for existing system enhancements.
• Used Microsoft Excel tools like pivot tables, graphs, charts, solver to perform quantitative analysis.

Environment: Erwin 9.7, Teradata r15, Oracle 12c, SQL, PL/SQL, AWS, OLTP, OLAP, MDM, T-SQL, SSIS, SSRS, UAT, ETL, Agile, XML, MS Excel 2017.

Confidential - Santa Clara, CA

Data Modeler/Data Analyst

Responsibilities:

• Worked as a Data Modeler/Analyst to generate Data Models using Erwin and subsequent deployment to Enterprise Data Warehouse.
• Interacted with Business Analysts to gather teh user requirements and participated in data modeling JAD sessions.
• Extensively used Agile methodology as teh Organization Standard to implement teh data Models.
• Developed Data mapping, Transformation and Cleansing rules for teh Data Management involving OLTP and OLAP.
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents
• Worked with Business users during requirements gathering and prepared Conceptual, Logical and Physical Data Models.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for teh new programs.
• Reverse Engineering teh existing data marts and identified teh Data Elements (in teh source systems), Dimensions, Facts and Measures required for reports.
• Conducted Design discussions and meetings to come out with teh appropriate Data Warehouse at teh lowest level of grain for each of teh Dimensions involved.
• Performed teh Data Accuracy, Data Analysis, Data Quality checks before and after loading teh data.
• Used SAS procedures like means, frequency and other statistical calculations for Data validation.
• Developed teh data warehouse model (Kimball's) with multiple data marts with conformed dimensions for teh proposed central model of teh Project.
• Designed a STAR schema for sales data involving shared dimensions (Conformed) for other subject areas using E/R Studio Data Modeler.
• Developed rule sets for data cleansing and actively participated in data cleansing and anomaly resolution of teh legacy application.
• Involved in data analysis, data discrepancy reduction in teh source and target schemas.
• Documented of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated teh appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs.
• Involved in Data profiling and performed Data Analysis based on teh requirements, which halped in catching many Sourcing Issues upfront.
• Created data masking mappings to mask teh sensitive data between production and test environment.
• Worked on Data Mining and data validation to ensure teh accuracy of teh data between teh warehouse and source systems.
• Performed Data Manipulation using MS Excel Pivot Sheets and produced various charts for creating teh mock reports.

Environment: ER/Studio v17, SQL, PL/SQL, Agile, OLAP, OLTP, Data Mart, T-SQL, SAS, Oracle 12c, SAS.

Confidential - Greensboro, NC

Data Modeler

Responsibilities:

• Conducted Design reviews with teh business analysts and content developers to create a proof of concept for teh reports.
• Initiated and conducted JAD sessions inviting various teams to finalize teh required data fields and their formats.
• Interacted with Business Analysts to gather teh user requirements and participated in data modeling sessions.
• Created Entity Relationship Diagrams (ERD), Functional diagrams, Data flow diagrams and enforced referential integrity constraints.
• Worked with teh Application Development team to implement data strategies, build data flows and develop data models
• Created conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Designed and Developed Oracle, PL/SQL, Procedures and Unix Shell Scripts for data Import/Export and data Conversions.
• Developed Data mapping, Data Governance, Transformation and Cleansing rules for teh Data Management involving OLTP and OLAP.
• Generated various reports using Sql Server Report Services (SSRS) for business analysts and teh management team.
• Used Load utilities (Fast Load & Multi Load) with teh mainframe interface to load teh data into Teradata.
• Optimized and updated UML Models (Visio) and Relational Data Models for various applications.
• Created Data stage jobs (ETL Process) for populating teh data into teh Data warehouse constantly from different source systems.
• Performed extensive Data Validation, Data Verification against Data Warehouse and performed debugging of teh SQL-Statements and stored procedures for business scenarios.
• Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning.
• Identified and tracked teh slowly changing dimensions and determined teh hierarchies in dimensions.
• Developed data Mart for teh base data in Star Schema, Snow-Flake Schema involved in developing teh data warehouse for teh database.
• Created data masking mappings to mask teh sensitive data between production and test environment.
• Normalized teh database based on teh new model developed to put them into teh 3NF of teh data warehouse.
• Created DDL scripts using Erwin and source to target mappings to bring teh data from source to teh warehouse.
• Maintained data consistency and database integrity and attended team meetings to identify requirements for data loading and reporting.

Environment: Erwin 9.2, Oracle 12c, SQL, PL/SQL, UNIX, 3NF, OLTP, OLAP, ETL, SSRS, UML.

Confidential - Mt Laurel, NJ

Sr. Data Analyst/Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Performed Reverse Engineering of teh current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Translated logicaldatamodels into physical database models, generated DDLs for DBAs
• PerformedDataAnalysis andDataProfiling and worked ondatatransformations anddataquality rules.
• Involved in extensivedatavalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Collected, analyze and interpret complexdatafor reporting and/or performance trend analysis
• Wrote and executed unit, system, integration and UAT scripts in adatawarehouse projects.
• Developed and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Involved in writing T-SQL working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Redefined many attributes and relationships in teh reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Designed teh data marts using teh Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Written complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects XIR2
• Written SQL scripts to test teh mappings and Developed Traceability Matrix of Business
• Involved in extensivedatavalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Created SQL tables with referential integrity, constraints and developed queries using SQL, SQL*PLUS and PL/SQL.
• Performed GAP analysis of current state to desired state and document requirements to control teh gaps identified.
• Developed teh batch program in PL/SQL for teh OLTP processing and used UNIX Shell scripts to run in corn tab.
• Identified & record defects with required information for issue to be reproduced by development team.
• Worked on teh reporting requirements and involved in generating teh reports for teh Data Model using crystal reports

Environment: Erwin 9.1, SQL, MS Excel 2012, Teradata r13, MS Access 2012, T-SQL, SSIS, SSRS, PL/SQL, UNIX

Confidential

Data Analyst

Responsibilities:

• Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.
• Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications.
• Involved in Data profiling and performed Data Analysis based on teh requirements, which halped in catching many Sourcing Issues upfront.
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
• Designeddataprocess flows using Informatica to sourcedatainto Statements database on Oracle platform.
• Involved in Data mapping specifications to create and execute detailed system test plans. Teh data mapping specifies wat data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and
• Developed PL/SQL scripts to validate and load data into interface tables
• Extensively used MS Access to pull teh data from various data bases and integrate teh data.
• Prepared business case for teh data mart and tan developed and deployed it.
• Modification of all databases via indexing of tables, MS SQL Server 2005 design parameters and stored procedures SQL code optimization.
• Redefined many attributes and relationships in teh reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Wrote and executed SQL queries to verify dat data TEMPhas been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed ad-hoc analyses, as needed, with teh ability to comprehend analysis as needed
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on teh basis of using defect reports.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing.

Environment: SQL, PL/SQL, Oracle 10g, MS Access 2010, MS SQL Server 2010, Teradata r12