Pawan

+1-623-***-****

adgqfv@r.postjobfree.com

Professional summary:

• Total 17 + years of commercial software development experience with exclusive focus on Data warehouse, data modeling, data virtualization solutions for Financial Institutions, Life science, Energy and Utility,Insurance, Telecom, Automotive, Consulting and Entertainment Industries using High end Tools such as MS SQL Server (OLAP Services, SSIS, SSAS, SSRS), Composite Software Data Virtualization, Informatica, Erwin, Power Designer.

• These solutions Include Data Modeling, Extraction of Data (ETL) from the source system or legacy system, data cleansing, data pumping, data optimization, data aggregation, de normalization and provide distributed multi-dimensional analysis of business dimensions (e.g. Channels, Products, Customers and Regions) in numeric and graphical views. Strong Analysis and Designing Skill

• Extensive experience in Data Modeling, Data Architecture, Data Governance, Metadata Definition, Change Management, Compliance, and Data Quality Management.

• Extensive experience in support and design OLTP architecture for transactional systems.

• Extensive experience in support and design of Data warehousing and reporting solutions via Star, Snowflake, Data Mart, ODS and hybrid approaches.

• Extensive experience in providing support for SSIS and Informatica ETL development efforts, through schema modifications, mapping, profiling and transformation definitions.

• System expertise: strong database & system landscape knowledge (like MS Office (esp. Access and Excel), BI, Dimensional and Relational data modeling, Reporting, ETL)

• Ideally strong expertise in database and Data modeling

• Experience in developing business requirements into technical requirements.

• Experience in utilizing Agile/SCRUM methodology and ensuring consistent, successful objective delivery.

• Experience in applying the techniques of business process reengineering for application and system design.

• Extensive experience of reporting and validation requirements of data and able to develop or revise business or program requirements based on changing program needs.

• Proven ability to work with onsite and offshore teams to meet project objectives with cost, resource, and time constraints.

• Skilled in presenting status to stakeholders on project progress and seeking guidance to mitigate risks.

• Provide expertise on systems and act as a Key User for topics like Data Modeling and Reporting, ETL, etc. towards team and business partners by providing insights & trainings

• Excellent verbal and communication skills.

• Experience of providing consultancy and mentoring services for several projects.

• Experience in designing data model for Datalake and DataHub using SAP Power designer Management Skill

• Partner with the business within the assigned area of responsibility

• Manage small to medium sized projects and/or actively participate in projects including the definition of specific deliverables and documentation and system requirements; implement findings and ensure sustainability of achievements

• Take ownership of assigned processes and systems, i.e. responsible for setting up new team and prepare project planning activities and road map implementation

• Provide expertise for assigned functional areas/systems and processes towards team and business partners, i.e. responsibility on data modelling expertise for KPI definitions

• Significantly enhance and improve standardization and cross-functional collaboration across different groups with the organization.

• Partner with IT horizontal organizations and service partners to drive implementation and testing

• Deep business understanding of process and structure

• Ability to maneuver in consistently changing environment

• Very good Project Management skills

• Conduct regular standup meeting and grooming and planning sessions

• Perform individual yearly performance review and share feedback and rating

• Demonstrated ability to develop comprehensive project plans and experience managing to budgets, profit targets, and timelines

• Demonstrated experience managing Agile Scrum projects

• Experience in a consulting environment managing projects for multiple external clients Technical Skills:

BI Tools Business Objects, Cognos, SQL Server Analysis Services (SSAS) Big Data Technologies Hadoop, Hive, Hbase, Sqoop, Oozie, MapR, IBM DB2 BLU Languages: VB, C, C++, PL/SQL, T-SQL, VB Script, R, Python Data Modeling: Erwin data modeler, Power Designer, Database Design Tool (DDT) Data Virtualization: Cisco Data Virtualization tool Data Visualization: Tableau

Data Science: R, Python,

ETL Tools: Informatica, SQL Server Integration Services (SSIS), Talend Open Studio Databases: Oracle 11g, MS SQL Server, SSIS, SSAS Reporting Services, MySQL 5, DB2, IBM DB2 BLU

Robotics Automation: UiPath Robotics Process Automation (RAP) Other Software: MS Word, MS Excel, MS Access, Microsoft IIS, SharePoint MOSS Environment: MS win 2K/NT/98/XP, UNIX, and MSDOS.

Affiliations/Certifications:

UiPath Training and Certificate for Robotics Process Automation (RPA) 1. Robotics RPA

Machine Learning A-Z: Hands on Python and R in Data Science 1. Machine Learning Data Science

2. DataCamp

Tableau 10 A-Z: Hands on Tableau Training for Data Science 2. Tableau

MCP – Microsoft Certified Professional -- # 2190558 Immigration Status:

Green Card

Employment History:

Company: Sogeti US LLC Sep 2019 – Present

Data & Solution Architect:

World’s leading ready-mix manufacturing company based out DFW area. To enhance customer relationship, planning and sales forecasting purpose’s management undertook a new initiative to onboard North American business under their new CRM365 cloud solution. As part of this solution all the customer from JDE were migrated to SAP and existing Microsoft CRM 2015 (on-prem) to Dynamics in cloud. As part of CRM implementation Master Data Management (MDM) played a key role in data standardization and harmonization with other systems like HANA. Job Responsibilities:

• Defined the scope of the project in collaboration with business team

• Assist with the design of the end-state Data Integration architecture workflow

• Designed ETL Load Strategy and packages for data integration

• Participate in project planning, technical solution and working session with teams

• Master Data preparation and Standardization from different sources

• Analyze Data Extraction Mechanism and Data Transformation requirements per LOB

• Worked with Source to target mapping (STM) team to build the transformation logic for data transfer

Environment: SQL Server, Azure, SAP, Dynamic 365, HANA reporting Client: Lehigh Hanson, Irving, TX Jan 2019 – Aug 2019 Data Integration Consultant:

German based multinational construction company. The management decided to move there on-prem Essbase and Planning to Oracle cloud (EPBCS). As part of that program multiple files extracts were generate from cloud which included planning, budgeting and forecasting data. This data was fed into BW and ERP for reconciliation and reporting purpose.

Job Responsibilities:

• Defined the scope of the project in collaboration with senior management

• Assist with the design of the end-state Data Integration architecture workflow

• Designed ETL Load Strategy and packages for data integration

• Designed rules engine to incorporate the business logic and mathematical calculations

• Participate in story grooming and planning session

• Participate in JAD (Joint Application Development) Sessions

• Providing strategic direction during the implementation stages

• Analyze Data Extraction Mechanism and Data Transformation requirements per LOB

• Worked with Source to target mapping (STM) team to build the transformation logic for data transfer

• Designed rules engine to incorporate the business logic and mathematical calculations Environment: SQL Server, OCS, SAP BW

Company: Syntel Inc

Client: Penn National Insurance, Harrisburg, PA Jan 2018 – Dec 2018 Lead Data & Solution Architect:

Penn National Insurance (PNI) has partner with Duck Creek (DC) Technologies, a leading provider of comprehensive P&C insurance software and services for insurers of all sizes worldwide for a Data Integration project. PNI agents sell policies to its customers via Duck Creek System, which enable agents to access wide range of products and services offered with in DC. Information captured within the DC system is stored in the internal database (Intuitive Data Optimization - IDO) and with the help of a shredding job the same information is made available to downstream system. As part of this data integration project, we read data from shredding database and integrate the same into the PNI Enterprise Data Warehouse which enable the corporate users to access report via reporting tool for further analysis and fulfill corporate reporting needs.

Job Responsibilities:

• Defined the scope of the project in collaboration with senior management

• Assist with the design of the end-state Data Integration architecture workflow

• Worked with ETL team to build the Load Strategy and Error reprocess

• Participate in story grooming and planning session with onsite team

• Created a detailed work plan which identifies and sequences the activities needed to successfully building of data model

• Designed Multidimensional data model

• Published Data Dictionary Report for users

• Participate in JAD (Joint Application Development ) Sessions

• Providing strategic direction during the implementation stages

• Analyze Data Extraction Mechanism and Data Transformation requirements per LOB

• Worked with Source to target mapping (STM) team to build the transformation logic for data transfer

Environment: SQL Server, VB Script, Visual Studio 2017, Duck Creek (Intuitive Data Optimization - IDO) Client: Daimler Truck North America, Portland Feb 2017 – Dec 2017 Data & Solution Architect:

DTNA Quality team wishes to improve the speed and effectiveness with which it is able to analyse on the issues related to Quality of the Truck. To achieve this, DTNA needs to continue linking together the datasets that relate to quality issues from different sources. Bring multiple information systems together in one place in real time and with history to identify and resolve build issues earlier in the process. Moving this earlier will result in reduction of costs of future trucks upstream (preferably design) before warranty is requested. It also wishes to develop the tools that it uses to explore, analyse, report and take actions on these datasets.

Job Responsibilities:

• Defined the scope of the project in collaboration with senior management

• Created a detailed work plan which identifies and sequences the activities needed to successfully build a data model

• Designed IBM BLU lake Architecture ( Raw Data Layer, Data Integration Layer, Operational Data Layer) for different subject area data integration

• Participate in story grooming and planning session with onsite team

• Analyze multiple sources identified, Data Format, Data Extraction Mechanism, Data Transformation requirements

• Providing strategic direction during the implementation stages

• Designed new Dynamic Reporting Data model to support new business model

• Transform business requirements / rules into data models by applying dimensional modeling rules and adhering to DTNA specific data modeling standards

• Conducted logical data model review sessions with Product Owner

• Worked with Source to target mapping (STM) team to build the transformation logic for data transfer

• Worked with ETL team to build the Load Strategy and Error reprocess

• Published Data Dictionary Report for users and coordination with offshore team Environment: IBM DB2 BLU lake columnar data model, CA Erwin 9.14, AlignAlytics, Informatica Client: America Express Global Business Travel, Phoenix, AZ Nov 2015 – Jan 2017 Solution Architect:

America Express Global Business Travel (GBT) Finance team is re-architecting there legacy reporting system with new reporting solution. My team responsibility is to help GBT with re-architecting the solution. GBT serves several clients which share financial transactions data for processing. This data includes transaction performed worldwide. New reporting solution is designed to store and process large data volume. The proposed solution road map will cater current and future application needs. Job Responsibilities:

• Defined the scope of the project in collaboration with senior management

• Created a detailed work plan which identifies and sequences the activities needed to successfully build of data model for BI Finance DataMart

• Participate in story grooming and planning session with onsite team

• Build data model for DataMart and Staging area using SQL Server

• Build mapping document for data transformation between Staging area and DataMart

• Participate in JAD (Joint Application Development) Sessions

• Analyze multiple sources identified, Data Format, Data Extraction Mechanism, Data Transformation requirements

• Providing strategic direction during the implementation stages

• Developed strategy and lead implementation for any required “real-time” information integration with BI applications

• Served as the Lead Designer of all MOLAP/OLAP capabilities for a specific project

• Worked closely with End Users to produce prototypes of MOLAP/OLAP solutions and user interfaces and define end user analytical requirements

• Worked closely with project Business Analyst, Data Modeler and ETL Lead to ensure that the end to end designs (together, including MOLAP/OLAP) meet the business and data requirements

• Develop the task plan for MOLAP/OLAP developers and UI developers for a specific project

• Designed Multidimensional data model

• Designed logical and physical data modeling techniques, for both dimensional models Environment: Microsoft SQL Server, Microsoft SharePoint, Analysis Services, Integration Services Other Projects:

Client Tenure Company

Valence Health, Chicago, IL Jan 2015 – Oct 2015 Syntel Inc CRL, Edinburgh, Scotland, UK Aug 2014 – Nov 2014 Syntel Inc Wells Fargo, San Francisco, CA July 2013 – June 2014 Syntel Inc Allstate Insurance, Chicago, IL Feb 2011 - May 2013 Syntel Inc Schumacher Group, Dallas, TX Sep 2009 - Dec 2010 Schumacher Group Texas Utility, Dallas, TX Nov 2007 - Aug 2009 Capgemini US LLC Dell Computers Inc, Austin, TX April 2007 - Oct 2007 Capgemini US LLC Verizon, Irving TX Feb 2006 - Mar 2007 CCS US LLC

Hewlett-Packard March Mar 2004 - Dec 2005 Independent Contractor Kiwi Bank Limited Jan 2003 - Dec 2003 Independent Contractor Fonterra Co-operative Jan 2002 - Dec 2002 Independent Contractor Auckland University of Technology (AUT) July 2000 - Oct 2001 AUT

Contact this candidate