Lead Developer Analyst

HINA PATEL

**** ********* **, ********, ** ****3 630-***-**** **********@*****.***

PROFESSIONAL SUMMARY

10+ years of experience in IT industry as Team Lead Developer Analyst, Data Analyst and Junior DBA with hands on experience in database administration. Adept at all stages of project lifecycle, from identifying business requirements and technical definitions to testing, documentation, production support, training and completion. Trusted advisor with quick problem identification and resolution skills. Proficient in database queries, functions, store procedure, analysis, and development. Recognized for good working relationships with colleagues all levels within the organization.

SKILLS

PHP, XML, XSL Stylus Sheet, Linux, C++, SQL

Data analysis, Import Data and Export Data, Data Encryption and Decryption, Data Processing.

Oracle Database, PL/SQL, Pivot tables, processes, Research,

Servers, Shell Scripts, MS SQL Server, tables, T-SQL

Troubleshoot Database issue, Upgrades, Database tuning

And performance monitoring, SFTP

Implement and maintain the database design, Create database objects (tables, indexes, Store Procedures etc.) Plans and implements backup and recovery of the database.

Operating systems: Windows XP, Linux, Mac OSX

Enterprise Manager, Medisoft, Epic, E-Care, Home Pro, FISS, ICD – 9, HCPCS, CPT.

Mastery of Microsoft office programs (Word, Excel, Access, PowerPoint, Outlook)

WORK HISTORY

Team Lead Developer Analyst, 06/2015 to Current

Trondent Development Corp. – Barrington, IL

Research, analyze, troubleshoot, and resolve profile data related issues.

Write ad-hoc T-SQL queries and updates using SSMS.

Export and Import traveler profiles data using various processes and formats.

Generate custom reports, Encryption and decrypt data.

Develop, modify enhance and troubleshoot profile data sync process and mapping php code.

Prioritizes work and assigns tasks to the team members.

Supervise team members assignments.

Worked closely with the customer throughout the development cycle ensuring the proposed design met customer requirements.

Monitor Servers and sync Processes.

Monitor and track the changes happening at database structural level, such as changes to the tables, views, procedures, triggers, schema, and more.

Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.

Junior DBA/Data Analyst, 07/2012 to 05/2015

American Geo Engineering Inc. – Glendale Heights, IL

Migrating file system database to ASM, Facilitate installation and creation of databases

Performance tuning of database, Using AWR and/or ADDM Real application testing (using SPA and database replay)

Perform backup and recovery using RMAN, Perform database cloning using RMAN, Implementation of Oracle Managed Files (OMF) concept, Undo tablespace management, Recovering from database failure, Monitoring database performance.

Use RMAN recovery catalog, Design and creates shell scripts to manage the Oracle database system, Oracle upgrades and RAC, PL/SQL tuning.

Monitor Daily, Weekly and Quarterly Database.

Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.

Set up and controlled user profiles and access levels for each database segment to protect important data.

Data Analyst, 12/2008 to 06/2012

Best Care Home Health Inc. – Oakbrook, IL

Run reports for Medicare billing, Transmit electronic and paper claims for Medicare and insurance, Follow-up claims, Download remittance advice, Enter Medline supplies to Home Pro, Run backup and recovery reports, performance and tuning Database.

Upgrades software.

Designed reports in Access, Excel using advanced functions not limited to Macres, VLOOKUP, Pivot tables, formulas.

Load data from different source system like flat files, Excel, and SQL Server.

Extracted, updated, and deleted data from MS SQL server using SSMS.

Coordinated statistical data analysis, design, and information flow.

Participated in requirements meetings and data mapping session to understand business needs.

Consistently met deadlines and requirements for all production work orders.

Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.

Data Analyst, 03/2008 to 11/2008

Loyola University Health System – Maywood, IL

Transmit electronic and paper claims for both primary and secondary Medicaid coverage using E-care and documented all billing activity in Epic system.

Billing Analyst, 09/2006 to 01/2008

Oakton Medical Associates – Hanover Park, IL

Data entry of CPT codes and ICD 9 Diagnosis using MediSoft, Generate reports for patient statements, Use E-Care system to process Claims, Follow up bills and unpaid claims.

Customer Service Representatives, 08/2005 to 05/2006

Days Inn –Mt Vernon, IL

Customer Service and other office work.

Data Entry Clerk, 06/2001 to 07/2004

Community Health & Emergency Service – Cairo, IL

Data Entry, Medical Records, Front Desk, accounts receiving and other office duties.

Data Processor, 07/1999 to 03/2001

Pharmaceutical Returns Service – Bensenville, IL

Data Processing and other office duties.

Verified the accuracy of data before transcribing.

Sorted and processed incoming reports before putting data into the processing software.

Managed large data projects, including scheduling, data entry, and checking for accuracy.

Answered data questions to company leaders.

EDUCATION

Associate Degree: Teaching, 1996

Primary Teaching College – India

Associate Degree: Computer Information Systems

College of DuPage – Glen Ellyn, IL

Oracle Database Administration 11g: Database Management, 2013

Oakton Community College – Des Plaines, IL

CERTIFICATIONS

Certificate of Database Proficiency

Certificate of Spreadsheet Proficiency

Oracle Database 11g Administrator

Oracle Database 11g Performance Tuning

Contact this candidate