Two years of experience in business and data analysis data modeling, database management, strategic analysis, requirements gathering, application and decision support.
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'.
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
Informatica Power Center, Datastage
NET Framework 4.0, ASP.NET Microsoft Visual Studio 2010/2013
05/2016 to Current
Data ModelerMartin Marietta Materials – Raleigh, NC
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.
06/2015 to 03/2016
Data AnalystWaddell & Reed Financial Services – Overland Park, KS
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.
12/2014 to 06/2015
Data AnalystLiberty Mutual Insurance – Dover, NH
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.
06/2014 to 12/2014
Software Developer InternBentley Systems, Inc – Covington, LA
Designed and created Data Views from Oracle and SQL Server databases.
Performed analysis using Microsoft Office consisting index matching, v-look-ups, Macros and pivot tables in Excel.
Identified data errors and inconsistencies found through data mining activities and analysis.
Created reports using Dashboards in Tableau.
08/2012 to 05/2014
Graduate AssistantLouisiana State University – Baton Rouge, LA
Hands on experience on maintaining SQL Database for EHS department.
Performed Data profiling on the chemical Inventory depending on the requirements.
Generated reports in Delphi Report Builder using SQL.
IT and Computer Network needs.
Master of Science: Systems Science Louisiana State University - Baton Rouge, LA Systems Science
Bachelors of Technology: Information Technology JNTU- HYD - Information Technology