Senior Systems Engineer Resume

SUMMARY

Performed a comparative study to evaluate the capabilities of a relatively new Business Intelligence tool, Pinpoint, and Tableau using health care insurance data related to charges and payments.
Translated the real world business requirements already developed in Pinpoint into reports and data visualizations in Tableau to help hospital staff improve revenue and receivable cycle management, delay reduction and trend/pattern mining.
Created reports and dashboards to optimize scheduling efficiency by projecting FTE needs by department, seasonality, function etc. and to evaluate efficiency/productivity by employee, equipment, department, etc.

TECHNICAL SKILLS

Data Warehousing/Reporting and Analytics Tools: Tableau, SAP BI (7.0/7.3/7.4), SAP BI - IP, SAP Business Explorer, SAP Business Objects, SAP HANA (basics), Oracle 11g, Talend Studio, SAS E- Miner, Advanced MS Excel, SAP HANA(basics)SAP Web Application Designer

Language and Other: SQL, SAS Programming, ABAP, R, Visio, Balsamiq, BMC Remedy Tool, HP ALM, Service Now, AWS Redshift

PROFESSIONAL EXPERIENCE

Senior Systems Engineer

Confidential

Responsibilities:

Developed solutions using SAP IP for Budgeting and Forecasting, integrated it CRM and other ancillary systems, and acted as the SPOC for a FTSE 100 client, while working in an agile scrum environment.
Designed and delivered reports based on important Trade Promotion Management related KPIs using Business Explorer and BO that helped business in planning and forecasting each promotion more accurately and efficiently.
Steered a team of 6 comprising of BI and CRM consultants, monitored the project progress, coordinated with clients, global team members and other stakeholders to prioritize the issues and ensure timely and accurate resolutions on daily basis.
Elicited, gathered and documented the design changes, developed crucial functional specification, business flow diagrams and high-level design documents. Provided knowledge transfer and mentored to the junior team members and end users.
Assisted business financial planners analyze the root cause for data inconsistencies during reconciliation process using MS Excel features like pivot tables and v-lookups.
Streamlined the month end reporting process by creating APDs and process chains that removed the dependency on the offshore team, enabling the business to complete their analysis and reconciliations 15 hours in advance.
Performed meticulous gap analysis for all change requests and new requirements, worked with cross-functional teams to provide them with necessary data and inputs for conducting the unit test, user acceptance test and regression test.

Systems Engineer

Confidential

Responsibilities:

Extensively worked on data modeling - multi dimensional data modelling/Star schema and extended star schema.
Developed complex transformations for data extraction (ETLs) from Finance, Sales & Distribution data sources.
Analyzed the recurring issues and automated health checks using scripts leading to a reduction in FTE by 50%.
Created transformations using complex ABAP logics for start/ end routines for data consolidation and loaded data marts that helped business to plan and forecast the products for each promotion more accurately and efficiently.
Designed, created and maintained both custom planning functions and inbuilt functions using Fox formula, formula function and customer exit variables.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship