REENA PATEL

Banking Systems and Analyst Consultant

Email: ad2o0x@r.postjobfree.com Phone: 678-***-****

Highly talented, accomplished Senior Data Analyst and IT certified professional with years of progressive experience in Software Programming and Data Analysis. Strong track record assisting in the efficient operation of business procedures and improving the quality and value of the work performed. Consistent history of reducing costs, improving efficiency, and increasing productivity.

CORE COMPETENTCES

Software Development

Script Writing

Data Analysis

Reporting

Process Improvements

Data Process Management

Software Development Life Cycle Management

Data Cleansing

Professional ACCOMPLISHMENTS

DATA ANAYLST/ IT SUPPORT August 2018 to Present

VIRU Package LLC

Tasked with converting data from ad hoc systems to Microsoft Dynamics Retail Management System.

Provided IT Support for Operations and the leadership team.

Analyze and cleanse big data regularly for inconsistent data and other errors.

Generated various reports to assist with executive decisions. Reports included various key sales performance indicators, operations costs, trending analysis, and other ad hoc reports as needed. Many of the reports were created using SQL language.

Migrate inventory from SQL Server supporting legacy POS system to new cloud based Square POS system.

DATA ANALYST/REPORT DEVELOPER

Alcon Jan. 2018 to Aug. 2018

Demonstrated proficiency with reporting functions of MS-Excel (Pivot charts, pivot tables)

Database construction (MS Access)

Ability to build macros (VB) to automate data collection & manipulation.

Importing of data from various sources (existing Excel files, SQL Server, Business Object) to combine into a single source for analysis.

Demonstrated proficiency with MS PowerPoint to create slide decks and presentations.

Created Control Charts using statistical analysis package (Minitab).

Generate data views from raw data using Tableau.

Building Tableau dashboards and have aptitude for development that improves business processes.

Developed and executed strategic vision of performance reporting, responsible for ownership and servicing of analytics tools.

OPERATIONS DATA ANALYST June 2013- June 2014

First Data Corporation

Successfully participated in the process of converting the manual process of entering client data into internal systems to a semi-automated process in which developers will use to fully automate.

Analyze and cleanse big data regularly for inconsistent data and other errors.

Utilized to oversee the accuracy of reports created by various team members.

Worked with management to improve the external customer experience.

DATA ANAYLST/ IT SUPPORT June 2007 – June 2013

VIRU Package LLC

Tasked with converting data from ad hoc systems to Microsoft Dynamics Retail Management System.

Provided IT Support for Operations and the leadership team.

Generated various reports to assist with executive decisions. Reports included various key sales performance indicators, operations costs, trending analysis, and other ad hoc reports as needed. Many of the reports were created using SQL language.

ACCESS DB DEVELOPER/ CONTENT REVIEW ADMINISTRATOR May 2006 – August 2006

Vanguard, Malvern, PA

Responsible for modifying database for external Integrated Retirement planning system.

Developed new programs in Visual Basics V6.0 to match new business requirements.

Created various documentations and process manuals for internal and external use.

Reviewed accuracy of plan information verbiage/content based on prescribed guidelines.

ACCESS DB DEVELOPER September 2005- April 2006

Citigroup Bank, New Castle, DE

Improved internal operations by designing and developing an Access database to handle their daily Lockbox operations.

Analyze ACH and Electronic Files Processed for accuracy.

Created various documentations and process manuals for internal and external use.

SENIOR PROGRAMMER ANALYST October 1993- July 2003

Chase Manhattan Bank (USA), Wilmington, DE

Assisted with the coding of the new Visual Remittance System (Unisys) from the existing TRW application.

Participated in 2 major systems upgrades in which involved the integration of data, and quality system testing.

Utilized C & SQL Script to convert data files, Visual Basic 6.0 for front end processes, and was used for the back end Oracle 7.2.

PROGRAMMER ANALYST

Responsible for development and maintenance of Payment Processing system.

Participated in the design and enhancements of existing applications in the preparations of Y2K.

Supported applications and systems for end- users.

EDUCATION

Masters of Statistics

S.P. University, India

Major: Statistics, Mathematics & Computer Science

Bachelors of Science of Statistics

S.P. University, India

Major: Statistics, Mathematics & Computer Science

SOFTWARE COMPENTIENCIES

Continuing Education & Certifications:

Data Management and Statistical Analysis (SAS)

FORTRAN 77

COBOL

Visual Basic 5.0 & 6.0

FoxPro

Dbase III+

Systems: SQL Relational Database, Microsoft Office 2010+ (Excel, Word, Power Point, SharePoint, Visio), UNIX, MS-DOS

Applications: Visual Basic 6.0, SAS, Oracle, SQL Server, Tableau Developer 2000 (Forms 5.0, Reports 3.0), Win Runner, Test, AOS/VS

Languages: C, SQL, Visual Basic, PL/SQL, Shell, TSL, Power Builder, COBOL, FORTRAN, Flex, FoxPro, Dbase-III+ & IV, Word Star, Lotus

Contact this candidate