SUMMARY:

• Seasoned professional with over seven years of experience as an analyst, modeler and developer.
• Well versed with complete architecture (data loading, data modeling and reporting).
• Worked with analytical, attribute views and calculation views.
• Created analytical privileges and procedures for modeling
• Solid understanding of various components of SAP HANA and SAP HANA Studio.
• Worked on SAP BPC legal consolidation processes like BPF, currency translations, intercompany eliminations, account transformations, validations, script logic, business rules, excel based calculations and EPM Tools.
• Proficient in OPEX and capital planning.
• Worked with Drill Through functionality, user and report administration.
• Experience in development of reports, input schedules and journals.
• Experience with strong business analysis skills and an understanding of the Software Development Life Cycle (SDLC).
• Experience in gathering Business and Functional Requirements, developing Business Requirement documents, Functional specification documents, Communication plans, Use Cases, Test Plans and Test Scripts.
• Created and maintained Requirement Traceability Matrix concerning design documents.
• Experienced in elicitation techniques like questionnaires, brainstorming, focus groups and risk analysis.
• Worked on 2 full implementation projects.
• Facilitated JAD sessions and SCRUM meetings, workshops and interviews.
• Excellent in performing GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements and moved from the as - is towards the to-be scenario.
• Extensive experience in Functional and User Acceptance testing (UAT).
• Proficient at adapting quickly to changing work environments with a strong desire to learn new technologies, tools and applications.

TECHNICAL SKILLS:

Methodologies: SDLC, Waterfall methodology, agile methodology.

Reporting/OLAP/DSS Tools: HANA 1.0, SAP BPC 10.0, BW

Other Tools: HP Quality Center, Rational Clear Case, Rational Requisite Pro, Test,Director, SOAP UI, TOAD, MS Project, MS Visio, MS Outlook, MSWord, MS PowerPoint, Adobe Acrobat

Operating Systems: Windows, Windows XP

Databases: Oracle, DB2, MS SQL Server, Teradata

Web Technology: HTML, XML, JSP

PROFESSIONAL EXPERIENCE:

BI Analyst

Confidential, Reston, VA

Responsibilities:

• Gathered requirements and created business requirement document (BRD), documented the overall process as well as functional and non-functional requirements, assumptions and out of scope items.
• Tracked and documented changes to business specifications.
• Participated in design and development reviews
• Created attribute views, analytic views and calculation views based on the requirements.
• Created reports using excel based on business requirements.
• Worked with the BO developers to create reports based on HANA Models.
• Define work flow process to be Re-Engineered and Process boundaries.
• Created Dimensions and Models for SAP BPC.
• Consumed data using MDX provider in excel.
• Loaded data into Dimensions and applications from an external source using a flat file.
• Collaborated with IT and business partners to identify source data fields and to define the transformation rules.
• Maintained the exchange rates in the rate application.
• User and report administration.
• Developed Business Rules and Script logic based on business requirements.
• Create Input schedules and reports.
• Involved in data extraction and conversion between BPC, SAP and non-SAP systems.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio) SAP BPC, SAP HANA.

BI Analyst

Confidential

Responsibilities:

• Gathering requirements for business definition Interacted with internal users, developers and Management to get better understanding of business processes.
• Created business requirement document (BRD), Documented the overall process as well as functional and non-functional requirements, assumptions and out of scope items.
• Facilitated JAD session with management, development team, users and other stakeholders to refine functional requirements.
• Tracked and documented changes to business specifications.
• Participate in design and development reviews
• Create Attribute Views, Analytic Views and Calculation views based on the requirement.
• Create Adhoc reports using Excel to expose to consume HANA models
• Define work flow process to be Re-Engineered and Process boundaries.
• Create Dimensions and Models for SAP BPC.
• Consume data using MDX provider in Excel.
• Loaded data into Dimensions and Applications from an external source using a flat file. Collaborated with IT and business partners to identify source data fields and to define the transformation rules.
• Maintained the exchange rates in the Rate Application. Developed Business Rules and Script logic for Currency Conversions.
• Used Content Library to publish Documents. Developed BPC Live Reports using drag and drop option and included interactive chart. Developed BPF, Audit and Work Status Reports.
• Involved in data extraction and conversion between BPC, SAP and non-SAP systems.
• Created and managed project templates, use case templates, requirement types and traceability matrix.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio) SAP BPC, SAP HANA, Teradata, Oracle and Quality Center.

Analyst

Confidential

Responsibilities:

• Gathering requirements for business definition Interacted with internal users, developers and Management to get better understanding of business processes. Create Dimensions and Models for SAP BPC.
• Data analysis for accounts receivable and create aging reports.
• Loaded data into Dimensions and Applications from an external source using a flat file. Collaborated with IT and business partners to identify source data fields and to define the transformation rules.
• Maintained the exchange rates in the Rate Application. Developed Business Rules and Script logic for Currency Conversions.
• Used Content Library to publish Documents. Developed BPC Live Reports using drag and drop option and included interactive chart. Developed BPF, Audit and Work Status Reports.
• Create Views and facilitate reporting requirements.
• Worked on GL and COPA reports.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio, MS Access, MS SharePoint), HTML, SQL Server, Oracle.

Analyst/BA

Confidential

Responsibilities:

• Interacted with the business users, understanding their business processes, understanding their current IT systems to facilitate customization process.
• Gathering requirements for business definition Interacted with internal users, developers and Management to get better understanding of business processes.
• Created business requirement document (BRD), Documented the overall process as well as functional and non-functional requirements, assumptions and out of scope items.
• Prototyped the ING CCS (ING Credit Card System) application, providing screen shots/artifacts for better visualization.
• Facilitated JAD session with management, development team, users and other stakeholders to refine functional requirements
• Tracked and documented changes to business specifications.
• Define work flow process to be Re-Engineered and Process boundaries.
• Created and managed project templates, use case templates, requirement types and traceability matrix.
• Ensured the testability of the requirements. Involved in creating test criteria and test case flows for user acceptance testing using MS Excel.
• Conducted walkthroughs with the end users and stakeholders (UAT) to gather the modification requests from the user to upgrade or change the specifications for the product.
• Part of functional and knowledge transfer to the technical team.
• Part of user on application functionality and application changes.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio, MS Access, MS SharePoint)

Analyst/Financial Analyst

Confidential

Responsibilities:

• Liaison with management to ensure accurate and timely monthly closings.
• Develop weekly sales and expense reports for management.
• Prepare commercial credit reports for the management.
• Prepare and run weekly accounts payable checks.
• Set up vendors in the accounting system.
• Calculate weekly cash requests for vendor payments.
• Complete purchase orders.
• Match all payable to purchase orders and review.
• Set up customers in the accounting system.
• Enter cash, deposit checks and process manual checks.
• Monitor aging reports and make collection calls on an as-need basis.
• Process claims by contacting customers, assigning claim number, and obtaining approval from management.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio, MS Access, MS SharePoint), HTML, SQL Server.