Data Analyst

Pramod

Mobile #: +1-508-***-****

Email ID: ******.***********@*****.***

Professional Summary:

* ***** ** ********** ** data modeling, Business and Data Analysis, production support, database management, strategic analysis, requirements gathering, Application and Decision Support.

Efficient in analyzing, developing and documenting technical Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) along with Use Case Modeling and UML.

Experienced in developing Conceptual, logical models and physical models database design for Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer.

Proficient in Data Mart Design and Creation Of Cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.

Well versed in Normalization / De-Normalization techniques for optimum performance in Relational and Dimensional Database Environments and Data Management.

Good experience in Data Mapping and identifying the gaps between the systems.

Proficient in performing the Data Cleansing, Data Analysis and business process transformation.

Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using Erwin tool.

Involved in implementing the Referential Integrity by using Primary and Foreign key relationships.

Good Knowledge in designing the data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling Techniques.

Well versed in conducting Joint Application Design (JAD), User Acceptance Testing (UAT) and Gap analysis.

Professional Experience:

New York Life Insurance, Lebanon, NJ June 2016 to Jan 2017

Data Modeler / Data Analyst

Responsibilities:

Worked with the business users and ETL architect to gather and understand the business requirements in agile methodology.

Developed logical and physical data models using ERWIN according to the modelling standards using Kimball approach.

Worked on different Schemas and designed the Data Marts, dimensional data modelling using STAR schema.

Generated DDL statements for the creation of new ER/studio objects like table, views, indexes and Sequences.

Worked on the STAGING source systems (OLTP) and developed the data model according to the data that is needed to be driven into the INTEGRATION layer (OLAP).

Analyzed the data from various source systems and driven the data design from end-to-end processing for the CRM.

Identified the Facts and Dimension tables from the source systems and designed the data model based on the subject area.

Implemented the TYPE 2 slowly changing dimension (SCD) for all the dimension tables.

Developed Source to Target Mapping along with the transformation logic and shared with the ETL team.

Worked closely with the ETL (Datastage) team to extract data from multiple source systems and loading the data into the ORACLE database.

Worked on a periodical data cleansing exercise and documented the errors and its related solutions.

Performed changes that are needed to be done for the ETL team to run the jobs accordingly.

Worked closely with DBA’s for executing the DDL’s in order to create the tables, views, indexes and sequences.

Supported throughout the construction, testing and implementation phases.

Environment: ERWIN 9.5, Oracle 11g, ETL – DataStage 11.5,TOAD 12.7, PL/SQL, MS-Office tools.

Delaware Life, Waltham, MA Mar 2015 to Apr 2016

Data Analyst / Modeler

Responsibilities:

Responsible for taking requirements from business users, understanding business needs by scheduling meeting at regular basis.

Analyzed OLTP source systems and Operational Data Store and research the tables/entities required for the project.

Involved in modelling the risks with retail and commercial real estate sectors financial institution.

Implemented dimensional model using snowflake schema(logical and physical data modeling) in the existing architecture using Erwin.

Implemented advance modeling concepts like accumulating snap shot grain, periodic grain, transactional grain, fact less facts.

Analyzed potential transactions and investments, including economic benefits, risks, and strategic and financial impacts

Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.

Imported and performed data cleansing from various data sources to standardize the data.

Developed and Maintained data dictionary by revising and entering definitions.

Worked on Data profiling to check invalid values, nulls percentage and data related in tables.

Performed Ad-hoc analysis, data manipulation for analyzing complex data sets.

Supported Development team helping them understand the Schemas and the Data model.

Environment: ERWIN 9, Oracle 11g, ER Studio, Informatica Power Center 7.1.4, TOAD 8.5, SQL, PL/SQL, MS-Office tools.

Hanover Insurance, Worcester, MA Aug 2014 to Feb 2015

Data Modeler/ Data Analyst

Responsibilities:

Interacted with Business Analysts to understand the business requirements.

Gathered the necessary information for Business Object Modelling (BOM).

Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.

Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.

Coordinated with DBA on database build and table normalizations and de-normalizations.

Maintained the quality of data analysis, researched output and reporting, and ensured that all deliverables met specified requirements.

Developed SQL and PL/SQL scripts to perform data cleansing and PL/SQL procedures to populate date and time dimensions.

Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.

Performed data mapping between source MDM data model and the target EDW data model.

Worked with Model Manager and multiple data marts, involving multiple subject areas simultaneously, domains and Naming Standards.

Environment: Erwin, Oracle10g/11g,Oracle SQL Developer, PL/SQL, Business Objects, MS office suite, IBM Rational Software Architect 7.1s, Data Stage 7.5, DB2.

Prime Technology Group, King of Prussia, PA Apr 2012 to Jul 2014

Data Analyst

Roles & Responsibilities:

Reviewed requirements together with QA Manager, ETL Leads to enhancing the data warehouse for the originations systems and servicing systems.

Performed GAP Analysis of business rules, business and system process flows, requirements and developed Requirement Traceability Matrix to ensure current project requirements are met and their timely update.

Worked with the data management to design the claim adjustment and processing for the EDI HIPAA 4010.

Developed the data models according to the EDC systems and FDA standards and regulations.

Extensively involved in the Physical/Logical Modeling development identified, organized, and documented the changing requirements of the project.

Developed the Master Data Management (MDM) for the product logical and physical data model to validate and update the process for the completion of the functional design that is present in the Data management program of the product.

Documented requirements in ER Studio created Requirements Traceability Matrices (RTMs).

Worked on the change requests and performed the enhancements accordingly by data cleansing.

Developed and maintained data dictionary to create metadata reports for technical and business purpose.

Acted as a liaison between the Product owners and Development/QA teams for the issues and change requests.

Supported QA/ETL Teams in ensuring proper implementation of the requirements and developed and executed test plans and test scripts for testing and UAT (User Acceptance Testing).

Environment: ER Studio, Teradata V14, Mainframes, TOAD, XML, CA Harvest, MS SQL Server 2008, Clear Quest.

HDFC - Hyderabad, India Nov 2010 to Dec 2011

Database Analyst

Responsibilities:

Interacted with client, Onshore Consulting and Offshore development teams to drive projects towards goals.

Analyzed customers' business requirements and Provided Solutions within stipulated deadlines.

Prepared Technical Design Documents Based on Functional Design documents.

Performed Build, Unit Testing and Deployment.

Executed data migrations using Microsoft Data Migration Framework and other technologies.

Worked on Bug Fixing, Enhancements, Customizations and Upgrades.

Interacted with Customers in UK to gather business requirements.

Prepared Test Plan, Test Cases and Test Scripts.

Performed Assembly, System, Integrated and User Acceptance Testing.

Used Agile Scrum Methodology.

Data Mart Reporting Engine development on MS SQL 2008 for internal and external customers.

Data profiling, validation, report designing framework using BIDS on SQL 2008.

Worked with third party data base to store the required data for the client (Remedy A R Systems).

Environment: Erwin, MS SQL Server 2008, Informatica 8.6, SSIS, Win 7, Toad for Data Point.

ICICI - Hyderabad, India Jul 2009 to Oct 2010

SQL Developer/Data Modeler

Responsibilities:

Involved in the entire system study, analysis and design.

Provided ER diagrams via Erwin and ER Studio.

Prepared logical and physical data models by recognizing the proper entity and the attributes and implementing a proper relationship between them.

Worked on data mapping process from source system to target system.

Created ER Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified PK/ FK for lookup tables.

Used SQL*Loader for data transfer to the oracle databases.

Involved in testing the database for queries that were generated and handled the performance issues efficiently.

Designed XML schemas using Unified Modeling Language (UML) - translating business concepts into XML vocabularies.

Created Stored Procedures Using PL/SQL and tuned the databases and backend process.

Performance Tuning of the Database, which includes indexes, and Optimizing SQL Statements, monitoring the server.

Used SQL to Run Ad-hoc Queries and prepare reports to the management.

Environment: Oracle 9i, SQL Server 2005,XML, ER Studio, Erwin, Windows 2000/NT, UNIX, Load Runner.

Education: Master of Science in Information Security and Intelligence.

Technical skills:

Data Modeling Tools : Erwin r7.1/7.2, Erwin R8, R9, 9.5, ER Studio and Oracle Designer.

OLAP Tools : Microsoft Analysis Services, Business Objects, and Crystal

Reports 9

ETL Tools : Data Stage 9.2, 11.2 and Informatica 7.1.3

Programming Languages : SQL, T-SQL, PLSQL, HTML

Database Tools : Microsoft SQL Server […] Teradata, Oracle 11g, TOAD 12.7

MS Access Packages : Microsoft Office 2010, Microsoft Project 2010 and

Microsoft Visio, Share point Portal Server.

Operating Systems : Microsoft Windows 8x / NT / 2000/XP / Vista/7 and UNIX.

Quality Assurance Tools : Quick Test Pro, Quality Center, Rally, Trello.

Contact this candidate