Developer Data

Location:

Phoenix, AZ

Posted:

May 13, 2020

Contact this candidate

Resume:

Rick Arora

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

**** * ******* **, ********** Park, AZ 85340 623-***-****

Certified leader in analytics & data transformation with 15+ years of extensive hands-on expertise in Business Intelligence (BI), Visual Analytics, Reporting, Data Operations, Data Governance & Data Warehouses (DW). Upgrade reporting to Business Intelligence & legacy tools (SSRS, Crystal Reports, Excel) into interactive, associative dashboards (Power BI, Tableau, QlikView)

Present BI solutions, services, scope, strategy, technology & methodology via proposals to clients & portfolio of existing BI Dashboards & projects

Awards & Recognition

BI application showcased in 2016 Technology Conference Scottsdale AZ Excellence & Innovation

Custom Business Intelligence application displayed as a public-sector demo on QlikView software corporate website

Experience

Listed below are engagements & projects during my 4+ years of BI & IT Consulting in numerous industry segments (6-12 months projects each)

These projects spanned across every aspect of Software Development Life Cycle (SDLC) & Business Intelligence Applications: Requirements Collection, Data Discovery, Project Management, Data Modeling, BI Development, Testing & Rollout

Senior BI Developer/ Architect Innovative Aftermarket Solutions July 2019 – Present

Analyze, design, develop Qlik Sense data visualization dashboards with the Qlik systems suite of products (QlikView, Qlik Sense, NPrinting, Qlik Administration, security & job scheduling (QlikView Management Console (QMC))

Gather business requirements, establish review sessions & perform analysis of current contract & policy source systems reports

Design conceptual model, working model & ensure consistency in architecture & design/code practices

Develop, test & automate data load & transformation scripts to import data from various source systems, data feeds, flat files to display key metrics & automate manually created reports, saving an average of 450 hours per month

Analyze source data, understand relationships, hierarchies, calculations & formulas to automate the data load procedures (ETL Scripts) & eliminate manual data loads and utilization of Excel spreadsheets

Prepare test cases in coordination with business owners & test the applications before deploying to production

Deliver static reports via NPrinting to external users, eliminating the manual creation and distribution of 10+ reports in Excel

QlikView Developer/ Architect Rackspace Cloud Computing Feb 2019 – June 2019

Design & Develop the Utility Bookings QlikView Dashboard for sales teams for Rackspace Cloud based products & support services

Standardize, simplify & automate utility bookings calculations across platforms & products enabling sellers to easily reconcile performance with bookings

Utilize SQL Views to create a global data mart with invoices (BRM) as the source of truth for bookings calculations, & automating the manual work involved in bookings calculations

Develop BI Reporting solutions for business units at Rackspace, using QlikView & Data Warehouse environment, built out on MS SQL Server

Technical Lead / Senior BI Consultant State of Maryland/B&D Consulting July 2017– Feb 2019

Create QlikView BI dashboards, lead project from start to finish including data discovery, requirement collection, data gathering, creating Oracle SQL views, data modeling & QlikView application development, security & training

Define data sources & Key Process Indicators (KPIs) by interviewing key team members, reviewing current static reports & existing database views & procedures

Implement a Parole Case Management dashboard with details related to population, workload, aging of cases for offender management for 200+ users and replacing silo reporting in Excel spreadsheets

QA BI metrics with internal & external team, write test cases, debug issues, implement changes in Dashboard & Data Warehouse

Design customized security with document chaining & URLs to create a seamless experience for BI application users with links to existing applications

Technical Lead / Senior BI Developer Adecco Staffing Group/B&D Consulting Nov 2017– March 2018

Manage, lead & assist in all phases of development for HR BI dashboard implementation. Plan & design business matrix, detailed requirements for HR Business Intelligence MicroStrategy application for worldwide Staffing firm

Collect data from disparate sources for staffing company, define metrics for headcount, terminations, retention, new hires, online surveys to present a Dashboard for Executives & Power Users

Build structure, define standards and Master Data Management guidelines for staffing data with SQL views, procedures & pre-calculated metrics to create reusable repository for development team

Design dashboard layout, navigation & collaborate with HR executive team, utilizing fast paced, iteration based agile methodology

Create detailed requirements, Data Dictionary, Key Performance Indicator formulas, test cases before start of development to follow the agile development process

BI Technical Lead / Developer Sunlight Financial/B&D Consulting Jan 2017–June 2017

Plan & design data model & data mart for Business Intelligence to organize data for Sunlight Financial reporting

Collect data from disparate sources for solar loan application processing, define custom loan stages, build structure, define standards for loan milestones with SQL views, procedures & pre-calculated metrics

Implement short term solutions, SQL Server Reporting & subscriptions to automatically deliver reports to internal & external users until long term Improvements are implemented

Explore BI tools & Data Warehousing available in the marketplace, present BI & DW options to client for advancement in the BI roadmap

BI Senior Consultant / IT Lead State of Arizona/B&D Consulting August 2015–November 2016

Create Award Winning BI dashboards, lead projects from start to finish including data discovery, requirement collection, data gathering, SQL scripting, data modeling & QlikView application development, security & training

Define data sources & Key Process Metrics by interviewing key team members, reviewing current spreadsheets & existing database tables, procedures & reports

Build & enforce security for QlikView Users, schedule import jobs via QlikView Management Console & share dashboards via Qlik View Access point

BI Technical Lead Bechtel Corporation June 2014 – August 2015

Build & Enhance 6-7 executive level dashboards using QlikView & numerous data sources to fill gaps in reporting & provide an

inclusive reporting interface for executive senior level management team

Manage, repair & improve 7-8 data interfaces between Bechtel University Learning Management System (LMS), reporting, Certification Applications & existing QlikView Dashboards

IT Manager / Reporting & Data Operations Mirixa Corporation May 2007 – May 2014

Lead reporting & data operations for 15+ Fortune 500 customers with a team of 5-6 developers, IT business analysts & cross functional project teams of 20+ members in multiple locations

Create standards, procedures, policies, process flows to build, streamline & improve the reporting & data operations processes, reducing expenses & defining areas for potential revenue increase

Automate entire data feed ingestion process (200+ tasks) by utilizing Automate software, JAMS & PowerShell scripting to build wake up & execute processes

Senior Reporting Developer Sprint Telecommunications June 2005 – April 2007

Provide business analytics, trending data to prepare for contract negotiation leading to increase in sales by 15%

Create & modify Oracle PLSQL procedures, packages, functions for Sprint Nextel coupon process to provide new promotions, discounts to eligible customers

Senior Developer/Report Admin Department of Homeland Security May 2004 – May 2005

Lead migration project to transfer 2 million rows of training & certification data for 400-500 airport screeners from Lockheed Martin, Boeing databases to TSA database to create a seamless training & education portal for TSA personnel

Detect limitations in reporting tools, streamline manual procedures, create project plan to replace current Oracle Discoverer Plus version with a more robust version of the software

Administer Crystal Reporting databases, create complex data views & enhance data access, creating a pre-calculated presentation layer of metrics for future reporting

Senior Oracle Developer / Team Lead Florida Rock Industries April 2003 – April 2004

Reengineer Block & Building material process including Oracle forms, packages, reports utilizing Developer 2000 & Oracle Designer 6i in Windows NT environment to expand business product line, increasing revenue by 15%

Senior Oracle Developer MEM Employers Mutual Insurance December 2001 – April 2003

One Stop Shop - Implement IS projects & resolve software bugs through all steps of Oracle life cycle development from Impact Analysis, coding, testing to implementation in production environment

Team Lead / Oracle Developer ReturnBuy.com September 2000 – December 2001

Perform start to end testing & development for improvements related to eBay auction process, build custom software with a team of 3-4 developers to integrate web application with Oracle Applications & contribute in making internet startup profitable

Application Developer / Process Improvement MCI WorldCom, Bell Atlantic, AT&T October 1992 – May 1998

AT&T Long Distance Billing October 1997 – May 1998 MCI Local Billing Solutions March 1997 – October 1997

Bell Atlantic Quality Billing Ctr March 1996 – March 1997 MCI Process Improvement October 1992 – March 1996

Education

o1989 George Washington University, D.C. Psychology Bachelor's Degree

o2000 University of California, Los Angeles Oracle 8i – DBA Certification Classes

o2012 QlikView Developer & User Interface Training

o2018 QlikView Certification

TECHNOLOGY

QlikView, Power BI, Tableau, MicroStrategy

Cronacle Job Automation

SQL Server, SSIS, SSRS

Network Task Automation, JAMS

Oracle Forms, Oracle PLSQL, Oracle

Designer, Oracle Discoverer, Oracle

Reports, Crystal Reports

SharePoint

PowerShell Scripting

AREA OF EXPERTISE

Reporting & Business Intelligence

Extract Transform Load, ETL

Software development lifecycle

Job Scheduling Automation

Change Management

Database Operations

Business Process Management

BPM

Process Improvement

Data Modeling

INDUSTRY

Startups

Banks & Financial Institutions

Healthcare

Telecommunications

State & Federal Government

Defense

Insurance

Pharmacy

Online Auctions

E-Commerce