SUMMARY:

• Has around 15 Years of experience in IT and played multiple roles as project demand - Data Architect, Data Modeler, Data Warehouse/ ETL Developer, BI Developer, Data Analyst.
• Strong experience in multidimensional (OLAP) data modeling, such as Star schemas, Snowflakes schemas normalized and de-normalized models, handling -slow-changing- dimensions\attributes.
• Expertise in Data Modeling: - Domain Driven Design (DDD) Modeling, Conceptual Data Modeling (CDM), Logical Data Modeling (LDM), Physical Data Modeling (PDM), Canonical Data Modeling, Hierarchies, relationships, Metadata, data lineage, data.
• Expertise in forward engineering, reverse engineering, complete compare, DDL scripts, JSON Schema.
• Experienced in Domain Driven Design (DDD) model Commercial Property & Causality LOB that are most suitable for Micro Services implementation.
• Extensively used Performance Optimization best practices for making database healthy and provide optimal performance including table partitioning, Buffer Sizing, Threading and Indexing strategy.
• Exposure in Project Management activities -Resource optimization, task estimation, costing for fixed Time & Material, experienced SDLC & Agile-Scrum Model that includes short term goals, iterative development.
• Exposure on INCA (GIS Application), Oracle Spatial DB and MapInfo (GIS Software) application to generate Geographical maps in Nordic Region.
• Sound Knowledge of Insurance (P&C, Life), Healthcare, Life Science, Telecom domains & BFS

TECHNICAL SKILLS:

Data Modeling: OLTP | OLAP | Canonical Data Modeling | Star Schema | Snowflake schemas| Data Mart -Dimensional Modeling | Facts & Dimensions | Logical Data Model | Physical Data Model | MDM | Document Data Model | Data Model | Domain Driven Design Model | Data Vault Modeling |

Data Management: SSIS | SSAS | SAP BODS | Informatica Power Center 9.5 | Designer | Workflow Manager | Workflow Monitor | Repository Manger | ETL | Reporting | SQL Server | Oracle 12c | DB2 10.5

Business Intelligence: SAP Business Objects | COGNOS | Microstrategy9.2 | SSRS

Analytics: XMLA Query | SSAS | SAP Lumira | Tableau Desktop 9.3 | Tableau Server 9.3 | QlikView\Qlik Sense | Power BI | SiSense.

Databases: Oracle 12c | DB2 | SQL Server 2016 | XML | MongoDB | Oracle Spatial | Mark Logic (NoSQL Enterprise Application Database)

Programming Languages: SQL | T-SQL | PL/SQL | JSON | Unix Shell Scripting | Python | R | TCL

Data Tools: Informatica IDQ | Informatica MDM | Information Steward | MapInfo

Version Control Tools: Microsoft SharePoint | Share File | GitHub | Tortoise SVN repository | Tomcat Server | IIS

Project Management Tool: JIRA | Microsoft Project | HPSM | Agile Manager

ERP: Oracle- E-Business Suite R12 (PA)

Integration: SOA architecture | Data Power | API | Microservices | XML

Industry Model: IBM - ACCORD | IAA | IIDM | IBM BDW

EXPERIENCE:

Confidential, Gainesville, FL

Data Modeler/Architect

Responsibilities:

• Collaborates business owners to defines and establish Data Quality Rules and Standards definitions consistent with department and organizations strategies.
• Work on Design and develop data models using Erwin Data Modeler and apply best practices for optimum performance of the models
• Develop the Conceptual Data Model (CDM), Logical Data Models (LDM)
• Coordinates and performs the data analysis required to identify required data elements and create source-to-target mappings (including business logic) for data transformations.
• Working on to develop Domain Driven Design Model that support Micro Services Architecture.
• Design LDM and Canonical Data Model to support the Integration, API and for messaging interface
• Working on the solution to Deploy the micro services on AWS Cloud Architecture
• Technological stack: Amazon RDS for PostgreSQL, Amazon Elasticache, AWS MongoDB, Amazon Kafka.
• Develops data quality standards to identify gaps and ensure compliance across the enterprise.

Environment: ERwin 9.7, Domain Driven Design Model, Oracle12c, NoSQL- MongoDB, XML XSD, JSON Schema

Confidential, Erie, PA

Data Modeler, Data Architect

Responsibilities:

• Collaborates business owners to defines and establish data quality rules and definitions consistent with department and organizations strategies.
• Develops Data Management Functions like data quality management and standards to identify gaps and ensure compliance across the enterprise.
• Work on Design and develop data models using Erwin Data Modeler, enforced the Naming Standards, create Meta data and apply best practices for optimum performance of the models
• Coordinates and performs the data analysis required to identify required data elements and create source-to-target mappings (including business logic) for data transformations.
• Develop the Conceptual Data Model (CDM), Logical Data Models (LDM)
• Work with the application teams to identify Target model mapping design and ensure that it aligns with Integration standards and guidelines.
• Design Canonical Data Model to support the Integration, API and for messaging interface and maintain the and Master Data Management.
• Support Integration Development Team to develop message flows using IBM WebSphere Message Broker for all interfaces/services.
• Design JSON and xml canonical model using schema definition tool Like Altova
• Designed Canonical Data Model to support in transformation of various types of messages formats: CSV, TDS, XML and fixed length using compute node and Message sets in IBM WebSphere Message Broker.
• Designed and develop XML Queries, DDL scripts for Data Accessibility to support the Reporting need.
• Identify and referred IAA & BOM Mapping for integration standards, guidelines, best practices styles and patterns to the teams
• Identify relevant checklists to validate the adherence to the standards and guidelines

Environment: Technologies used: OneShield Policy Management System, Canonical Data Model, Oracle, SQL Server, NoSQL DB- MarkLogic9, OSPAS, XML XSD, Erwin9.7

Confidential, Memphis

Data Modeler \ Enterprise Data Management

Responsibilities:

• Create and Maintained the Logical data models, Physical data Models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems
• Extensively worked Reverse Engineering, Forward Engineering, Compete Compare, Created and Maintained Logical and Physical layer of Data Models.
• Generates Meta Data report from Logical and physical layers to define the business and technical information mapping and constraints.
• Responsible for leading the technical design of the tables and views that will be consumed by users of the data warehouse. Creating and maintaining processes for gathering high quality metadata.
• Experiences in Data Quality Management, Meta Data Management, DWH-BI Management and Database operation management, Enterprise Data Dictionary for data projects
• Gather, define and business requirements and develop solution design best practice guidance.
• Prepare impact and risk assessments for proposed changes and/or recommended business solutions

Environment: Erwin 9.7, IBM DB2 10.5, Oracle 11g, SQL Server 2016 or lower.

Confidential

BI Developer\ Data Analyst

Responsibilities:

• Worked as Sr. BI Developer cum data modeler on retail chain-based project.
• Defined the scope of the project and documented business requirements, constraints, assumptions, business impacts, project risks and scope exclusions.
• Report development, problem identification and its fix through major or minor enhancements.
• Prepared ETL design strategy document which consists of the database structure, change data capture, Error handling, restart and refresh strategies.

Environment: SQL Server 2016, SSIS, Tableau Desktop 9.3Company: Confidential Corporation

Confidential

BI-ETL Developer\Data Modeler

Responsibilities:

• Worked in multiple roles like- Sr. DWH-BI, Data Modeler in SICS Business Analytics projects used by 150+ Reinsurance customers globally.
• Defined, Created, and managed business specifications, technical specifications, and others project documentation for applications development. and Performed and documented gap analysis.
• Created and Maintained the Logical data models (LDM), Physical data Models (PDM) in support of Enterprise Data Models (Star Schema & Snowflake Schema ), OLTP, Operational Data Structures and Analytical systems
• Worked on data profiling the source systems for validating data, defining the data standards, size and datatypes in the data warehouse or mart.
• Created ETL mapping documents from source to target systems for ETL developers.
• Used advanced data techniques in data modeling, integration, visualization, database design and implementation.
• Expertise in Business Objects Installation with IIS/Tomcat Server configuration, Upgrade, Migration and Implementation for Insurance Customers
• Worked on MS-SSIS (ETL) Solution to extract, transform and load data into DWH target system, expert in writing complex SQL query, function and stored procedure to perform specific task.
• Monitor and improved performance of ETL, Reporting and Database optimization, Expertise in defining data types, optimal normalization, referential integrity, triggers, partitioning design, indexing methods, and data security procedures.
• Worked in Agile-Scrum that includes short term goals, iterative development and daily stand-up

Environment: IBM DB2, SQL Server 2016, SSIS, SSAS, Tomcat server, Power Pivot, TSQL, Oracle 11g, SAP BO XI 3.1/4.2, SiSense 6.2\6.5, Erwin 9.5, JIRA

Confidential, Blythewood, SC

BI-ETL Developer\Architect\ Data Modeler

Responsibilities:

• Worked as various roles like Sr. BI Developer, Data Modeler in POINT Business Analytics projects used by 170+ USA Insurance customers
• Defined, Created, and managed business specifications, technical specifications, and others project documentation for applications development. and Performed and documented gap analysis.
• Created both logical and physical design of a database and ran the reports, used advanced data techniques in data modeling, Access, integration, visualization, database design and implementation.
• Extensively worked on Dimensional Modeling (OLAP data-marts - Star Schema, Snowflake Schema) and manage logical and physical data models for data warehouse
• Worked to design data marts for account level and account status databases that help various teams to analyze the user experience, user statistics etc.
• Incorporated industry standard modeling practices to support a detailed and subject oriented data mart.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Maintained the data model and synchronized it with the changes to the database.
• Expertise in Business Objects Installation with Tomcat Server configuration, Upgrade, Migration and Implementation for Insurance Customers
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop. And Data Source created and modified.

Environment: IBM DB2, SQL Server 2016, MS-SSIS, SSAS, T-SQL, .NET, JSON, CA Erwin, Data Vault Model, SAP BO XI 3.1/4.2, SAP Dashboard, Tomcat Server, Tableau Desktop 9.3 Tableau Server 9.3, JIRA

Confidential, Bloomington, IL

Technical Architect-BI \ Data Modeler

Responsibilities:

• Worked as Project Lead cum Technical Architect role in Confidential - Asset Management project
• Defined, Created, and managed business specifications, technical specifications, and others project documentation for applications development. and Performed and documented gap analysis.
• Created both logical and physical design of a database, worked on Dimensional Modeling (OLAP data-marts - Star Schema, Snowflake Schema) and manage logical and physical data models for data warehouse
• Incorporated industry standard modeling practices to support a detailed and subject oriented data mart.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Maintained the data model and synchronized it with the changes to the database.
• Developed the team of data analytics and visualization development engineers and convert data into actionable insights using descriptive and predictive modeling techniques
• Worked on SAP Business Objects & COGNOS reports design and development
• Worked on INFORMATICA (ETL) Solution to extract data from various source, transform and load into target system (Data warehouse and data Mart).
• Worked on T- SQL packages Solution to extract data, transform and load into DWH/DM system
• Expertise BO Universes- Design and develop new BO universes, modification and enhancement of existing universe by UDT, Resolve loops, traps, and cardinality on universe.
• SAP BO administrator activities - access, server properties, SIA, Scheduling, publishing documents, managing BO server, Tomcat server and BO services, Excellent understand of CMS Audit DB tables.
• Interacting with the clients and the business partners for issues and queries in the project

Environment: SQL Server2016, TSQL, .NET, Oracle PL/SQL, INFORMATICA9, IDQ, T-SQL, BO XI 3.1 SP5, Dashboard, QlikView, COGNOS10.2

Confidential

Data Modeler\ DWH- BI Architect

Responsibilities:

• Defined, Created, and managed business specifications, technical specifications, and others project documentation for applications development. and Performed and documented gap analysis.
• Created both logical and physical design of a database, worked on Dimensional Modeling (OLAP data-marts - Star Schema, Snowflake Schema) and manage logical and physical data models for data warehouse
• Worked on data profiling the source systems for validating data, defining the data standards, size and datatypes in the data warehouse or mart.
• Created ETL mapping documents from source to target systems for ETL developers.
• Expertise in Design, Implement and support development end to end data warehouses, data marts, ETLs development that provide structured and timely access to large datasets
• Worked on SAP Business Objects & SAP BODI Installation at SAFIC environments
• Worked on SAP BODI (ETL) tool to extract data from POLISY/J (Japan) system, transform the data and load into target system (Data warehouse and data Mart).
• Expertise in BO Universes- Design and develop new BO universes, modification and enhancement, BO Reports -Design and create new BO reports, troubleshoot the BO reports issues.
• Experienced in SAP BO administrator activities, server properties, SIA, Scheduling, publishing documents, managing BO server, Tomcat server and BO services, Excellent understand of CMS Audit DB tables.
• Interacted with the clients and the business partners for issues and queries in the project

Environment: SQL Server 2008R2, Oracle10g, SQL, SAP BODI, SAP BO XI 3.1, Dashboard, CA ERwin, Tomcat 5/7, QlikView

Confidential

BI- ETL Developer

Responsibilities:

• Played as Sr. BI Developer role in Confidential (Tele Denmark Communications) project
• Worked on ARTEMIS Reports, major/minor bug fix, improved performance and Production Support
• Experienced on Data Acquisition from Oracle e-Business Suites R12 (PA Module) using ETL Job scripts.
• Expertise to writing complex SQL query, function and stored procedure to perform specific task.
• Exposure on Project Registration, Project Tracking, development & Maintenance HLD and DLD Document

Environment: TCL, INCA (GIS Application), Oracle 10g, PL/SQL scripts, Oracle Spatial DB Oracle- EBS R12 (PA Module), ARTEMIS, Oracle Spatial, MapInfo.

Confidential

Senior Software Engineer

Responsibilities:

• Worked as ETL - BI Developer role in Thomson Reuters ( Confidential Healthcare) Business Analytics projects
• Experience in creating of Schema objects (Attributes, Facts and Hierarchies) and building application objects (Filters, Prompts, Metrics, custom Groups, Consolidations, Drill Maps, Templates).
• Experienced in design and setting up of new users, roles, privileges, data and application security
• Extensively worked on Data Modeling concepts - Type2 DIM, Fact-Less-Fact and Confirmed DIM and Fact and ..etc.
• Experienced in Quarterly release development process and production live support.
• Worked on INFORMATICA 8.6 as an ETL tool to make Data warehouse and data Mart
• Exposure of MapInfo to deploy additional ZIP CODE into the system to have them into MSTR Reports
• Experienced on reports issues, enhancements, ETL operational environment, DB Optimization
• Expertise to writing complex SQL query, function and stored procedure to perform specific task.
• Interacted with the clients and the business partners for issues and queries in the project

Environment: SQL Server 2008 R2, Oracle 9i, UNIX Scripting, Oracle SQL Developer Data Modeler, INFORMATICA PowerCenter 8.6, IDQ, ICS, Microstrategy9, Onyx, MapInfo