PROFILE

Senior Application/SQL Server Developer/Analyst

Software: MS SQL SERVER 2012/2008 R2/2005, T-SQL, MS SSIS/SSRS, MS VISUAL STUDIO, ERWIN, FACETS/TRIZETTO, VISUAL BASIC 6.0, NDM, UNIX SHELL SCRIPTS, SUBVERSION, SOURCESAFE, MS (ACCESS, WORD, EXCEL), CRYSTAL REPORTS v11

Platform: CLIENT/SERVER, LINUX/UNIX (SOLARIS/AIX), WINDOWS 7, XP, MAINFRAME (MVS/XA)

Education: BA degree (Spanish/Teaching), State University of New York at Stony Brook

EXPERIENCE

AETNA HEALTHCARE, Phoenix, AZ 8/16 - Now

Application Developer

SQL Server database development and analysis for Medicaid data warehouse.

Used Erwin data modeling tool for complex database diagrams.

Extensive development of stored procedures, tables, primary/foreign keys, indexes, views, UDF’s for critical data warehouse using sophisticated import and validation processes (ETL).

Maintained processes for importing multiple plans member data, enrollment, provider, prior authorization, claims, Rx formulary data.

Managed data feeds in differing formats from QNXT and non-QNXT data sources from multiple state Medicaid plans.

Performance tuning and query optimization using SSMS standard tools.

Ad Hoc and scheduled data extracts and reporting via SSIS.

CONIFER HEALTHCARE, Phoenix, AZ 4/15 – 5/16

Senior SQL Server Database Developer/Technical Analyst

Extensive SQL Server database development, analysis, coding for Medicare/Medicaid related applications.

Develop/enhance SSIS/SSRS packages and Crystal Reports. Scheduled/Ad Hoc.

Coordinate technical support with business analysts/medical staff for federal (CMS) and state government audit compliance/internal quality management.

Support complex technical efforts to transition from legacy db systems to consolidated/updated MS SQL Server 2012 database system.

UNITED HEALTHCARE, Phoenix, AZ 2/12 – 11/14

Senior Application/SQL Server/Technical Database Developer-Analyst

Created new and enhanced existing database objects (stored procedures, tables, etc) in close coordination with data architects to insure finely tuned, efficient code and normalized tables.

Serviced backend Medicare/Medicaid claims processing system in close coordination with LOB requirements (MS SQL Server and Sybase).

Performed all database development in strict compliance with state and federal government requirements for ACA upgrades and state specific issues.

Documented analysis, testing, deployments for internal and external auditors.

Followed SDLC and extensive testing standards for all database development.

Participated in complex production deployment releases involving shared/common code affecting multiple states.

Great track record meeting/surpassing the business needs of our external customers.

HUNTER CONTRACTING, Gilbert, AZ 8/11 – 1/12

SQL Server Database Developer/Admin

Planned, developed, tested, implemented SQL Server db import/export process for HR department to external client.

Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.

Created additional ad-hoc reports using MS Access for Operations Director.

Received MS Sharepoint 2010 application development training covering Visual Studio 2010, Sharepoint Designer 2010

WELLS FARGO, Chandler, AZ 4/04 – 6/11

Application Engineer/SQL Server Database Developer/Admin

Coordinate technical support with LOB to improve existing client/server applications. Support, enhance, and administer several SQL Server databases on multiple servers.

Support essential application databases and database instances, including all development, testing, documentation, and disaster recovery for production databases and physical/virtual SQL servers.

Used Erwin data modeling tool for database diagrams.

Develop, test, implement, and support db maintenance plans, security roles, tables, stored procedures, views, triggers, indexes.

Follow System Development Lifecyle process for database and application development.

Prepared db staging environment and installation documentation for production database modifications and additions.

Created well tuned multipurpose stored procedures, DTS/SSIS packages for data importing, reformatting, and ad hoc troubleshooting.

Used Query Analyzer tuning tools for optimal SQL code design and performance.

Develop, test, implement SQL replication process for BCP disaster recovery, replacing tape backup/recovery.

ADVANCEPCS, Scottsdale, AZ 4/99 – 6/02

Senior Programmer/Analyst

Responsible for the total development effort of assignments from design through post implementation for rebate application generating 20% of company revenue. Provided support, maintenance, and enhancements for real time claims adjudication application. Delivered projects on time using software development lifecycle management methodology.

Rebates system.

Designed, coded, tested, implemented GUI screens and database modifications for key client/server application. Extensive development of stored procedures. Assisted with DB design. Creation/modification of DDL and DML.

Guided and facilitated projects through status meetings designed to encourage and integrate feedback from business users and technical staff. Developed system documentation and flow charts (VISIO).

Provided accurate analysis and quick resolution of problems related to application system testing, integration and UAT testing, and post implementation issues.

Online pharmacy claims adjudication system.

Delivered timely response, analysis and resolution of production problems surpassing designated service levels. Received commendation from business community.

Developed/implemented inferred relationship process enhancement for patient enrollment.

Contact this candidate