Senior Project Manager Resume Example Mace

SENIOR PROJECT MANAGER

Summary

Schaumburg, IL, USA

Accomplishments

Project Management IT Project Life Cycle Value Added Leadership Project Name : EIDM ZNA Base Support Domain : Insurance Customer : Zurich North America Role : Senior Project Manager Start Date : 04-01-2015 End Date : Till Now Onsite Duration : 10 Months Skill : Project Management Team Size : 33 Project Description.

Experience

Senior Project Manager, 01/2017Mace

16 of experience in IT service industry, which includes service delivery, project management, customer facing roles and developing people.
Eight Years of Insurance Domain experience, primarily in DW/BI projects & programs.
Two years of Program management experience in handling large programs with 30+ team size Five years of project management experience in handling small, mid and large size projects Delivered 18+ projects worth of 2500 man months of effort in last 6 years Experienced in Handling HADOOP BIG Data Projects and managed HADOOP platform and upgrades Mentoring and developing talent, including recruitment support within the Zurich team Achieved Average Customer Satisfaction Score of 4.7/5 for Projects I managed Client engagement including IT/Business, management & status reporting and dashboards Worked on multiple Proposals across ZNA, and converted the same to an active business with TCV of $10M per year Expert level knowledge in Wipro operational (CPro, PWBS, EBS & ECube) & Quality Systems Extensive consulting and solution delivery experience in Microsoft DI & BI Technologies Consulting and SME support to customer in DW/BI engagements.

Tech Lead Consultant / Onsite Coordinator & SME for ZEA

I involved in following activities.
Gathered all requirements and proposed Solution Approach Post approval for Solution, Prepared High Level design and Data model changes Provided KT to Off-shore to complete Development & testing Involved in Development, Testing and Review activities Responsible for On-site / Off-shore Co-ordination, Client & user communication Deployed all the enhancements / CRs successfully and currently owning this application Project Name: DMO Base Support Domain : Insurance Customer : Zurich North America Role : Technical Lead Skill : SQL Server DI & BI Start Date: 02-13-2010 End Date: 04-30-2010 Onshore Duration: 3 Months Team Size: 3 Project Description As part of Base Support, Wipro is responsible to manage all DMO applications running in Production.
This deals with running all daily and Monthly jobs in various applications such as ZNAW, ZEA and BOE Reports running in Zurich DMO portfolio.
It also involves fixing issues raised by users across production system.

Tech Lead Consultant / Onsite Coordinator

I involved in following activities.
Worked with DBA in managing all job execution (Daily & Monthly jobs) Played SME role for ZEA Application and being SME I took responsibility and fixed any issues with respect to ZEA application raised by user.
Provided solution for production issues and prepared design document for the same and guided offshore team to complete the development and testing activities Involved in Development, Testing and Review activities.
Responsible for On-site / Off-shore Co-ordination, Client & user communication Deployed all the enhancements / CRs successfully and currently owning this application.
Apart from ZEA also taken care of other SQL Server related applications and provided solution in various situations (ZLAPS / GCAPS, CORE jobs, etc) Developed Voyager Reports on top of SSAS cubes using BOE 3.1 environment Also involved in performance tuning of various ETLs / Jobs Project Name: SQL Server Consolidation - Phase II Domain : Insurance Customer : Zurich North America Role : Technical Lead Skill : SQL Server DI & BI Start Date: 02-09-2009 End Date: 02-10-2010 Onshore Duration: 12 Months Team Size: 10 Project Description SQL Server consolidation project Phase II is for technology upgrade as well as to achieve target level consolidation by eliminating redundant objects & process.
Technology upgrade deals with migration of all existing DTS packages into SSIS packages to achieve features of SQL Server 2005.
The process level improvement leads to organized data flow from source systems to reporting datamart through staging & atomic.
As part of this project, ZEM complaint atomic database will be created for specific set of source systems and data load from source to Atomic will happen through Informatica ETL tool in order to achieve reusability It involves,(i).
Migration / Development of SSIS packages to load data from Source To target and to process cubes(ii).
Migration of Analysis Services (SSAS) 2000 cubes which are in scope to SSAS 2005(iii).
Modifying Crystal Report to source data from new datamart(iv).
Creating reports using Voyager on top of OLAP Cubes to replace existing OLAP reports.

Tech Lead / Onsite Coordinator

I involved in following activities in my previous & current projects.
Provided Architecture and Technical Solution for this project.
Responsible for Project Execution and implementation Prepared Requirement specification, HLD & Test strategy document for this project and presented the same to client for approval.
Involved in Development, Testing and Review activities.
Responsible for On-site / Off-shore Co-ordination, UAT Support, communication Assigning work to offshore resources & Guide them to achieve the goal and review the code and documents.
Deployed all the releases of this project successfully and currently maintaining this application as SME.
SME for this application in production environment Project Name: TD WORK FLOW ANDE MAIL SUPPORT Domain : Banking Customer : Lloyds Bank TC Role : Technical Lead Skill : SQL Server DI & BI Start Date: 08-04-2008 End Date: 12-12-2008 Onshore Duration: 3 Months Team Size: 1 Project Description This Project deals with migration of Stored Procedures & SQL scripts from SQL Server 2000 environment to SQL Server 2005 environment Responsibilities I handled this project individually.
This Project had 2 Phases.
I executed Phase I of this project at Onsite and Phase II from off-shore.
Being the single person, I carried out following activities 1.
I have done requirement analysis at client place and prepared effort estimation for migration activities 2.
Prepared Various Documents such as TDD, Test Plan, Unit Test Cases and Metrics for comparison and got sign-off from the client.
3.
I have done Coding & Unit Testing of SQL scripts in both the environment to make sure the migrated SQL server 2005 scripts are providing same results as that of the existing SQL server 2000 scripts.
4.
Interaction with Client & with on-site support team on a daily basis to provide Daily status report of the entire team as well as to escalate issues & concerns (if any).
5.
On-site & off-shore Coordination by having call with my Project Manager to review estimation details & other key documents as well as to provide status report.
6.
I provided UAT Support and tested all the scripts with business user and completed implementation & Post Production Support for a week 7.
Involved in preparation of reports such as WSR, MOM, etc Project Name: DWH Strategy Domain: Banking Customer: Lloyds Bank TC Role : Technical Lead Skill : SQL Server DI & BI Start Date: 01-01-2008 End Date: 05-31-2008 Offshore Duration: 5 Months Team Size: 5 Project Description This Project deals with various data warehousing activities like Taking care of Production relates issues.
New Development & enhancement tasks related to DB.
This includes Following tasks.
1.
Creation of New Data base & DB objects.
2.
Modification of Existing DB schema 3.
Creation of new AI graphs & DTS packages, schedule the job to load data form source to Target (ETL).
4.
Bug fixing or modification of existing DTS package/SP/AI graph to meet the required result Responsibilities 1.
Doing development activities pertains to SQL Server 2000 / DTS 2.
Managing 4 Member Team & taking care of following Team management activities such as Task allocation and ensure completion of tasks as per the schedule with high quality code.
3.
On-site & off-shore Coordination by having call with onsite Tech lead on a daily basis to get tasks as well as to gather necessary details to complete the tasks.
4.
Interaction with Client & with on-site team on a daily basis to provide Daily status report of the entire team as well as to escalate issues & concerns (if any).
5.
Taking care of ECube related activities for my team and generating PDMR on a monthly basis.6.
Involved in Estimation & generating Metrics (Agile metrics for each sprint) & other reports such as WSR, MOM, etc Project Name: COAF DWH Core Domain: Banking & Finance Customer: Capital One Finance Role : Technical Lead Skill : SQL Server DI & BI Start Date: 07-02-2007 End Date: 12-31-2007 Offshore Duration: 5 Months Team Size: 6 Project Description This Project dealt with Development activities pertains to COAF Data Warehousing.
Development and enhancement activities using SQL Server 2000, DTS and AbInitio Tool.
Also doing documentation work Responsibilities Development Activities pertains to SQL Server 2000 / DTS.
Managing six member team.
It involves activities such as tasks allocation, arranging & coordinating calls with Client and with onsite team.
Taking of ECube activities.
Project Name: DM MS Access Consolidation Domain: Banking & Finance Customer: Capital One Finance Role : Technical Lead Skill : SQL Server DI & BI Start Date: 07-03-2006 End Date: 06-27-2007 Offshore Duration: 10 Months Team Size: 15 Project Description This project deals with Analysis and migration of MS Access Databases.
MS Access 97/2000 database applications will be migrated to Access 2003 as the Front End and either Access 2003 (in case of non NPI/API Data) or MS SQL Server2000 (in case of NPI/APIData) as the Back End.
Project Scope 1.
Plain MS Access 97 migration to MS Access 2003 Migration 2.
Front Migration from Access 97 to 2003 and backend to SQL Server 2000/ Oracle 3.
Migration from Access 97 to .NET/SQL Server 2000 It has two main phases which are, Analysis & Migration (It involves Design, testing and implementation) Responsibilities Following are the list of activates I performed in migration phase 1.
Calculation Effort and Estimation for migration.
2.
Co-ordination with off shore to do migration activity.
3.
Doing Integration Testing for each migrated database.
4.
Providing Final DB Scripts and tested Migrated DB for implementation 5.
Creating various documents (Design Document, Integ.
Test Plan, Test Cases & Implementation Document)Phase II to IV Role Played at off shore as Module Lead 1.
Doing Costing, Effort Estimation and preparing project schedule plan.
2.
Managing Team (It includes daily team meeting, preparing status report, etc) 3.
Co - ordination with onsite folks 4.
Allocating job to Team members and getting this done as per the schedule.
5.
Also doing documentation, Migration of Access 97 DB & Unit Testing.
6.
Documentation Review.
Tools Development I also involved in development of following tools in Access 2003 using VBA code also 1.
Complexity Tool - To identify the complexity of the Access objects 2.
Smart Query Tool - To create query dynamically for each migrated table Following tool is developed using ASP.NET, c# Front Loader tool: web based application to capture vital information about each Access DB that requires migration.
Project Name: One Source Retail Domain: Retail Telecom Customer: Verizon Data Service Role : Developer Skill : SQL Server DI & BI Start Date: 10-20-2005 End Date: 03-17-2006 Offshore Duration: 5 Months Team Size: 5 Project Description One Source system is a single window desktop system through which the BSG customer can do following (Pricing, Proposal & Ordering of new/additional products, Billing Information, 360 View of Customer details, Various Reports).
Responsibilities Production Support (Fixing Production related DB Issues, Performance Tuning), Writing Stored Procedures and Triggers for different business rules in our application.
creating DTS Packages using T-SQL Statements and ActiveX Scripts for Transferring data from one system to other.
Designing the Database Objects and Maintaining Quality Standards.
Planning and Maintaining DB Backups using Scheduled Jobs.
Project Name: New Mexico Retirement System Domain: Government Customer: US Government Role : Developer Skill : SQL Server DI & BI Start Date: 05-24-2004 End Date: 10-14-2005 Offshore Duration: 16 Months Team Size: 15 Project Description Public Employees Retirement Association (PERA) is a New Mexico & Oregon State Government agency.
It is a retirement system.
Over 600 state and local government agencies provide pension benefits to their employees through PERA.
There are five major funds governed by PERA, like Legislative, Magistrate, Volunteer Firefighters, education and public.
Each fund has its own list of plans (call it as division) Each plan has unique retirement functionality, like pension factor and maximum pension limits.
This retirement system divided into two phases of implementations, like membership implementation and another one is benefit implementation.
Responsibilities My Role as Senior Developer Creating DTS Packages using T-SQL Statements and ActiveX Scripts for Data conversion.
Designing the Database Objects and Maintaining Quality Standards.
Writing Stored Procedures and Triggers for different business rules in our application.
Backing up and restoring Databases Creating the Login and restricting the permissions to them.
Maintaining the Security of the Database and giving permission to the Users on demand.
Planning and Maintaining Database Backups using Scheduled Jobs.
Project Name: Invoicing System Domain: Manufacturing Customer: TVS Role : Developer Skill : SQL Server DI & BI Start Date: 08-01-2003 End Date: 05-20-2004 Offshore Duration: 10 Months Team Size: 5 Project Description It automates the process of invoicing and its related areas.
The system is to maintain Invoices and finished goods.
It consist of Finished Goods Inward entry, Forwarding Note, Packing Slip Invoice Generation, Modvat Accounting, MIS Reports are the modules in Invoice System.
Responsibilities Creating DTS Packages using T-SQL Statements and ActiveX Scripts for Data conversion.
Designing the Database Objects and Maintaining Quality Standards.
Writing Stored Procedures and in Sybase & SQL Server for Data migration from Sybase to SQL Server Backing up and restoring Databases Maintaining the Security of the Database and giving permission to the Users on demand.
Planning and Maintaining Database Backups using Scheduled Jobs.
Project Name: Sales Order System Domain: Manufacturing Customer: TVS Role : Developer Skill : SQL Server DI & BI Start Date: 03-01-2003 End Date: 07-30-2003 Offshore Duration: 5 Months Team Size: 3 Project Description The Objective is to maintain the orders and part numbers.
Order entry Module, Maintenance of Part Master, Customer Master, etc., Daily Transfer of orders to various plants is the modules involved in Sales Order System.
Responsibilities Actually this is a Migration Project from C/Sybase to VB.NET/ SQL Server.
It Involves 1.Application Development in VB.NET2.Data Migration of from Sybase to SQL Server (To Move All Production Data) & vice Versa to maintain data consistency in both the database servers (Sybase & SQL Server) Project Name: Public Deposit system Domain: Manufacturing Customer: TVS Role : Developer Skill : SQL Server DI & BI Start Date: 10-01-2002 End Date: 02-28-2003 Offshore Duration: 5 Months Team Size: 3 Project Description The Objective is to maintain the company's deposit holders.
Deposit system provides General Receipts / Payment Processing, Deposit Receipt entry and generation, renewal and repayment, pre-closure of deposits, Maintenance Deposit Account Master Module, Warrant Processing, MIS Reports etc Responsibilities Database Design after initial study Creation of Tables, Rules, Defaults, Triggers and Stored procedures at Back-end Develoop Front End Application using Power builder.

Education

Master Of Computer application (M.C.A):2000

Bachelor Of Science:ChemistryChemistry

B.Sc:1997

Skills

.NET, VB.NET, VB.NET2, ASP.NET, Accounting, ActiveX, Agile, API, Application Development, Approach, AI,agency, Banking, benefits, BIG Data, Billing, BI, Business Objects, C, Consulting, Costing, Crystal Report, Client, Customer Satisfaction, Data conversion, Data Management, Data Migration, DTS, Data warehouse, database applications, DBA, Databases, Data base, Database, Database Design, Data Warehousing, delivery, Designing, Documentation, ETL, features, Finance, funds, Government, graphs, DB2, Informatica, Insurance, Invoicing, local government, Managing, Managing 4, Mentoring, Access, MS Access, MS Access 97, Access 97, c#, MAIL, MOM, SQL Server 2000, window, 2000, 3.1, Migration, MIS, OLAP, Oracle, DB, developer, Order entry, Payment Processing, Power builder, Pricing, Program management, Coding, project management, Proposals, Proposal, Quality, recruitment, reporting, Requirement, Retail, Sales, SAP, SAS, servers, Scripts, specification, MS SQL Server, SQL, SQL Server, Strategy, Sybase & SQL Server, Sybase, Tables, Team management, Telecom, T-SQL, unique, upgrades, upgrade, View, VBA

Resume Overview

Job Titles Held:

Senior Project Manager
Tech Lead Consultant / Onsite Coordinator & SME for ZEA
Tech Lead Consultant / Onsite Coordinator
Tech Lead / Onsite Coordinator

Degrees

Master Of Computer application (M.C.A) : 2000
Bachelor Of Science : Chemistry
B.Sc : 1997

Senior Project Manager Resume Example

DISCLAIMER

How this resume score could be improved?

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes