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 teh forward engineering of teh logical models to generate teh physical tables using Erwin2.5
• Vast experience of requirement gathering, to hold teh 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 teh reporting team using data virtualization tools like Tableau, Power BI Etc.
• Excellent noledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, TEMPeffective functions, cursors, and indexes using T-SQL.
• Extensive experience in relational and dimensional data modeling for creating logical and physical design of teh 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

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. Aid Production Issues

PROFESSIONAL EXPERIENCE:

Senior Data Modeler

Confidential

Responsibilities:

• Responsible for creating solution designs and work with cross functional teams to gather requirements.
• 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 teh sprints with deadlines.
• Analyzed data and forwarded it to testing team and halp them fix any kind of data issues.
• Worked on loading teh data into database 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 teh whole process from staging teh data to creating dimensions and facts.
• Created DDL’s to stage teh data.

Environment: Erwin, Power BI, SharePoint, MS Excel, MS Visio, SQL developer, Jira, GitHub, Oracle, Teradata.

Senior Data Modeler/Analyst

Confidential, Indianapolis, IN

Responsibilities:

• Responsible for creating business scenarios and use cases required for development and process in teh industry.
• Gathering and documenting all business requirements as a part of teh development by conducting numerous JAD sessions across teh 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 teh sprints with deadlines.
• Designing and developing conceptual models using MY SQL, work bench and Erwin designing tool as per teh user requirements and demonstrated to teh business how their database design look like.
• Developing and coordinating with teh java development teams by providing them proper extraction logics from different sources.
• Provided extensive support to development team to finalize teh UI dashboards which are needed to be customized accordingly.
• Maintaining teh data of teh other data (metadata) in-order to give teh business a single point reference to teh 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 teh requestors and coordinate with teh development and testing team.
• Document teh complete process flow to describe teh 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 and business analysts.
• 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 teh existing OLTP systems, modification and designing new requirements in teh existing systems.
• Worked on upgrading Erwin data modeler from version 7.3 to version 9.5, served as Erwin repository administrator.
• Involved in designing teh context flow diagrams, structure chart and ER-diagrams.
• Performed forward engineering to create a physical SAS model with DDL, based on teh 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 teh 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 teh form of Entity Relationships and elicit more information.
• Acted as strong Data Analyst analyzing teh data from low level in conversion projects, provided mapping documents between legacy, production, and user interface systems.
• Used Model Mart of Erwin for TEMPeffective 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 teh logical datamodel.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Extensively used SSIS import/export wizard for performing teh ETL operations.

Environment: Erwin r8.0, 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 teh 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 teh engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Developed teh data warehouse dimensional models &schema for teh proposed central model for teh project.
• Extensively used Star Schema methodologies in building and designing teh logical data model into ER/ Studio.
• Did Performance Tuning of teh database which included creating indexes, optimizing SQL Statements & monitoring teh server.
• Worked on teh Snow-flaking teh Dimensions to remove redundancy whenever required.
• Involved using ETL tool Informatica Power Center to populate teh database, data transformation from teh old database to teh new database.
• Analyzed teh reverse engineered Enterprise Originations (EO) physical data model to understand teh relationships between already existing tables and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Designed and implemented basic PL/SQL queries for testing and report/data validation.
• Used Data warehousing for Data Profiling to examine teh data available in an existing database and created Data Marts.
• Ad hoc reporting, data analysis and troubleshooting for various business groups.
• Responsible for understanding teh 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 teh metadata approved for teh 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, PL/SQL, MS Excel, MS Word, HTML, ER/Studio.

Data Modeler/Analyst

Confidential

Responsibilities:

• Responsible for generating innovative solutions to bridge teh gap between business and IT.
• Involved as a part of a team for gathering and analyzing teh 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 teh logic and loaded into Data Warehouse.
• Extensively used SQL for DataAnalysis and to understand and documenting teh databehavior within and between two companies.
• Created packages to schedule teh jobs for batch processing.
• Designing teh procedures for getting teh datafrom all systems to DataWarehousing system. Teh 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 teh requirements.

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.