Post Job Free
Sign in

Data Financial Analyst

Location:
Chicago, IL
Salary:
50000
Posted:
May 24, 2018

Contact this candidate

Resume:

FEROZ KHAN

312-***-****

***************@*****.***

Professional Summary

IT experience with 4 years and expertise in Salesforce CRM analysis, administration and development

Well versed in analyzing company processes, translating business workflows into accurate Salesforce.com workflows and configuring Salesforce.com to meet business needs

Comprehensive experience in designing of Custom Objects, Custom Fields, Page Layouts, Validation Rules, Approval Processes, Custom Tabs, Custom Reports, work flows, relationships, Visual force Pages, Dashboards, Report Folders and Email generation as per the application requirements.

Proficient in writing test cases for Systems testing, Test Plans for Unit Testing, System Integration Testing and User Acceptance Testing (UAT).

Experience in Data Transformation, Data Quality Analysis, Data Relationships, Source Systems Analysis and Reporting Analysis.

Experienced in Data Modeling and concepts such as Physical/Logical Data Modeling, UML data modeling.

Knowledge of SFDC development using Apex classes, Triggers, Components, SOQL and Force.com IDE

Good understanding of Org hierarchy- Roles, Profiles, Users, object level security, field level security, record level security and sharing rules

Experience working with salesforce.com sandbox and production environments, also with Eclipse IDE Force.com plug-in environments

Worked with various salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads, Campaigns, Forecasts, Reports and Dashboards

Detailed knowledge in the security and sharing model to control user access

Experience in Release management, deployments and documentation of release notes

Good understanding of Software Development Life Cycle (SDLC), AGILE methodologies and implemented SCRUM and SPRINT techniques

Experience in creating Scrum artifacts like User Stories / Backlogs, Burn-down charts

Worked on Elicitation techniques like Interviewing, Questionnaires, Brainstorming, focus groups meetings

Experience in Data Migration and Data Integration using different data tools – SFDC Data Loader, Force.com Import Wizard, SFDC Data Export and Mass Delete

Creation of user stories for the implementation of SOQL and WSDL

Good in adapting new technologies and effectively applying them to projects and operations

Technical Summary

Salesforce Components

Apex classes, Apex Triggers, Apex Custom Controllers and Extension, Visual force (Pages, Components &Controllers), Validation Rules, Dashboards, Reports, Workflows, Custom Objects, Apex Web Services, Sandbox development and testing, Connect Offline, SOQL, SOSL, Ajax Toolkit

Scripting Languages

Apex

Markup Language

Visual force

Salesforce Tools

Force.com IDE plugin, Eclipse, Apex Explorer, Apex Data Loader, Data loader, Visual Studio, Workbench, Excel Connector, Offline Edition, Force.com Migration Tool

Business Modeling Tools

Use case diagrams, Activity diagrams, UML

Desktop Software

MS Visio, MS Word, MS Access, MS Project, QuickBooks Enterprise

Operating Systems

Windows 95/98/2000/XP/2003

Education:

Masters in information security SEP 2017

University of Cumberland, college in Williamsburg,KY.

6178 college station drive, Williamsburg,KY 40769.

B. Tech., Civil Engineering. MAY 2013

Jawaharlal Nehru Technical University, Hyderabad, AP, India.

Project Summary

Deloitte, India feb’14 to Jul’15

Financial Analyst

Worked in collaboration with various Financial Planning and Analysis teams and middle management to support business priorities and objectives through complex financial modeling and ad-hoc reporting

Providing analytical support by conducting research as required to drive and distribute ad-hoc reports/mines and assimilate related data for use in planning and forecasting activities

Distribution of recurring reports for all aspects of management reporting activities leveraging technology and automation

Managing small system enhancements projects in accordance with established SDLC and PMLC methodologies (e.g. Agile, RUP) as directed by the leadership

Various regional reporting packs prepared at month close to give an overview of the revenue, expenses and head count for various business lines

Worked on cost center rationalization to streamline the number of cost centers in the system which is the basis for reporting

Worked on Business Resource Planning tool for the headcount forecasting and reconciliation

Implemented financial trend reports to identify performance issues within the business line and risks or opportunities in current financial plan/estimate

Compiled various management reports such as cost center Reports/Indirect spend /Travel Expense, etc. to provide variance explanation

Supported Ad Hoc requests for data mining and analysis

Sequencing of critically impacting issues to the MIS reporting

Sensomatic, India Jan’13 to Nov’14

Salesforce Business Analyst/Admin

Worked as the sole Salesforce Admin and Business Analyst involved in the application implementation built on the Salesforce platform.

Involved in gathering requirements and converting them into a technical design in implementation of salesforce.com

Interacted with Stakeholders for requirement gathering and implementing in Salesforce

Worked on Sales Forecasting and enhanced the Salesforce tool on customer focus.

Utilized standard objects provided by Salesforce in order to save on development time

Created Custom Objects and Tabs to suit the business needs

Assisted Developers with Apex and Visual force.

Created users, roles, and implemented role hierarchies and sharing rules to manage sharing access amongst different users.

Identify and document customer pain points and business process GAPS, and help customer suggesting best practices and business process model

Acting as the SPOC for managing user access and roles of the Portal users.

Created page layouts, search layouts to organize fields, Search Lookup, Lookup Filters, custom links, related lists, and other components on a record detail and edit pages

Day to day activity of troubleshooting a variety of application issues including configuration,Reporting, Security and Workflow across the application

Defined and refined Data mapping files for Data migration and worked on Data Scrubbing process

Participated in post-production validation and contributed to user manual documentation

HP Support Services, India Apr’12 to jan’13

Financial Analyst

Provided financial application support, report queries, and analysis

Acted as initial point of contact for data questions and resolve through investigation and analysis

Worked directly with the business and suppliers to understand business processes, review current systems and define data requirements

Cross reference/validate data, and execute confirmation of GR to IR required to release payment

Assisted Project Manager with SRM (Supplier POs) workflow and troubleshoot processing errors

Run and analyze various transaction reports in SAP to understand existing usage and identify process gaps

Prepare SOP, work instructions, SOP Process maps on Rolling Accrual, Amortizations, Journal vouchers, Inter-company transactions in GTO (Global Technology Operations)

Reconciling transactions by comparing and correcting data

Monitor and explain variances of data and analytics used in key business processes

Assist in the Quality Control process through the construction of SQL queries and variance analysis to highlight any discrepancies in monthly financial reporting package.

Utilize database querying, budgeting, and forecasting tools (SQL, Microsoft Access) to design process improvements in the financial reporting process

Audit accounting documents such as, invoices, bills and reimbursement claims for accuracy, completeness and compliance with procedures

Reconcile and eliminate discrepancies between supplier invoices and inventory detailed reports

Prepare documents for data processing by assigning relevant transaction codes and account numbers

Sort documents into batches according to data processing requirements

Provided timely reporting of issues that affect project progress and responsible for financial forecasting and tracking; this included documenting, prioritizing and tracking requests (changes, enhancements, etc.)

Solving the SAP vendor block issues, reconciliations of accounts, raising Purchase Order as per the different department manager requirements



Contact this candidate