SUMMARY

• 15 years of IT experience in large - scale mission-critical software development, maintenance and infrastructure projects at large / Fortune 500 companies. Dynamic leadership with vision, organization and a history of success. Developing and implementing programs to meet business goals through use of organizational delivery methodology.
• 10 years into Project Management, Business Analysis, Process Analysis, System Analysis, Data Analysis.
• Requirement Gathering, Software Development, Testing, Support, Transition, Integration & Migration.
• Gap Analysis, Scope, Feasibility & Priority, Stakeholder Expectation Management.
• Multi Industry Experience: Resources (Oil & Gas, Utilities - Smart Grid & Chemicals), Finance (Banking, Credit Cards & Insurance) & Logistics.
• Organization’s Delivery Methodology (ADM, PDM), Scrum/Agile, Waterfall, SDLC, STLC.
• Web Applications, Mobile Apps, Desktop Applications, Legacy Systems, Batch, Online, Middleware, Databases, Data warehousing (EDW), Business Intelligence (BI).
• Aggressive in tracking of issues & action items with traceability to WBS tasks. Micro-management of time, cost, risk, scope, resources and quality.
• Expert in Excel /VBA - complex macros, formulas & complex automations.
• Schedule Management - Project Schedule, Project Estimation, Work Breakdown Structure (WBS), critical path using CPM in network diagrams, Rolling Wave Planning, Schedule Compression using Crashing & Fast Tracking, Resource Leveling, Tracking using Gantt charts/milestone chart.
• Quality Management - Quality Assurance (QA) using benchmarking, checklist, Quality Control (QC) activities comprising of defect prevention activities like inspection, walkthroughs, reviews, using Pareto’s 80/20 principle, Root Cause Analysis with the help of Ishikawa/Fishbone Diagrams.
• Communication Management - Communication Plan, Status Reporting, Performance Metrics using Earned Value Measurement (EVM), Variance Analysis & Forecasting.
• Risk management - Qualitative Risk Analysis (Brainstorming, SWOT Analysis), Risk Register, Risk Response Planning (Mitigation Plan, Contingency Planning).
• Team Building & Management - Resource Requirement & Staffing, Resource, Drives, Conflict Management, Appraisals & Feedback, Career Counseling and Guidance.
• Vendor Management, Release Management, Delivery Management.
• Service Management, CSI, Service Transition, Incident Management, Problem Management, Service Desk, Change Management & Configuration Management.
• Experience using SQL, SQL Server, T-SQL, TOAD, Oracle PL/SQL, Stored Procedures, Excel, Pivots (including Power Pivots), SSIS, SSRS and Report Builder 3.0.
• Experience in databases, data schemas, data extraction, transformation, and loading (ETL), and data warehouse operations.
• In-depth understanding in Conceptual, Entity Relationship (ER), Relational, Logical, Multi-dimensional and Physical data models for various Online Transaction Processing (OLTP) systems, Online Analytical Processing (OLAP) systems, Operational Data Stores (ODS), Data Marts and Enterprise Data Warehouses (EDW).
• Self-Starter; ability to manage projects with minimal supervision or guidance.
• Decision making ability on risks, issues and escalation management.
• Ability to manage own time to ensure that deliverables are met.
• Good organizational skills, good analytical skills with attention to detail.
• Good communication skills (verbal and written) with the ability to build relationships.
• Good time management and ability to know when and whom to escalate.
• Effective at running meetings.
• Good follow up skills to ensure deliverables are met.
• Ability to review SOWs, contracts and provide meaningful input and recommendations.
• Ability to work with global teams, different time zones and diverse cultures.
• Ability to engage dynamically and effectively with different levels of resources and personalities.
• Recipient of multiple performance s and client recognitions for contributions outside normal responsibilities, exceeding expectations and winning client’s confidence.

TECHNICAL SKILLS

• Delivery Methodology (ADM
• PDM)
• Waterfall Methodology
• Agile/Scrum Methodology
• MS Project (2010 2007 2003 )
• Clarity
• SharePoint (2013 2010 2007 2003 )
• MS Office
• Office 365
• Visio
• Excel-VBA (Macros)
• Pivots
• PowerPivots
• MS Access
• SQL
• SQL Server (2012 2008 R2 2005)
• T-SQL
• SSIS
• SSRS
• Report Builder 3.0
• PI Database
• Oracle PL/SQL
• TOAD
• Informatica
• ASP.net
• Visual Studio
• Subversion(SVN)
• TFS
• IBM Lotus Notes
• IBM ClearCase
• BMC Atrium CMDB
• BMC/Remedy ITSM
• SolveIT
• ServiceNow
• 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
• Mainframe
• 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
• HP Quality Center
• Rational Quality Manager.

PROFESSIONAL EXPERIENCEProject Manager/Business Analyst

Confidential, Dallas - TX

Responsibilities:

• Migration of DHL’s existing customers from legacy system (EZ-FTZ) to new web based system (GTK), and implementation of new business.
• Lead Design, Development and Delivery of Core Business Processes, decision support and user workflows for sustainable business model.
• Conducted business/system analysis. Facilitated requirement gathering sessions with DHL Customers, Business Directors and Product Owner to collect business standards, SLA and studied business process.
• Performed “Gap Analysis” to compare all elements of existing “As Is” with the desired “To Be” process.
• Documented “As-Is” and “To-Be” business process model (IDEF0), functional and technical requirements in traceability matrix, test cases & test acceptance criteria.
• Worked with architect and solution delivery team to prepare technical specification document to include details on the interfaces, file types and message structure, business and validation rules, transformation rules, data field mapping and implementation logic.
• Worked with business & customers to prepare customer profile checklists to consolidate necessary information needed for customer setup in the new system.
• Created proj. schedule, proj. plan, communication plan, RACI Matrix and UAT plan & RTP plan to track project timeline & delivery.
• Created templates for business process documentation, requirements, checklists, design specs, action trackers, defect trackers, risk registers, change control log, status reporting, pre-UAT checklists & UAT execution reporting.
• Translated business requirements into user stories. Created Product Backlog in TFS out of user stories, bugs and change requests.
• Facilitated Scrum ceremonies like Sprint Planning, Daily Standups, Backlog Grooming (Product Backlog Refinement) sessions, Sprint Reviews and Sprint Retrospectives.
• Coached and mentored the Development team members, product owners and other project managers on agile principles, tools and techniques.
• Removed impediments of the development team and assisted product owner in arranging the product backlog.
• Manage coordination between scrum team and external teams.
• Drive daily status calls, schedule implementation specific meetings and coordination in multi-vendor environment.
• Drive UAT meetings and manage interactions with various teams/vendors for defect status, triage, resolution, defect discussion and prioritization. Assist UAT team with acceptance criteria, test cases and preparation of test data.
• Coordinate with other project managers and organizational entities to identify and monitor issues, impacts and dependencies, and to prioritize the projects.
• Manage stakeholder expectations, status and performance reporting (EVMs), risks, issues, escalation & quality.
• Created change control log template. Defined roles and responsibilities. Coordinated with the Change Control Board (CCB), originator, evaluator, modifier, tester and project managers for prioritizing and managing the life cycle of change requests. identified & defined specifications for industry-level standard reports for the benefit of each customer.
• Work with the Business, IT and support team on problem tickets.
• Used SharePoint for centralizing process management, and for content & document management.
• Interaction with Data Warehousing/BI team on ETL data mapping, data content Analysis, and data cleaning.
• Extensive database analysis and identification of incorrect data and data cleaning/correction initiatives.
• Advanced excel expertise - macros, formulas, pivot tables, charts. Automated reports and graphs.

Project Manager / Business Analyst

Confidential, Houston - TX

Responsibilities:

• Project Manager / Sr. Business Analyst for the Health, Safety & Environment (HSE) application. Single Point of Contact (SPOC) for all projects deliveries across all HSE modules.
• Responsible for the management of Incidents module, Safety Observations module, Near Misses Module, Stop and Think About Safety (STAR) module and Job Safety Analysis module of the HSE application (Web and Mobile/iPad apps).
• Partnered with Sponsor, Business Directors, Product Owner & IT Executives to prepare roadmap for 2015 in the HSE applications.
• Extensive interaction with Business teams for requirement gathering and for defining scope & priority.
• Created project plan, requirement documents, screen design mockups, application workflow diagrams, application interface diagrams & test acceptance criteria.
• Managed effort estimation, project tracking, timelines and budget, task allocation and delivery.
• Managed stakeholder reporting (status and performance EVMs), quality, risks, issues and escalation.
• Facilitated Scrum events like Sprint Planning, Daily Standups, Sprint Reviews and Sprint Retrospectives.
• Removed impediments of the development team and facilitated Backlog Grooming (Product Backlog Refinement) sessions with the product owner.
• Coached and mentored the Development team members, product owners and other project managers on agile principles, tools and techniques.
• Manage coordination between scrum team and external teams.
• Translated business requirements into user stories. Created Product Backlog in TFS out of user stories, bugs and change requests.
• Interaction with DBA on database diagrams, database objects, schemas and normalization rules.
• Provided assistance to the Data Warehousing/BI team during ETL processes like data discovery, data analysis, data mapping, data cleaning & development of reusable Mapplets and Transformations.
• Worked with the business teams, IT executives, product owners & support team on problem management, conducted extensive system analysis for RCAs and provided solutions for the recurring problems.
• Worked with Change Control Board (CCB) for approval of new change request.
• Manage coordination between Development, QA, UAT and support teams for the build, test and support of the modules, provide functional and technical support as needed.
• Advanced excel expertise - macros, formulas, pivot tables, charts. Automated reports and graphs.
• Used SharePoint for centralizing process management, and for content & document management.

Project Manager / Sr. Business Analyst

Confidential, Houston - TX

Responsibilities:

• Project Manager / Sr. Business Analyst for the migration of OMS application from MOSS to SharePoint 2010, and further enhancements on the new platform.
• Partner with business teams, users and product owner in re-organizing the functional model of the BP OMS Navigator at organization level.
• Created project charter, defined scope and priority, created project plans and monitor day-to-day project execution.
• Responsible for user interaction, strategies for user review, users documentation, data mapping and monitoring data changes. Created screen design mockups, sample team sites, lists and libraries, and workflows.
• Worked with business and other BAs on requirement gathering and documentation through customer interface (use case, use case diagrams, traceability matrix). Translated business requirements into user stories. Created Product Backlog in TFS out of user stories, bugs and change requests.
• Worked with business & customers to gather necessary information needed for business user setup in the new system.
• Performed “Gap Analysis” to compare all elements of existing “As Is” with the desired “To Be” process.
• Managed coordination between Development, QA, UAT & support teams for build, test and support of the modules.
• Managed Effort estimation, project tracking, timelines and budget, task allocation and delivery.
• As a scrum-master, conduct daily standup meetings, remove impediments of the development team, help the product manager create and manage product backlogs. Facilitated Sprint Planning, Daily Standups, Sprint Reviews and Sprint Retrospectives.
• Used SharePoint for centralizing process management, and for content & document management.
• Worked with business and other BAs in preparation of test cases, user acceptance testing & verification of test logs.
• SQL hands-on to process data extracts from a variety of support systems and data tables.
• Worked on database diagrams, database objects, schemas and implemented normalization rules.
• Interaction with business and Data Warehousing/ETL team on data mapping, provide assistance on Data Discovery phase, determining System of Record, Data Content Analysis, determining change data, data cleaning, development of reusable Mapplets and Transformations.
• Analyze data, interpret results & convey findings in a concise & professional manner. Implement & maintain daily/weekly/monthly reports at LOB/Executive levels to enable data driven business decisions.
• Assure the integrity of project data and process, including data extraction, manipulation, processing, query optimization, analysis and reporting.
• Prepare as needed data-sets and presentations for senior management.
• Worked in a multi-vendor environment and coordinated with teams across multiple geographies.
• Managed a team of 12 members onshore & offshore.
• Responsible for status reports consolidation & stakeholder reporting, and for Risk/Issue/Escalation/Quality Management.

Service Design & Transition Manager

Confidential, Houston - TX

Responsibilities:

• Responsible for overall Service Design & Transition Management for 80+ projects (Web & Mobile)
• Formed and lead 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 Operational Excellence (OE) acceptance - including scope analysis, support model discussions, cost model, governance on migration & decommissioning processes, backup & disaster recovery processes, CMS/CMDB validation, application/ infrastructure onboarding & early life support entry/exit criteria evaluations.
• Project sizing (project tier) based on duration, resources, budget, technical complexity, requirement stability, external constraints and dependencies, commercial/contractual complexity and strategic importance.
• Contributed towards the development of configuration management (CM) standards, procedures and plans and implementation, maintained libraries of baseline change requests for multiple IT systems and tracked & Accreditation activities for multiple systems.
• Interface with process managers and key stakeholders for change, problems, release and, asset management processes, ensuring a clearly defined methodology for developing an accurate Configuration Management Database (CMDB).
• Ensure uniqueness and appropriate naming conventions for the CIs.
• Follow up with Change Control Board (CCB) for approval of new change request.
• Conduct weekly review meetings to ensure uniqueness and completeness of all CMDB entries, report stray or improper entries and flag them for either correction or deletion.
• Overall team management - 10+ resources.
• Responsible for process development, management and improvement.
• 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
• Lead/organize productive & efficient meetings as well as analyze reasonableness and validity of conclusions.
• Ensured projects are executed & transitioned within acceptable levels of quality & cost before formally accepted by Operational Excellence (Support Groups).
• Regular meetings with VPs, Directors, Service Line Leads, Solution Delivery Managers & stakeholders to manage expectations.
• Financial Forecasting and Analysis. This involved forecasting budget as well as tracking time & efforts for billing purpose on a monthly basis.
• Stakeholder reporting & tracking, Risk/Issue/Escalation/Quality Management.
• Staffing and optimized demand management.
• Advanced excel expertise - macros, formulas, pivot tables, charts.
• Used SharePoint for centralizing process management, and for content & document management.

Sr. Project Manager

Confidential

Responsibilities:

• Worked as a Sr. Project Manager, managed multiple projects/initiatives including client deliverables as well as various organization level initiatives.
• Lead the Oracle Fusion & MDM team to provide integration solution to the Customers and Metering Modules of the client using Oracle’s CC&B and MDM2.0.
• Implemented Meter Data Synchronizations for customers (persons), accounts/service agreements (SAs), service points (SPs), meters, meter configurations, and SP/meter history between CC&B and MDM.
• Implemented Billing related processes for Batch Billing and Online Billing Determinants Request and Response, Replacement Reads, Register Reads High-Low Boundaries & Usage Request.
• Implement Customer Self-Service related processes for Usage Adjustment Request, Usage Overview & Usage Detail.
• Managed a team of 25+ members across multiple projects, offshore & onshore.
• Work planning & forecast, ensuring minimum 4 weeks of pipeline work for onshore/offshore members.
• Built Organization’s own Smart Grid integration platform to showcase ability to provide integration solution to common business scenarios in Utilities - Smart Grid domain. Provided demos to many prospective clients.
• Standardized naming convention, coding standards, design templates, deployment guidelines and release management.
• Created functional design (FD) documents. Streamlined FD transition process. Introduced checklists for every process which reduced the risk of errors and hence improved the transition.
• Created integration specifications to detail the designs of web services, including interfaces exposed by web services, business and validation rules, transformation rules, data field mapping and implementation logic.
• Involved in Design & architecture of the integration layer.
• Used SharePoint for centralizing process management, and for content & document management.
• Highly appreciated for planning ahead and on-time high-quality delivery.
• Contributions towards Global CBT by rolling out a new material on the usage of latest high-tech integration solutions for common business scenarios in Utilities - Smart Grid domain.
• End-to-end responsibility of project delivery.
• Effort estimation, project tracking, task allocation and delivery, people management, performance goal setting and evaluation.
• Tracking & Consolidating Stakeholder Reporting.
• Risks/Issues/Escalations/Quality management.
• Process improvements in overall Team aspects and inter-team coordination.
• Functional and Technical Architecture support.
• Staffing and optimized demand management.
• Effective Earned value and various Matrices management.
• Organize sessions, run drive within the Capability.
• Thorough reviews at unit level (high unit test defects) resulting in low defects during assembly testing.
• Data analysis of meter data in MDM and generating reports, identifying data mismatches and proposing data fix solutions.
• Conducted CAR Analysis after every release that helped in identifying the common defects and taking necessary steps in addressing them.

Project Manager

Confidential, Des Moines - IA

Responsibilities:

• Lead the Catalyst project - a business/IT transformation initiative to consolidate Allied, Confidential and Nationwide Agribusiness commercial lines onto a single business model, product portfolio and processing system.
• Managed a team of 20+ members across multiple projects, offshore & onshore.
• Work planning & forecast, ensuring minimum 4 weeks of pipeline work for onshore/offshore members.
• Accountable for successful delivery of multiple parallel projects running within the engagement.
• Managing expectations of application owners, business owners, program manager and other stakeholders.
• Extensive interaction with business managers, application owners and executives to gather precise requirements and to define scope and priority. Prepared requirement documents, application workflow diagrams, application interface diagrams & test acceptance criteria. Also worked with system architects on technical designs.
• Won the confidence of some of the toughest clients by successfully delivering critical projects with highest visibility, and by maintaining highest quality standards of the deliverables.
• Facilitated standardization of naming convention, coding standards, design templates, deployment guidelines and release management.
• Fine-tuning templates, checklists and delivery processes in onshore-offshore model for smoother coordination and delivery.
• Active involvement in gap analysis, SDLC (requirements, design, build, unit test, implementation and post-implementation), STLC (Test Analysis, Test estimation, Test planning, Test scenario identification, Test execution, and Test closure) & defect coordination (defect verification, defect prioritization, defect assignment and defect resolution and defect closure), defect status reporting & defect metrics (KPIs).
• Conduct CAR sessions after each release in order to identify common and repetitive defects and identify ways for reducing them.
• 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.
• Quality/Risk/Issue/Escalation Management.
• Contributed towards the development of configuration management (CM) standards, procedures and plans and implementation, maintained libraries of baseline change requests for multiple IT systems, and ensured clearly defined methodology for developing an accurate Configuration Management Database (CMDB).
• Ensure uniqueness and appropriate naming conventions for the configuration items (CIs).
• Conduct review meetings to ensure uniqueness & completeness of CMDB entries, report stray or improper entries & flag them for correction or deletion, and Follow up with Change Control Board (CCB) for approval of change requests.
• Managed coordination between Development, QA, UAT and support teams for the build, test and support of the modules.
• Report consolidation and project performance reporting including EVMs.
• Interaction with DBA in development, maintenance and enhancement of databases.
• Extensive data analysis, identifying data mismatches and proposing data fix solutions.
• Delivered REXX-based tool for code merging after every implementation. Streamlined code merging process.
• Designed and implemented an SCM tool using Excel-VBA in order to manage the versioning and change control of tablebase.
• Created transition plans to better manage resource roll-off / roll-on.
• Performance management - feedback & appraisals.
• Received People Developer Recognition for commitment in mentoring and guiding team members.
• Recipient of the “I got Caught’ client recognition for successfully delivering a complex and high-visibility unstable module that got scraped earlier because of constantly changing requirements and poor design & coding standards.

Test Lead & Onshore-Offshore Coordinator

Confidential

Responsibilities:

• Lead a 15-member team at onshore and offshore.
• Test Lead for the functional and integration testing of multiple projects.
• Software Testing Life Cycle - Test Analysis, Test estimation, Test planning, Test scenario identification, Test execution (test cycles and clean pass), and Test closure.
• Coordination between onshore & offshore teams, project & program managers and other stakeholders on project delivery, issue resolution, status communication & reporting.
• Defect coordination, 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 & offshore team members.
• Help offshore on technical/infrastructure challenges & coordinate with other groups for issue resolution.
• Identify/raise/escalate risks/issues and facilitate discussions towards mitigation & resolution.
• Structure own or others' activities to improve productivity or minimize delays/rework.
• Review offshore work before delivery. Provide feedback for performance improvement.
• Adhere to the Quality procedures in the team.

Sr. Programmer Analyst

Confidential, Des Moines - IA

Responsibilities:

• Fine-tuned Commercial Batch systems and saved around 600 minutes on job execution time in Critical Path of the Nightly Cycle, enabling them to complete at least 2 hours before the SLA deadline.
• Fine-tuned Commercial Online systems to save CPU consumption, resulting in a saving of approx. $200,000 annually.
• Responsibilities include in-depth analysis of legacy systems (batch & online) to identify key areas for performance improvements, suggesting better ideas for fine tuning, design, coding, testing and Implementation.

Support Analyst

Confidential, Wilmington, Delaware

Responsibilities:

• Worked as a technical support analyst for various systems.
• Daily monitoring of batch jobs/schedules and tickets and provide resolution within the defined SLAs.
• Data conversion to / from EDI (X12, EDIFACT)/ Application-specific format (iDoc, Datasets, text files, CSV).
• Usage of Transaction Sets for business transactions.
• Technical analysis of the systems, programs and jobs and providing suggestions for fine tuning.
• Coordination and interaction with onshore team, users, and other departments e.g. Billing & Rewards.
• Documentation & repository of different / new types of tickets handled with the resolution steps.
• Designed and developed a HTML based Knowledge Portal for the project as a self-initiative.
• Designed, developed and implemented a Time & Ticket Tracking Application (Excel-VBA).
• Automated various processes and report generations.