SUMMARY:

• Over all 12+ Years of experience in Data Warehouse\BI, Data Modeling Technique & Data Visualization
• 7+ Years experience in multidimensional (OLAP) data modeling, such as Star schemas, Snowflakes schemas normalized and de - normalized models, handling -slow-changing- dimensions\attributes.
• Expertise in entity relationship modeling, conceptual and logical Data modeling, Physical Data Modeling, hierarchies, relationships, metadata, data lineage, reference data.
• 7+ Years experience in Microsoft BI & SAP BI, ETL Solution Design and Analytics Reporting.
• Expertise in Project design, Estimation, Implementation, Upgrade, Migration, Client-interaction, maintenance and team management.
• Extensive experience in SQL Server 2016/2014/2012/2008 R2 performance tuning, load balancing, backup, Database design, upgrade and migration.
• Expertise in ETL Tools- Microsoft SQL Service Integration Services (SSIS), Analysis Services (SSAS), SAP BODS (Data Services), INFORMATICA PowerCenter, IDQ, ICS,
• Extensive experience in BI Tools - SAP Business Objects, SSRS, SAP Lumira, MicroStrategy9.2, COGNOS 10.2 Report Suite, Tableau, QlikSense, SiSense & Sap Lumira
• Expertise in Business Objects Configuration, Administration, Server Clustering, Load Balancing, Universe Design, Reporting, Dashboard, Tomcat settings, CMS Repository, Lumira Stories.
• Worked on Integration packages (SSIS), SAP BODS & Informatica Power Center for data movement and ETL\ELT process to populate the data warehouse from various source systems.
• Proven Track records of multiple Upgrade\Migration\Development project for various Insurance clients- FPI, FBL, BAHAMAS & Dongbu, SwissRe Insurance
• Worked on Data Modeling tools - Erwin, ER\Studio, & Oracle SQL Developer Data Modeler tools
• Extensively used Performance Optimization best practices for making database healthy and provide optimal performance including table partitioning, Buffer Sizing, Threading and Indexing strategy.
• Analysis of current data, Gathering the business requirement, discussing with Subject Matter Experts (SME’s), Gap Analysis of Current requirement, future needs and builds the Logical\Physical Data Model for Enterprise Data Warehouse Application.
• Extensive experience in QA Processes, QA Metrics, KPI’s in Q-Lab, P-Lab & C-Lab environments.
• Good Knowledge of Big Data -Hadoop, AWS Cloud, Amazon RedShift, MongoDB and Python.
• Built Enterprise Data Warehouse using Ralph Kimball Dimensional Technique.
• Involved 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 and daily stand-up
• Sound Knowledge of Insurance, Healthcare, Life Science, Telecom domains
• Goal Oriented individual with ‘get the things done’ attitude

TECHNICAL SKILLS:

ETL Tools: SAP BODS 4.2 SP8 (or Lower), INFORMATICA9, IDQ, ICS, MS- SSIS, Information Steward

BI Tools: SAP Business Objects 4.2 (or Lower), SAP Lumira, SSAS/OLAP, SSRS, COGNOS10.2, Microstrategy9.2, Crystal Report, Tableau, QlikView, Sisense, Power Pivot

DATABASES: MS SQL Server 2016 (or lower), ORACLE 11g, IBM-DB2, XML, MS AccessLANGUAGE: T-SQL and PL/SQL, Visual BasicAPP/WEB: IIS, Apache Tomcat, WSDL, SOAP

DATABASE MODELING: CR ERwin, ER Studio, Oracle SQL Developer Data Modeler

VERSION CONTROL: Microsoft Visual Source Safe, GIT, Tortoise SVN repository

SCHEDULER TOOLS: Control-M, Auto-Sys

PROJECT MANAGEMENT: JIRA, Microsoft Project, HPSM, Agile Scrum

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

OTHERS: Hadoop, AWS Cloud, Amazon RedShift, MongoDB and Python, MapInfo

PROFESSIONAL EXPERIENCE:

Confidential, Austin

Sr. BI\ Data Analyst\ Data Modeler

Responsibilities:

• Working as Sr. DWH- BI Developer/ Data Modular for In-house project.
• Requirement gathering with Business Analyst, SME and technology team.
• Projected to use SSIS Solution to to extract, transform and load data into DWH target system
• Projected to Use SAP Business Objects Reporting tool to create reports.
• Expertise on BO Universes- Design, develop, modify in UDT & IDT & BO Reports -Design, Create BO reports, troubleshoot issues, enhancement.
• Expertise in Confidential, SAP BO administrator activities - access, server properties, SIA, Scheduling, publishing documents, managing server, Tomcat server, BO services, Excellent understand of CMS Audit DB tables.
• Experienced in designing analytical solution using SAP LUMIRA & Tableau.

Environment: SQL Server 2016, SSIS, SSAS, Power Pivot, SAP Business Objects 4.2, Tableau, JIRA

Confidential

Sr. DWH-BI \ Data Modeler\Data Architect

Responsibilities:

• Worked as Sr. Consultant cum Technical Architect in SICS Business Analytics projects
• SICS - (P&C, Life ) Reinsurance Product used by 150+ Reinsurance customers globally
• Played a key technical role in advanced data techniques in data modeling, integration, visualization, database design and implementation.
• Expertise in Business Objects Installation, Upgrade, Migration and Implementation for Insurance Customers
• Worked on MS-SSIS (ETL) Solution to extract, transform and load data into DWH target system
• Expertise to writing complex SQL query, function and stored procedure to perform specific task.
• Expertise on BO Universes- Design. develop, modify in UDT & IDT & BO Reports -Design, Create BO reports, troubleshoot issues, enhancement.
• Expertise in SAP BO administrator activities - access, server properties, SIA, Scheduling, publishing documents, managing server, Tomcat server, BO services, Excellent understand of CMS Audit DB tables.
• Experienced in designing analytical solution using SAP LUMIRA & SiSense
• 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, Power Pivot, TSQL, Oracle 11g, SAP BO XI 3.1/4.2, SAP LUMIRA, Tableau, JIRA

Confidential, Blythewood, SC

Sr. BI Developer\BI Architect\ Data Modeler

Responsibilities:

• Worked as Sr. Programmer Analyst cum Technical Architect in POINT IN Business Analytics projects
• POINT IN/J is CSC - P&C Insurance Product used by 170+ USA Insurance customers
• Performed a key technical role in advanced data techniques in data modeling, Access, integration, visualization, database design and implementation.
• Expertise in Business Objects Installation, Upgrade, Migration and Implementation for Insurance Customers.
• Expertise in MS-SSIS (ETL) Solution to extract, transform and load data into DWH target system
• Expertise to writing complex SQL query, function and stored procedure to perform specific task.
• Expertise on BO Universes- Design. develop, modify in UDT & IDT & BO Reports -Design, Create BO reports, troubleshoot issues, enhancement.
• SAP BO administrator activities - access, server properties, SIA, Scheduling, publishing documents, Managing BO server, Managing Apache Tomcat server and BO Services, Excellent understand of CMS Audit DB tables.
• Experienced in Dashboard Design, SAP LUMIRA
• Monitor and improved performance of ETL and operational reporting environments
• Expertise in defining data types, optimal normalization, referential integrity , triggers , partitioning design , indexing methods, and data security procedures.
• Delivered simple, complex end-to-end data solutions on-time, budget, and with a high level of quality
• Expertise of troubleshooting complex production support issues and Database optimization
• Worked in Agile-Scrum that includes short term goals, iterative development and daily stand-up
• Interacted with the clients and the business partners for issues and queries in the project
• Followed, and enforced, industry and organization standards and best practices

Environment: IBM DB2, SQL Server 2016, MS-SSIS, SSAS, T-SQL, .NET, CA Erwin, SAP BO XI 3.1/4.2, SAP Dashboard, Tableau, SAP LUMIRA, JIRA

Confidential, Bloomington, IL

Technical Architect-BI \ Project Lead\ Data Modeler

Responsibilities:

• Worked as Project Lead cum Technical Architect role in State Farms- Asset Management project
• Partnered with Business to understand the challenges and pain points, desired business outcomes and provides technical feasibility insight and solution options.
• Design, Implement and supported development end to end data warehouses, data marts, ETLs development that provide structured and timely access to large datasets.
• Developed the team of data analytics and visualization development engineers and convert data into actionable insights using descriptive and predictive modelling 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).
• Expertise to writing complex SQL query, function and stored procedure to perform specific task.
• Expertise in defining data types, optimal normalization, referential integrity , triggers , partitioning design , indexing methods, and data security procedures.
• Worked on MS- TQL 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.
• Expertise in Reports -Design, create reports, Changes/enhancement of existing BO & COGNOS reports
• Worked on IBM COGNOS Report Studio, COGNOS Framework Manager
• 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.
• Monitors and improves performance of ETL and operational reporting environments
• Handled a team of resources at client location in Bloomington, USA
• Interacting with the clients and the business partners for issues and queries in the project

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

Confidential

Team Leader\ Data Modeler\BI Architect

Responsibilities:

• Worked as Technical Architect cum Project Lead role in SAFIC- POLISY/J -Business Analytics projects
• Defined and achieved the strategy roadmap for the enterprise; including data modeling, implementation and data management for enterprise data warehouse and advanced data analytics systems.
• 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
• 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 & 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 to writing complex SQL query, function and stored procedure to perform specific task.
• 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

Senior Software Engineer

Responsibilities:

• 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.
• Worked on INCA Application, Oracle Spatial DB and Map Info application to generate Geographical maps
• Exposure on Project Registration, Project Tracking, development & Maintenance HLD and DLD Document

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

Confidential

Senior Software Engineer

Responsibilities:

• Experienced in MSTR Report Development and objects (Attributes, Facts, Metrics, Filters, Prompts), Dashboards, Cubes.
• 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

Confidential, NJ

Programmer Analyst

Responsibilities:

• Performed role of Programmer Analyst -BI Developer in Cognizant Technologies Solutions in Pune
• Had Exposure of Pharma Client used SQL* LIMS System for NG-LIMS and Stability-LIMS products and captured sample life cycle phase data to design the DSS system.
• Worked for 24 LIMS sites across the Globe to capture NG-LIMS and Stability-LIMS Sample data and loaded successfully into data warehouse and DSS system by setting up the Data Stages at UNIX server
• Worked on UNIX Shell Scripting, Crontab Job Scheduling, MSTR & COGNOS Admin and Framework Manager, User Access
• Expertise in MSTR & COGNOS Report Development and Production Support
• Monitoring processes running on UNIX server of Stability DSS and maintaining their continuation
• Worked on troubleshooting COGNOS and MSTR reports issues, Modify or enhance existing MSTR reports

Environment: UNIX Shell Script, Oracle 9i, SQL*LIMS, PRO*C, Oracle PL/SQL, COGNOS 8.2, COGNOS FrameWork Manager, Microstrategy9,

Confidential

Software Engineer

Responsibilities:

• Performed as Software Engineer - Developer role in NDPL location in Delhi
• Worked in Data center to monitor and maintained the process in server room
• Worked on Crystal report design & development, Unit testing, System testing, UAT and PRODUCTION Deployment.
• Worked on Tables, Views, Indexes, Stored Procedures, Triggers, Crystal Report, Oracle PL/SQL and Bug Fixing
• Tested the Crystal reports, debugging application issues and fixed them

Environment: Oracle 9i, Oracle PL/SQL, TOAD, UNIX Commands, Unix Shell Script, Crystal Report.

Confidential

Software Engineer

Responsibilities:

• Worked as a Software programmer in creation of functions in VB Modules
• Worked on Crystal report design & development, Unit testing, System testing, UAT and PRODUCTION Deployment.
• Involved in coding and Testing windows based applications
• Created Test case, executed them and worked on user manuals
• Worked on Tables, Views, Indexes, stored Procedures and triggers, debugging of issues & fixed them

Environment: Oracle PL/SQL, Crystal Report, Oracle 8i, VB6.0, Windows NT