SUMMARY:

• 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

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, Confidential -SQL, HTML, VB, CRYSTAL REPORT, LISP, VBA

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/CLEARQUEST DEVELOPER

Confidential, Lanham, MD

Responsibilities:

• 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 ( Confidential ).
• 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

Confidential, Rockville, MD

Responsibilities:

• 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

Confidential, Herndon, VA

Responsibilities:

• 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

Confidential, Rockville, MD

Responsibilities:

• 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

Confidential, Mclean, VA

Responsibilities:

• 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

Confidential, Mclean, VA

Responsibilities:

• 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 Confidential 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

Confidential

Responsibilities:

• 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, Confidential and Confidential
• 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)

Confidential, Mclean, VA

Responsibilities:

• 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

Confidential, Rockville, MD

Responsibilities:

• Worked as a reporting specialist, data analyst and database programmer in MS Access, SQL, Oracle, Excel for the Confidential & Confidential 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

Confidential, Los Angeles, CA

Responsibilities:

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