RELEVANT EXPERIENCE

Experienced senior analyst with about 17 years background in the IT industry with special emphasis as a System/Business/ Data Analyst. Proficient in SQL/Access/Excel and also experienced in Crystal Reports, Cognos and Visual Basic. 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. 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

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

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

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.

Management Skills - Project Management Suite, FPA, Primavera 6.0, PRIMAVERA 5.0, MS Project, PMBOK

PROFESSIONAL EXPERIENCE

RISK MANAGEMENT ANALYST/

ITRAC/CLEARQUEST DEVELOPER, IRS, September 2016 to Present 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.

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. Its solutions include primary, complementary, and specialty networks, as well as non-network solutions, centers of excellence, network management services, and negotiation and medical reimbursement analyzing services. The company’s commercial solutions are aimed at companies and organizations that are responsible for paying healthcare claims generated from commercial group and individual health plans; government solutions are aimed at helping Medicaid and Medicare advantage health plans to control their healthcare costs; and multi-tiered solutions are designed to provide savings to payers of workers' compensation and auto medical bills. Its clients include insurers, health plans, third party administrators, self-funded employers, HMOs, and other entities that pay medical bills in the commercial healthcare, government, workers’ compensation, property and casualty, and auto medical markets.

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

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 banker. The primary platforms used are SQL, Teradata, Excel and Business Objects, PowerPoint, Visio and 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)

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

Prepare methodologies for process improvement

Automation of Pipeline report

SENIOR BUSINESS 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

Documenting any new process and procedures and modifying existing documentation if required

Assisting junior team members whenever required

Maintain and prepare status report for the ongoing project

Communicate and present the project metrics to the business team and management

Overlooking the QC part of the project.

Working on the testing of Vendorscape System

Maintenance and troubleshooting for SSIS Packages

Prepare methodologies for process improvement

SENIOR BUSINESS ANALYST CONSULTANT, Fannie Mae, Jun 2011 to April 2012

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 adhoc 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 Worldwide (Tata Consultancy Services), 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, SQL, EXCEL, Access etc.

Tracked project schedules and reviewing deliverables as a part of QA and team lead.

Interfaced with the business community to define objectives and requirements. Translate them into a format that allows technical solutions to be developed and implemented.

Facilitated regular project meetings and follow up with team members as required focusing on business and operational issues or technical issues

Produced executive reports on assigned project to keep management apprised of project status, major issues, scope changes, resource changes and milestone achievements or misses

Commendable knowledge in Project Management, Project Planning & Control, Scheduling & Programming, Network Diagrams, WBS, Technical Architecture Planning, Use Cases etc.

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 where 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.

Was responsible for maintaining the whole database and monitoring users.

Automated encrypt and email reports which allow users to email or assign to other users for review of documents using VBA modules.

Generated various ad-hoc reports on Excel spreadsheets and created VBA modules to automate the procedure on Access database.

Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per design documents.

Monitored the performance of the application and data clean up tasks where 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.

Imported data into MS Access from Oracle database using stored procedure in VBA.

Extensively used pivot tables and charts in reports.

UNIX commands where used to interact with the Informix database and process the files to tables.

Created Excel applications (VBA, Macros) to import data and perform various statistical analyses, charts and graphs.

Worked to check the quality assurance of the output and its functionality.

Documented the whole database with applications and also provided user guide, which described functionality of the applications

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 also 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 for FSD and Elucian Banner for other departments

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.

Communicated with the clients (various departments) focusing on their needs and did requirement analysis

Involved in all aspects of Existing facilities Documents

Attended the follow ups of the board meetings occasionally for the planning of School Information Panel

Involved heavily with the Existing Facilities planning for short and long term projects.

Managed the Sustainability projects for cost effectively.

Managed and worked extensively on the Repair and Modernization Projects which had about 24000 projects on going at anytime

Managed and was the independently scheduled all Relocatable Housing Unit (RHU) projects from start to end

Successfully delivered results for all ongoing RHU projects which was a major achievement as RHU was a bottleneck for the Existing facilities

Planned and documented many Construction Safety Documents

Extensive experience with Project Charter, Bid Schedules, Cash flow Analysis, Planning Sessions, Baseline CPM Schedules, Cost/Resource Loading, Recovery Schedules, Cost and Schedule Variance, Monthly Invoices, Project Meetings & Weekly Management reports, resource planning and allocation.

Used primavera 6.0 for Project Scheduling

Compiled and validated business requirements, discussed scope changes with business partners.

Interfaced with the business community to define objectives and requirements. Translate them into a format that allows technical solutions to be developed and implemented.

Facilitated regular project meetings and follow up with team members as required focusing on business and operational issues or technical issues

Produced executive reports on assigned project to keep management apprised of project status, major issues, scope changes, resource changes and milestone achievements or misses.

Accountable for on time product delivery, product quality, product unit cost, capital and expense budget management, product innovation, and operations life cycle mgmt.

Successfully planned and managed projects throughout the entire project lifecycle, as a skilled Project Management professional responsible for all aspects of project implementation, tracking, analysis and deliverables.

Worked on various modules (Student information and HR and Finance) of Banner for reports and scheduling and data management for various departments of LAUSD.

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

Executrain Corporation is a leading Training and Consulting company in southern California. They help big clients in imparting training and helping their employees in helping in business process for quick short term projects. For critical projects which are time bound Executrain help the clients in providing effective quick solutions and also establishing a running applications. They also help the client in the usage of the applications and train their employees to effectively independently handle the applications /software.

Extensive experience with Project Charter, Bid Schedules, Cash flow Analysis, Planning Sessions, Baseline CPM Schedules, Cost/Resource Loading, Recovery Schedules, Cost and Schedule Variance, Monthly Invoices, Project Meetings & Weekly Management reports, resource planning and allocation.

Commendable knowledge in Project Management, Project Planning & Control, Scheduling & Programming, Network Diagrams, WBS, Technical Architecture Planning, Use Cases etc.

Compiled and validated business requirements, discussed scope changes with business partners.

Interfaced with the business community to define objectives and requirements. Translate them into a format that allows technical solutions to be developed and implemented.

Facilitated regular project meetings and follow up with team members as required focusing on business and operational issues or technical issues.

Produced executive reports on assigned project to keep management apprised of project status, major issues, scope changes, resource changes and milestone achievements or misses.

Accountable for on time product delivery, product quality, product unit cost, capital and expense budget management, product innovation, and operations life cycle mgmt.

Successfully planned and managed projects throughout the entire project lifecycle, as a skilled Project Management professional responsible for all aspects of project implementation, tracking, analysis and deliverables.

Imparted training in various topics ranging from Microsoft software (MS Office/MS Access) to Oracle software (SQL, PL/SQL) for Corporate level people from various companies and clients

Underwent extensive study for being a teacher

Imparted training at Corporate level on Oracle, Access, MS suite and other tools like Primavera and Elucian Banner

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

Liberty Travels is one of the leading Travel Companies in the Country. It was established in 1951 and has its corporate office in New Jersey. They are the travel experts be it for domestic, international, business or pleasure travel. They offer competitive prices for all travels and their cruises are reported to be the best in comparison to their prices. With 59 years in the industry they have travel experts who cater to the needs of all. All the 160 store locations are managed by the corporate office. They also offer price beat guarantee.

Interface with the business community to define objectives and requirements. Translate them into a format that allows technical solutions to be developed and implemented.

Research data stores; execute complex queries to extract data from the data warehouses and data marts.

Translate business objectives into criteria and logical specifications to generate end deliverables (including file extracts, MIS reports, and SAS data marts).

Design, develop and maintain databases and data marts as needed for MIS, end user computing and statistical modeling.

Code highly complex application programs, queries or profiles according to specifications.

Gather business requirements, code, test, debug, create documentation and implement solutions.

Used Crystal for reporting and primavera as a tool for project scheduling

Implement and support a wide variety of information deliverables in both adhoc and production fashion. Generate and deliver standard reports and files.

Ensure that the databases and data marts are accurate, documented and accessible.

Recommend various methods of improving efficiencies in database design, programming tools and coding methodologies for business analysts and the department.

Employ several programming languages of varied utilities to access information systems for supporting the information needs of marketing and other departments.

Support the campaign process by developing the interim information deliverables required for decisioning and creating campaign files to populate mail, telephone and internet channels.

Develop code to generate information deliverables and assists other analysts in other departments regarding the use of information sources to satisfy information requirements

Analyzed business and all other data processing problems for application to electronic data processing systems

Configured user requirements, procedures, and problems to automate or improve existing systems and review computer system capabilities, workflow, and scheduling limitations using Oracle, Unisys Software, MS Access, SQL

SYSTEMS SPECIALIST, TATA INFOTECH/ TATA UNISYS LTD, Mar 1995 to Aug 2001 Various Locations in US and UK and Mumbai, India

As of February 20, 2006 Tata Infotech Limited was acquired by Tata Consultancy Services. Tata Infotech Limited provides information technology (IT) products and services in India and internationally. The company operates three divisions: System Integration Services, Manufacturing Services, and Education Services. The company was established in 1977 and is based in Mumbai, India. Tata Infotech is a part of Tata Group, India

Assigned to various projects at client sites to represent Tata Infotech and performed the duties of System Tester, Programmer Analyst, system Analyst, software Trainer, QA, Team Leader and more over a 6.5 year tenure using various platforms (Unisys, Oracle, Microsoft)

Assignments:

Nationwide Insurance, Columbus OH (2 Months)

Unisys, Malvern PA (10 months)

Unisys, Puerto Rico (5 months)

City of Hayward, CA / Mumbai India (10months)

Bank of Scotland, Milton Keynes, UK (2 months)

Banco Cafetero SA / Mumbai India (5 months)

CMIG, Bristol UK (18 months)

LTRIMS / Mumbai India (4 months)

Laclede Steel, St Louis MO, (8 months)

Job Service ND, Bismark (8 months)

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

Unit Trust of India Children’s Gift and Growth System:

In charge of development and maintenance of the Children's gift and growth system CGGS for UTI

TRAINING

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

Godfrey Phillips is one of the leading organizations in the cigarette industry in India. The Provident Fund system was developed & implemented to process the Governmental laws as relating to the salaries of the employees.

The system was developed on UNIX System V Release 3.0 & the RDBMS UNIFY 4.0 The programming language was UNIFY ACCELL. Activities included Requirement study & detail design, development, acceptance testing & implementation of the system

Contact this candidate