Project Management Senior Analyst

RELEVANT EXPERIENCE

Experienced lead/senior analyst with almost 24 years in the IT industry with special emphasis in System/Business/ Data Analysis. Proficient in Oracle/SQL/Access/Excel/Mainframe. Have significant experience in project management, program management, process improvement, team leadership, program testing with extensive experience in project management software’s Primavera and MS Project.and Agile Methodology tools. Possess exemplary skills in written and verbal communications, time management, organization, and departmental operations. Reputation for ability to interact easily with co-workers and subordinates of diverse backgrounds, cultures, and professional and technical levels. Well experienced in all levels of SDLC.

EDUCATION

Master of Computer Applications: (S.N.D.T University - Mumbai, India) 1994

Bachelor of Science: (University of Calcutta - Calcutta, India) 1990

Professional Certification: Scrum Master

TECHNICAL SKILLS

Platform Experience - UNIX, DOS, MCP, Windows NT, VMS, Windows 98, Windows XP Professional, Vista

OS Systems - UNIX, UNISYS A SERIES, UNISYS CLEARPATH, IBM, PC COMPATIBLES, VAX 4000/100, INTEL, Microsoft Packages - MS Office, MS Access, MS Project, VISIO, Excel, Business Object

DBMS - Oracle, DMSII, Clipper 5.2, DBASE III, RDB/VMS, Unify 4.1, Access, Informix, SQL Server, Teradata

Programming Languages - SQL, PL/SQL, COBOL, ACCESS, C/C++, MS SQL, T-SQL, HTML, VB, CRYSTAL REPORT, LISP, VBA, SAS. 4GL – LINC, LINC II, UNIFY ACCELL

GUI/Tools - LDA III, LINCLITE, RELY, NAP, SQL Developer, TOAD, DOORS, COGNOS, RRC, RSA, Clearcase, QlikView, ClearQuest, BOXI, SharePoint, Remedy. Snapshot, Hadoop, Visio, JIRA, Kanban

Analysis / Methodology/ Standards: Business Process Modeling, Business Process Reengineering, Rational Tool Sets, Waterfall, Expectation Management, Project Management – Project Planning, Project Scheduling, Change Management, Risk Management, Functional Analysis, release Management, White Box/Black Box Testing, Agile. Requirement Analysis.

Management Skills - Project Management Suite, FPA, Primavera 6.0, PRIMAVERA 5.0, MS Project, PMBOK, CSM. JIRA, Kanban .

PROFESSIONAL EXPERIENCE

SENIOR BUSINESS ANALYST, Integrated Systems Inc/ IRS, Jan 2024 to Current Remote

Worked for the Internal Revenue System (IRS) in modernization of the CADE2 projects in IRS primarily ITPE and SSRA

Documented the requirements for the ITPE project.

Key focus was to co-ordinate with the stakeholders for additional requirements and create research documents

Regularly coordinated with stakeholders for review and updating the documents.

Worked in various capacity for the SSRA projects.

Coordinated with the stakeholders for the creation, maintenance of the business as well as other documents.

Lead and facilitate several meetings and daily stand ups

Maintain liaison between various groups of the project.

Maintained the Kanban board for the project

Worked in created and maintaining RACI Traceability Matrix

Guided other team members

Created and maintained the Requirement Plan for the SSRA project.

LEAD TECHNOLOGIST, BOOZ ALLEN HAMILTON, August 2019 to May 2023 Remote/Mclean

Product Owner/Lead Business Analyst (OTCnet – Bureau of Fiscal Services)

Synthesized a wide array of business and technical documentation to identify, design, and implement requirements to enhance and modernize the OTCnet system during various O&M and DME releases.

Determined scope for various project releases/phases and created relevant release requirements, use cases, user interfaces and user stories in an agile environment. This includes creating, and refining both release & sprint backlogs.

Constructed workflow charts and diagrams to perform business process analysis and reengineering.

Demoed high-fidelity wireframes to internal and external stakeholders across different government agencies during design sessions for feedback and/or approval.

Leveraged Atlassian JIRA for user story and acceptance criteria development and execution tracking.

Facilitated and coordinated technical and non-technical meetings across all OTCnet work streams – development, test team, customer service, security, agency adoption, etc. – to review and communicate requirements updates and design options and ensure continuity across the larger project team.

Managed sprint and release start-up and close-out activities, developed sprint and release lessons learned, and participated in several agile ceremonies (i.e., backlog grooming, sprint planning/grooming, standups etc.)

Created Data Design Document and maintained data validity.

Lead Business Analyst (ITAM - IRS)

Key contributor in eliciting business requirements for the ITAM (IT Asset Management) at IR

Led the business requirement gathering for GSS and HWAM streams of the Data Orchestration

Acted as key liaison between the Data Remediation Team and Data Orchestration framework team.

Developed business requirement documents for the project.

Developed test cases and led user testing for GSS and HWAM.

Worked and researched on data various related artifacts.

Worked as the key person in communicating with the stakeholders for GSS and the technical team for DB design.

Worked in process improvement for GSS and HWAM

Documented various artifacts in the business as well as delivery side.

SENIOR DATA ANALYST, FEPOC, October 2018 to June 2019 Washington, D.C.

FEPOC (Federal Employees Plan Operating Center) is a division of CareFirst Blue Cross Blue Shield which deals with all the insurance plans of Federal Employees. As a part of Data Analyst Team currently working on the Incentive Plans Project. The current project is to migrate all the legacy system (DB2 and Cobol) applications to Big Data (Hadoop)

Working on migrating the Performance Incentive Plans (PIP) Project to Big Data

Understand the Current existing Cobol Programs used for Reporting in PIP

Analyze the Cobol Program to understand the requirement and design.

Work closely with the legacy team (Cobol and DB2) for creating the functional specification.

Created design and technical specification for the PIP project.

Prepared STTM (Source to target mapping) for all the reports (about 10) for the PIP project.

Reviewed the test cases for MIP project.

Worked closely the testers to help them develop the test plans for the PIP project.

Participated in the daily scrum meeting.

Adhered to the best practice methods.

RISK MANAGEMENT ANALYST/

ITRAC/CLEARQUEST DEVELOPER, IRS/DTI, September 2016 to November 2017 Lanham, MD

The Enterprise Life cycle (ELC) division of Internal Revenue Services (IRS) provides and maintains all process improvement, program management (including Risk management) and documentation needs for all projects in IRS. Thi9s division interacts and spans across all other departments and division in IRS setting standards and procedures throughout IRS.

Provides subject matter expertise in software design, development of coding, testing, and deployment of new applications and implementation methodologies.

Does Business rules analysis and translates new requirements into programming changes?

Utilizes the ELC Information Tracking, Reporting and Analysis Control Risk Reporting tool (ITRAC).

Implements metrics gathering through scripting and Rational Project Console.

Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs of a variety of platform including Oracle, Crystal Report and IBM Mainframe.

Implements a variety of the field's concepts, practices, and procedures.

REPORTING ANALYST III, MULTIPLAN INC, June 2015 to August 2016 Rockville, MD

Multiplan, Inc. provides healthcare cost management solutions through regional preferred provider organization networks in Wisconsin and the southwest. The company offers a single gateway to a host of network-and analytics-based solutions for managing the financial risks associated with healthcare claims; and products that fight waste, abuse, and fraud before payments are made.

As a Reporting analyst create reports for in house as well as for clients (includes both batch as well as ad-hoc reports)

Schedule and run the batch reports/ad hoc reports as needed.

Automated the Cigna Score card Report.

Managing some applications in QlikView

Write queries for data analysis.

Writing specs and technical documents

Creating Test cases and testing the reports generated.

SENIOR SYSTEMS ANALYST, CGI (FANNIE MAE), February 2015 - June 2015 Herndon, VA

CGI took over the ownership of various Fannie Mae applications in order to support them. In this project CGI took over 6 applications of Fannie Mae.

Communicated with the Business team to get the Requirements.

Analyzed the requirements and provided solutions if needed.

Translated the requirements to design documents using DOORs.

Created STTM documents.

Prepared Test cases and performed in System Testing

Was the contact point with the development team and the business team as a team lead.

Provided assistance to the business team in UAT if needed.

Helped the project manager in various project management tasks.

ASSOCIATE BUSINESS MANAGER, HCL AMERICA (AARP), April 2104 to September 2014 Rockville, MD

AARP is a nonprofit, nonpartisan organization, with a membership of more than 37 million, that helps people turn their goals and dreams into real possibilities, strengthens communities and fights for the issues that matter most to families such as healthcare, employment security and retirement planning. HCL had acquired the project to provide support and help in the daily operations of certain applications/groups of AARP. One of the groups is Mission which has various applications.

Lead for the BA team. Responsible for assigning, validating and monitoring the L2 tickets and other work in Mission.

Provided the daily status report as well as analysis for L2 to senior management as well as the client.

Worked on L2 tickets to maintain them.

Provided guidance to junior team members as well as conducted trainings for L2 tickets methodology and process.

Responsible for gathering requirements for enhancement and support work and documenting them.

Responsible for creating BRD-s and reviewing BRD-s for other team members.

Responsible as a point of contact between the team and the business team of client,

Provided the daily status report as well as analysis pending work to senior management as well as the client.

Helped in creating test cases for regression testing.

Responsible for performing testing at various levels.

Created several documents for process improvements.

Helped senior management in planning of the project and resource allocation.

Created RACI traceability matrix for tracking and assignment of work for the project.

SENIOR DATA ANALYST CONSULTANT, Capital One, June 2013 to Dec 2013 Mclean, VA

The Sales and Specialty Team in Small business Banking provide support to the daily operation and reports to the entire Small Business Banking Group. This team has a special role as it services the broad audience of high executive level as well as 300 business bankers. The primary platforms used are SQL, Teradata, Excel and Business Objects, PowerPoint, Visio &Word.

Responsible for generation and validation of BAU reports for the business banker.

Communicate with the bankers and provide support to them as and when needed.

Provide data analysis to the users as well as senior management team.

Make changes, test and implement the reports as and when needed.

Responsible for documenting business specification and technical specification for all the BAU reports

Provide help and support to the other team members.

Converting the pipeline report from manual in excel to Teradata (SQL) (requirement to testing, complete)

Responsible for automating the Sales Data Control and other report in Business Object

Prepare methodologies for process improvement.

Automation of Pipeline report

SENIOR BUSINESS/DATA ANALYST CONSULTANT, Freddie Mac, May 2012 to April 2013 Mclean, VA

Single Family Operations help in assisting the servicers (banks) in their daily operations for running of their business such as reconciliation, data validation, data check to maintain the loans up-to date and correct. They also help in assisting servicers in terms of all loan modifications. Report generation for the servicers and the business team is also an integral part.

Responsible for generation and validation of reports for the business team to communicate with the servicers.

Communicate with business team as well as the servicers to gather information about their business changes and prepare business and technical specification.

Validation of production reconciliation reports for the servicers using SQL Server, SQL, Access and Excel

Support the business team on analysis of defects and discrepancies.

Provide supplemental information as needed.

Generation of weekly reports for reconciliation for Servicer data and Freddie Mac data

Performing data quality check for servicers for each cycle and validating servicer data with Freddie data

SENIOR BUSINESS/DATA ANALYST CONSULTANT, Fannie Mae, Jun 2011 to April 2012 Mclean,VA

HAMP Operations - Back Office Operations

Making Home Affordable (MHA) Program was introduced to stabilize the housing market and help struggling homeowners get relief and avoid foreclosure. Back-office operations’ responsibilities include Servicer Reporting, Loan Cancellations & Corrections, Loan Reconciliation (FNM, FRE, and TRE), Monthly Close, Caps Reporting and Validation.

Responsible for generation and validation of public metrics and other ad hoc reports for consumption by treasury and external oversight agencies monitoring the MHA program.

Validation of production interface files for Treasury, Fannie Mae and Freddie Mac

Support consumers on production interface issues

Provide supplemental information as needed.

Validation of public and government loan data

Analysis and development of validation services for compensation and accounting

Analyze and develop new reporting capabilities, work with requirements and technical teams on data field analysis Oracle Database 11g Enterprise Edition, SQL, PL/SQL, Business Objects Web Intelligence Documents

Optimization and fine tuning of queries

Document business requirement specs for new requirements as well as for existing system

Convert the requirement specs into technical specification.

Prepare Job aids for the team to work on

Help in preparing QA documents for audit purpose and help and work with the QA lead.

Help in process improvement.

Prepare business specification depending in any change in any rule about the HAMP program upon the feedback from the treasury as well as the business team.

SENIOR ANALYST (TEAM LEAD), Hilton Hotel (TCS), Nov 2010 to Jun 2011 Mclean, VA

Tata Consultancy Services is the largest IT software services provider in India. Its headquarters are in Mumbai, India with offices all over the globe. The provide services in all sectors of IT with huge manpower resources of over 170,000 employees globally and revenue of over 7 billion USD.

TCS had signed a multimillion-dollar project with Hilton Hotel worldwide for 2 projects. The first one is for preparing Hilton for IPO readiness and the second is the SST project. This project will consolidate the distributed systems of Hilton into one single system and also implement the latest version of PeopleSoft to the system.

Worked as a BA/DW person for the 1st phase of the IPO readiness program.

Worked as a key person in the EDW/BI perspective in the SST phase 1 program.

Interacted with the client in consolidating of the project plans along with other team members.

Acted as the UML/Rational lead person for the UML side of the requirement definition part of the project.

Imparted UML training to junior team members

Attended workshops arranged by Hilton to understand their requirements.

Attended JAD sessions for requirement gathering.

Analyzed the requirements and measuring their facts and dimensions and helping in converting them in Rational as Business process diagram.

Prepared prototypes and templates for requirement gathering and was accepted by client.

Understood the data warehouse part of Hilton and analyzing them, further planned on how to consolidate into a single system.

Worked on how to consolidate the multi chart of accounts into a single COA.

Prepared on developing a transitional layer for the data translation for the new COA.

Data consolidation from various systems using Hyperion, PeopleSoft, OBIEE, Mainframe, SQL, EXCEL, Access.

REPORTING ANALYST CONSULTANT, FINRA, Mar 2010 to Jul 2010 Rockville, MD

FINRA is a leading private-sector provider of financial regulatory services, dedicated to investor protection and market integrity, FINRA touches virtually every aspect of the securities business: from registering and educating industry participants to examining securities firms and enforcing rules of federal securities laws, to administering the largest dispute resolution forum for investors and member firms. The project was migration of Access database source Informix to oracle also from MS Access database 2003 to Access database 2007.

Worked as a reporting specialist, data analyst and database programmer in MS Access, SQL, Oracle, Excel for the T&CE group under RADS department.

Maintained, enhanced and helped users for an application system in VB and Access.

Maintained and resolved issues in the testing and continuing Education database.

Monitored the performance of the application and data clean up tasks were performed on regular interval of time.

Handled technical support for troubleshooting and support for database-linked users in sales team, marketing and field support team.

Involved in the design and development of several VBA/Excel /SQL server automation solutions and reports.

Interacted with manager and the database users to gather complete work process and requirement.

Involved in migration of complete database from using Informix database to oracle database as source for Access database.

BUSINESS SYSTEMS ANALYST CONSULTANT, LAUSD (Senior Scheduler Cost Specialist), Apr 2007 to Sep 2009 Los Angeles, CA

Los Angeles Unified School District (LAUSD) is the largest (in terms of number of students) public school system in California. It is the 2nd largest public-school district in the United States. During the 2007-2008 school year, LAUSD served 694,288 students, and had 45,473 teachers and 38,494 other employees. It is the second largest employer in Los Angeles County, after the county government. Being such huge in size all the departments involve huge amount of work.

The Facilities Services Division (FSD) has undertaken the largest school building and modernization project in history. In FSD there are three main areas intended for contractors who do business with LAUSD, employees who work for the District, and for the general public who have overwhelmingly approved capital projects.

Worked as a reporting specialist, data analyst and database programmer in MS Access, SQL, Oracle, Crystal, Reports, Excel, Cobol for FSD Generated various level of complex reports and charts to be presented at various level of managements on a daily, weekly and monthly basis.

Managed and maintained a large amount of data through complex queries and forms.

Managed projects including various aspects like QA/QC, documentation, client requirement analysis etc.

Worked as a senior scheduler of project management tool Primavera version 5.0 & 6.0 and managing various projects.

As a scheduling analyst statuses schedules, worked on quality checks, resource usages and analysis, time impact analysis and reporting.

IT ANALYST, EXECUTRAIN Corporation, Dec 2006 to Mar 2007, Ontario, CA

SYSTEMS ANALYST/PROGRAMMER, COGNICASE USA INC. Liberty Travels, Feb 2002 to Aug 2002 Ramsey, NJ

SYSTEMS SPECIALIST, TATA INFOTECH/ TATA UNISYS LTD. Mar 95-Aug 01

Assigned to various projects at client sites to represent Tata Infotech and performed the duties of System Tester, Programmer Analyst, Trainer, QA, Team Leader and more over a 6-year tenure in US, UK and India.

PROGRAMMER, M.N. DASTUR & CO, Dec 1994 to Mar 1995, Mumbai, India

TRAINING

Certified Scrum Master

SQL Certification course as a part of OCA of Oracle DBA

Primavera 5.0 Certification for project management

Unisys A-Series concepts, Data communications using COMS, Database concepts, Developing application programs on Unisys A-Series using COBOL, DMS II, LINC, System programming with ALGOL, Networking concepts, BNA V.2 (Burroughs Network Architecture) and Basic system support for Unisys A-Series

Trainer’s training

NAP (Telephonic System)

INTERNSHIP PROJECT (JAN 1994 -AUG 1994)

Development of Provident Fund Accounting System for Godfrey Phillips (India) at Mumbai, India, MCA, 1994

Contact this candidate