SUMMARY

• Around 8 years of excellent experience as a Data Modeler in Pharmacy, Finance, Insurance, Health care, banking domains.
• Also experienced in database management, strategic analysis, requirements gathering, application and decision support, which plays a key role in software development life cycle (SDLC).
• Around 8 Years of Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
• Proficient in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/ Business Intelligence (BI) applications.
• Worked extensively on SAP Power Designer, Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Experienced in designing the Conceptual, Logical and Physical data modeling using SAP Power Designer, Erwin and ER Studio Data modeling tools.
• Experienced in Physical data modeling for DB2, Oracle, SQL Server and Teradata.
• Have good knowledge on Oracle Exadata Architecture and features: smart scan, smart flash cache, Hybrid columnar compression, Infiniband Network Storage Indexes.
• Worked extensively on forward and reverse engineering processes. 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.
• Practical understanding of the Data Modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, creation of cubes.
• Experience in hands-on predictive modeling, using both structured and unstructured data
• Experience in Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports.
• Experience in defining and designing regulatory report solutions using Axiom SL.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Good understanding and knowledge with Agile and Waterfall environments
• Involved in JAD sessions with developers, user interface personnel and end users.
• Performed extensiveData profiling, Data Cleansingand analysis for detecting and correcting inaccurate data from the databases and to trackdata quality.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and query optimization techniques in transactional and data warehouse environment.
• Exceptional communication and presentation skills and established track record of client interactions.

TECHNICAL SKILLS

Data Modeling tools: Erwin 6/7/8/9, Sybase Power Designer, ER/Studio, MS Visio, Rational Rose, SAP Power Designer

Data Warehousing: Informatica Power Center 8.1/8.0/7.1/7.0/6.2/6.1/5.2 , Informatica Power Mart 4.7, Power Connect, Power Exchange, Data Profiling, Data Cleansing, OLAP, OLTP, SQL*PLUS

Data Bases: Oracle 8i/9i/10g/11g,12c, Oracle Exadata, Teradata V2R6.1/12/13, DB2, Netezza, Microsoft SQL Server 2005/2008,2012, MS Access, SSIS, SSRS

Programming languages: SQL, PL-SQL (Triggers, Stored Procedures and Functions, packages), C, C++, .Net, MATLAB.

Scripting: UNIX, LINUX

Operating Systems: Mainframes, Windows Vista/XP, UNIX, Sun Solaris, AIX

PROFESSIONAL EXPERIENCE

Confidential, Kentucky

Sr. Data Modeler/Data Analyst

Responsibilities:

• Participated in requirement gathering session, JAD sessions with users, Subject Matter experts, Architects and BAs.
• Participated in Sprint Testing and documented the Project Change Control and the Impact analysis, worked with BA’s on GAP Analysis
• Worked with System Architects in providing solutions to the system design, reducing the number of screen selections, internal and external application workflow design and also in design of user interface screens.
• Provided solutions to performance issues in the databases includes re-indexing, recompiling stored procedures and other maintenance tasks.
• Applied Normalization techniques and created Logical and Physical models based on the requirements.
• Conducted and participated in Database design review meetings.
• Prepared Enterprise Naming Standard files and also project specific naming standard files in some exception cases.
• Worked with Enterprise Architect team in developing Enterprise Data Models, which is used by most of the applications.
• Worked with MDM team in making changes to database to accommodate requirements and also in capturing the demographic information from different applications by providing source application data dictionaries, identifying the demographic information and by providing DDL.
• Involved in the redesigning of Legacy systems, Modifications, Enhancements and Break Fixes to existing systems and in integration of one system with the other.
• Worked on Forward and Reverse Engineering using Erwin, reverse engineered XSD structures, excel spread sheets and copybooks.
• Worked on Comparing different models, different versions of models using complete compare in Erwin and also compared Databases directly and produced alter scripts.
• Worked on upgrading Erwin Data modeler from v7.3 to v9.5, served as Erwin Repository administrator
• Experience with Version Control tools.
• Experience in Developing Stored Procedures, Functions and Triggers using T-SQL.
• Worked with DBA’s in migrating data from one database environment to other environment.
• Worked with ETL teams in designing Load jobs and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, table load order documents, design mappings, create repositories and establish users, groups and their privileges.
• Analyzed Data Specification Documents (DSDs) and implemented their logic in the form of Informatica mapping design.
• Worked with BI team in providing SQL queries, Data Dictionaries and mapping documents (Report attributes to Database columns).
• Acted as a Strong Data Analyst analyzing the data from low level in conversion projects, provided mapping documents between Legacy, Production and User Interface systems.
• Extensively performed Data Profiling, Data Cleansing, De-duplicating the data and has a good knowledge on best practices.
• Involved in high complex research, quantitative analysis, modeling and monitoring of data necessary to produce the logical design for review.
• Developed and initiated more efficient data collection procedures
• Worked with Architects in designing conceptual model for the Data warehouse and Identified Facts and Dimensions, designed Logical and Physical data models
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Worked on Converting Physical only models to Logical and Physical models.

Environment: Oracle 10g/11g/11c/12c, SQL Server 2005/2008/2012 , Erwin 7.3/9.5, IBM DB2, Case Complete, Blue Zone, Toad SQL Developer, Informatica Analyst 9.6.1 Sybase Power Designer 15, MS OFFICE 2015, Crystal Reports, ALTOVA XML Spy.

Confidential, Trenton, New Jersey

Sr. Data Modeler /Data Analyst

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Interacted with the Business Analyst in gathering Functional Requirements.
• Interacted with End user community to understand the business requirements and in identifying data sources.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Identified various facts and dimensions from the source system and the business requirements to be used for the data warehouse
• Created Logical and Physical models based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Exhaustively collected business and technical metadata and responsible for defining the naming standards for data warehouse.
• Performed Data Quality analysis to identify the quality of data, which is being stored.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• Efficient in all the faces of the SDLC, coherent with data cleansing, data conversion, data profiling.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms and documented the Purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes.
• Implemented the slowly changing dimension scheme (Type II) for most of the dimensions.
• Performed GAP Analysis for the attributes in the data model.
• Involved in the modeling of the missing dimensions on the existing data model.
• Part of team conducting logical data analysis and data modeling JAD sessions with other data modelers/analysts, ETL Developer, reporting team and SHI team, communicated data-related standards.
• Prepared documentation for all the analysis done and extensively used MS Office to prepare presentations.

Environment: Erwin 9.0, Oracle 9i/10g, PL-SQL developer, Quality center-9.2, Informatica Power Center 9.1, Microsoft Access, Teradata SQL Assistant 12.0/13.11, SAP Power Designer, Data stage 8.1, Aginity Netezza Workbench, UNIX, Tableau, Github, Control-M 6.3.01, MS OFFICE, DB2.

Confidential, Oaks, PA

Data Modeler/ Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in the redesign of the existing OLTP system.
• Acted as a Strong Data Analyst analyzing the data from low level.
• Worked with DBAs to recreate a best fit physical data model from the logical data model.
• Did logical and physical data modeling with Erwin and Model Manager
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business user
• Performed Data modeling using Erwin. Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering ERWIN tool.
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Involved in the Database design and application development to support the creation and management of online business units for business users and customers usage.
• Used Erwin to transform data requirements into data models.
• Involved in extensive Analysis on the Teradata and Oracle Systems.
• Helped in migration and conversion of data from legacy system to oracle database.
• Widely used Normalization methods and have done different normalizations (3NF).
• Good experience in data analysis querying and writing in SQL and TOAD.
• Analyzed the performance of the jobs during the project. Utilized standard techniques for enhancing the performance.
• Performed tuning of SQL Queries to improve the response time.
• Authored User reference documents on all the deliverables created for future reference by Business Users and conducted training sessions.

Environment: Oracle 10g, DB2, Erwin 8.2.5, Teradata SQL Assistant, SQL, PL/SQL, ODBC, HTML, TOAD, SQL * LOADER, UNIX, MS OFFICE.

Confidential, Winston-Salem, NC

Data Architect/ Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing system.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards. Conducted Design discussions to come out with the appropriate Data Mart.
• Defined and processed the facts, dimensions. Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling methodology using ERWIN.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Involved in the integration of data coming from different sources.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts toTeradatadata warehouse.
• Mapped the data between Source and Targets.
• Created data model for the star schema using Erwin, created DDL scripts for static dimensions.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Developed data mapping documents between Legacy, Production, and User Interface Systems
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data
• Imported millions of records from .CSV files .TXT files using SQL * LOADER and Test Importer.

Environment: Oracle 9i/10g, SQL, ERWIN 7.3, Teradata, HTML, TOAD, SQL * LOADER, MS OFFICE.

Confidential

Data Modeler / Data Analyst

Responsibilities:

• Communicated with end users and business analysts to gather information and functional requirements.
• Used Rational Requisite Pro to document technical requirements and business user requirements.
• Gathered accurate data by data analysis and functional analysis.
• Created entity / process association matrices, entity-relationship diagrams and data flow diagrams
• Created logical data model from the conceptual model and it’s conversion into the physical database design.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Participated in the Data Modeling to generate target database layout use for the data marts.
• Generated data mapping documents to define mapping from source to target.
• Involved in the creation of database schemas, Conceptual and Physical Data Models using Erwin.
• Performed data profiling and analysis applied various data cleansingrules designeddatastandards and architecture/designed the relational models.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic.
• Designed architecture of system using UML CASE tools and applied design patterns to the solution.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in Rational Rose.
• Involved in requirement gathering and database design and implementation of star-schema/dimensional data warehouse using Erwin.
• Understood existing data model and documented suspected design affecting the performance of the system.
• Developed different database Objects like tables, views, materialized views etc using SQL.
• Extensively used MS Power Point, Excel for the preparation of presentations.

Environment: Oracle 9i, SQL, PL/SQL, ERWIN 7.3, MS VISIO, TOAD, SQL*PLUS, HP-Unix 10.x/11, Shell.

Confidential

Data Analyst/SQL Developer

Responsibilities:

• Provided analysis support for defects and/or incoming incidents or user requests
• Interacted with the client for business requirements gathering. Worked with MS Access.
• Provided application support during the build and test phases of the SDLC for their product
• Identified the Entities, attributes and designed a relational database system.
• Participated in defect resolution and coordination.
• Used Star schema methodology in building and designing the logical data model in the dimensional Models.
• Mapped the data between Source and Targets.
• Built the application according to the requirements (wrote some PL/SQL procedures, functions, database triggers, created some forms and reports) and Created views and index views.
• Developed PL/SQL stored procedures and packages for validation purpose.
• Developed the batch program in PL/SQL for the OLTP processing and used Unix Shell scripts to run in corn tab.
• Interacted with DBA to discuss database design and modeling, index creations and SQL tuning issues.
• Used SQL*Loader to load the database from flat files.
• Converted Data stored in flat files into Oracle tables.

Environment: SQL Server 2000/2005, SQL, MS Access, PL/SQL, SQL*Loader, Import/Export.