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, attributed views and calculation views.
• Created analytical privileges and procedures for modeling.
• Good understanding of various components of SAP HANA and SAP HANA Studio.
• Data provisioning and data loading.
• Designed and developed the SAP BPC and objects.
• 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.
• Worked on OPEX and CAPEX planning.
• Worked with Drill through functionality, user and report administration.
• Experience in developing the reports, input schedules and journals.
• Experience with strong business analysis skills and a good understanding of the Software Development Life Cycle (SDLC).
• Experience in gathering business and functional requirements, developed the 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 two 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.
• Prepared the models and dimensions according to USGAAP and IFRS accounting standards in consolidation.
• 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 ProTest Director SOAP UI, TOAD, MS Project, MS Visio, MS,Outlook, MS Word, MS PowerPoint, Adobe Acrobat, Informatica 6.4

Operating Systems: Windows, Windows XP

Databases: Oracle, DB2, MS SQL Server, Teradata

Web Technology: HTML, XML, JSP

PROFESSIONAL EXPERIENCE

HANA Developer

Confidential, Irving, TX

Responsibilities:

• Participated in design and development reviews.
• Created attribute views, analytic views and calculation views based on the requirements.
• Worked on projections, Join and Union in the HANA calculation views.
• Worked on filters, restrictions, calculated measures and restricted measures in HANA views.
• Created reports using excel based on the business requirements.
• Worked with BO developers to create reports based on HANA Models.
• Defined a work flow process to be re-engineered and had process boundaries.
• Worked with HANA Live on business suites.
• Extended HANA Live query views and reusable views using extension assistant.
• Used star join features provided in calculation views. Worked on currency conversions and units of measure conversions in the HANA views.
• Identified and worked with ECC table replications using SLT.
• Worked with the authorization assistant.
• Consumed data using the MDX provider in excel.
• Gathered the requirements for the data archive project according to the company records retention policy and schedules.
• Worked on ILM tools for data archiving projects for retention policy and purged the data.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint and MS Visio), Informatica 6.4 and SAP HANA.

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 the 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 the business requirements.
• Worked with the BO developers to create reports based on HANA Models.
• Defined the work flow process to be re-engineered and the process boundaries.
• Created Dimensions and Models for SAP BPC.
• Consumed data using the MDX provider in excel.
• Loaded data into Dimensions and applications from an external source using a flat file.
• Collaborated with the IT and business partners to identify Source Data fields and defined the transformation rules.
• Maintained the exchange rates in the rate application.
• User and report administration.
• Developed business rules and script logic based on the business requirements.
• Created 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:

• Gathered requirements for business definitions, interacted with internal users, developers and management to get a better understanding of the business process.
• 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 teams, users and other stakeholders to refine the functional requirements.
• Tracked and documented changes for the business specifications.
• Participated in design and development reviews.
• Created attribute views, analytic views and calculation views based on the requirements.
• Created Adhoc reports using excel to expose to consume HANA models.
• Defined the 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 defined the transformation rules.
• Maintained the exchange rates in the rate application. Developed the business rules and script logic for currency conversions.
• Used Content Library to publish documents. Developed BPC live reports using drag and drop options and included interactive charts. Developed BPF, audit and work status reports.
• Involved in data extraction and the 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 and MS Visio) SAP BPC, SAP HANA, Teradata, Oracle and Quality Center.

Analyst

Confidential

Responsibilities:

• Gathered requirements for business definition, interacted with the internal users, developers and management to get better understanding of the business process. Created 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 the business partners to identify Source Data fields defined 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 options and included interactive charts. Developed BPF, audit and work status reports.
• Created views and facilitated the reporting requirements.
• Worked on GL and COPA reports.

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

Analyst/BA

Confidential

Responsibilities:

• Interacted with the business users, understood their business process and their current IT systems to facilitate the customization process.
• Gathering requirements for business definition interacted with the internal users, developers and management to get better understanding of the business process.
• 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, provided screen shots/artifacts for better visualization.
• Facilitated JAD Sessions with management, development teams, users and other stakeholders to refine the functional requirements
• Tracked and documented changes to business specifications.
• Defined the work flow process to be re-engineered and processed the 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 a 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:

• Acted as a liaison with management to ensure accurate and timely monthly closings.
• Developed weekly sales and expense reports for management.
• Prepared commercial credit reports for the management.
• Prepared and ran weekly accounts payable checks.
• Set up the vendors in the accounting system.
• Calculated weekly cash requests for vendor payments.
• Completed purchase orders.
• Matched all payables to the purchase orders and reviews.
• Set up the customers in the accounting system.
• Entered cash, deposited checks and processed the manual checks.
• Monitored the aging reports and made collection calls on an as-needed basis.
• Processed the claims by contacting the customers, assigned claim numbers and obtained approval from management.

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