SUMMARY

• A highly accomplished Data Analyst and a Data Modeler with 8 years of IT experience specialized in Software development life cycle (SDLC), designing and developing of database and data models for various OLTP (online transaction processing), OLAP (online analytical processing) systems.
• 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.
• Strong experience in data modelling, conceptual, logical/physical, relational, and multi - dimensional modeling, Data Transformation (ETL) and reporting.
• Worked with star schema and snow-flake schema, fact and dimension tables in both data warehousing models and normalized data models.
• Proficient in data mart design and creation of cubes using dimensional data modelling.
• Well versed in normalization and de-normalization techniques for optimum performance in relational and dimensional database environments.
• Involved in the forward engineering of the logical models to generate the physical tables using Erwin2.5
• Vast experience of requirement gathering, to hold the sessions of JAD (Joint Application Development), JRP (Joint Requirement Planning), UAT (User Acceptance Testing), GAP analysis.
• Experience in SSIS, SSRS in solving business problems and managing reports in organization.
• Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS 2005/2008).
• Experience with data warehousing design methodologies using Kimball orInmon approaches
• Experience working with agile and waterfall methodologies.
• Provided Strong Support to the reporting team using data virtualization tools like Tableau, Power BI Etc.
• Excellent knowledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, effective functions, cursors, and indexes using T-SQL.
• Extensive experience in relational and dimensional data modeling for creating logical and physical design of the database and ER diagrams using data modeling tools like ERWIN and ER studio.
• Expertise in extracting, transforming, and loading (ETL) data from spreadsheets, database tables and other sources.
• Excellent team player to work in conjunction with business analysts, production, support teams, subject matter experts, database administrators, ETL team and database developers.
• Exceptional communication and presentation skills and established track record of client interactions.
• Committed Team player and capable of working independently. Good problem-solving skills, initiation, and judgment.

TECHNICAL SKILLS

Data analysis: Requirements Gathering, JAD sessions, Process/Production Model analysis, Data Normalization, Cleansing, Profiling, System Design, Data architecture internal Standards development, Metadata and Reports, Source and Target system Analysis, Project Management.

Languages: SQL, T-SQL, PL/SQL, C, C++, MATLAB

Database Systems: SQL Server, Oracle, Teradata, PeopleSoft,Metadata

MS Office Suite: MS Word, MS PowerPoint, MS Excel, MS Access, MS Visio.

Operating Systems: Microsoft Windows 2000/2003/2007/2008

ETL and Reporting Environment: SQL Server, SSIS, SSRS, Informatica, Data Stage, Crystal reports

Data Modeling Tools: Power Designer 16.5, Erwin, ER/Studio

Additional QA Skills: Business and Software Process and Procedure Definition, Quality Models, data standards, Measures and Metrics, Project Reviews, Audits and Assessments.

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Kansas City

Responsibilities:

• Analyzed data and created mapping documents using CDMA for developers.
• Worked with cross functional teams to fix the production issues.
• Performing product development process in agile sprint methodology and even involved in project management to deliver the sprints with deadlines.
• Assisted in building SQL code for loading data into Informatica.
• Performed testing after loading the data into the Datawarehouse.

Senior Data Modeler/Analyst

Confidential

Responsibilities:

• Responsible for creating solution designs and work with cross functional teams to gather requirements.
• Interact with Business analysts and product owners to gather the requirements which are necessary to build the Datawarehouse.
• Interact in scrum meetings with cross functional teams to check whether the standard process for workflow is being followed.
• Improvise the requirements for better database performances.
• Design a Requirement or Solution design document which helps the business analysts, developers and project managers to understand the approach.
• Based on the business requirement, create a data model to understand the high level granularity of the data.
• Create SQL Queries on how to handle the data.
• Create a technical specification document after the approach is finalized and the design is ready.
• Discuss the updated solutions with the data architect and team to make sure if the approach is right.

Senior Data Modeler/Analyst

Confidential

Responsibilities:

• Responsible for creating solution designs and work with cross functional teams to gather requirements.
• Interacted with stake holders to understand the data base and create a solution design document as needed.
• Performed forward engineering in Erwin tool to generate schemas and implement them in DB.
• Developed a Conceptual model using Erwin based on business requirements.
• Performed reverse engineering SQL DB to get physical data models.
• Performing product development process in agile sprint methodology and even involved in project management to deliver the sprints with deadlines.
• Worked on Star schema and Snowflake schemas and extensive knowledge on Dimensional Modelling.
• Created technical documents using CDMA tool and delivered it to the developers.
• Analyzed data and forwarded it to testing team and help them fix any kind of data issues.
• Worked on loading the data into data warehouse using informatica.
• Worked extensively on creating views and creating a standard flow for a data warehouse.
• Assisted building reports for reporting team using Power BI.
• Documented the whole process from staging the data to creating dimensions and facts.
• Created DDL’s to stage the data.
• Extracted data from Oracle and Teradata databases to SQL Datawarehouse.
• Analyzed Peoplesoft payroll data and created Solution design document for Payroll and Billing related data.
• Built dashboards using power BI for clients and mobile apps.

Environment: Erwin, Power BI, SharePoint, MS Excel, MS Visio, SQL server management studio, Jira, GitHub, Oracle, Teradata, Metadata, T-SQL.

Business Data Analyst

Confidential, Indianapolis, IN

Responsibilities:

• Responsible for creating business scenarios and use cases required for development and process in the industry.
• Gathering and documenting all business requirements as a part of the development by conducting numerous JAD sessions across the industry.
• Performed forward engineering in Erwin tool to generate schemas and implement them in DB.
• Developed a Conceptual model using Erwin based on business requirements.
• Performed reverse engineering SQL DB to get physical data models.
• Worked with slowly changing dimensions 1 and 2.
• Participated in all phases of system testing.
• Performing product development process in agile sprint methodology and even involved in project management to deliver the sprints with deadlines.
• Designing and developing conceptual models using MY SQL, work bench and Erwin designing tool as per the user requirements and demonstrated to the business how their database design look like.
• Developing and coordinating with the java development teams by providing them proper extraction logics from different sources.
• Provided extensive support to development team to finalize the UI dashboards which are needed to be customized accordingly.
• Maintaining the data of the other data (metadata) in-order to give the business a single point reference to the product development process flow.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform in a team as well as individually.
• Document, clarify and communicate requests for change requests with the requestors and coordinate with the development and testing team.
• Document the complete process flow to describe the program development, logic, testing and implementation, application integration and coding.

Environment: Erwin, MY SQL, Workbench, MS Excel, MS Visio, Oracle SQL developer, Jira, Github, Oracle.

Senior Data Modeler/ Data Analyst

Confidential, Dallas, TX

Responsibilities:

• Participated in requirement gathering sessions, conducted JAD sessions with users, subject matter experts.
• Developed conceptual model using Erwin based on business requirements.
• Developed and normalized logical and physical data base model using OLTP systems for finance applications.
• Extensively used normalization techniques (up to 3NF).
• Produced functional decomposition diagrams and defined logical data model.
• Involved in redesigning of the existing OLTP systems, modification and designing new requirements in the existing systems.
• Worked on upgrading Erwin data modeler from version 7.3 to version 9.5, served as Erwin repository administrator.
• Involved in designing the context flow diagrams, structure chart and ER-diagrams.
• Performed forward engineering to create a physical SAS model with DDL, based on the requirements from logical data model.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data-mart.
• Worked closely with ETL SSIS developers to explain the complex data transformation using logic.
• Implemented referential integrity using primary key and foreign key relationships.
• Involved in development and implementation of SSIS, SSRS and SSAS applications.
• Performed extensive data analysis and data validation on Teradata.
• Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy oracle and SQL server database systems.
• Assisted Reporting developers in building Reports using Crystal Reports.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Acted as strong Data Analyst analyzing the data from low level in conversion projects, provided mapping documents between legacy, production, and user interface systems.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Interacted with client, management, and staff to identify and document business needs and objectives, current operational procedures for creating the logical datamodel.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Extensively used SSIS import/export wizard for performing the ETL operations.

Environment: Erwin r8.0, T-SQL, Erwin 7.3/9.5, SQL, SQL Server 2000/2005, Rational Rose, Windows XP, Oracle 8i, Windows XP/NT/2000.

Data Modeler/ Data Analyst

Confidential, NJ

Responsibilities:

• Gathered business requirements and conducted a series of meetings with business users.
• 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.
• Conducted Review sessions of Data Models with DBA to best fit physical Model Indexes for better DB performance.
• 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.
• Worked on the Snow-flaking the Dimensions to remove redundancy whenever required.
• Involved using ETL tool Informatica Power Center to populate the database, data transformation from the old database to the new database.
• Analyzed the reverse engineered Enterprise Originations (EO) physical data model to understand the relationships between already existing tables and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Designed and implemented basic T-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.
• Conducted data profiling for better understanding of joins in ER models.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.

Environment: SQL Server, Oracle, Teradata, Erwin, Windows, MS office, MS Access, Visio, Informatica, Share Point, MS Outlook, MS Project, T-SQL, MS Excel, MS Word, HTML, ER/Studio.

Data Modeler/Analyst

Confidential

Responsibilities:

• Responsible for generating innovative solutions to bridge the gap between business and IT.
• Involved as a part of a team for gathering and analyzing the end user requirements.
• Translated business requirements into functional requirements for development and QA teams.
• Created database and database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Created user requirement documents based on functional specification.
• Involved in performance tuning to optimize SQL queries.
• Extracted data from Flat files, Excel and transformed as per the logic and loaded into Data Warehouse.
• Extensively used SQL for DataAnalysis and to understand and documenting the databehavior within and between two companies.
• Created packages to schedule the jobs for batch processing.
• Designing the procedures for getting the datafrom all systems to DataWarehousing system. The datawas standardized to store various Business Units in tables.
• Datamodeling was performed using ERWIN tool to build logical and physical models.
• Recommended opportunities for reuse of datamodels in new environments.
• Involved in extensive DATAvalidation using SQL queries and back-end testing.
• Involved with Design and Development team to implement the requirements.
• Understanding the DLD specifications document and working with design to develop the mappings using SQL Server Integration Services (SSIS).

Environment: ERWIN 7.3, MS SQL Server, Microsoft windows, Visual Studio, T-SQL, Enterprise Manager, Query Analyzer, Windows, MS Office, MS Word, MS Project, MS access.