SUMMARY

• Around 14 years of IT experience in Finance (Banking, Credit Cards & Insurance) and Resources (Oil & Gas, Utilities - Smart Grid & Chemicals) in leading, designing, developing, testing and maintaining large-scale mission-critical software projects.
• Around 8 years of onshore experience (US & Canada).
• Around 8 years of strong Project Management with business analysis experience. Have worked as Delivery Lead, Integration Lead, Test Lead, Onshore-Offshore Coordinator, System Analyst & Data Analyst in other projects.
• Extensive experience in communicating with client/business customer & onsite-offshore resource model.
• Proven track record of designing and implementing flexible solutions which support frequent functionality changes.
• Expertise in delivering software solutions by following the organization’s Delivery Methodology with micro-management of time, cost, risk, scope, resources and quality.
• Thorough knowledge/expertise in creating project management plans, creating and tracking project schedule, reviewing solution architecture, status reporting, EVMs and providing solution cost.
• Experience using SQL, SQL Server, T-SQL, TOAD, Oracle, Stored Procedures, Excel Formulas & VBA (Macro coding), Pivots (including Power Pivots), SSIS and SSRS.
• Aggressive in issue tracking, task tracking, action item tracking with traceability to WBS tasks.
• Experience with MS SharePoint 2010, 2007 & 2003 for centralizing process management, and for content & document management. Also have basic knowledge of SharePoint architecture.
• Experience with MS Project Server 2010 and 2007 in creating and managing project schedules, timelines, resolving resource conflicts, setting up baselines and publishing project, configuring critical path, network diagrams & calculating earned value metrics.
• Strong experience in SDLC and STLC.
• Experience in Waterfall and Agile/Scrum Methodology.
• Experience in Project Delivery Methodology (PDM) & Organization’s Delivery Methodology (ADM).
• L1 & L2 certified in all domains.
• Experience in Service Management, Service Operation, CSI, Service Transition, Event Management, Incident Management, Problem Management, Service Desk & Change Management.
• Actively pursuing PMP and follow PMI guidelines for managing projects.
• Recipient of multiple performance awards and client recognitions for contributions outside normal responsibilities, exceeding project’s expectations and winning client’s confidence.
• Experience in multiple domains:
• Finance (Banking, Credit Cards & Insurance) - 8+ yrs
• Resources (Oil & Gas, Utilities - Smart Grid & Chemicals) - 5+ Yrs
• Winner of White Paper presentation on Insurance domain (1st prize).

TECHNICAL SKILLS

Project Management / Business Analysis / System Analysis: MS Project (2010, 2007, 2003), SharePoint (2013, 2010, 2007, 2003), IBM Lotus Notes, Clarity, Organization’s Delivery Methodology (ADM), Project Delivery Method (PDM), Waterfall and Agile/Scrum Methodology, Excel-VBA (Macros), Pivots, PowerPivots, Access, SQL, SQL Server, T-SQL, SSIS, SSRS, PI Database, TOAD, Oracle, IBM ClearCase, MS Office, Office 365, Visio, ASP.net., SVN, TFS.

Integration Architecture: Oracle Fusion Middleware, BPEL, OSB, SOA, EAI, EDI (EDIFACT, X12), CIM, AIA, SOAPUI, PIP, WSDL, JMS, FTP, XML, Web Services, CC&B-MDM Integration, JDeveloper, Weblogic, AMTrix, HARBINGER.

Mainframes: COBOL, JCL, VSAM, CICS, SQL, IBM DB2, FILE-AID, XPEDITOR, REXX, EASYTRIEVE, CHANGEMAN, INFOMAN, Control-M Scheduler, INSYNC, Jobtrac, ZEKE, SPE, SPUFI, ISPF, MQ, Strobe.

Test Tools: HP Quality Center, Rational Quality Manager.

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, TEXAS

Project Manager / Business Analyst

Responsibilities:

• Migration Project Manager / Business Analyst in migration from MOSS to SharePoint 2010.
• Partner with Business Owner in re-organizing the functional model of the BP OMS Navigator at organization level.
• Created the migration plan and managed the day to day execution of the plan. Responsible for user interaction, strategies for user review, data mapping and monitoring data changes.
• Gathered requirements through customer interface, drafted documents defining scope and priority, developed high level project plans using MS Project.
• Prepared test cases for unit testing, system testing, user acceptance testing and verified test logs.
• Prepared business documents defining the project requirements and functional scope for the developers.
• Worked on database diagrams, database objects, schemas and implemented normalization rules.
• Worked on SSIS packages to support the development team while writing migration scripts.
• Assure the integrity of project data and process, including data extraction, manipulation, processing, query optimization, analysis and reporting
• Develop SQL queries to process data extracts from a variety of support systems and data tables.
• Implement and maintain daily, weekly and monthly LOB and Executive level reporting that enable data driven business decisions. Used SSRS for preparing business reports.
• Prepare as needed data-sets and presentations for senior management
• Analyze data, interpret results and convey findings in a concise and professional manner
• Worked in a multi-vendor environment and coordinated with teams across multiple geographies.
• Managed a team of 12 members (onshore, offshore), provided technical support and tracked deliverables.
• Risk/Issue/Escalation/Quality Management.
• Consolidating reports from offshore leads and stakeholder reporting.
• Created documentation for training the end users.

Confidential

Service Design & Transition Manager

Responsibilities:

• Responsible for overall Service Design & Transition Management for 80+ projects.
• Forming and leading the PTAD team - Project Transition & Assured Delivery - to serve as the main interface between Application/Infrastructure projects and Upstream IT Application Support.
• Delivered tools for governance of the transition activities from kick-off to OE acceptance - including scope analysis, support model discussions, cost model, governance on migration & decommissioning processes, backup & disaster recovery processes, CMS validation, application/ infrastructure Onboarding & early life support entry/exit criteria evaluations.
• Responsible for process development, management and improvement.
• Responsible for effort estimation, project tracking, task allocation and delivery, people management.
• Responsible for providing the teams with a sense of direction and understanding of the teams' responsibilities
• Responsible to lead and organize productive and efficient meetings as well as analyze reasonableness and validity of conclusions.
• Ensure the projects are executed and transitioned within acceptable levels of quality and cost before formally accepted by Operational Excellence (Support Groups)
• Regular interactions with client VPs, Directors, Service Line Leads, Solution Delivery Managers and other stakeholders and managing their expectations.
• Responsible for Tracking & Consolidating reports.
• Responsible for Financial Forecasting and Analysis. This involves forecasting budget as well as tracking time & efforts for billing purpose on a monthly basis.
• Responsible for Risks/Issues/Escalations management.
• Responsible for staffing and optimized demand management.

Confidential

Project Manager / Business Analyst

Responsibilities:

• In this project the objective was to upgrade the client’s conventional grid infrastructure to SmartGrid.
• The IT part of the project was to implement a robust solution to integrate Customers and Metering Modules using Oracle’s CC&B and MDM2.0.
• On a techno-managerial role, lead the Oracle Fusion & MDM team in order to provide integration solution to Customers and Metering Modules of the client; as well as build Organization’s own Smart Grid integration platform to showcase ability to provide integration solution to common business scenarios in Utilities - Smart Grid domain.
• Overall Team management (25+ members - onshore and offshore)
• Managed multiple projects/initiatives running in parallel.
• End-to-end responsibility of project delivery.
• Design & architecture of the integration layer.
• Used SharePoint for centralizing process management, and for content & document management. Knowledge of SharePoint architecture.
• Used Lotus Notes at client side for emails, calendaring, contacts management, instant messaging, documentation repository, user directories and scheduling online meetings.
• Effort estimation, project tracking, task allocation and delivery, people management, performance goal setting and evaluation.
• Tracking & Consolidating Stakeholder Reporting.
• Risks/Issues/Escalations management.
• Process improvements in overall Team aspects and inter-team coordination.
• Functional and Technical Architecture support.
• Client Team Interaction.
• Quality Management.
• Staffing and optimized demand management.
• Effective Earned value and various Matrices management.
• Organize training sessions.
• Certification drive within the Capability.
• Designed and architected integration solution towards SmartGrid implementation, and had set it up for various client demos.
• Got the FD transition process streamlined. Had setup checklists for every process which reduced the risk of errors and hence improved the transition.
• Thorough reviews at unit level (high unit test defects) resulting in low defects during assembly testing.
• Conducted CAR Analysis after every release that helped in identifying the common defects and taking necessary steps in addressing them.

Confidential, DES MOINES, IA

Project Manager / Business Analyst

Responsibilities:

• Leading the Catalyst project - to consolidate the Allied, Confidential and Nationwide Agribusiness commercial lines onto a single business model, product portfolio and processing system.
• Managing onshore developers and coordinators (10+ members) and leading the offshore team (30+ members)
• Ensure 100% resource utilization.
• Forecast work/resource utilization and ensure minimum 4 weeks of pipeline work for onshore and offshore members.
• Performance Management/ appraisals of onshore members.
• Accountable for successful delivery of multiple projects running in parallel within the engagement.
• Managing expectations of application owners, business owners, program manager and other stakeholders.
• Fine-tuning delivery processes, checklists, templates and onshore-offshore model for smoother coordination and delivery.
• Used Lotus Notes for emails, calendaring, contacts management, instant messaging, documentation repository, user directories and scheduling online meetings.
• Active involvement in gap analysis, SDLC (requirements, design, build, unit test, implementation and post-implementation) and STLC (Test Analysis, Test estimation, Test planning, Test scenario identification, Test execution, and Test closure).
• Conduct Post Implementation Review (PIR) sessions after each major release in order to identify and document the best practices, lessons learned and areas of future development.
• Rolled out Transition plans to better manage rolling-off and rolling-on of resources during ongoing projects.
• Used SharePoint as an intranet portal for centralizing process management, and for content & document management. Have knowledge of SharePoint architecture.
• Consolidating reports from offshore leads and onshore coordinators.
• Defect Management and coordination between the leads.
• Quality Management.
• Risk/Issue/Escalation Management.
• Conduct CAR sessions after each release in order to identify common and repetitive defects and identify ways for reducing them.
• Fine-tuned coding standards & design templates.
• Delivered a REXX-based tool for code merging after every implementation. Streamlined the code merging process.
• Introduced the capturing and tracking of review comments in order to ensure orderly reviews of deliverables.
• Mandated the process of capturing the minutes of meeting during every meeting.

Confidential, DES MOINES, IA

Business Analyst/Dev Lead & Onshore-Offshore Coordinator

Responsibilities:

• Leading a 20-member team at offshore and onshore.
• Ownership of delivery until completion/implementation
• Ensure full resource utilization.
• Ensure low/medium priority work always in pipeline for offshore/onshore team members
• Design, Coding, Testing and implementation.
• Forecast work/resource utilization.
• Identify/raise risks/issues.
• Make/propose improvements to work products, services or processes
• Build skills of offshore resources by coaching/training.
• Provide feedback to improve performance
• Structure own or others' activities to improve productivity or minimize delays/rework.
• Help resolve offshore's connectivity/infrastructure related issues
• Review self/offshore/colleague's work before delivery
• Active involvement in gap analysis, SDLC (requirements, design, build, unit test, implementation and post-implementation) and STLC (Test Analysis, Test estimation, Test planning, Test scenario identification, Test execution, and Test closure).
• As a defect coordinator, responsible for efficient management and resolution of defects across all projects, including activities like defect verification, defect prioritization, defect assignment and defect resolution and defect closure.
• Assisted Test Manager in defect status reporting, defect management reporting, defect metrics, KPIs.
• Used Lotus Notes for emails, calendaring, contacts management, instant messaging, documentation repository, user directories and scheduling online meetings.
• Adhere to the Quality procedures in the team
• Keeping track of billable/non-billable activities
• Preparation of reports
• Designed and implemented various tools/utilities for the Client as well as Project Management out of the normal responsibilities to carry out /manage various internal tasks.

Confidential

Business Analyst/Test Lead & Onshore-Offshore Coordinator

Responsibilities:

• Lead a 15-member team at onshore and offshore.
• Worked as a Test Lead for the functional and integration testing of multiple projects.
• Good experience in Software Testing Life Cycle - Test Analysis, Test estimation, Test planning, Test scenario identification, Test execution (test cycles and cleanpass), and Test closure.
• Coordination between onshore and offshore teams, project managers, program managers and other stakeholders.
• As a defect coordinator, responsible for efficient management and resolution of defects across all projects, including activities like defect verification, defect prioritization, defect assignment and defect resolution and defect closure.
• Assisted Test Manager in defect status reporting, defect management reporting, defect metrics, KPIs.
• Formalize standards for test planning and test script writing.
• Organize knowledge transitions for onshore and offshore team members for better understanding of client's business.
• Help offshore on their technical difficulties and make arrangement /coordinate with other groups for issue resolution.
• Identify/raise risks/issues.
• Provide feedback to improve performance
• Structure own or others' activities to improve productivity or minimize delays/rework.
• Help resolve offshore's connectivity/infrastructure related issues
• Review self/offshore/colleague's work before delivery
• Adhere to the Quality procedures in the team
• Keeping track of billable/non-billable activities
• Preparation of reports

Confidential, DES MOINES, IA

Sr. Programmer Analyst

Responsibilities:

• To fine-tune the Commercial Batch systems to save as much job execution minutes as possible in Critical Path of the Nightly Cycle so as to keep them far away from missing the SLA deadline.
• To fine-tune the Commercial Online systems to save as much CPU consumption.
• Responsibilities include deep analysis of the batch and online systems to identify key areas for performance improvements, suggesting better ideas for fine tuning, design, coding, testing and Implementation.
• Used Lotus Notes for emails, calendaring, contacts management, instant messaging, documentation repository, user directories and scheduling online meetings.

Confidential, WILMINGTON, DELAWARE

Programmer Analyst

Responsibilities:

• The project’s objective was to provide technical support for its various systems namely NEXUS, CEDIS, HARBINGER, MANUGISTICS and AMTrix.
• The support work included maintenance or enhancement work on the existing system, all monitored via tickets.
• Working as a senior programmer involved in maintenance or enhancement of the existing systems.
• Monitoring and resolving tickets/PQRs - Cat2, Cat3 & Cat4
• Monitoring batch jobs/schedules
• Handled multiple applications like CEDIS, HARBINGER, MANUGISTICS, NEXUS and AMTrix.
• Data conversion to / from EDI format (X12, EDIFACT)/ Application-specific format based on the flow of data (inbound/outbound)
• Usage of Transaction Sets for business transactions.
• Technical analysis of the systems, programs and jobs.
• Organize and manage work effort of self and others to provide quality service in a productive and cost effective manner.
• Setup Quality procedures within the team and ensure team adheres to the standards.
• Guide new team members/ juniors and address their project-related questions and technical / non-technical concerns.
• Professional interaction with clients and users.
• Prepare MoMs during weekly meetings
• Designed and implemented a Time Tracking Application for the offshore team to keep a track of the various billable/non-billable daily activities across all applications (Excel VBA)
• Automated various processes and report generations.
• Created various automated tools in Excel-VBA that reducing manual efforts in repetitive tasks and also eliminated the changes of errors.

Confidential

Developer

Responsibilities:

• The project was named CRS - standing for Customer Relationship Statementing. CRS was a subsystem of the entire billing process focusing on the preparation and printing of statements based upon billing data coming from Billing Systems. The team was involved in faultfinding and fixing issues during the entire statement generation process.
• Working as a programmer involved in production support for ICRS & ECRS, collectively called I/ECRS for International & European Customers.
• Monitoring and resolving production tickets - Sev1, Sev2 & Sev3
• Monitoring batch jobs/schedules
• Setting up test environment for System Testing
• System analysis / Analysis of programs
• Providing suggestions for fine tuning programs/jobs
• Coordination with onshore, billing, rewards and other departments
• Interaction with users, verbal as well as written
• Shift working - day shift, afternoon shift and night shift
• Preparing a repository of different / new types of tickets handled with the resolution steps.