PROFESSIONAL SUMMARY:

• 8+ years proficiency in Information Technology gathering business requirements and handling requirements management.
• Good knowledge about all phases of Software Development Life Cycle(SDLC) which includes Requirement gathering and analysis, Design, Implementation, Testing, Deployment & Maintenance.
• Expertise using of ERWIN & Embarcadero ER/Studio for developing Conceptual, Logical & Physical models.
• Experience with Financial & Healthcare Domains.
• Good understanding of Ralph Kimball modeling technique.
• Experience in Data Modeling with expertise in creating Star - Schema, Snow-Flake Schema, FACT and Dimensions Tables, Physical,Hierarchial and Logical Data Modeling using ERWIN Tool.
• Experience wih using ETL.
• Experience using SSIS and TSQL.
• Experience with relational modeling and dimensional modeling in SQL Server using ER/Studio.
• Extensively worked on ERWIN tool with features like Reverse Engineering, Forward Engineering, Subject area, Domain, Naming Standards Documentation etc.
• Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Developed Data dictionary and maintained Metadata for each model.
• Strong expertise in Data Warehousing, Operations Data Store (ODS) concepts, data marts, Data Discovery and OLAP technologies.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I,II,IV.
• Understanding of WBS, Sequence Diagram, Data Flow diagrams and requirement gathering.
• Experience using Data Quality,Data Mapping, Data Lineage, Designed system test plans,Data Governance.
• Undestanding of Object-Oriented Programing (OOP) design using UML.
• Experience in Database Programming SQL, Oracle 11g/10g,Database Tuning and Query Optimization.
• Experience in Property & Casualty (P&C) area & Master Data Management(MDM).
• Expertise in Normalization to 3NF/Denormalization techniques for optimum performance in relational and dimensional database environments.
• In depth knowledge of Waterfall, Agile development life cycles.
• Experience of Power Business Intelligence tool like Tableau for visualization of data.
• Well versed with data analysis using MS Excel.
• Worked with Various RDBMS Platforms (SQL Server,Oracle,DB2,Teradata)
• Experience with DDL (Data Definition Language) AND DML (Data Manipulation Language) Commands.
• Experience designing Large Scale Data Models for Functional, Operational and Analytical environments.
• Experience with Application Delivery using Offshore/Onshore Model.
• Experience with Data Vault Methodology.
• Experience with Business Processes across Multiple Master Data Domains.
• Experience with working on Normalized,De-Normalized and Data Profiling skills..
• Experience with Provider, Member and Claims data in Healthcare industry.
• Experience in Analytics, Operations Strategy, Decision Support, Data Management.
• Excellent knowledge in Data Analysis, Data Archiving, Data Validation, Data Verification, Data Cleansing, Data Verification and identifying data mismatch.
• Excellent analytical, inter-personal,problem solving, critical thinking and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r9.6/9.1/9/4, ER Studio, TOAD.

BI & Reporting Tools: Tableau 10.1/8.3,SSIS.

ETL Tools: Informatica Powercenter 9.6/9.5/7.8.

Databases and Tools: Oracle 12c/11g/10g, DB2, SQL Server (2014/2008), SQL Navigator, Teradata.

Programming Languages: SQL,Python,PL/SQL.

Operating Systems: Microsoft Windows 10/2000/XP/Vista/7/Unix/Linux.

Other Tools,Applications & Methodologies: MS Office Suite, Star Schema, Snowflake Schema, Data Warehousing Methodology,Kimball Methodology,Hive,HBase.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Data Modeler/Data Analyst

Environment: MS Visio 2010, Erwin r9.6,PL/SQL, Oracle 12c, Informatica Powercenter 9.6,MS SQL Server 2014,Tableau 10.1, Teradata,Unix, SSIS,Oracle SQL developer.

Responsibilities:

• Participated in JAD session with Business Users and Sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Proficient experience as a Data Analyst in gathering data from various sources, data profiling, data definition, and loaded the data to business warehouse.
• Participated in brain storming sessions with application developers and DBAs to discuss about various de-normalization, Partitioning and Indexing Schemes for Physical Model.
• Worked on the OLAP for data warehouse and data mart developments using Ralph Kimball methodology as well as OLTP models Identified the Facts & Dimensions Tables and established the Grain of Fact for Dimensional Models.
• Performed Data analysis,Data Archiving,Data Verification, Data Vault and Data profiling using complex SQL on various sources systems including Oracle and Teradata
• Created Logical,Conceptual & Physical Data Models using Kimball Methodology.
• Worked on Requirements Traceability Matrixto trace the business requirements back to Logical Model.
• Built and maintained a robust data warehousing system for the organization.
• Monitored the Data quality and integrity of data was maintained to ensure effective functioning of department.
• Responsible for Dimensional Data Modeling and Relational Modeling Diagrams using ERWIN for Data Warehouse, Data Lake, Data Marts, ODS.
• Reviewed the Physical Data Model with Application Developers, ETL Team, DBAs and Testing Team to provide information about the Data Model and business requirements.
• Performed ETL SQL optimization designed OLTP system environment and maintained documentation of Metadata.
• Performed Data loading using SQL Server Integration Services packages (SSIS)
• Used SSIS Packages for Data Importing, Cleansing and Parsing.
• Implemented Data Vault Modeling Concept solved the problem of dealing with change in the environment by separating the business keys and the associations between those business keys, from the descriptive attributes of those keys using HUB and LINKS tables.
• Created Multi-Way Aggregate Fact Tables as a specific summarization across dimensions of product, region and date.
• Created Snowflake Schemas by normalizing the dimension tables as appropriate, and creating a Sub Dimensionnamed Demographic as a subset to the Customer Dimension.
• Created refined data models pertaining to reassessed business requirements conforming to applicable data standards and successfully documenting the existing system model and changes proposed/applied to the model.
• Wrote SQL queries and optimizing the queries in Oracle, SQL Server and Teradata
• Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
• Worked with DDL and DML Commands.
• Extracted data from databases like Oracle and DB2 using Informatica to load it into a single repository for data analysis.
• Designed and Developed Oracle PL/SQL, Data Import/Export, Data Conversions and Data Cleansing.
• Provided development expertise in enterprise and project level logical data models which focused on business data.
• Worked with UNIX Shell Scripts and Data Definition.
• Extensively worked in SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences.
• Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Created Hive architecture used for real time monitoring and HBase used for reporting and worked for map reduce and query optimization for Hive and HBase architecture.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments.
• Performed Database Design and Optimization including Indexes, Tuning at Database and Query Level.
• Experience with Unit Test Cases for Mapping and Code Reviews.
• Worked with Unix Commands and Shell Scripts.
• Experience in Informatica data quality and analytics tools.
• Incorporated business requirements in quality conceptual, logical data models using Embarcadero ER Studio and created physical data models using forward engineering techniques to generate DDL scripts in agile environment.
• Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Led stakeholder teams to design and develop strategies incorporating the use of data.
• Extensively used Metadata Management & Data Dictionary Management, Data Profiling, Data Mapping.
• Experience in Data Replication Techniques and Data Retention through backup and recovery.
• Analyzed historical data and transform large data sets to consumable format using SQL, Excel.
• Worked with XML and High Volume Data.
• Experience with Multi Data Entities and Multiple Sector Business Data.
• Design and implement data ingestion techniques for real time and batch processes for structured and unstructured data sources.
• Applied Data Governance rules (primary qualifier, class words and valid abbreviation in Table name and Column names).
• Worked on the Snow-flaking the Dimensions to remove redundancy Created Business Glossaries.
• Involved in capturing Data Lineage, Table and Column Data Definitions, Valid Values and others necessary information in the data models.

Confidential, St.Louis, MO

Data Modeler/Data Analyst

Environment: Oracle 11g, Erwin r9.1, Informatica 9.5,PL/SQL, SSIS, Tableau 8.3,MDM,MS Office, MS SQL Server 2012,Teradata,CSV files, UML.

Responsibilities:

• Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.
• Perform Data Analysis, Data Verification,complex Data Profiling, Data Vault,Data definition, Data Mining, validating and presenting reports.
• Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks.
• Used Reverse Engineering and Forward Engineering techniques on databases and created tables and models in data mart, data warehouse and staging.
• Created entity-relationship diagrams for relational systems and dimensional diagrams for the Data Warehouse, DataMarts, ODS, and data lake.
• Involved in design and conversion of business requirements to Conceptual Data Model, Logical Data Model and Physical Data Model for subject areas.
• Handled performance requirements for databases in OLTP and OLAP models
• Created Logical and Physical Data models of the Centralized Relational Database for both OLTP and OLAP systems using Kimball Methodology and assisted DBAs in the implementation of the data models.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot.
• Extensive experience in development of T-SQL,PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Wrote triggers for implementing data integrity.
• Identified the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications.
• Extensive experience in project management best practices, processes, & methodologies including SDLC.
• Ensure compliance of Data Quality in MDM.
• Performed the 3NF Technique.
• Worked on complex this business transformation project.
• Worked with DDL and DML Commands
• Undestood of Object-Oriented Programing (OOP) design using UML.
• Involved in Data Mart Designing and Data Lineage.
• Worked on the the Mapping between Sources and Target in MDM
• Used data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment
• Used Agile Methodology in this project.
• Experience with Multi Data Entities and Multiple Sector Business Data.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience in Data Replication Techniques and Data Retention through backup and recovery.
• Created Business Glossaries and Data Lineage.
• Performed Database Sizing, Availability and Scalability.
• Responsible for different data mapping activities from Source systems to Teradata.
• Performed Database Sizing, Availability and Scalability.
• Extensively used Erwin for developing data model using star schema & snowflake methodologies.
• Interaction with Cross-Flow teams,Business Analysts to gather requirements and provide solutions.
• Understood Databases through User Acceptance Testing (UAT).
• Created Entity relationship diagrams (ERD), Function relationship diagrams (FRD), data flow diagrams (DFD) and enforced all referential integrity constraints using Erwin.

Confidential

Data Modeler/Data Analyst

Environment: Microsoft SQL Server 2008, Informatica Powercenter 9.1,Oracle 11g, SSIS,PL/SQL, ERWIN r9,Visio,Tableau, SQL Assistant, ER Studio,Unix.

Responsibilities:

• Analyzed the business requirements by dividing them into subject areas and understood the dataflow within the organization.
• Collaborated with SMEs to identify and gather metadata for critical data elements for subject areas.
• Excellent experience and knowledge on data warehouse concepts and dimensional data modeling using Ralph Kimball methodology.
• Created a relational model and dimensional model for online services such as online banking and automated bill pay.
• Developed the logical data models and physical data models for OLAP systems that capture current state/future state data elements and data flows using ER/Studio.
• Performed Dimensional Data Modeling and Relational Modeling Diagrams in SQL Server using ER Studio.
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable.
• Performed Database Sizing, Availability and Scalability.
• Created and maintained Metadata, including table, column definitions.
• Performed source Data Analysis, Data Archiving,Data Discovery, Data Lineage and Data Mapping.
• Extensively used SQL for Data Analysis.
• 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.
• Developed and deployed SSIS packages to load data and understand the business logic to modify the legacy code.
• Integrated multiple data Models and created a Single Unified Model.
• Used Model Mart of ERWIN r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Worked with QA for developing test plans and test cases for unit, system and Enterprise testing.
• Worked with DDL and DML Commands.
• Worked with SQL Tool SQL Navigator.
• Designed and Maintained Complex data model assets in Transactional process.
• Performed Database Optimization including Indexes, Tuning at Database and Query Level.
• Used ERWIN r9 for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Helped the BI, ETL Developers, Project Manager and end users in understanding the Data Model, data flow and the expected output for each model created.
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Performed Gap and Impact Analysis.
• Worked in Property & Casualty (P&C) area.
• Worked on architecting data conversion projects particularly in Policy data conversion &
• Guideware.
• Worked with multiple customer stakeholders like architect, analysts, SME & product vendor
• Experience with Data integration patterns, Exposure to Documenting ETL process, and tools.
• Experience with Quantitative Financial Analytics in Mortgage Credit Risk Analytics
• Performed Exploratory DataVisualizations and created dashboard reports using Tableau.
• Developed PL/SQL programming that included writing Views, Stored Procedures, Packages, Functions and Database Triggers.
• Extensively used ERWIN r9 as the main tool for data modeling along with MS VISIO.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Extensively used SQL for performance tuning and Performed Data Discovery.
• Used Agile Methodology in this project.
• Extensive experience in project management best practices, processes, & methodologies including SDLC.
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
• Worked on data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Performed gap analysis between the present data warehouse to the future data warehouse being developed and identified data gaps and data quality issues and suggested potential solutions.
• Assisted developers, ETL, BI team and end users to understand the data model.
• Analysing raw data, concluding, developing recommendations and manipulate data for data loads and extracts.

Confidential

Data Analyst

Environment: ERWIN r4.0, Windows NT, MS Excel, MS Visio, DB2, Oracle 10g/9i, XML files, Agile SCRUM, SCRUM/XP.

Responsibilities:

• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Collected requirements from business users and analyzed based on the requirements.
• Working Experience with star schema and snowflake schema methodologies.
• Designed and built Data models by using Kimball Methodology.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Designed OLAP data models and extensively used slowly changing dimensions (SCD).
• Served as a member of a development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin.
• Maintained current documentation for all primary and backup responsibilities.
• Worked as part of a team of Data Management professionals supporting a Portfolio of development projects both regional and global in scope.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for an effective Data Warehouse and Data Mart.
• Used Agile Methodology & HEDIS in this project.
• Worked with XML and High Volume Data.
• Worked on Provider, Member and Claims data in Healthcare industry
• Followed project management processes and methodologies ensuring projects are delivered on time, within budget, meets high-quality standards, and meet customer needs.
• Involved in defining the source to target Data mappings, business rules and Data definitions.
• Involved in data lineage and Informatica ETL source to target mapping development, complying with data quality and governance standards.
• Applied organizational best practices to enable application project teams to produce data structures that fully meet application needs for accurate, timely, and consistent data that fully meets its intended purposes.
• Conducted peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.
• Reversed engineered existing data bases to understand the data flow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.

Confidential

SQL Developer

Environment: SQL, SQL Loader, PL/SQL, SQL Server 2000, Oracle, UNIX, MS Visio, MS Word, MS PowerPoint, MS Excel.

Responsibilities:

• Gathering the requirements by interacting heavily with the business users, multiple technical teams to design develop the workflows for the new functional piece.
• Experience in SQL joins subqueries, tracing and performance tuning for better running of queries.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views, and indexes
• Performance tuning of stored procedures and functions to optimize the query for better performance.
• Transformed complex business logic into database design and maintaining it by using SQL objects, stored procedures, user defined functions, views, T-SQL scripting, and jobs.
• Interaction with the clients to gather out the requirements and assist them in immediate workarounds for the issues with the application.
• Worked extensively on various kinds of queries such as Sub-Queries, Correlated Sub-Queries, Dynamic SQL and Union Queries and concentrated much on Query Tuning.
• Involved in daily, weekly and a Monthly load of data from Mainframe dataset to Oracle database.
• Worked on very large Database environment in terabytes and tuned queries for performance.
• Developed and maintained a lot of batch scripts in UNIX shell scripts like scheduled data loading, Create, databases, Tuning and Backup and Recovery.