ARCHANA PATEL

***** * **** **

Broken Arrow, OK *4014 918-***-****

SKILLS

·Data Warehousing

·SQL Server Database Administration

·ETL using Kimball’s Star Schema Dimensional Modeling

·Data Analysis

·SharePoint Administration

·Reporting in an accurate and timely manner

TOOLS

·SQL for MS SQL database server, SSIS

·SQL for IBM DB2 database server

·SAS

·IBM DataStage

·IBM Cognos Framework/Power BI

·IBM Data Architect (IDA)

·Fast Track

·Windows and Mac OS platforms

·MS Office (Access, Visio, PowerPoint, Excel, Word)

·Quickbooks

·Online learning and assignments for AWS, Java, Angular, React, HTML, and CSS

EXPERIENCE

*I have just finished taking classes on SAS and am currently looking for a job

09/22 – 04/23

Oklahoma State University, Institute of Technology — Okmulgee, OK

Database Administrator

·Because I work with sensitive information about students, I am always researching data governance

·Design ad-hoc Cognos Analysis reports using analytics and complex queries for the multiple departments at the university

·Provide advanced Excel reports primarily pivot tables

·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

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.

*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 (updates, create groups/user security permissions, back-up/restore files, migrating data)

·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 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 installation and analyst

·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

·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 designed the DB2 server tables using the Star Schema model

·Extracted, transformed, and loaded VSAM files using DataStage

·Created 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

·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