Internal - General Use

SUBRAMANIAN B - Senior Project Manager

(M) 469-***-****

Email: adxcjz@r.postjobfree.com

PROFESSIONAL SUMMARY

Dynamic, versatile, hands-on Program Manager with experience leading and delivering AI and business intelligence projects with expertise in Power BI Desktop, Power Bi Service, Power query, DAX, SQL Server an Azure data services and have successfully managed large data and complex data sets like Big data and adept in ETL to extract data from various sources to develop custom visuals as per the Business needs to implement the project to meet the business and IT objectives and deliver rapid results. 18 years of experience across IT, Infra, SCM, Vendor Management projects to build a sustainable platform for clients across Oil and Gas, Airlines, Banking, Retail, Healthcare, Insurance, Banking Domain. Having Expertise in Re-Engineering projects and has a reputation of turning around projects to Green.As an accomplished Program Manager with a strong background in leading cross-functional teams and managing complex projects, I offer a wealth of experience in driving successful program outcomes. My expertise includes strategic planning, resource allocation, risk management, and stakeholder engagement. I am a strategic thinker and proactive problem solver who can identify project risks and make strategic decisions to deliver project on time. Throughout my career, I have demonstrated my ability to adapt to new technologies and work in a fast-paced environment, managing multiple projects concurrently while delivering high-quality results. I am a collaborative leader who fosters a culture of teamwork and inspires team members to achieve excellence. Delivered 10Mn month on month Savings for Healthcare client using Six Sigma expertise to extend the budget to accommodate additional IT projects.

AREAS OF PROFICIENCY

Project Management •Business Intelligence•IT Management • Strategic Planning • Contract Negotiation& Management• Financial Analysis • Infrastructure/Service Delivery •Analytics and Reporting • Business Development • Budgeting/ P&L Management •Cloud Data Warehouse• Cost Analysis • Forecasting •Azure and Snowflake cloud •Revenue and Operating Income Improvement •Vendor Management • Process Implementation •Governance/Compliance • Market Research •Change Management • Scrum Master • MicrosoftOffice Suite •Cloud Data Migration• ITIL •MicrosoftProjects •Confluence • SharePoint •Agile • Azure DevOps • Jira PROFESSIONAL EXPERIENCE

Wipro, LTD.

Senior Project ManagerData Engineering Cloud and Reporting April 2022 – Present

Manager Cloud Data migration of Legacy systems to new Cloud based architecture.

Managed MC App Support team during the Medicare season through RTS and managing and processing agent information.

Managed the Development and Support project across MDM, EDW, Medicare, RTS, Sunfire, Connecture and Power BI pipelines and daily report including SSAS Model refresh.

Planning, Forecasting and Budgeting projects from inception to completion.

Established best practices and standards to setup anoperationvertical for the client to streamline the DevOps across the organization using agile methodology.

Created Cloud Infrastructure for Processing Big Data and CI/CD Pipelines to optimize the Development activity.

Create project plans and WBS using Gantt charts for implementation projects that track the project to completion using JIRA.

Conduct Daily sprints and scrum meetings and monitor and assign tasks to the developers and engineers based on criticality and severity and track status of sprint using burn down charts and report to the leadership team on weekly basis and conduct Demo sessions to showcase sprint achievements and learnings post the sprint cycle.

Created weekly and monthly Reports including business critical Reports and Dashboard for Reporting,Functional validations and Audits. Real time dashboard with geography,products, agent hierarchy, Consumer policy information, Switchers, Revenue, Commissions etc.

Data Profiling and Data Collection using ADF pipelines, Talend, stitch and Airflow using legacy and migrated database tables to consolidate the data in a single data warehouse. Internal - General Use

Performing Data Transformation and modeling and data correction including mapping and standardizing data sets by slicing and dicing of data and formulated DAX Expressions to create Date to yearly columns and implemented partitions in Tabular Models for Power BI and developing SQL stored procedures, views, and adding/changing tables for data load and transformation, and data extraction.

Created dimensions and measures, calculated columns, and performed time series analysis using DAX in Power BI and Creating SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Analyzing the data using Statistical features to develop trend analysis and published the Dashboard reports and Build data blending, filters, actions, and hierarchies feature in Power BI dimension and BRD to meet client requirements.

Performing unit and system testing including User acceptance testing, troubleshooting and bug fixing in development and UAT environments before deployment.

Define report layout in SSRS based on the Business and stakeholder needs and create complex stored procedures for reporting services and Analysis reports using different chart types and drill down reports.

Team Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services

(SSIS) and managing the ETL packages by the Support teams.

Developed and maintained SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.

Manage AD access and create groups, roles, users and assigning access privileges to users.

Manage Server Performance and tune the Logic Aps to maintain scalability and to improve the performance.

Managed Azure Cloud Server through Dashboards to track server/container utilization, capacity, and downtime.

Manage offshore to deliver key components for projects, initiate change management through CR using JIRA and GitHub.

Created Realtime Dashboards and Monitors for tracking and monitoring the Pipeline and jobs to ensure no disruption to the Data Warehouse and Business Stakeholders.

Create Burndown charts to track Project status on a weekly basis and drive agile projects including overseeing budget and productivity.

Weekly and Monthly Dashboard Reports to track server performance and dependencies.

Worked closely with the external and internal Business stakeholder to ensure Business can sell policies on time with the Consumers.

Awarded for Inspiring performance and mentoring the team towards to deliver with exceptional results.

Drive Monthly optimization programs and coordinate with multiple stakeholders to drive productivity. Project/Delivery Manager - TCS

May 2014 – Jan 2017

Managed Knowledge Transfer from Mainframe to Siebel including setting up infrastructure for Managing Global delivery and taken over Support and Operations BAU.

Coordinate with Business Stakeholder and product Owners daily to gather business requirements and create a BRD to and coordinate with Scrum master and product owners using JIRA to create story point and estimate.

Migration of Big data from Legacy systems to CRM and installation of MS SQL enterprise servers on test and development boxes

Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services SSIS including migration of DTA objects to SQL SSIS SQL Server Integrated Services.

Created ETL process using SSIS to transfer data from heterogeneous data sources.

Designed and Created databases, tables, views, stored procedures, and triggers.

Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data and normalized tables and write Stored procedures and refine queries to transform and standardize data.

Created Parameterized, Cascaded, Drill-down, Crosstab and Drill-through Reports using SSRS 2005.

Created usage-based aggregations in cube to minimize time for query retrieval from client tool Target. Internal - General Use

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Established Joins and created Clustered/Non-clustered Indexes wherever necessary.

Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers and tune the SQL queries using SQL Profiler.

Extensive use of Stored Procedures by creating new stored procedures and modifying existing ones.

Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Plan and Schedule the project into various phases and oversee QA testing process along different phases of the project. using industry best practices while maintaining compliance according to FEMA policies.

Managed workstreams with timelines and deliverables with quality control and managed customer escalations and ensuring Project is compliant as per the iQMS guidelines QCP, QBR, CMatrix, FMEA, Trigger,PMR, PMF,ePMO, eSIPOC,

Managing multiple projects including 24X7 Call Field Support team and asset management team.

Adept in Process Management (PMO) and process reengineering projects.

Managed level 2 and 3 support, worked with subject matter experts, Business Unit stakeholders, developers to assign any tickets issues that arose during the term of the SOW.

Oversaw the development, testing, and move into production of deliverables through DevOps.

Strategic planning and implementation of new lines of business and Developed concept and business model through forecasting and Planning during the acquisition of new vendors (customers).

Managed and setup Global Operations and Delivery Center including hiring and application setup.

Managing healthcare assets, accountable for renewing and swapping of assets including Software updates and Calibration.

Disposition of medical assets including radioactive equipment’s as per the FDA rules. Project Manager - Genpact

Sept 2011–Aug 2013

Create and manage all global and regional changes to client contract/SOW.

Managed offshore team in Report migration project.

Followed agile methodology and coordinated daily scrum meetings.

Responsible for Product Releases and support calls.

Work closely with management and end-users to create and evaluate business requirements.

Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.

Used different Control Flow Tasks and Dataflow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks.

Experience in Error handling and debugging coding issues and troubleshoot production problems.

Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.

Experience in writing custom code expressions in SSRS.

Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level

Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.

Created Report Models for Business Users to create their own reports and designed created OLAP Cubes with Star schema using SSAS 2008 R2.

Monitoring nightly ETL process from various highly different source systems (SQL 2005 and 2008 R2 databases )and SSIS Processes. Sources included SQL based databases and Excel Files while ensuring that nightly backup jobs or cube processing or other ETL jobs didn't interfere with each other.

Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids and in deploying the changes to QA, Staging and Prod environments.

Developed Strategy for Global Platform for SCM, Infra and Create regional and global high level and low-level project plans.

Developed Procurement, Sourcing Platforms for Oil and Gas client and Strategy formation for Contract/Vendor negotiation. Internal - General Use

Technology contracting for a top 3 Oil and Gas client including Negotiate Master Service Agreements.

Draft and negotiate Amendments, Changed Orders, Statements of Work, Software Schedules, manage vendor relationships.

Work with service providers to obtain the most favorable pricing, terms, and conditions.

Coordinate with our legal and the various supplier’s legal teams to resolve problems with impending and existing contracts. Business need, legal implication, and financial analysis of all contracts and IT contract portfolio optimization.

Use Ariba Contract Management Software and Strong working knowledge of HIPPA and PHI compliance.

Obtain all the necessary documents to negotiate and execute contracts.

Interface directly with several client stakeholders at mid to high level Technical Lead – Infosys

Nov 2010–Aug 2011

Leading a Team for Procurement Related Operations & doing Spend Analysis of the client Data (AP&PCard ) and identifying the Procurement areas for the US client.

Analyzing Spend of the Client data and Providing Saving & Sourcing solutions to minimize their Corporate Spend.

Starts with Transition of the Process (Due Diligence), Training the Team on the process & Implementation which includes Data Audit, Project Planning, Staging, Enrichment, Execution, Delivery, and Analytics Reports.

Specialized in QA for Enrichment process, Taxonomy and Spend Consulting using Custom Taxonomy.

Creating BI reports like top Spend Vendor, Business Units, Commodity etc. Creation of Item and Vendor Master.

Understanding the client PeopleSoft system and integrating it with the internal process.

Lead several IT infrastructure projects from conception to completion for a media client.

Managed client requirements and work with the team to manage project milestones and objectives. AI Project Lead - IBM

Feb 2009 – Oct 2010

Consultant for Spend Analysis Implementation Projects including Analyzing Spend of the Client data and Providing Saving & Sourcing solutions to minimize their Corporate Spend.

Using ETL techniques to extract transactional data including Sales data, Master data and transactional data and consolidating all data using data mapping techniques on SQL servers.

Slicing and dicing the data using data Analytics techniques and creating various Slice Item, Vendor Customer tables by indexing, and using Star Schema Model to create Spend Analysis tool for client to Analyze their Company Spend.

Data Audit, Project Planning, Staging, Enrichment, Execution, Delivery, and Analytics Reports. Specialized in QA for Enrichment process, Taxonomy and Spend Consulting using taxonomies like UNSPSC.

Creating BI reports like top Spend Vendor, Cost Center, Commodity etc. Creation of Item and Vendor Master.

The SA Software specializes in Slice and Dice of the data, Online Feedbacks and Reports Creation for various Spend and

Sourcing Reporting. Staging activities include RDBMS activities along with ETL Start Schema structuring. Using in built tools for Staging Activities.

Spend and Sourcing: Cost reduction, Spend Visibility, Savings Opportunities, Improved customer service & quality, Scalability, Standardization, New market exposure. Materials Consultant- Zycus

Sept 2007–Feb 2009

Working in Zynapse, a division of Zycus, provides Master Data Management (MDM) solutions for ERP projects to offer.

end-to-end automated ERP MDM solutions.

End-to-end automated processes to Harmonize & Enrich Historical Master Data withDomain Expertise Consulting Solutions on Creating Specsheets, UNSPSC, eClass, NATO, EOTD and other Custom taxonomies.

Cataloging of the data for Enrichment and providing migration solutions using ETL

Migrating client legacy data from their old ERP systems using ETL tools and techniques, staging data enrichment with UNSPC and other standard policies and procedures.

Internal - General Use

Data Engineer – DTIPL

Feb 2005 to Aug 2007

Creating dimensions and measures for various attributes and combined master dimensions using Star schema model and master data with unique ids.

Data cleansing and modelling by consolidating understanding Data and their domains and Business Unit and Creating specification sheets for the ERP systems for Items and Services including millions of data and using AI tools and techniques to classify and organize the data.

Software’s used: Auto Class, Auto Spec, Integrity, Spend Analyzer.

Utilized ServiceNow Change Management to facilitate the migration of several legacy IT functions to new platforms.

Set Key Performance Indicators based on account improvement goals to facilitate and monitor success.

Communicating account performance milestones to senior and regional leadership.

Developed written communications and user guides for new software applications and internal processes. EDUCATION

Mumbai University, Mumbai, India

Bachelor of Technology December 2004

SKILLS AND TRAINING

Applications used JIRA, Azure, ADF, Snowflake, SQL, Talend, Stitch, Confluence, Reltio, Sharepoint, Siebel CRM, Connectors, Airflow, SnowSQL, Ariba, Zynapse, AutoSpec, Peoplesoft, Power BI, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, Linked Services.

Databases MS SQL, Azure SQL, MS Access, Mondo db, Excel files, Sharepoint, Azure Blob, Snowflake Cloud db, Zoho, SalesForce, Quickbooks, DB2. Environment Power BI, DAX, Power BI gateway, Power Query, Azure SQL, Snowflake Cloud, SSAS, SSRS., Windows 8/10, UAT, DEV, SIT

Trainings and

Certifications

Six Sigma Certified, Snowflake, Azure, Project Management and Delivery Management

Contact this candidate