Awais Ali
Valley Stream,NY
Summary
6+ years of IT experience including 4+ years of proven track record in OneStream, Management, Financial Modeling/Analysis, Budgeting, and Client Management. Experienced in leading teams of varied types/sizes and possesses excellent analytical, problem solving, communication and interpersonal skills. Involved in Creating Financial Statements Reports. Capable of managing an organization's data, assess and fulfill its reporting needs and develop powerful BI solutions that have true impact on the performance of a company. Expertise in gathering and analyzing the requirements of users and translating them into specifics Cube Definitions and Design. Maintained database optimization while performing Data Loading, making Business Rules, Calculation Scripts, and Report Scripts. Proficient in building Dimensions, Attributes using Rules files and loading Fact data in OneStream applications by means of several build methods such as generation, level and parent-child references. Experience in development of OneStream application with Forms, Business Rules, Menus, Task List, Smart List and Application Migration. Outstanding Communication, Interpersonal, Written, Analytical and Problem-solving skills. Excellent ability to understand Complex Scenarios and Business Problems and transfer the knowledge to other users/developers in the most comprehensible manner. Created customized Financial Reports using different tools like Hyperion Financial Reporting Studio according to the client requirements. Ability to perform Life Cycle Management utility to migrate artifacts from one environment to the other. Extensively involved in Maintenance, Automation, Backups, Performance tuning and Optimization of cubes and Calc Scripts to facilitate effective business decision making.
Overview
6
6
years of professional experience
1
1
Certification
Work History
OneStream Consultant
Red Hat
Raleigh, NC
07.2019 - Current
- Involved in discussions and gathered requirements with Business Users to Implement multiple enhancements which were required for Application to Go-Live
- Analyzed Data and Current Process to resolve all the pain points for Consolidation Solution
- Involved in creating/maintaining Extensibility and Shared dimensions to utilize these dimensions within OneStream Cubes
- Updated and Created multiple Data Sources and Transformation Rules to bring data from Flat File and updated NetSuite load process to modify logic and to bring new entities into the system
- Created Data Management jobs to run Business Rules, Consolidate, Copy Data, Clear Data etc
- Created XFBR, Extensibility BR, Finance BR and Formulas for Business Process, Allocation, Calculation and Consolidation purposes
- Created Complex Dashboards for Consolidation based on Users Requirements
- Create Cube Views to create Financial Statements Reports (Balance Sheet, Income Statement, P&L Statement, Cash Flow Statement, Statement of Budgetary Resources etc.) based on Users Requirements
- Created Workflow Process based on Scenario and Time to do Planning based on Individual Entity and Business Function
- Designed and updated Admin Guide and User security Process in OneStream for Consolidation, Dashboards and Workflow based on Users Requirements
- Successfully conducted UAT and once approved migrated applications to Production
- After Go-Live to Production, successfully closed Monthly and Yearly Close.
Salesforce Developer and Admin
API Group Inc
New Brighton, MN
04.2018 - 07.2019
- Understanding the requirement, estimating it, and delivering on time
- Configuration and administration of Salesforce.com enterprise editions
- Maintained and customized the Salesforce.com scopes such as users, roles, profiles, groups, accounts, contacts, record types, sharing rules, custom objects, pick lists and page layout
- Used field level security along with page layout to manage the visibility and accessibility of fields for different profiles
- Created Record types, roll up Summary, Workflow rules, Approval process, Auto Response rules and Validation rules to ensure data is validated and automate business logic conditionally
- Set Permissions for users using object-level and Field-level security best Practices
- Created and maintained user profiles, workflows, dashboards on Salesforce.
Education
Associate in electrical engineering -
01.2015
Certification
- Salesforce Certified |Admin
- Salesforce Certified |Platform Developer 1
Modeling Tool
Star Schema, Dimension and Fact tables, Logical and Physical Modeling.
Databases
- Oracle 11g/10g/9i
- MS SQL Server (2003, 2005)
- MS Access
Client Tools
- MS Office Suite 2007
- 2003
- 2000
- 2013
Reporting Tools
- Financial Reporting
- Web Analysis
- Spreadsheet Add-In
- SmartView
- OneStream Cube View
- Dashboards
Languages
- SQL
- PL/SQL
- VB.Net
Timeline
OneStream Consultant
Red Hat
07.2019 - Current
Salesforce Developer and Admin
API Group Inc
04.2018 - 07.2019
Associate in electrical engineering -
- Salesforce Certified |Admin
- Salesforce Certified |Platform Developer 1