SUMMARY

• A highly - accomplished Data Analyst and a Data Modeler with 4+ years of IT experience specialized in Software development life cycle (SDLC), designing and developing of database and data models.
• Extensive experience in Relational and Dimensional data modeling for creating logical and physical design of database and ER diagrams using data modeling tools like ERWIN and ER studio.
• Strong knowledge in using Erwin r9.7, r9.5, ER-Studio & Power Designer 16.5 for developing conceptual logical/physical, relational and multi-dimensional modeling, Data Transformation (ETL) and reporting.
• Expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources.
• Have knowledge with ETL Tools like INFORMATICA and IBM infosphere.
• Experienced in SSIS, SSRS in solving business problems and managing reports in organization.
• Good knowledge in Database programming PLSQL&SQL, SQL Server 2012/2008/2005 ORACLE 12c/11g/10g/9i, DB2, TERADATA 14.0, NoSQL Database tuning and query optimization.
• Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS).
• Excellent knowledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, effective functions, cursors and indexes using T-SQL.
• Provided Strong Support to the reporting team using data virtualization tools like Tableau, Power BI, etc.
• Strong hands on experience implementing dash boarding, data visualizations and analytics using Tableau Desktop and Sever.
• Experienced working with agile and waterfall methodologies.
• Have a good exposure in overall SDLC including Requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies and Microsoft SQL Server database management.
• Exceptional communication and presentation skills and established track record of client interaction.

TECHNICAL SKILLS

Programming Languages: C, C++, Python, SQL, T-SQL, PL/SQL, MATLAB,R programing.

Database Systems: SQL Server 2012/2008/2005 , NoSQL, MS Access, Oracle 11g/10g/9i, Teradata, MYSQL.

ETL and Reporting Tools: SSIS, SSRS, informatica 8.6/7.1/6.2, IBM Infosphere, Data Stage, Crystal reports, Tableau, x Celsius, QlikView.

Data Modeling Tools: Power Designer 16.5, Erwin9.3, 9.5,9.7, ER/Studio, UML 2.x, Erwin, MY SQL Workbench.

Bug Tracking Tool: IBM ClearQuest, Jira.

Operating Systems: MS Office Suite MS Word, MS PowerPoint, MS Excel, MS Access UNIX, DOS, Microsoft Windows 8.1/7/vista/7.

Methodologies: Waterfall & Agile.

PROFESSIONAL EXPERIENCE

Data Modeler/ Data Analysis

Confidential, Durham, NC

Responsibilities:

• Performed forward engineering in Erwin tool to generate schemas and implement them in DB
• Collected external data sources and stored the data into MySQL
• Built and automated KPI reports, data monitoring, forecast reports and product quality reports using SQL, Python to reduce reports preparation time
• Developed a Conceptual model using Erwin r9.7 based on business requirements
• Worked on ER-studio to develop physical and logical models after retiring ERWIN
• Create, maintain and publish logical and physical data models using ER STUDIO, GitHub, Neo4j
• Worked with business owners and took the lead to create METADATA definitions for 50,000 columns and deployed it in PRODUCTION for business and company use
• Collaborate with business users and architects to understand Business and Technical requirements
• Collaborate with data integration analysts to resolve data issues and translate business concepts and solution architecture into data models that reflect user needs
• Created data narratives and data functional design document, artifacts used by the developers as a source on how to use the data model
• Reverse engineer data structures to data models for data mapping and establish Data and Conceptual Flows
• Designed the Data Marts using Ralph Kimball’s dimensional data modelling technique.
• Provided Strong Support to the reporting team using data virtualization using Tableau.
• Designed and Developed Dashboards using Tableau for various ROI metrics
• Automated monthly excel reports into Tableau Workbooks and Dashboards
• Designed Dashboards using Filters, Parameters and Action Filters
• Produced standard monthly reports using Tableau
• Expert knowledge in Microsoft Excel, Microsoft Access, PowerPoint, and Tableau
• Established the connection between legacy system using MySQL and SQL Server
• Migrated data from legacy system to SQL Server and completed 99% records mapping
• Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages
• Formulated procedures for integration of R programming plans with data sources and delivery systems
• Prepared and facilitate weekly PMO meetings; captured meeting decisions and content into Excel based tracking logs
• Submitted Statements of Work into Contracts database
• Responded to all incoming questions and inquiries related to JIRA applications
• Prepared projects, dashboards, reports and questions for all JIRA related services
• Involved in documentation of Data Mapping and ETL specifications of data warehouse designing and developing conceptual models using Workbench and ERWIN designing tool as per requirements and demonstrated to business.
• Documented the complete process flow to describe the program development, logic, testing and implementation
• For good efficiency and better performance tuned several SQL Queries
• Created DDL scripts for implementing Data Modeling changes
• Performing product development process in agile sprint methodology and even involved in project management to deliver the sprints with deadlines

Environment: Erwin 9.5, Tableau, MYSQL, R Programming, Workbench, MS Excel, MS Visio, Oracle11g, SQL developer, Jira, GitHub, crystal reports 9.

Data Analyst/Data Modeler

Confidential, Glen Allen,VA

Responsibilities:

• Mapped business needs/requirements to subject area model and to logical enterprise model& developed many Subject areas from the scratch.
• Created Data Base Design of Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Validated the business data objects for accuracy and completeness.
• Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Developed the data warehouse dimensional models &schema for the proposed central model for the project.
• Extensively used Star Schema methodologies in building and designing the logical data model into ER/ Studio.
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
• Designed and develop Tableau visualization solutions.
• Worked on generating various dashboards in Tableau server using various data source.
• Installed upgrade Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked on the Snow-flaking the Dimensions to remove redundancy whenever required.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• Managed the extraction, transformation, and population of data files and databases (MS SQL Server 2008, Excel, and Access)
• Gathered business requirements and conducted a series of meetings with business users.
• Designed and implemented basic PL/SQL queries for testing and report/data validation.
• Used Data warehousing for Data Profiling to examine the data available in an existing database and created Data Marts.
• Ad hoc reporting, data analysis and troubleshooting for various business groups.
• Responsible for understanding the design and structure of different databases and writing ad-hoc queries for data mining using different data mining tools.

Environment: SQL Server 2008, Oracle 10g, Teradata 14.0, Erwin 9.5, Windows, MS office, MS Access, Visio, Informatica, Share Point, MS Outlook, MS Project, PL/SQL, MS Excel, MS Word, HTML, ER/Studio

Confidential

Jr. Data Analyst

Responsibilities:

• Worked in close association with the Business Analysts and DBA’s for gathering requirements, business analysis, and testing and project coordination.
• Interacted with end users and acquired the reporting needs.
• Defined best practices for Tableau report development.
• Prepared Dashboards using calculations, parameters in Tableau.
• Created all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting.
• Used Erwin to create tables using Forward Engineering.
• Reviewed the data model with the functional and technical team.
• Assisted the ETL staff, developers and end users to understand the data model.
• Maintained a change log for each of the data models created.
• Created SQL codes from data models and interacted with DBA's to create development, testing and production database.
• Added database objects (like indexes, partitions in oracle database) for performance.
• Checked to see if the data models and the databases are in sync.

Environment: Erwin7.x, Oracle 8i, Tableau, SQL Server 2008, ER/STUDIO, informatica, TOAD and UNIX.