SUMMARY

• Around 7 years of technical experience in Data analysis and Data Modeling business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed timelines.
• Experienced in all phases of Software Development Life Cycle (SDLC). (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Experienced Data Modeler with strong conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, creating data mapping documents, writing functional specifications, queries.
• Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT & Dimension tables.
• Experienced in identifying entities, attributes, metrics, and relationships; also, assigning keys and optimizing the model.
• Extensive knowledge on producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Extensive experience with Normalization (1NF, 2NF and 3NF) and De - normalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
• Developed Tableau visualizations and dashboards with interactive views, trends and drill downs along with user level security using Tableau Desktop.
• Good experience with Oracle 9i, 10g,11g, MS SQL Server, MS Access,
• Excellent experience in troubleshooting SQL queries, ETL queries, data warehouse /data mart/ data store models.
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for Physical models using ERwin tool.
• Excellent verbal and written communication skills with the ability to interact professionally with stakeholders at all levels of the organization, including the ability to exercise good judgment and nature of communications to senior management, stakeholders and team members.
• Possess a disciplined, professional and quality centered approach with strong analytical and problem solving skills.

TECHNICAL SKILLS

Data Modeling: Erwin 4.0, Power Designer, Microsoft Visio 2003, ER Studio, Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

ETL Tools: Informatica, Microsoft SSIS

Databases: Oracle 9i, 10g,11g, MS SQL Server, MS Access, Teradata

Operating Systems: Linux, Unix, Windows Server 2003/2007/10

Programming Languages: SQL, C,C++,UNIX Shell scripting, Python

Reporting tools: Tableau and Crystal Reports.

Office Applications: MS Office (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Sr. Data Modeler/Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Participated in requirement analysis and meetings with business team to understand the source model.
• Coordinate with the users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Prepared source for target mapping and technical specification document.
• Designed the Physical and Logical models using Erwin.
• Expert in Data Analysis Primarily Identifying Datasets, Source Data, SourceMeta Data, Data Definitions and Data Formats.
• Maintained expertise in the warehouse ecosystem, including industry trends, strategies, and products.
• Enforced referential integrity in the OLTP data model for the consistent relationship between tables and efficient database design.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• Created a list of domains in Erwin and worked on building up the data dictionary for the company
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs’ to apply the data model changes.
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Reverse engineered from Oracle database using Erwin to understand source system data relationships.
• Experienced in maintaining the stage and production conceptual, logical, and physical data models along with related documentation for a large data warehouse project. This included confirming migration of data models from Oracle Designer to Erwin and updating the data models to correspond to the existing database structures.
• Defined and processed the facts, dimensions and also designed thedata model using the dimensional methodologies.
• Expert in integration ofdatacoming from different sources and maintain the integration and repositories containing metadata.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis.
• Stayed current on trends, latest industry developments and shared knowledge among colleagues.
• Developed the financing reporting requirements by analyzing the existing reports/
• Used the MS Excel, MS Access for data pulls and ad hoc reports for analysis.
• Generate DDL scripts for database modification, Teradata, Macros, Views, and set tables.
• Handled performance requirements for databases in OLTP and OLAP models.
• Generated ad-hoc SQL queries using joins, database connections, and transformation rules to profile datafrom Oracle and SQL Server database systems.

Environment: Oracle 12c, Teradata, sql server, SQL Manager, Erwin, Unix, MS Office, DB2.

Sr.Data Analyst

Confidential, Seattle, WA

Responsibilities:

• Work with users to identify the most appropriate source of record required to define the asset data for financing
• Designing of logical and physical data models using SQL Data model based on the client requirements.
• Perform data profiling in the source systems that are required for financing
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the trumping rules applied by Master Data Repository
• Define the list codes and code conversions between the source systems and MDR.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Responsible for defining the key identifiers for each mapping/interface
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates
• Document data quality and traceability documents for each source interface
• Establish standards of procedures. Generate weekly and monthly asset inventory reports.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Provided direction and shares knowledge with and mentored team members in areas of expertise.
• Excellent skills in user research and analysis of the existing systems, with knowledge of traceability matrix.
• Strong Experience in conducting User Acceptance Testing (UAT), Unit Testing and documenting Test Cases and Test Scripts.
• Involved in Test Planning, Test Preparation, Test Execution, Issue resolution and Report Generation to assure that all aspects of a project are in compliance with the business requirements.

Environment: SQL/Server, ER Studio 9.1.0, Oracle 9i, MS-Excel, Teradata, MDM, SAP, QlikView, Microstrategy, Informatica, PowerPivot, ER Studio, XML, Selenium, SoapUI, CruiseControl.Net, HP Quality Center 10, Maven Business Objects, OBIEE, Cognos

Sr. Data Modeler

Confidential, Herndon, VA

Responsibilities:

• Performed variousdataanalysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for an effectiveDataWarehouse andDataMart.
• Worked closely hand in hand with the Business Analytics manager, who was also a part of the design/datamodeling team
• Scheduled changes, dependency impact, code changes for various change requests on the existingDataWarehouse applications that are running in Production environment.
• Created logical and physicaldatamodels using Erwin and reviewed these models with the business team.
• Worked on Optimization of the application and the designing of the database tables with the right partitioning.
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created tables, views, sequences, tablespaces, constraints and generated DDL scripts for physical implementation.
• Performed data mining on data using very complex SQL queries and discovered a pattern.
• Used SQL for Querying the database in UNIX environment.
• Experience in Project development and coordination with onshore-offshore ETL/BI developers & Business Analysts.
• Prepared scripts for the model anddatamigration from Oracle to the new Appliance environments.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve performance.
• Performeddatamanagement projects and fulfilling ad-hoc requests according to user specifications by utilizingdatamanagement software programs and tools like Toad, MS Access, Excel and SQL.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL server.
• Ensured onsite to offshore transition, QA Processes, and closure of problems & issues.

Environment: Teradata 13.10, Microsoft SQL Server 2012, Data stage, SQL Manager, Erwin, Business Objects XI, ER Studio 9.1.0, Linux.

Data Modeler / Data Analyst

Confidential, Tampa, FL

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Experience in modifying the instance and purging (i.e. clearing the data from the database) the data from the data warehouse as required by the client to get the clean validation pass for the files.
• Ability to analyze the data by performing Extraction, Transformation & Load function mentioned by clients to process and get the accurate feedback that includes cause for warnings & failures. Ability to explain the cause for the loss of records when the data moves from import table to Transformation table.
• Worked on Bank Data ware house and Mortgage Data ware house.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Normalized the database to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL scripts for database modification, Views and set tables.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: ORACLE, Erwin, Windows, XML, Excel, Access, Visio

Data Analyst

Confidential

Responsibilities:

• Worked with business users to gather requirements and createa dataflow, process flows, and functional specification documents and created Conceptual, Logical and Physical data models using Erwin.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snowflake Schemas.
• Used forward engineering in Erwin to create databases scripts for OLAP model.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs’ to apply the data model changes
• Worked with business to identify the distinct data elements in each report to determine the number of reports needed to satisfy all reporting requirements.
• Worked on integratingdatafrom heterogeneous sources like Oracle, flat files, and XMLfiles.
• Developed the design & process flow to ensure that the process is repeatable.
• Performed analysis of the existing source system (transaction database).
• Extensively worked Data Governance, i.e. Metadata management, Master data Management, Data Quality and Data Security.
• Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
• Successfully created and managed a conversion testing effort which included adataquality review, two system test cycles, and user acceptance testing.
• Staging and Target Schema Model Designed and Deployed DDL in Oracle Database.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user.

Environment: CA Erwin 7.0, Oracle 11g, MS-Office, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, SQL Server 2008/2012.

Data Analyst

Confidential

Responsibilities:

• Involved in thestudy and understanding of existing system and data architectureand proposed changes necessary to in corporate the new data models.
• Gathered and analyzed business requirements through continuous discussionswith the business analysts, data analysts, and performed GAP analysis of the business rules, user administration and requirements.
• Reverse Engineeredthe existing database structure to understand the existing data models so that any changes in corporate would synchronize with current model.
• Created conceptual models and conducted several walkthrough meetings with Architects for approvals and conducted team meetings for creating logical and physical models from the conceptual model.
• Created physicaland logical models using Erwinto effectively translate conceptual model into logical and physical models conforming to the business and data requirements.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in ERwin after analyzing the database systems currently in use.
• Createda family of starsto effectively translate the physical model into a dimensional model usingconformed dimensions, role playing dimensions mini and sub dimensions and fact less fact tables.
• Execution, Maintenance & Debugging of the scripts with Teradata Bteq.
• Execution, Maintenance & Debugging of SAS scripts to update the Teradata Tables
• Creat Teradata tables, Views, Macros and analyzed various Teradata tables for UPI’s and Monitor the same. Execution of Mainframes JCL scripts.
• Utilized ODBC for connectivity to Teradata & MS Excel.
• Good experience in identification and requirements gathering as per the business requirements via meetings, interviews, interface analysis, research, etc.
• Incorporated enhancements into DW in accordance to Ralph Kimball Design specifications and adhering to the business needs and industry standards.
• Development of Daily and Weekly inventory and sales reports using Micro strategy.
• Worked onintegrating datafrom disparate sources and the was involved withdata cleansing, validating and loading, client user and account information
• Implemented performance tuning strategies like sub query flattening, view merging and recreating indexesto speed up the performance of highly resource intensive queries.
• Performed logical and physical data modeling and database design for an Oracle Retail Data ODS designed to enable Retail LOB fraud detectiondata miningwith the use of analytics tools.

Environment: Erwin, Oracle, DB2, Windows XP, SQL Server 2005, XML, MS Office Suite.