SUMMARY:

• Highly skilled Senior Project Management Consultant with more than 8 years of experience as Project Management /Agile Scrum Master and 18 years of experience in Information Technology.Managed large, strategic and technologically demanding projects/programs for various clients including Banking, Oil, Retail and Healthcare domains. Project Management experience in Data warehouse projects
• Provided leadership, direction and oversight for multi - million dollar global application technology projects involving multiple technologies, leading cross functional teams and geographically distributed teams of up to 70 resources.
• Utilized both Agile and Waterfall project methodology based on PMBOK, utilizing MS Project Server, JIRA, Clarity, MS TFS and SharePoint tools.
• Senior IT Project Manager for Fortune 500 P&C insurance client.
• Program Manager for one of the largest retail client.
• Expert, hands-on, end-to-end project manager with proven results in all aspects of strategic project management and delivery in matrixed, projected and hybrid structures.
• Expert in project initiation, feasibility & planning, scope and schedule management, cost estimation and budget management, risks & issues management, resource, quality and communication management, release and rollout planning etc. for smaller to very large initiatives.
• Proven expertise in stakeholder relationship building & management . Highly capable in handling the entire delivery and client engagement responsibilities by collaborating with Business, IT stakeholders and other vendors.
• Seasoned professional with excellent verbal and written communication skills, strong interpersonal skills.
• Strong analytical and problem solving skills with a prior background in requirements management, technical design, development and testing of applications involving different technologies and tools.
• Both authored and responded to detailed and complicated Requests for Proposals (RFP)

TECHNICAL SKILLS:

Project Management Skills: PMBOK, SDLC methodologies and practices, Project/Program/Release Planning, Scope/Schedule/Cost management, Resource/stakeholder relationship and management, Change and Communications management, Risk and Issue management, Deployment/rollout planning and best practices etc, Agile Scrum Methodology and practices, Agile tools, Project/sprint metrics, status reporting, escalations, vendor management etc.

Tools: MS-Project, Clarity, Workbench, Rally, Jira, Share Point, MS Office, TFS,TWS, WINSQL, HTML, Excel, Word, HP Service Desk for Configuration Management, Quality Center, QTP, Test DirectorTechnology: Sybase, MS SQL Server (Expert), Oracle (Trained skills), DB2,Oracle Application Server, Oracle Fusion middleware, Oracle SOA suite, Oracle OSB oracle Portal, Forms, Reports and Discoverer. Oracle WebLogic server, JDeveloper, Apache, Tomcat

Data Modeling/ ETL BI tools: Informatica Power Center, Business Objects, Ascential Data Stage, Cognos, Dimensional Data modeling, Star Join Schema/Snowflake modeling, & logical data modeling, ERWIN 3.5.2, MS Visio

Operating System: IBM AIX, UNIX Sun Solaris, MVS/ESA, Z/OS on IBM-Mainframes, Windows, IBM PC and compatibles.

PROFESSIONAL EXPERIENCE:

Confidential

Program Manager

Responsibilities:

• Developed a project roadmap (project plan, scope & schedule baseline and communication plan).
• Supported as Program Manager and managed 3 projects in Workforce Management Program in agile framework.
• Facilitated Scrum Ceremonies like Sprint Planning, Daily Standup’s, Sprint Reviews and Sprint Retro’s.
• Responsible for initiation of the projects under the program.
• Responsible for projects pre kickoff and kickoff
• Worked closely with the business and products team to understand their requirements.
• Responsible for Build vs. Buy analysis of the projects.
• Work with third party vendors to procure scanners and monitors required for some of the projects under the program.
• Responsible for helping the scrum teams in resolving the impediments in the project
• Responsible for status reporting and communication to all stakeholders
• Involved in preparing the Project Charter, Statement of Work, and Functional and Business requirements.
• Proactively managed Issues and risks.
• Provided overall direction to the formulation, development, implementation, and delivery of a project.
• Ensured that the project plan maintains tasks, schedules, estimates, and status, and disseminates information to team members and customers.

Confidential

Sr. Technical Project Manager/Sr. Scrum Master

Responsibilities:

• Developed a project roadmap (project plan, scope & schedule baseline and communication plan).
• Supported as Project Manager and Scrum Master for clients Toshiba and Sally Beauty
• Facilitated Scrum Ceremonies like Sprint Planning, Daily Standup’s, Sprint Reviews and Sprint Retro’s
• Worked closely with Product owner’s to refine Product Backlog and Sprint Backlogs
• Responsible for tracking metrics of the project like Product Backlog and Burndown’s
• Responsible for helping the scrum teams in resolving the impediments in the project
• Responsible for status reporting and communication to all stakeholders
• Involved in preparing the Project Charter, Statement of Work, and Functional and Business requirements.
• Proactively managed Issues and risks.
• Provided overall direction to the formulation, development, implementation, and delivery of a project.
• Ensured that the project plan maintains tasks, schedules, estimates, and status, and disseminates information to team members and customers.
• Developed plans for system documentation and disaster recovery planning for Oracle Fusion Middleware components.
• Directed corrective actions where performance falls below objectives.
• Application Business and Portfolio Analysis, formulation of knowledge transfer plan, quality checkpoints, due diligence, scheduling, monitoring & controlling IT services in the construction with the end users and off shore delivery team
• Interacted with business users to get technical requirements and clarifications for offsite team
• Developed staffing model based on IBM Domain and industry verticals which will clearly define the number of resources required to support the application, the on call and 24x7 support requirements and logistics. Complete resource requests with Global Resource Deployment System process and co-ordinate with Global Resource fulfillment team for staffing
• Initiated/helped/reviewed/completed the delivery and sign off of transition documents
• Assisted in the planning, design and roll-out of network and infrastructure setup
• Worked on CICS application server
• Both authored and responded to detailed and complicated Requests for Proposals (RFP)

Environment: MS Office Suite, MS Project, Visio, Excel, PowerPoint, BMC Remedy, Rally, PVCS, Team Foundation Server (TFS), SharePoint, HP PPM, CICS, Mainframe, DB2,SQL Server, Oracle

Confidential

Sr. IT Project Manager/Scrum Master

Responsibilities:

• Worked as project manager managing multiple DWH (BI DW) projects (2 large projects at a time) in Waterfall model end to end from gathering requirements, performing analysis required for total effort estimation for the project.
• Produce project reports and engage with senior management to provide updates, visibility and tracking.
• Working experience in both Water and Agile methodologies.
• Knowledge on Healthcare business process
• Over 1.5 years' Scrum Master experience I was Agile Project Manager for United Healthcare’s most rewarded Athena Program .Athena Program is a vision of United leadership and in spite of many vendors unable to progress with the project our team did the detailed scoping and kicked off the project from scratch, this project mines customer information for more targeted and personalized digital marketing, such as email messages. Athena helps in making recommendations based on browsing history, location and demographics. It helped in creating deals for targeted customers for specific occasions like Customer's life events and registry, and new movers.
• Facilitated Scrum Ceremonies like Sprint Planning, Daily Standup’s, Sprint Reviews and Sprint Retro’s
• Worked closely with Product owner’s to refine Product Backlog and Sprint Backlogs
• Responsible for tracking metrics of the project like Product Backlog and Burndown’s
• Responsible for helping the scrum teams in resolving the impediments in the project
• Worked in bringing together multiple teams like PDW hardware box deployment team, Support teams, PDW DBAs, Software development team, migration teams.
• Coordinated Release management and deployment management activities and guided the team to take proper decisions in case of any bottlenecks.
• Involved and contributed in creating the Project Charter and WBS
• Working knowledge of Rally software.
• Perform day-to-day monitoring of Project Scope, resources, timelines, critical path, issues and status reporting.
• Consistently report on project status/ metrics to top management using Weekly Status Reporting, Monthly Reviews.
• Maintained project financials and tracked it within budget. • Validated cost and effort burnt on project every week, invoicing month end financials to business.
• Earned Client's trust and provided them transparency with Value additions that was useful for closely tracking the Project.
• Closely worked with Business Users for Acceptance Phases.
• Project Manager on a large Migration project with critical delivery timeline - EDW (Teradata) to PDW (Microsoft). Tracking the Reporting Track delivering re-build of 200+ reports from ETL/ BI solution to a new platform - Parallel Data Warehouse (PDW), Microsoft SSIS, SSAS, SSRS.
• Utilized MS Project as the tool of choice for Project Scheduling, Resource Allocation, Budget Reporting, Earned Value Analysis and Management, Task Assignment/Milestones management.
• Other responsibilities include project monitoring and reporting, change control, PMO Governance, revenue and cost budgets forecasting, vendor management, team mentoring and project administration.

Environment: s: MS Office Suite, MS Project, Visio, Excel, PowerPoint, BMC Remedy, Rally, PVCS, Team Foundation Server (TFS), SharePoint, HP PPM

Confidential

BI Solution Architect, ETL Architect

Responsibilities:

• Responsible for leading, designing and creating data marts for Billing, Members, Provider, Claims, Real-time Quote Analysis, Forecasting Analytics
• Responsible for requirements gathering, business client interviews, data analysis and data profiling
• Translated business rules document into Fact Qualifier, Lineage document, conceptual and logical designs of Staging, EDW, ODS and Data marts
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Defined and documented architectural patterns including data acquisition and data delivery patterns and communicated them to various groups in the organization
• Architected and designed multiple projects with dimensional modeling techniques like star/snowflake schemas, FACTs & Dimensions tables by using Kimball/Inman methodologies.
• Created DATA Architecture Documents and ETL Architectures for major enterprise integration projects in the BI environment.
• Created reporting solutions with Business Objects
• Designed and Developed solutions for sending data to various third party vendors
• Provided various data architecture solutions with conceptual models and source to target data flows.
• Worked on various projects to create data extracts for State and Finance reporting
• Extensively worked on Performance tuning of mappings, sessions and workflows using database optimization techniques, parallelization, temp tables, shared caches, session partitioning and various memory settings in Informatica

Environment: Informatica Power Center, Business Objects), Ascential Data Stage, Cognos

Confidential

Database Administrator Sybase/SQL Server

Responsibilities:

• Install/upgrade of SQL servers on Standalone and Clusters 32/64 bit, SQL Server 2005/2008/2012/2014 installed on Clusters 32/64bit 2 node clusters. Applying SQL Server Service packs, Hot fixes (Cumulative updates) on production/DR/QA servers
• Involved in initial stage of reviewing Architectural Diagram, Database Design and Storage allocation layout for new database server.
• Installed SQL 2012/2014 in Azure and implemented BLOB storage Backups and Restores in cloud.
• Created SLA’s and SOP’s for support teams after executing the projects.
• Involved in POC’s to implement various products.
• Design and Implement Database Schema and Exported data to SQL Azure from On-Premises.
• Upgraded SQL Server 2000 to SQL Server 2005/2008 and SQL server 2005 to SQL Server 2008 on Production/DR/QA Servers.

Environment: SQL Server 2000/20 /2014, Sybase 11/14, MS Access, Windows 2003/2008/2012, ASP.Net, Java, C#.Net, ADO.Net, VB Script, IIS 6, SSRS, SSAS, SSIS, NetBackup, Magic, Team Track, ER Studio, SharePoint 2007 and 2010.

Confidential

SQL Database administrator

Responsibilities:

• Installed SQL Server 2000/2005/2008 on Windows 2003/2008 advanced servers, applied services packs and security fixes.
• Migrated 10 servers from SQL Server 2000 to SQL Server 2005 without any issues.
• Extensively used VB Script and T-SQL to create databases and objects through batch files.
• Implemented 6 projects in a span of 18 months and supporting 4 new projects. Some of the products provided by Microsoft.
• Extensively worked on SharePoint projects and applications having Terra bytes of databases
• Supported 14 applications as a Primary DBA.
• Primary DBA for Client Critical business applications.
• Implemented Log shipping, Mirroring and Replication and supported them.
• Extensively worked on SQL and Windows Clustering.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server 2000/2005/2008, MS Access, Windows 2003/2008, ASP.Net, Java, C#.Net, ADO.Net, VB Script, SharePoint MOSS 2007, IIS 6, SSRS, SSAS, MOM, SCOM, SCCM, TDP, TSM, HP Service Desk, HP Service Manager, ER Studio, WSDB, Lotus Notes, Active Directory

Confidential

SQL Developer/Database Developer

Responsibilities:

• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Involved in creation of Stored Procedures, Functions and DTS Packages, enforced database triggers for auditing.
• Migrated old data from legacy system into SQL Server 7.0.
• Spotlight Tool for Discover, diagnose and resolve SQL Server performance Issues. (Replication, storage health, blocks, disk activity).
• Filtered bad data from legacy system using complex T- SQL statements, and implemented various constraint and triggers for data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Wrote complex stored procedures to process, record and balanced the processing load between front end and back end.

Environment: SQL Server 7, MS Access, Windows 2000, ASP.Net, C#.Net, ADO.Net, XML, XSL, XML Web services, JavaScript, ERWIN, CSS, IIS 6, SQL Reporting Services