SUMMARY:

• Over 11 years of experience in IT Industry, including 5 years of experience as a Project \ Program Manager for both Waterfall and Agile Projects
• Working as a Program Manager , for a leading consumer financial services company
• Leading a team size of 70 people , in an onshore - offshore model, responsible for the delivery of enhancement \ maintenance for ETL operations to support the initiatives running by business functions i.e. Enterprise Operations, Marketing & Sales, Credit, Risk Management, Core (Finance, HR, IT), Enterprise Analytics
• Responsible for maintaining DWHs having information for Consumer, Commercial, Salesforce, Collections, Recovery, Operations, Offers, Token, Deposits, Risks and Reporting , which have a direct impact on client business. Many of the clients are Fortune 500 American companies
• Supported projects simultaneously in a matrix organization structure and managed offshore- onsite vendor teams, liaison closely with Business PM, IT PM, Delivery Account Lead, System Engineers, System Architectures, Build Leads and PMO Team
• Established and implemented appropriate governance and methodology for the project portfolios
• Experience in planning, forecasting, monitoring and tracking projects and expertise in Risk analysis, and Change management
• Involved in all phases of SDLC, with an emphasis on analysis, design, development, installation, configuration, deployment and performance tuning for both OLTP and OLAP systems
• Expertise in SQL database designing and development with Business Intelligence, using MS SQL Server, SSIS (Integration Services), SSAS (Analysis Services)
• Involved in resource hiring and year-end performance evaluation process
• Part of the innovation team, responsible for supporting proof of concepts over Enterprise Data Lake . Having exposure to Big Data-Hadoop ecosystem, HDFS, Map Reduce, Pig, Hive, Sqoop ,

TECHNICAL SKILLS:

Technologies: Business Intelligence, Data Warehousing, ETL, Big Data Hadoop

Development Tools: MS SQL Server, SQL Azure, SQL Server Integration Services ( SSIS )Visualization Tools: Power BI, Power View, Power Pivot

Languages: SQL, MapReduce, Pig, Hive, Sqoop

Operating systems: Windows, Linux.

Versioning Tools: Visual Studio Team Foundation ( VSTF ), Visual Studio Online ( VSO ) Team Foundation Server ( TFS ) and GIT

Project Management: MS Project Server (MSPS), MS Project Plan ( MPP ), MS Excel, Plan View, Jira, SharePoint, Team Site, Nintex Work Flows

Project Delivery: Agile (Scrum) Methodology, Water Fall Methodology, and Dev Ops Delivery Model

Functional: Financial Industry

PROFESSIONAL EXPERIENCE:

Program Manager

Confidential, Chicago, IL

• Works with Business PMs and to understand the high-level scope of upcoming projects and the DWH impact. Understand the business priority
• Allocating build leads based on the impacted DWHs, Identifying high-level efforts & onshore\offshore involvement. Generating cost estimates, collecting Purchase Orders
• Develop high-level project schedule along with build leads, based on the project priority and resource capacity. Drive the Identification of resources and task allocation in MSPS, with the help of build leads
• Completions of Project deliverables as per the schedule, and within the budget allocated. Monitoring milestone completions and actual hours burn down by the team . Monitoring project health, by maintaining and reporting Schedule Performance Index (SPI), Cost Performance Index (CPI) and KPIs. Identifying change controls, and driving it through project life cycle. Maintaining Risks and Issues and reporting to leadership as applicable
• Managing Stakeholder Communications, both internal and external. Regular portfolio status reporting, via dashboards. Handling Client Escalations
• Reviewing monthly invoice reports and resolving any financial disputes.
• As a new vendor for client, took the challenge to take transition and establish more streamlined process in place for delivering, monitoring and controlling the various aspects of project management, for a team size of 70, with this gained efficiency of 30% and have been able to deliver efforts worth of $5M in the year 2017
• Established Agile structure for one of the program, and gained client (VP) appreciations, this lead as a stepping stone for the encouragement of other programs
• Increased the CCI (Contract Controllable Income) of account by 20% in year 2018, by redefining the team org structure

Tools: /Skill: Data warehousing, Project Management, Plan View, JIRA, Excel, MSPS, SharePoint, Team site Nintex Work Flows

Project Manager/Scrum Master

Confidential, Redmond WA

• I have lead the team size of 18 resources (Onshore and Offshore), responsible for enabling and delivering Microsoft's New Product Launches into the market for end customers.
• Managed the program, which was responsible for operational delivery of weekly/monthly Microsoft product launches,
• Managed automation projects to gain efficiency, reduce the time to market and to reduce the cost involvement
• Involved in Scope acceptance, Capacity Planning, Publishing Plans, Reporting Statuses for design, development, test and deployment phases.
• Monitoring project health and handling any escalations
• Automation projects were having two weeks’ delivery, in a Scrum model.
• I was responsible for maintaining Project Backlog via Portfolio Governance meeting
• Prioritizing and reporting of approved projects via burndown charts, burn up charts, PowerPoint presentations & Power BI reports.
• Supervising Scrum Planning and Daily Scrum Meetings
• Monitoring team progresses and unblock them from any functional or technical obstacles for delivery.
• Supervising the daily scrum meetings for status updates and unblock team from any functional or technical obstacles for delivery.

Tools: VSO, VSTF, SQL, SSIS, SSAS, Power BI, Excel, PowerPoint, Scrum, MPP, SharePoint.

Project Manage

Confidential

• Responsible for “Capturing and Processing of Big Data via Hadoop 2.0 Ecosystem”, by using Hortonworks Distribution
• Used Pig Latin Commands/ Map Reduce programming to process Big Data.
• Used Hive for querying and ETL operations.
• Gained In-depth understanding of Hadoop v2.0 Ecosystem and the distributed computing principles(HDFS), have hands-on over Ambari, HBase, Linux commands and Java Core
• Have high-level knowledge of Sqoop and Flume for Data Ingestion.

Tools: Hortonworks, Ambari, Pig Latin, Hive QL, Map Reduce, HDFS, NoSQL(HBase), Sqoop, Flume, Linux Commands, Java Core, CentOS

Developer/Dev

Confidential

• Lead the team size of 15 Developers, responsible for analyzing, technical designing, developing, deploying and testing of OLTP and OLAP systems
• Extensive knowledge of T-SQL queries (DDL and DML) and expert in using stored procedures, triggers, user-defined functions, joins, sub-queries, CTE’s, temp-tables, transactions, and indexes
• Experienced in using SSIS for extracting, transforming the data using lookup, execute SQL task, fuzzy logic, sort, merge & union all transformations, and load it into OLEDB/ODBC/File destinations
• Integrated and transformed data from different data sources like Excel & Flat Files to SQL Server using OLE DB connection providers by creating various SSIS packages.
• Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union -all, merge join and checkpoints/break points in SSIS.
• Experience in testing and validating data, performance tuning by using execution plans, database engine tuning advisor, and SQL Server Profiler.
• Experience on Data Modeling-Star/Snowflake Schema design for DWH systems.
• Experience doing build, deploy and processing SSAS cubes to store data for analysis.

Tools: SQL, SSIS, SSAS, DWH, VSTF, Waterfall methodology