SUMMARY

• Overall, 8+ years’ experience in the IT industry as data modeler in Data modeling forData Warehouse, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Experienced in all phases of SDLCincluding requirement gathering, development, testing, debugging, deployment, documentation, production supportand agile project management methodologies, Microsoft SQL Server database management, OBIEE.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Big Data and Cloud experience using Hadoop, AWS, Azure, Snowflake, Informatica Power Center Business Intelligence, Dimensional Modeling, ER Modeling
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Experienced in integration of various relational and non - relational sources such as DB2, Oracle, SQL Server, NoSQL, XML and Flat Files.
• Extensive experienced in Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performance Data Warehouse/Data Mart environments.
• Experience in using Informatica ETL tools and utilizes such as BDM and IDQ.
• Proficient in Oracle tools and utilities such as TOAD, SQL*PLUS and SQL developer.
• Strong expertise in Metadata, Data Quality, Master Data Management (MDM) and Data Governance.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Knowledge on Data modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Implemented Slowly Changing Dimensions, Type I & II in Dimension tables as per the requirement specifications.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions
• Good understanding ofviews, Synonyms, Indexes, Joins and Partitioning.
• Experience in data extractions from SAP systems and performing data reconciliations between different source systems.
• Highly motivated team player with the ability to work independently and adapt quickly to new and emerging technologies.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x,10.x, Microsoft SQL Server Integration Services (SSIS), Microsoft Analysis Services, Business Objects

Data Modeling Tools: Erwin 9.5/9.X, HDFS, Redshift, ER/Studio, AWS, Azure, Snowflake.

RDBMS: Oracle, MS SQL Server, MS Access, DB2, Teradata, DB2 UDB 7.1, PL/SQL, TOAD, PUTTY

Languages: SQL, UNIX Shell, PL/SQL, UNIX shell scripting.

Reporting tools: Autosys/Control -M, Power BI, Tableau.

Operating Systems: Microsoft Windows 10/7/NT/XP and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Data Modeler

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Developed normalized Logical and Physical database models to design OLTP system for using Erwin based on requirements analysis.
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r9.5
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated, and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards for data warehouse
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 andSQL Serverdatabase systems
• Exhaustively collected business and technical metadata and maintained naming standards
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges
• Used Model Mart ofErwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation

Environment: Erwin, Informatica 10.x, SQL, Oracle, DB2

Confidential

Data Modeler

Responsibilities:

• Creating the Conceptual Data Model as per the Business process flow in Microsoft Visio.
• Involved in the Analysis of the Business requirements and Design the Logical, Physical data Model using ERWIN.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Creating Proof of Concepts from scratch illustrating how these data integration techniques can meet specific business requirements reducing cost and time to market.
• Working with BA engineers to answer questions about data quality and integrity as well as identifying opportunities for presenting existing data in novel ways.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Responsible for testing Web Based and Client Server FACETS, Healthcare Payer Application applications on different platforms.
• Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
• Generated DDL (DataDefinition Language) scripts using Erwin 8 and supported the DBA in Physical Implementation ofdataModels.
• Recognized Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Sequence Diagrams using MS Visio.
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Used SQL, Python, Excel, and other tools to create reports and develop practical solutions to challenges for operations, engineering, and sales.
• Designed and Deployed Big data solutions on Cloudera Platform.
• Development of database objects like Hive External tables and HBase table DDL’s.
• Performed the Data Mapping, Data design (Data Modeling) to integrate the data across the multiple databases into EDW.
• Understanding the data model, Data Extract, data profiling, de-duplication of data, data mapping, Source to Target mapping, look ups and transformations in excel, working with the development team to meet business requirements and logic for the Datawarehouse.
• Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
• Developed dimensional model forDataWarehouse/OLAP applications by identifying required facts and dimensions.
• Worked Extensively with DBA and Reporting team for improving the Report Performance with the Use of appropriate indexes and Partitioning.

Environment: Hortonworks, Oracle 10g, SQL Server 2005, PL/SQL, Toad, Informatica 10.4, AWS S3, EC2, Redshift, RDS, Informatica 9.6.1, Tableau.

Confidential

Data Analyst

Responsibilities:

• Worked as Data Analyst for requirements gathering, business analysis and project coordination.
• Worked with the Data Analysis team to gathering the Data Profiling information
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Performed Data Analysis and Data validation by writing SQL queries using SQL assistant.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Gathered business requirements through interviews, surveys with users and Business analysts.
• Worked on Data Mining and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
• Performed Data analysis of existing data base to understand the data flow and business rules applied to Different data bases using SQL.
• Generated Data dictionary reports for publishing on the internal site and giving access to different users.
• Used MS Visio and Rational Rose to represent system under development in a graphical form by defining use case diagrams, activity, and workflow diagrams.
• Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Worked in data management performing data analysis, gap analysis, and data mapping.
• Established a business analysis methodology around the RUP (Rational Unified Process).
• Developed stored procedures in SQL Server to standardize DML transactions such as insert, update, and delete from the database.
• Created SSIS package to load data from Flat files, Excel and Access to SQL server using connection manager.
• Produced report using SQL Server Reporting Services (SSRS) and creating various types of reports.

Environment: Oracle, SQL Server, DB2, UNIX, HP ALM, ERWIN, JIRA, Microsoft Visio, Autosys, Informatica.