Data Analyst It Support
Resume:
REENA PATEL
Banking Systems and Analyst Consultant
Email: ********@*****.*** 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