Farooq Chandiwalla

PROFESSIONAL SUMMARY

** ***** ** ********** ** Business Analysis, Data Analysis, Data Research, Data Extraction and Report Writing.

Experience in gathering business requirements and gap analysis.

4 years’ experience in creating Tableau reports, identifying data sources, writing SQL views and stored procedures in SQL Server 2008, using management studio.

Strong skills in analysis, problem solving, and customer service management, feasibility, communication and inter personal relations.

Experience with Microsoft SQL Server databases querying data for retrieving data, reading and writing select statements, views and stored procedures.

Experience creating financial, procurement, healthcare, operational and management reports.

4 year experience data Extract Transform and Load (ETL) using Alteryx and Toad Data Point.

TECHNICAL SUMMARY

Alteryx, Tableau, SQL Server 2008, Report Builder 3.0, SQL Management studio, SSRS, Crystal Reports, MS Excel, MS Access, MS Word, Outlook, Power Point, Visio, OneNote, BI web tools, Showcase Query tool, SQL Server 2012, Visual Studio 2008, Visual Studio 2012, Microsoft Test Manager.

PROFESSIONAL EXPERIENCE

CAMBIA HEALTH SOLUTIONS

Data Reporting Analyst Sr. (8/16–9/20) –Left to take time off to support family need.

Duties: to support wellbeing department for management and operational data reporting, writing queries, procedures documentation, and performing Extract Transform and Load (ETL) on various forms of data for reporting and tracking wellness engaged member’s activities and their incentive payoff.

Maintained existing dashboards and developed new dashboards via Tableau Desktop Designer (2020.2.4 version) for data analysis.

Developed Power Point Templates for presenting wellness engagements by customers and their employees.

Used Alteryx (2019.4 version), and Toad Data Point (4.3.0.718 64 bit version) for preparing reporting data.

EPIQ SYSTEMS, INC.

Data Analyst (5/14–10/15) - End Of Contract

Duties: programming queries and stored procedures and performing Extract Transform and Load (ETL) on various forms of data loading it into a common production system utilizing SQL Server as a backend.

Converted stored procedures into T-SQL from VB to replace the Data Junction application systems.

Converted stored procedures into T-SQL from COBOL to replace Main Frame System.

Performed QA/QC on Payment Process, Initial Customer Data Process, and Mass Update Process.

IBM SETERUS

Operations Data Analyst (9/13–3/14) - End Of Contract

Develop operational and financial reports for senior management and line level staff for use in tracking and monitoring business unit performance.

Keep organized records and maintain system data requirements, codes and tables for area of responsibility.

Rewrite SQL Server Queries to improve performance time.

Write macros to automate report preparation process in MS Excel.

Re-designed LossMitScoreCard for analytic reporting services department.

Learned some of the mortgage business terms and processes, such as, liquidation and retentions.

FOOD SERVICES OF AMERICA - Scottsdale, AZ (working remotely) 1/07–8/13

Data Analyst (9/12–8/13)

Responsible for converting reports from a newly acquired company.

Identified critical reports, converted in SQL Server, Excel, and using other in house query builders.

Utilized Excel for Pivot Tables and data validation.

Utilized SQL server 2008, created SSRS reports, created views and stored procedure for data extraction.

Environment: Excel, Pivot Tables, SQL Server, Excel, query builders

Systems Data Analyst/Reports/SQL Developer (1/07–7/12)

Maintained and developed SSRS reports using SQL Server 2008, SQL Management Studio, created views and stored procedure for data sources.

Managed and created SSRS reports subscriptions for users in Sales and Merchandising departments.

Responsible for supporting and training staff.

Utilized various software for BI data matrices and report creation including: Access, Excel, Word, Outlook, Power Point, Visio, OneNote, Portal, BI web tools, and Showcase Query tool.

Develop Ad Hoc Queries for analysis and decision making.

Coordinated and managed IT related projects for the Department with the Corporate IT Team.

Prepared documentation for the report development and preparation.

Created reporting tables from AS400 into Access for quick data analysis and reporting.

Created automation for data extraction processes.

PROVIDENCE HEALTH SYSTEM - Portland, OR 1/03–12/06

Data Extraction Analyst II

Managed multiple automated business data extraction processes.

Gathered report requirements, developed reporting tables and utilized Crystal Report software as per Providence’s methodology throughout project lifecycles.

Successfully managed and completed several projects including:

oCreated and delivered staff training on MS Office, accessing enterprise reports, Excel, Power Point, and basic computer application.

oImproved Procurement Data Analysis Process Efficiency by 75%., developed users training documentation, provided users training.

oSaved thousands of dollars in efficiency costs by producing an improved invoice data access process for AP department.

oWA and CA HR Processing Reports. Project leader in the design, created the new reports and data extraction process.

PORTLAND PUBLIC SCHOOLS DISTRICT - Portland, OR 1/99–10/02

Programmer Analyst

Successfully managed and completed several projects: Implementation of new financial reporting system project delivering automated and ad hoc reports to staff, Project lead in the reports requirements gathering, design, creation and implementation of Financial and Procurement operational and management reports.

Coordinated and communicated with cross functional teams.

EDUCATION

MS - Engineering Technology Management specialization in Project Management, Portland State University, Portland, OR – Graduated 2004

BS - Information System specialization in Quantum Analysis, Portland State University, Portland, OR – Graduated 2002

CERTIFICATIONS

70-561 Microsoft .NET Framework 3.5. ADO.NET Application Development using C# programming language– Microsoft Certification Received

70-433 Microsoft SQL Server 2008, Database Development – Microsoft Certification Received

Contact this candidate