Data Analyst
Resume:
ARCHANA PATEL
Broken Arrow, OK *****
SKILLS
Data Warehousing
SQL Server Database Administration
DB2 User
ETL using Kimball’s Star Schema Dimensional Modeling
Data Analysis
Dashboards
Financial Analysis
Data Visualization
Data Mining
Data Dictionary
SharePoint Administration
Data Migration
Problem Solving
Reporting
Technical Support
Data Entry
Documenting
Customer Service
TOOLS
SQL for MS SQL database server
SAS
SQL for IBM DB2 database server
Crystal Reports
SSIS, SSRS
Windows and Mac OS platforms
Lotus Notes
IBM DataStage
MS Office (Access, Visio, PowerPoint, Excel, Word)
IBM Cognos Framework/Power BI
Quickbooks
IBM Data Architect (IDA)
IBM Fast Track
EDUCATION
Graduated from Dalton High School in Dalton, GA
Some College at University of Georgia in Athens, GA
Some College at Tulsa Community College in Tulsa, OK
Online courses with multiple institutions for learning and assignments for SAS, AWS, Java, Angular, React, HTML, and CSS
EXPERIENCE
08/25 – 08/25
Okie Staffing — Assigned to the City of Coweta in Coweta, OK
Administrative Assistant
Greet visitors and manage the front desk operations, ensuring a welcoming environment.
Handle multi-line phone systems, directing calls appropriately and providing excellent phone etiquette.
Perform data entry tasks with accuracy and attention to detail.
Maintain organized filing systems for easy retrieval of documents.
Assist with communications in various departments
Provide customer support by addressing inquiries and resolving issues promptly.
Utilize Microsoft Office (word, basic excel, outlook)
Scan and organize documents and other items as required
Proofread documents/checks to ensure clarity and correctness before distribution.
Collaborate with team members on various administrative projects as required.
Make runs to the local bank and post office
1
10/24 -11/24
Mindlance Inc — Assigned to Blue Cross Blue Shield in Tulsa, OK
Investigation Specialist
Data Entry of details from customer service calls
Investigate medical claims that seem suspicious by customers
Investigate fraud enrollment by members
Communicate pertinent information to designated departments of findings
Provide excellent customer service and answer any questions for our clients
06/23 - 12/23
Priority Staffcorp — Assigned to Tulsa Club Hotel in Tulsa, OK
Front Desk Clerk
Enter data audit financials
Greet clients as they enter the lobby
Data entry of registration and assign rooms to guests
Confirm phone and online reservations
Respond to guest needs, requests, and complaints
Collect payment from departing guests
Keep records of occupied rooms and guests
Communicate pertinent guest information to designated departments
Provide excellent customer service and answer any questions for our clients
09/22 – 04/23
Oklahoma State University, Institute of Technology — Okmulgee, OK
Database Administrator
On call support with DB2 Subsystems and DB2 Tools
Work with IBM Level 2 support.
Design ad-hoc SAS data analytics and complex queries for the multiple departments at the university
Create, manage, and support DB2 Stored Procedures
Provide DBA and application developer support
Provide on-call support including nights / weekends / holidays on 24 / 7 rotating basis
Research data governance
Provide advanced Excel reports primarily pivot tables
Used KPIs to deliver existing academic reports to executive staff on a timely manner
Provide technical assistance with reporting as needed.
03/22 - 07/22
Linen King
Admin Assistant
Because this was the headquarter, I created sales, expenses, and services rendered reports of the Linen King locations
*During this gap, I was taking online courses for SAS to stay competitive in the work force.
05/21 - 08/21
Alltran Financial — Tulsa, OK
Collection Agent
Made outbound calls for collections to consumers
Empathize with consumers and provide a calm, positive experience
05/20 – 07/20 (on furlough until 08/20)
Pyramid Consulting – Assigned to DXC Technologies in Tulsa, OK
Call Center Agent
Troubleshoot and provide phone support with iPads for the parents & staff members for the Dept of Education for New York City
*2019—During this gap, my father passed away so I took some time off for funeral preparations and to tend to my mother in Georgia and then in India.
*2019—Multiple partners joined together to start a gardening venture
*2017 - 2018—During this time, I took classes on Java, Angular, and React
*2016—Although I didn’t get paid, I assisted a friend (Sucilla Dutta) at Gill’s Truck Wash in their kitchen
05/12 – 11/15
ABB – Bartlesville, OK
Business Analyst
Administered over ten SQL database servers which involved updates of tables/security patches, create groups/user security, back-up/restore files, data migration
Query hundred thousands of parts and products relating to measuring products
Administer Active Directory security for the network
Maintain Microsoft Access programs using VBA
Thoroughly test and provide a test copy of modifications along with details of the updated product
Provide desktop support to departments through out the facility
Administer SharePoint sites for internal and external clients
Created and maintained reports through through SAS, SSRS, SharePoint, Visio, MS Access, and Excel
Conducted business processes to internal and external clients for software requests
Worked closely with enterprise-wide employees, customers and vendors for assistance in data mining and data patterns of products that can expand their sales
Troubleshoot various computer software, hardware, and peripherals used in all platforms
Created an application to maintain help desk requests
10/11 – 06/15
Top That Pizza – Tulsa, OK
Owner
Managed and trained a crew of approximately 20 employees
Maintained inventory through data mining reports to determine product needs
Exhibited strong customer service relations
Completed payroll on a timely manner
Performed daily business operations
08/08 – 10/11
McJunkin Red Man – Tulsa, OK
ETL Developer & Data Architect
Was hired initially as a web developer
Received training for ETL and Dimensional Modeling Certificate from Kimball University and through IBM to focus on the company’s new Data Warehouse
With a group effort, we used database design concepts for the DB2 server tables using the Star Schema model
Performed data migration by extracting data from VSAM files, transformation, and loading using IBM’s DataStage
Designed complex SQL queries that would also transform and load datasets into the DB2 database server
Accurately provide data analytics for more than a billion records for an inventory table and over a million records in the sales table
Validated the integrity of the data
Created data models in IBM’s Data Architect (IDA). This entailed creating models and maintaining the copybook, staging, dimension, and fact tables.
Maintained meta data through Microsoft Visio, IBM’s Fast Track and IDA
Used Master Data Management for data definitions, data profiling, and data quality
Used Change Data Capture to get near real time transactional data
Created projects and imported metadata into the Cognos Framework Manager
Created and published Cognos packages for the company’s dashboard
09/04 – 08/08
EPES Software – Bixby, OK
Software Developer
Design, develop, and test new programs affiliated with schools using Visual Basic, Microsoft Access, and Microsoft SQL Server Express databases
Provided accounting reports using Crystal Reports
Maintain and modify existing programs for one of the leading school accounting software in the United States
Maintained Wise Installation packages to deploy at schools
Assist in customer support calls for schools’ in-house programs and Excel reporting
Created an application to maintain help desk requests
08/96 – 10/04
First Data Corporation
PC Software Development Analyst
Analyze various First Data's departments and their processes
Create and query databases and reports using Visual Basic, Access, and Excel
Design, develop, test, and maintain programs and SQL databases
Incorporated data mining to better relay the results of typing speed, accuracy, and statistics for the credit card approval/denial statistics
Write supporting documentation for business processes
Create training material and books for users regarding company software and applications that I developed
Operate and assist others in operating hardware and various software
Heavy data entry and customer service calls
Created an application to maintain my help desk requests
EDUCATION
Tulsa Community College, Tulsa, OK
Attended programming classes pertaining to a computer science degree
University of Georgia, Athens, GA
Attended core and continuing education classes pertaining to computer science
Contact this candidate