OBJECTIVE

• Looking for a challenging opportunity as an IT / Business Analyst to lead and drive IT, Finance or Supply Chain projects utilizing my IT skills, Education, and 6 years of work experience.

SUMMARY

• Performed as a Lead Analyst, Finance Analyst and Business Admin roles for various clients.
• Expertise in Design, Analysis, Administration of various applications in Client/Server OLAP environment using Hyperion Suite (Planning, HFM, ESSBASE, FDMEE, FCM, FR, SmartView, and Oracle cloud EPBCS), Tableau, Alteryx, Anaplan, MS Smartsheet, Inventory Management tools (TIM, TOM, NIM)
• Worked in Agile, Waterfall using Rational tools, MS Suites, MS Visio
• Installed ERP software and RFID tags on warehouse products which results automated restocking requests decrease workload 20%.
• Currently managing 3 projects at Confidential with various team size between 3 to 12.
• Develop detailed project plan to track project plan to track progress. Measure project performances escalate to management as needed.
• Measured Project performance, report and escalate to management, as needed.
• Translate business requirements into actionable process tasks.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Facilitated Joint Application Development JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• Assess, document, and communicate risks in context with the business operations and potential impacts along with statistical probability of an event and identify systema affected by the defined risk.
• Work with Leadership team to continually identify and implement team processes and workflow improvements. Ensure product backlog is prioritized, groomed, and refined to avoid ambiguity in specification.
• Developed user stories, coordinated with development teams on the solution development and user acceptance testing. And implementation support forAgile project releases related to FP&A applications

TECHNICAL SKILLS

Software: Oracle Hyperion suites, Tableau Desktop, Alteryx, Anaplan Add - in, Smartsheet, MS Teams, MS Office Suite, MS Visio, Cognos, JIRA, PeopleSoft, SAP BO, SAP Ariba, Share point

Database: Net DB, MS Access, SQL, SQL Server, DB2, Oracle 10g/9i/8i

Inventory Mgmt.: TIM (Telecom Inv Mgmt. Sys), TOM (Telecom Order Mgmt. Sys), NIM (N/W Inv Mgmt. Sys)

Modeling Tools: MS Visio, Rational Rose, Rational Clear Case, Rational Pro

OOA Tools: Rational Rose, Rational ClearQuest, Rational Requisite Pro and MS Visio

Testing: UAT for Oracle smart view

Programming: C, C++, C#

Methodologies: Waterfall, Agile/Scrum

PROFESSIONAL EXPERIENCE

Confidential, Collierville, TN

Lead IT Analyst

Environment: Workday, MS Smartsheets, NIM, TIM, TOM, Net DB, Peoplesoft CRM, MS Excel, MS Office

Responsibilities:

• Designing and developing Workday models and integration through Workday connect
• Open modules for user to input data which migrated to immigration portal to generate reports.
• Build and modify reports in Workday.
• Managed a team of 3 for Corporate Forecasting and Rolling Forecast implementations - included hub to model, model to model connections via Actions, formulas driven off of subsets and headcount to drive all of the workforce data.
• Provide industry leading knowledge to analyze and assess gaps, solutions, and recommendations for remediations while working with Carriers including Verizon, Sprint, AT&T, Comcast, Granite, Spectrum, Charter.
• Develop detailed project plan (work breakdown structure) in Smartsheet and built internal trackers for each team for visibility and to track progress.
• Use MS Smartsheet tool for tracking project status of all Circuits for all Confidential operating companies.
• Use MS Excel functions like V-lookup, sum if, count if, Pivot Tables, Macros in analyzing Work Order (Smartsheet) request and open Batch Nexus Tickets in Peoplesoft CRM and Forecast Work Order report.
• Performed Data Validations using Smartsheets and Net DB for Ethernet Circuits
• Use NIM (Network Inventory Management) tool for Forecasting of Routers.
• Create Report Metrics using MS Office tools to track and assess the information to show progress in implementation policies and procedures to secure operations.
• Use Telecom Inventory Management TIM which includes purchase order and Telecom Order Management tool for circuit Details.

Confidential, Washington D.C

Business Analyst/Admin

Environment: Oracle Hyperion Suite, Oracle Data Relationship Management, Oracle Data Integrator, Oracle ERP Cloud

Responsibilities:

• Worked on EPM Systems consisting of several Hyperion Products such as Shared Services, Workspace, HFM, HP, FDMEE, DRM, HFR, SmartView, Essbase Add-In for Excel and ODI
• Managed the Forecasting and Budgeting needs of the Corporate Forecast Planning & Application CFP&A, reporting and cost allocation business group. Perform all monthly, quarterly, and annual GL close process activities.
• Responsible for Systems Support, FDMEE Data Integration Development and development tasks associated with Hyperion Planning, HFM, FDMEE, EPMA, and the Overall EPM System.
• Responsible for the HyperionEPM 11.1.2.3 Environment setup, product installation and configuration, migration of HyperionPlanning applications.
• Performed Monthly and Quarterly close for Corporate Forecast in Oracle Hyperion Planning application
• Worked on ODI to move data from Planning to Oracle Hyperion Financial Management HFM. Also worked on integrations to pull data from EBS and load to HFM.
• Responsible for the timely deliverables of the Oracle HyperionPlanning and consolidation team.
• Run Business rules and Execute Calculation Script in Oracle Essbase
• Fixed Variances for assessment report for Corporate planning monthly close
• Handled user requests on SmartView installs and retrieves, user access issues, data validations and reconciliations to GL.
• Executed monthly rolling forecast for DFR expense plan.
• Tested automation of the statement of cashflow in Oracle HFM.
• Hands on JIRA. Working with team to solve Finance module tickets.
• Created new versions, run exports, and providing data to the downstream systems in Oracle DRM.
• Created and ran action scripts for Master Data changes, creating new version on monthly basis in Oracle DRM.
• Performed User Acceptance testing for Oracle Smart view 11.1.2.5.9
• Worked on proper implementation methodologies to eliminate Bottleneck in the process.
• Created, designed, implemented key regulatory reporting processes using HFM, SmartView and HFR financial reporting.
• Maintain existed SmartView and Oracle Hyperion Financial Reporting reports and create new reports as needed.
• Responsible for developing the operational procedure to produce the annual report.
• Created and updated the HFR reports based on hierarchy changes/impact by performing impact analysis.
• Responsible for Application administration activities such as user security and application security ofHyperion environment. Performed MST execution
• Supported a large development team in migration of legacy SharePoint sites to newly built SharePoint environment.
• After successful decommissioning of Hyperion, ran monthly close in just 15 minutes usingCloud Anaplan.
• Hands on experience in Anaplan Add-in.

Confidential, Wilmington, Delaware

Business Analyst

Environment: MS suites, SQL, Peoplesoft CRM

Responsibilities:

• Re-Designed the fulfillment process for the Client “ Confidential fulfillment”, projected saving for the client is $ 25000 annually.
• Decreased order management process time by 50% opened back office in INDIA for the round the clock work, results increasing in 1000 orders per day.
• Worked on more than 50 clients across UK and China.
• Worked on the Flowchart and Process diagrams, in addition to creating and presenting PowerPoint presentations. Involved in Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Load flat and Excel files into Access database and developed SQL scripts to create desired queries (views) for data analysis.
• Used Adobe software to edit and ensure effectiveness of images, sent images to stakeholders to develop a variety of communication templates, ensure that these templates uphold standards of functionality.
• Produced the detailed System Requirement Specification (SRS) document.
• Generated variety of business reports from SQL Server using excel with pivot table and pivot chart
• Generated Change Request for user requirements, which included Impact analysis and Cost Estimation.
• Used Data warehousing for Data Profiling to examine the data available in an existing database and collect information about data like properties of columns, find functional dependencies, primary keys, and foreign keys and duplicate data columns.

Confidential

Business Analyst

Environment: MS suites, Tableau, SSIS. HP Quality Center

Responsibilities:

• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions.
• Developed various Dashboards using objects such as Chart Box (Drill Down, drill up) List, cross tab etc. using Tableau.
• Created formulas and calculations within Tableau to meet the needs of business logic.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• As Scrum Master maintained the capacity plan, iteration board, sprint backlog, velocity charts and burn down charts. Facilitated all aspects of the Scrum framework, including sprint-planning sessions, backlog-grooming session, daily scrums product demos, sprint reviews and sprint retrospectives.
• Created various reports such as billing payment reports, Billing Grouping Payment, and discount reports. Used HP Quality Center to house all test documentation and report/track all issues and defects.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Planed, defined, and designed data flow processes for data migration to the Data Warehouse.
• Implemented different types of Constraints on tables designed in the data staging area for the migration.
• Created User Defined Function and complex stored Procedure to retrieve the search results and to get well formatted output.
• Used SSIS transformations - Lookup, Derived column, Data conversion, Aggregate, Conditional split, and Send Mail task
• Performed Analysis on Data mapping between different data models.
• Developed a single application to process data from multiple integration points, convert the data for reporting purposes and feed data into mainframe system to be compliant to reporting requirements.