SUMMARY:

• 18 years of expertise on Data Warehouse, Data Analytics, Data Migration and Data Products
• 12 years Expertise in Designing and developing solutions for Big Data Warehouse, Data Migration and Data Products
• 15 years of Expertise in designing Relational (OLTP) and Analytical (OLAP) Data Modeling
• 9+ years of experience on Database like Snowflake and Redshift
• Worked with all 3 public Cloud provider AWS, AZURE, GOOGLE
• Previously worked on Netezza, Teradata, Oracle, MS SQL Server, SAP HANA, MongoDB, Cassandra
• Used Data Vault 2.0 framework for designing new Datamart and Data Warehouse
• Hands - on experience with ETL tool like AWS GLUE, IICS, Pentaho DI, Talend DI Studio
• Hands-on experience with Cloud Serverless Function like AWS Lambda Function, Google Cloud Function and Azure Cloud Function
• Working knowledge of DBT ELT tool
• Used Data Vault 2.0 framework, Bottom Up and Top Down for Data Warehouse design and Data Modeling
• Domain expertise in Retail, Hi-tech, Manufacturing, Telecom and Banking Finance and Insurance.
• Designed few of the application like Real-time Analytics, Dynamic Pricing, Industrial IoT
• Develop guideline and best practices for Coding for consistency in system
• Worked on updating and optimizing metadata models.
• Expert in reviewing existing data model and framework for scalability, extensions and performance and security.
• Provide troubleshooting guideline for Nonperforming Workloads and Data pipes
• Develop Best practices on the project for smooth and scalable operations.

TECHNICAL SKILLS:

Cloud: AWS, Azure, GCP

AWS: Redshift, Aws Glue, Athena, AWS RDS, HUDI, ICEBERG, ENDPOINTS etc.

AZURE: ADLS, Azure SQL, Azure Data Factory, Databrick, Synapse, Azure Blob

GCP: Bigquery, Dataproc, Cloud Function, Cloud Dataflow, Cloud Pub Sub, BigTable

Cloud Analytics Database: RedShift, Snowflake, Azure Data warehouse, Synapse, BigQuery, Elasticsearch, ELK, Splunk

ETL Tool: SSIS, SSAS, Pentaho, DataStage, Database Build Tool (DBT)

Data Modeling: Data Vault 2.0, SQL Modeler, ER Win, Power Design

Cloud Machine Learning: AWS ML, AWS Sage maker, Azure ML Studio, GCP ML

Traditional Database: Teradata, Netezza, MS SQL Server, Oracle

NO SQL Database: MongoDB, Casandra, Redis

OpenSource Database: Apache Hudi, Apache Iceberg, Apache Deltalake

Data Modeling: Data Vault 2.0, Oralce SQL Data Modeler, ER Win

Data processing: AWS Glue, AWS Lamda, Azure ADF, GCP Dataproc

Realtime Message Quque: AWS Kinesis, Apache kafka, GCP Pub-Sub

Data Visualization: Tableau, Power BI, Qlik, AWS Quicksight, GCP Looker

Cloud Marketing: GoogleAds, Google AdSense, Google Analytics, DataStudio, HubSpot, Adobe marketing cloudPython, Java, .NET

Programming Skills: R, Python, Pig, Hive, SQL, C++, Java, VB.NET

Operating Systems: Window, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Snowflake and DBT architect, Business System Analyst

Responsibilities:

• Requirement gathering
• Understanding the Customer Life Cycle and its business value for reporting
• Finding gap between the existing application and new application requirement
• Communication with Business Stake holder and Product Owner
• Analyzing SQL queries for business rules
• Documenting and discussing design and rules with Product Owner
• High Level Design to Low Level Design for dataflow
• Data modeling
• Connect Snowflake and Oracle CDW
• Designing Data pipeline using DBT

Confidential

Snowflake Solution Architect

Responsibilities:

• Designed Data Architecture, Solutions for data migration
• Data modeling for HR Analytics processing
• Snowflake Administration for Security and User Management. Privileges Control etc.
• Snowflake Data Operation design and data integration

Confidential

Consultant for Data Modeling, Snowflake Database design

Responsibilities:

• Designed Data Model for Snowflake Cloud Database
• Snowflake Administration for Security and User Management. Privileges Control etc.
• Snowflake Data Operation design and data integration

Confidential

Data Architect for Data Integration between CISCO Install base and CAMS Storage

Responsibilities:

• There was a need to Develop a One View of Sale, Service and Installbase. This was conceptualized to merge data from Oracle ERP and underlying Product and Services to find a Single version of truth of whole Business. This will help business to know about Total Receivables and Payables and matching it with underlying data of Sale and Service and Product.
• Understanding of whole data flow and design the solution for near realtime update
• Data Analysis for Automation and designing of automation solution
• Data acquisitions using SnowSQL, using Snowflake Data Security and User access control

Confidential

Data Management Architect and API Design

Responsibilities:

• Designed system using AWS Cloud technologies for data capture
• Designed API before passing it to downstream applications and analytical purpose.
• Automated layer of DartaOps so that business can directly be participated in information building process.

Confidential

Data Management Architect

Responsibilities:

• Designed system using Cloud technologies and Snowflake (AWS) to move data from SAAS application to cloud databases.
• Automated layer of DataOps so that business can directly be participated in information building process.
• Designed real time feed using Oracle OIC to Snowflake database from Oracle Fusion application.
• Optimized 100+ 3rd party data feeds which directly lands in Snowflake using APIs.

Confidential

Program Manager

Responsibilities:

• Associated Products in different Product Category, Gender, and Store Region.
• Assessment of Customer Life Time Value
• Segmenting customer based on their buying behavior
• Recommendation Engine of Product for bundled products
• Campaign and Promotion Design
• Tracking the success of Promotions
• Partnered with Nakumatt to understand the problem statement
• Understanding their Business Processes
• Understanding their Business objectives and their technology preparedness
• Solutioning and Advising on technology options with guidelines
• Designing the High level and low-level solution architecture and Data Model for dataflow
• Eliminating the data integration challenges between sensors lag, data flow and collection
• Green Field Big Data Project deployed with Hadoop, Open R.
• Innovated ETL design in Hive to make it scalable.
• Application of data science for various Customer Analytical Reports.

Confidential

Business and Technical Consultant

Responsibilities:

• Assessment of Data Management System
• Understanding whole Business process and Operational process
• Finding Strength and Opportunity of improvement in their process using data
• Developing final assessment report with Architecture and improvement roadmap
• Analysis of SAP HANA Database

Confidential

Senior Architect and Solution Design

Responsibilities:

• Partnered with Business to understand the problem statement
• Understanding their existing state of the data and gap
• Understanding their Business objectives and their technology preparedness
• Advising on technology options with guidelines
• Designing the High level and low-level solution architecture
• Eliminating the data integration challenges between sensors lag, data flow and collection
• First project deployed with Hadoop and Splunk integration.
• Developed utility using Data Integration and data rules for unstructured json files
• Innovated ETL design in Hive to make it scalable.
• Application of data science for predicting productivity and machine maintenance.

Confidential

Senior Architect and Solution Design

Responsibilities:

• Well documented Project charter preparation
• Project Planning for clear schedule and communication
• Timely communication for Timely delivery
• Followed Agile methodology of delivery
• Project control and resource monitoring using Scrum meeting and planning
• Flexible Solution Architecture for adding any new subject area and dimensions
• First project deployed with full Cloud Infrastructure
• First time use of AWS Redshift Cloud database appliances.
• Developed utility using VB Script and Python for unstructured json file integration
• Innovated ETL design to make it superfast data loading i.e. 10 million of records in less than 3 minutes and million updates in less than 6 seconds.
• Integration of Schema less unstructured json to structured database
• Well documented ETL Coding and Testing results
• 2 new resources mentored on Pentaho and all team members on AWS RedShift.

Confidential

Program Manager / Senior Architect

Responsibilities:

• Showcasing the business benefit of Data Analytics and Business 360 view
• Coordinated with Key stake holder of business and understand the information gap of the existing business
• Identified the solution and its implementation
• Project Planning for clear schedule and communication
• Timely communication for Timely delivery
• Followed Agile methodology of delivery
• Project control and resource monitoring using Scrum meeting and planning
• I was responsible for Big Data Hadoop implementation
• I developed Statistical Data Science models for business and customer predictions.

Confidential

Senior Solution Architect / Data Warehouse/ Data Analytics

Responsibilities:

• Helped business in identifying the digital opportunity which can help business to improve the efficiency and scope of marketing and opportunity.
• Studied the various account like CISCO, ViaSat, Videojet to understand where they are missing on the Digital opportunity.
• Worked on delivering the roadmap of Digital Journey for identified business and their business benefits like Customer Experience and Productivity Improvement.
• Created Detailed Paper “On Digital Journey: Road to Follow”. This has helped Zensar in pitching new businesses and new opportunity with existing customer and new customer.
• Assisted Sales person on understanding the Digital Transformation.

Confidential, Chicago

Project Manager / Data Warehouse

Responsibilities:

• got selected for this program based on my technical skills and learning adoption was Responsible for all the activities at offshore with respect to this program.
• Setup and mentored 30 members team to work on this new Hadoop open - source technology
• I was in touch with the CIO and CTO for their further strategy and its implementation
• Identified the applications which can be planned for the migration from Mainframe to Hadoop
• Estimating the budget and the effort for reducing 10000 MiPs from Mainframe
• Tracked the whole program closely with all kinds of reporting with respect to Plan, Execution, Delivery and Testing.
• Followed agile methodology to achieve the goal.

Confidential, Chicago

Project Manager/ Data Warehouse

Responsibilities:

• Study of the existing program and the new technology platform to migrate existing reward system on new Hadoop Platform.
• Managed to whole program from Transitioning from Old Netezza platform to new Hadoop platform.
• Monitoring and tracking the tasks on regular basis.
• Communicating it to CIO for any exceptions.
• Finding the appropriate method or alternatives while getting technological challenge. Like performance, data quality and huge historical load of the program.
• Designed framework for real-time reporting and managing the campaign.
• Solution has given huge push to the personalized marketing promotions and campaign.
• Technology evaluation while keeping the program on and doing research.
• Configured 40 node clusters for this application.

Confidential, Chicago

Project Manager / Data Warehouse

Responsibilities:

• Defining the business case of Dynamic Pricing with respect to Inventory units
• Selecting the technology stack for this application
• Building the team and mentoring team for new technologies
• Developed the Project Plan and Status reporting
• Keep in touch with the Business Team, CIO, CTO for all kind of communication
• Risk monitoring on the project.
• Production movement of the application.

Confidential, Chicago

Assistant Manager / Data Warehouse

Responsibilities:

• Identification of requirements after discussing with Store Managers
• Defining the business benefits
• Designing and architecting application for business alerts and communications.
• Converting it as a project with planning, scheduling and deliverables
• Executing, Monitoring, Controlling and Communicating to Stakeholders
• Business were happy to get the systems for near to real time control with actionable information.
• Solution has given huge push to the employee motivation.

Confidential, Chicago

Project Manager / Data Warehouse

Responsibilities:

• Identification of requirements after discussing with Store Managers
• Defining the business benefits
• Designing and architecting application for business alerts and communications.
• Converting it as a project with planning, scheduling and deliverables
• Executing, Monitoring, Controlling and Communicating to Stakeholders
• Business were happy to get the systems for near to real time control with actionable information.
• Solution has given huge push to the store and inventory management.

Confidential

Assistant Manager / Data Warehouse

Responsibilities:

• He joined as a BI Program Manager looking after the process optimization on Business Requirements and Solution Delivery platform.
• Reviewed the IT Applications and their gap area to make it acceptable to the Business.
• Client Services are the team who collects the requirements and discuss the feasibility with the help of IT Solution delivery team.
• He was part of this team meeting and taking care of the technical areas.
• He was discussing the requirement with Client Services for any new changes and new solution delivery.
• He also did alignment on the BI Support area and worked as facilitator in Knowledge transition and SLA adherence.
• There were 42 applications related to Sales & Marketing and Activity. Altogether there were applications for Sales and Marketing, Sales Representative Activities, Doctor’s visits on Univadis website and Email marketing and capturing their learning data.

Confidential

Assistant Manager / Data Warehouse

Responsibilities:

• He was involved there as Project manager, looking after the proposal, project planning, monitoring, Quality assurance and delivery.
• He was interacting with Technical stuff for controlling the SCOPE, TIME and QUALITY of the project.
• Apart from project responsibilities, he was managing the expectation of Stakeholder as well as handling the Key communication and sharing information between project team and management.
• This was a challenging assignment where he was part of business and process integration between T System and T - Mobile Deutschland.
• He travelled to client location Darmstadt, Germany to manage stakeholder’s expectation and perceptions.

Confidential

Senior System Analyst / Data Warehouse programmer

Responsibilities:

• He was involved in this operation for successful execution and delivery of REITZ.
• After successful business planning, we have started migration planning which has involved of ANALYSIS, DESIGN, DEVELOPMENT, INTEGRATION & DELIVERY.
• He contributed as Project Leader and contributed to technology as Senior System Analyst.

Confidential

Senior System Analyst / Data Warehouse programmer

Responsibilities:

• He did the System Requirement Studies
• At Onsite Paris and Port Sunlight he was involved in planning meeting & Coordination
• He did Project Planning & Budgeting of new requirements
• He made the Execution of the plan
• He was managing Risk Control & Quality Control
• He was involved in Development - Universe, OLAP Database, Cube designing
• He was responsible for Report development
• He made the plan to Integration new changes to the present Architecture
• He was responsible for Implementation
• He led a team of 24 members.

Confidential, San Francisco

System Executive / Data Warehouse programmer

Responsibilities:

• He was responsible for Designing OLAP Database
• He was responsible for Designing DTS packages for Transformation.
• He was responsible for Loading data to Dimension tables and Fact tables.
• He was responsible for Cube designing and processes.
• He was responsible for Universe creation using Business Objects, OWC, WI.
• He was responsible for Business Reporting using Business Objects 5.5

Confidential

Senior Consultant / Application Programmer

Responsibilities:

• He was responsible for Designing the Process Flow
• He was responsible for Designing the Workflow
• He was responsible for Designing the Data layer
• He was responsible for Designing OLAP Database
• He was responsible for Loading Data
• He was responsible for Business Reporting using ADOMD.
• He was responsible for Designing the Business Layer
• He was responsible for Development of Application
• He was responsible for Implementation of PKI, Digital s using USB Tokens and Smart Card.
• He was responsible for Taking feedback from the APTS
• He was responsible for Testing the Application
• He was responsible for Delivery of the application

Confidential

Project Leader / Web Programmer

Responsibilities:

• He was the Project Leader and the Technical Lead for this project.
• He designed the whole project and the Database.
• This project has taken 9000 man - hours of the development.
• We have used no. of Database and their inter communication for this project.
• He designed the XML and written DTD for it. First time I used XML SQL queries to update the Database.
• This is a measure project using COM/DOM, XML, SQL-XML queries, and other advance technology.

Confidential

Project Leader / Web Programmer

Responsibilities:

• He was the person who is sole responsible for this project and coordination.
• This was the First Time when he implemented the MS Commerce server 2000 with MS OLAP Server 2000.
• He used the Decision Support Services and the Pivot Table Service for getting the output from the Data Cubes.
• He was the person behind the architecture and Design of this Project.
• He coordinated the Team member and communicated to the Client for the development of this Project.

Confidential

Web Programmer

Responsibilities:

• He was with the Design and development of this projects.
• He completed the programming of RFQ, Tenders, Sealed Bid and Order Processing Modules...
• He written the Java Beans for these modules and incorporated it into the JSP pages. The Backend of this project is Oracle 8i.
• He had written PL/ SQL for the Database Interaction.

Confidential

Web Programmer

Responsibilities:

• Involved in visualization of the site. Designing of the Existing flow of the Shopping Cart and integrating it with the database and the Credit card service Provider. MTS is used for the Transactions.
• Coordinated with the team for designing, coding, testing/debugging and site bashing
• Involved in hosting of the site and checking for the compatibility in different browsers.

Confidential

Web Programmer

Responsibilities:

• He completed the Shopping Cart as well as payment module of this Application.
• He was also involved in development of UI and validation of input fields. This is the project, which belongs to the Fortune 500 Company Nortel Networks Solution, Canada.
• He had written the COM component for database connection and updating using MTS. MTS is also used to keep the business logic in the middle tier.
• He generated the sales report in the XLS format using ASP.
• He had written the file Upload program code for File Upload.

Confidential

Web Programmer

Responsibilities:

• He did the total Database and UI design.
• He had written Active X component for Time Zone.
• He used this component to get the train and fight timings from the Database.
• He used the Winsock 32 component for this module.
• He made this site Web Enabled using WAP /WML

Environment: ASP, VBScript, JavaScript, Visual InterDev, SQL Server, IIS, and WMLS.

Confidential, California

Web Programmer

Responsibilities:

• He learnt the Web programming.
• He programmed the Payment Module, Shopping Cart, and Advance search.
• He used the VeriSign Component for validating real life Credit Cards. There is provision for calculating the cost of courier. The search, report generation on the total sale and Credit Card validation is the main module of this Web Application.
• He extensively used the MTS for validation and checking of logical integrity.