TECHNICAL SKILLS

Systems: Windows Servers version NT4, 2000, 2003, 2008, Windows XP, Vista, Seven, Virtual PC, VMWare

Hardware: Dell servers, HP Servers, Dell Power Vault, Watchguard firewall, Cisco routers and switches, and HP External Backup

Application: MS Office Suite 2003, 2010, Visual Studio, Perl, VBScript, Perl, Knowledge of Unix commands, IIS, ASP, Dreamweaver, Flash, FTP, SSRS2008, SSIS 2008 R2/ 2012, Visual Studio 2008, Visual Studio 2013, GlobalScape, FileZillaDatabases: Access 2000, 2003, SQL 2000, 2005, 2008, Oracle 8, 10g, My SQL, TeraData

PROFESSIONAL ACHIEVEMENTS

Confidential

Data Analyst

Responsibilities:

• Responsible for analytical data needs. Handle complex data requests, reports, and predictive data modeling.
• Analyze health management programs including: data collection, validation and outcome measurement. May include: Financial, pharmacy, claims, provider, and member data, IRS, CMS, HHSC, HEDIS reporting
• Internal data cleansing and data reconciliation analysis
• Trend analysis in various functional areas of health care management.
• Create and generate reports through MS - Excel, MS-Access, and SQL using Business Objects interface and direct links to core databases (ODS/EDW)
• Produce reports for and interface with senior management and internal and external stakeholders.
• Gather and interpret business requirements and monitor data trends to proactively identify issues
• Execute data changes and update core systems as needed
• Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly

Confidential

SQL Database Administrator / Developer

Responsibilities:

• Created stored procedures, triggers, and functions and develops code to extract, transform and load data
• Extracted relevant data from various sources and data enters information into database. Created store procedures, functions, and ad-hoc queries in automating tasks and SQL jobs.
• Created reports using report builder and various reporting tools.
• Design and created applications using MS Access VBA.
• Used SQL Management Studio (SSMS) and other SQL Server management tools.
• Developed and designed database objects such as: tables, indexes, and constraints.
• Used SSIS to import, transform data, and export data. Create and schedule packages.
• Installed and configured SQL Databases.
• Managed backups and performed routine DB performance tuning. Managed user roles and access rights.
• Troubleshot and maintained daily SQL jobs that import/export data from various sources.
• Troubleshot and resolved issued related to application software, ETL processes, reporting, and database development.
• Created SSIS packages to import data from external vendors.
• Installed and setup SSRS server. Created dynamic reports.
• Developed a database and imported data from Excel and flat files to tables to start collecting data and analyze requirements for a data warehouse development project.
• Worked closely with stakeholders to deliver data needed and created/modified database, tables, and T-SQL in a daily job functions
• Created, coordinated and administered databases, including base definition, structure documentation, operational guidelines, and security
• Administrated SQL databases and troubleshot issues with application software NorthRidge and MarkIV.
• Participated in project planning activities with the project managers and stakeholders.

Confidential

System Manager

Responsibilities:

• Performed servers and system upgrades to meet new industry standards while maintaining high stability. Upgraded SQL database to SQL server 2005.
• Created additional modules for existing applications to enable products to be received via different portals as well as in different formats based on client preferences such as HTML, CSV, Excel, and text delimited formats.
• Continued with VBA/SQL developing projects to support with new business requirements and to bring production efficiencies across departments. (2008 to May 2010)
• Lead the team through switching call center vendor applications to TouchStar while moving the office to a new site. The project replaced the Oracle database server with SQL 2000, all teller’s Unix terminals with Windows XPs, and the Davox dialer system with Dialogic system. Installed and configured new applications on the component servers. Planned for successful upgrades by coordinating with the vendor’s IT team in implementing backend databases in SQL 2000 and extracting and transferring database backup files to the new server. Rewrote a new SQL/VBA application to support the SQL 2000 backend processes.
• Installed and configured Watchguard firewall, Cisco Router and Switches to improve network connectivity and security. Ensured all upgrades were done on time. (2006 to 2007)
• Successfully upgraded Oracle 8 to Oracle 10g. Rewrote codes in VBA applications and VBScript to coordinate with the new database design across Unix and Windows flat forms and improve query performance. Performed duties of system administrator and Call Center technical support. (2004 to 2005)
• Oracle/VBA Database Developer, developed new User Interface modules to enhance automation of list extracting, transferring, and loading (ETL) processes. Heavily used Oracle8, PL/SQL, VBA coding, Perl script, VBScript, and Windows commands. Upgraded servers to Windows 2003 servers, configured Active Directory and Exchange Server, and maintained database and system backup. (2002 to 2003)