PROFESSIONAL SUMMARY:

• Over 12+ years’ experience as a Sr. Business Analyst/Data Analyst/UAT with good management skills, requirement writing, data analysis and User Acceptance Testing (UAT) of Commercial and Enterprise applications.
• Strong experience working with Data Warehousing related projects, Data Analysis and GUI applications.
• Extensive business knowledge of systems in the Health Care Industry, Mortgage Industry (Finance & Accounting) & IT Sales/Marketing Industry.
• Extensive use of techniques and methodologies like RUP, Conceptual Model, Behavior diagrams and designing Metrics for end users.
• Good Knowledge of Quality Assurance methodologies and strategies with understanding of Software Development Life Cycle (SDLC)
• Conversant in a broad range of technologies and tools, including business process tools such as MS - Project, MS-Visio, MS-Excel, MS-PowerPoint, Data Analysis/requirement gathering tools.
• Strong Analytical and Documentation skills, functional knowledge of systems in Financial, Insurance and telecom market.
• Exceptional ability to build productive relationships with colleagues, clients, and vendors across all functional and technical disciplines, providing focused management, accurate, detailed business and systems analysis.
• Extensively involved in managing UAT sessions, Test planning, Test design, writing Test cases, Test automation and Test execution of ERP, Client Server, Web, Data warehousing applications.
• Requirements Gathering: Managing Requirements gathering sessions, facilitating Joint Application Development (JAD) process with client to analyze client business needs, identify system requirements, and design software solutions.
• BI Tools: Hyperion System 11.1.2, Hyperion Planning, Hyperion Financial Management (HFM), Hyperion Essbase 11.1.2, Hyperion Financial Reporting Studio 11.1.2, Smart View 11.1.2, Hyperion Enterprise 6.5, Hyperion Retrieve, Business Objects (BOXI End User)
• Excellent communication and interpersonal skills, team player and self-starter.

TECHNICAL SKILLS:

Software: MS Office Project, Excel, Visio, Power Point, MS Word

Languages: Visual Basic, PL/SQL

Operating Systems: UNIX, Windows NT4/2000/2003

Databases: MS Access, QuickBooks, Oracle 9i/8i, SQL Server 2000, PeopleSoft GL 9.1

Methodologies: RUP, UML, SDLC, Six Sigma

Web Development: HTML, FrontPage 2002

Others: Rational Rose, DOORS, Rational RequisitePro, Remedy, ClearQuest, Rapid SQL (Query Tool), TOAD, HP Quality Center, SharePoint, BMC remedy, ALM

BI/Reporting Tools: Hyperion Planning (11.1.2), Hyperion Financial Management (Consolidations- 11.1.2), Hyperion Essbase (11.1.2), Financial Data Quality Management (FDM-11.1.2)

PROFESSIONAL EXPERIENCE:

Confidential

Business System Analyst

Responsibilities:

• Work closely with the stakeholders and DOE users to support the FDS 2.0 project.
• Contributed to build documents to educate the users on the business process by using new implemented systems for budget execution.
• Created SOP’s to document the System Change Request after the FDS 2.0 go live.
• Resolved issues experienced by users throughout the country and on-site by WebEx sessions to train, debug and document CR/enhancement (Dev/Non-Dev).
• Lead requirement gathering sessions for enhancement of various business process changes which required changes in Webform, Smart List, Reports, Business Rules, metadata updates.
• Created the BRD’s, FSD’s and Detailed Design Specs for various new reports as well as developed the reports using Hyperion Financial Reporting Studio.
• Lead development of various Books and Report requirements like Prior year, new reports and enhancements to existing reports.
• Debugged business rules while developing new reports by updating code, substitution variables and tested the same via smart view.
• Debugged calc scripts in Essbase for various process when reported issue.
• Administered and executed Security/Access/mapping for users.
• Performed financial analysis and Data Analysis using SmartView.
• Worked with STARS (GL), IDW (Data warehouse), STRIPES for better understanding of business process and Data integration between the various DOE systems.
• Worked with implementation, development/Technical resources and created Test plans, use cases and performed regression/UAT testing for the enhancements.
• Lead and executed the Disaster Recovery Testing.
• Performed analysis using MS Access and developed test queries.
• Worked with Data integration team and helped developed SQL queries to extract data from GL.

Confidential

Business Analyst

Responsibilities:

• Worked closely with the Fresenius business community and Project Bottom Line integration partners to balance functionality, speed to market, and project budgetary constraints.
• Worked with Reporting Track lead to ensure adequate associate and knowledge transfer is accomplished to support eventual Fresenius support of the newly implemented reporting tools.
• Ensured required project deliverables are produced and the project develops the deliverables necessary to demonstrate it meets audit requirements.
• Created and supported enterprise-wide project management standards for system design, implementation, and production deployment.
• Participated in applicable design and development reviews to ensure tools are properly implemented and leveraged to efficiently and effectively meet business objectives.
• Established priorities for self and, where appropriate, others, allocating own time effectively to meet Project Bottom Line goals in a manner that does not disadvantage other associates or groups.
• Demonstrated an awareness of personal strengths and areas for improvement and act independently to improve and increase skills and knowledge.
• Created the BRD’s, FSD’s and Detailed Design Specs for various reports.
• Worked with Business to gather requirements for existing and new reports and providing solutions for the existing reports.
• Conducted report rationalization sessions to understand the reports for various user groups and consolidated various reports with the help of new tools.
• Worked on creating the outline and calculation scripts in EAS (Essbase Administration Console).
• Provisioned users in the application.
• Worked with internal and external auditors for SOX compliance.
• Provided the FDM and Hyperion security reports to the financial application manager to help prepare the quarterly URM (User Responsibility Matrix) reports.

Confidential

Business Systems Analyst

Responsibilities:

• Interfaced with stakeholders and facilitated communication between client and the IT department.
• Involved in creating targeted questionnaires and interviews for SME’s, clients and business users to gather requirements.
• Involved in Feasibility and Risk Analysis to identify the business critical and high-risk areas of the application.
• Worked as a liaison between business users and developers to submit requirements and changes, clarify questions and issues.
• Extensively experienced for organizing and documenting requirements, preparing use cases, writing business documents and reports in Pre- Testing phase.
• Prepared use case documents and utilized MS Visio to create UML diagrams including use case, activity and class diagrams to extract business process flows and workflows.
• Participated in JAD sessions for requirement, feasibility and risk analysis with various stakeholders, including designers, developers, QA and management to identify critical and high-risk areas of the application.
• Collaborated with the QA team in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements.
• At the end of the project we were able to generate security reports which were used by internal /external auditors and application managers.

Confidential, Wilmington, DE

Business Analyst/UAT

Responsibilities:

• Responsible for the calculations of quarter end statistics for budgeting & analyst earnings calls.
• Credit Loss Accounting System (CLAS)
• Planned, coordinated, and monitored project levels of performance and activities.
• Created user requirements document for company-wide reports by communicating with end users and developers.
• Managed a multilevel responsibility matrix providing senior leaders with a thoroughly operative report management and problem-solving platform for the creation of crucial financial reports.
• Performed internal audits as appropriate to meet any internal control objectives or audit goals. Reviewed controls over the transaction life cycle for financial reporting (SOX) applications.
• Maintained documentation and requirement traceability matrixes (RTM); conducted gap analysis.
• Reviewed test cases written by team and made modification for better execution of test cases.
• Performed in-depth quantitative analysis and data analysis; extracted data from existing data source and performed queries by using SQL to cater to the ad-hoc report requests.
• Analyzed and validated the mappings for the source and target system.
• Worked with the BI Planning technical teams on a day to day basis.
• Worked with the Data warehouse (DW) teams in understanding the data being extracted using the ETL processes.
• Responsible for providing primary leadership in designing, leading, and directing all aspects of UAT Testing for the data warehouse.
• Worked closely with business users, developers and the QA team assigned to the particular domain in gathering and documenting the testing effort for the PWC audit.
• Reviewed success of functional, regression and end-to-end testing done by the team.

Confidential, Washington DC

Business Analyst

Responsibilities:

• Worked as a business operations analyst to build, manage and cater to the needs of existing and new customers.
• Responsible for defining the scope and implementing business rules of the project, gathering business requirements, and documenting them textually or within models.
• Understand and articulate business requirements through user interviews and JAD sessions with business stakeholders and then convert requirements into technical specifications.
• Use RUP methodology and follow iterative, Use Case driven process for requirement documentation and deployment.
• Responsible for reviewing requirements, creating screen mock-ups of the application and Business Process Flows using Visio.
• Act as a liaison and walk through the Business Requirement Document with the Technical group, to identify the technical constraints/restrictions that may have an impact on the Application development and to find alternatives for the identified issues to meet the proposed requirements.
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Create the UAT plan, UAT strategy and test cases along with expected results.
• Documented Requirement Traceability Matrix (RTM) in RequisitePro and MS-Excel for traceability of requirements through test cases.
• Day to Day Project Management activities performed: Set Timelines for project deliverables, Issues tracking, establish priorities, make recommendations and manage expectations, escalate issues, provide daily and weekly updates to team members.
• Reviewed Test plans, Test cases, Test case execution using specification documents with Test Director.
• Overlook User Acceptance testing (UAT) and create tickets for all defects and enhancement requests.
• Ensured compliance of project operations are met at every step.
• Responsible for developing and distributing the Balance Reconciliation reports to senior management.

Confidential

Business Analyst

Responsibilities:

• Interviewing Subject Matter experts and coordinating with multiple departments that provide data to the warehouse.
• Mapped data requirements to other systems, documented and communicated requirements to systems development team.
• Document and review system requirements, functional design specifications and obtain client sign-off for all deliverables.
• Managed various aspects of project lifecycle including problem definition, scope definition, business requirements gathering, data mapping, design interface development, UAT,, documentation and user support.
• Evaluate client business/system procedures and recommend efficiencies when applicable.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.
• Conducted Requirements and Design walkthroughs with the business area, designers, developers.
• Assumed ownership as the analytical lead for various projects, as well as business/system development, reconciling to source systems, issue resolution and implementation of new applications.
• Generating regular Audit reports and responsible for analyzing data sources and effectiveness and integrity of data.
• Designed, planned and implemented UAT strategies, test plans and scripts. Created expected results and performed tests in accordance with project plans.
• Ensuring data compliance and standardization of Database.
• Performing accurate recording, analysis, and validation and updating of critical financial module data, within the established deadlines.
• Assisted with the enforcement of project deadlines and mentor junior staff on an ongoing basis.
• Train internal clients on the various financial applications we support (i.e. Expense Reporting, and numerous proprietary applications)

Confidential

IT Sales Analyst

Responsibilities:

• Sales Specialist - catering to Defense & Security for the requirements of servers, storage and networking.
• Deliver personalized product/service recommendations.
• Achieving individual sales goals and assist with projected team goals by proactively cross-sell existing customers and new customers through rate contract business, business partners and integrated projects.
• MIS, Quarterly login targets in Siebel and reporting to the country manager.
• Tendering to win the contract and Individual defense & paramilitary forces project business.
• Making effective sales presentation on the products to the business partners and key clients.
• Maintaining good contacts within the Defense and security & paramilitary forces, and the ability to preserve and nurture networks and relationships.

Confidential

Unit Manager

Responsibilities:

• Recruiting, and licensing self recruited team of advisors.
• Motivating and updating the team by giving existing and new products presentation to achieve sales target.
• Building relationship with the Client, Sales team and the Organization.