Two years of experience in business and data analysis data modeling, database management, strategic analysis, requirements gathering, application and decision support.
Skills
Financial Industry, Insurance and Retail industry.
Hands on experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems (Data Marts).
Expertise in the latest version of ERwin.
Knowledgeable in modeling Kimball and Inmon Data Warehousing environments.
Experienced in using SQL/DB2/Oracle/ SQL Server for data analysis and data profiling.
Proficient in using Normalizing (1NF, 2NF, 3NF) and De-normalizing techniques for optimum performance in relational and dimensional database environments.
Experienced in performing Data Analysis on SQL querying on Oracle, DB Visualizer Pro, MS SQL Server & MS Access and Information Data Quality (IDQ)
Working knowledge on creating Dashboards in Tableau.
Working knowledge in using 'R'.
Skills:
Database Modeling Tools
Erwin 7.1/7.3/8/8.2/9.5/9.5.2,Rational Rose 2000, MS Visio 2000/2007/2010
Databases & Database Tools
MS & SQL servers 2000/2005/2008 , Oracle 10g/11g/12c, MS Access 2007/2010/2013, DB2 Visualizer Pro 9.1.2
Reporting & Analysis Tools
Informatica Developer Quality(IDQ) 9.6.1 , Tableau, Delphi Report Builder, OBIEE, R Studio
Web Technologies
C#, HTML
ETL Tools
Informatica Power Center, Datastage
Technology
NET Framework 4.0, ASP.NET Microsoft Visual Studio 2010/2013
Work History
Data Modeler, 05/2016 - Present Accenture – Trenton, NJ,
Experience in working with JD Edwards and performing extensive analysis on the data.
Designing Data warehouse for different subject areas.
Using Erwin to design physical model for the subject areas.
Creating and maintaining Naming standard and source to target documents.
Data Analyst, 06/2015 - 03/2016 The Nielsen Company – Oldsmar, FL,
Worked closely with the Project Manager in creating the process swim lane and estimates for completion of the technical artifacts needed for development.
Participated in requirement analysis and efficient in understanding business requirement documents (BRD) and functional requirement documents (FRD).
Working knowledge with IBM Mainframes, DB2 tables, VSAM files and SSRS to migrate from legacy system to distributed environment like SQL Server and HDFS.
Worked on source to target Data mappings in excel as well as Informatica Data Quality (IDQ) tool to deliver the application level specific rules to the developers and performed Data Profiling.
Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
Performed Forward engineering, Reverse engineering, and applied naming standards in Erwin.
Worked closely with ETL, Hadoop and SSRS developers to deliver the business rules for them to produce report, flat file or PDF format.
Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN Created an enterprise data dictionary and maintained standards documentation.
Data Analyst, 12/2014 - 06/2015 The Nielsen Company – Chicago, IL,
Involved in requirement gathering and analysis with Business analyst, systems analysts, Developers and DBA and translated them into detailed reporting requirements.
Created and maintained Logical Data Model (LDM) and Physical Data Model (PDM) Generated DDL scripts and view on DB2 layers using forward engineering utility.
Written SQL Views for UI and Downstream to send data (Both Normalized and de-normalized views) Proficient in model versioning based on the releases on ERwin model mart Developed Data Mapping, Data Governance, and Transformation and cleansing rules as part of transferring the data from source to target.
Performed Reverse Engineering for a wide variety of RDBMS including DB2 in order to connect to an existing database and create ER diagrams.
Created an enterprise data dictionary and maintained standards documentation.
Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment Designed tables and implemented the naming conventions for Logical and Physical Data Models in ERwin r9.5 Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
