OBJECTIVE:

Software Engineer/Systems Analyst using my diverse background in systems analysis and innovative software design to develop cost - effective solutions in a client/server computing environment.

BACKGROUND SUMMARY

• Extensive programming and system analysis experience in the following:
• In House Conversions Medical, Government, Banking, Securities, POS Apps
• SQL Server(2000, 2005) Database Conversions, Database Recoveries
• Application Development VB6, VBA, Access, Visual Studio 2008 .Net for Financials, Health Insurance, Wireless, POS.
• Oracle and Teradata SQL queries and Data Mining.
• MS Office 2003, 2007, 2010 (Excel, Word, Out Look, Mail merge Automation).
• Extensive Health Care - Medical Billing, Insurance, Financials, Doc Fulfillment background.
• Business Intelligence/logic

TECHNICAL SKILLS:

Oracle SQL: Visual Basic 6, C, C++(Visual 4.0), T-SQL, SQL Server 2000/2005/2008 , Access, Cobol, Visual Studio.Net 2008/2010, Visual Source Safe, SAP Crystal Reports, Olap, ODBC drivers/connections, VBA, n-tier, multi-tiered, Oledb, RDO, ADO, COM, MS Access( ), Paradox(DOS), Schemas, RDBMS, Triggers/ Stored Procedures, PLSQL, OLTP, OOD, SQL Server Enterprise Manager Studio, Oracle 9i, Clearcase, Magic, DTS Imports, SQL Scripting, API, Pervasive Map Designer, vba outlook, vba access, vba excel, asp.net, vb.net, vpn, Remote Desktop, MySQL, MySQL WorkBench.

Office Suites: MS Office for Windows 95 and MS Office 97, 2000,2003 Corel WordPerfect Office, Windows Me, XP, Vista,Excel, Powerpoint, Word

Internet Tools: Visual Studio 2008, ASP.Net, VB.Net, AJAX, HTML, CGI, Perl, Java Script, Java, XMLDreamWeaver, photoshop, paintshop pro, snagit Knowledge of video distribution formats Video Compression

Multimedia: Frontpage, Micrographx Suite, CD/DVD burning, Digital Cameras, scanningVideo editing/reformatting, digital photo animation

Operating System: Mainframe MVS(IBM-3090),VAX(DEC), MPE (HP), MCP (Unisys) UNIX (SCO),Windows 95, 98, NT, XP, Vista, Windows 7, Workgroups, VMS, TSO, ISPF

Hardware: IBM 3090 ESA, HP 3000, Burroughs 2900, Citrix

Data Bases: Oracle 7 and 9i, SQL Server 6.5 / 7, Access, IMS DB/DC, DMSII, FoxBaseClarify, Business Objects, SQL Server Enterprise Manager(2000/2005), T-SQL, MySQL, SQL-Express 2005, Paradox, DBaseIV, Crystal Reports, Visual Foxpro, Physical data modeling. Altova MapForce.

Utilities: Query Analyzer, Clearcase, SQL Plus, SQL Loader, Oracle Browser, ToadMS Outlook & Express, Robohelp, BlackBox testing, VSS (Visual Source Safe) Wise Install Master 9, Crystal Reports 7/8, Photoshop, MS-Project, Visio, Norton PcAnywhere, WinFTP, Cisco Web-Ex (meetings/data transfers), Veritas Backup Exec

Mainframe: Easytrieve, Roscoe, Focus, Intertest, Librarian

Telecom: CICS, 3270 Emulation, HLLAPI, Netview, FTP, RDP, VPN

PROFESSIONAL EXPERIENCE:

Confidential

Application Developer

Responsibilities:

• Development & Automation of Metric Reports.
• Gathers requirements, converts them to technical specifications, develops, tests, releases and maintains reports
• Lead the design of software architecture specifications and technical interfaces.
• Create table views, KPI data pulls from primary sources.
• Development Projects, automation of performance metrics Contest Scorecard & Deliverables, Rewards Scorecard & Deliverables, Career path Scorecard & Deliverables
• Automation of daily Production Metrics, create a new Dashboard
• Automation of KPI Trends & Charts currently being used
• Planning and Integration of the KPI & Scorecards with any IT Server changes (MCSA decommission, and assimilation into CCA 2.0)
• Extract, Transform and Load (ETL) processes and infrastructure
• Evaluate, assess and recommend software and hardware solutions
• Performs quality assurance reviews & test, documents operating report design, procedures and data structures
• Communicates scope dependencies, time & cost to stakeholders to prioritize requirements and corresponding schedules
• Design, initiate and handle technical request within complex application features
• Build flexible data models and seamless integration points
• Innovate and develop high-value technology solutions to streamline processes
• Coordinate with other Developers and software professionals
• Review all Control Charts, provide analysis of trends and correlations
• Data & Information Management; extraction from databases to create reporting metrics and scorecards. Significant use of advanced analytical tools and data manipulation will be required to successfully develop control charts and dashboards.
• Conduct correlation coefficients, review for variable impact to change.
• Provide daily trend charts.
• Perform data analysis to support ongoing process improvement efforts including identification of baseline metrics, development of KPIs and dashboards and tracking tools.
• Ability to manipulate information in Excel and MS Access
• Ability to create complex queries
• Large data set manipulation especially with flat file extracts from legacy systems
• Significant use of advanced analytical tools and data manipulation will be required to successfully develop control charts and dashboards.
• Provides feedback to management to help prioritize improvement opportunities and monitor performance
• Prioritize workload based on business needs
• Develop process maps using Visio, describing the current status of processes
• Evaluate software change request, develop UML diagrams, use cases, requirements, project implementation plans, track defect, enhancements

Confidential

Data Analyst, Tampa/St. Petersburg, Florida

Responsibilities:

• Developed Business Intelligence Qilkview apps primarily Finance for the Turbine Industry.
• Extensive development of SQL data load scripts for Qlikview from Oracle 12i databases,
• Extensive development of Qlikview charts (bar, pie, tabular) for Qlikview apps.
• I was responsible for developing and organizing in-depth technical and support
• Extensive experience with Sharepoint 2010.
• Design dashboards reports that display key performance indicators (KPIs), scorecards and drilldown details

Confidential

QA Analyst, Tampa, Florida

Responsibilities:

• Used MS Access, Excel to create ad-hoc reporting and daily production reports and files for client involved in health care advanced payer search and reimbursement.
• Experience in data mining, scrubbing and modelling

Confidential

QA Analyst, Tampa, Florida

Responsibilities:

• Programming Document Fulfillment in a mail merge language called Docuflex (Oracle) for a 30 state rollout of Health, Life and Disability claims for Nationwide Insurance.
• Loaded and Configured Mutiple Carriers Databases based on Input Feeds.
• Worked with QA Team to setup test parameters for QA test data and production test data.
• Perform heavy Multiple regression analysis to verify that state specific docuflex inclusion rules did not impact generic inclusion rules.
• Worked on benchmarks for speed of production reports.
• Used Visual Source Safe to track code changes. Performed a large amount of manual testing and worked with QA on best practices and test cases for testing. Experience with developing Functional Specifications, Process Flows.
• Demonstrated understanding of SDLC’s and use of version control systems (SVN).
• Excellent time management, organizational, and prioritization skills and ability to balance multiple priorities.
• Performed SIT and UAT Testing
• Requirement gathering
• Support User Acceptance Testing (UAT) by automating scenarios to allow the scripting to be used for regression and/or daily verification of the test environment.
• Mentor and coach others on testing tool usage, testing methodology, application domain; works independently while also guiding the Testing Services Team as the "go-to" person for automated testing.
• Analyze the results from usability tests, and document findings (i.e., end-to-end user experience, user workflows, specific UI screens and components, etc.
• Test scenarios, test scripting, test execution, defect entry documentation, logging and metrics
• Prepared a custom welcome letter to introduce the client to HPS.
• Used a Remedy Trouble Ticketing System
• Creates test transactions

Confidential

Data Analyst

Responsibilities:

• Created 20 ad-hoc SQL queries using Access VBA and Teradata SQL Assistant for sales reports.
• Created an Access VBA front-end to data mine Teradata for wireless device sales.
• Wrote Outlook VBA automation code to email sales quotes (sales quotes) written in Access with excel back-end to Confidential customers .
• Wrote an Excel VBA program to mail merge Spanish/English wireless contracts.
• Wrote a Word VBA automation project to create Word sales quotes.
• Interfaced Rockwell call center monthly call volume using Access VBA for sales tracking.
• Combined Word VBA automation and Outlook VBA email automation into a single process.
• Skill in designing windows, dialogues, menus and toolbars
• Extensive work with VBA Excel functions (cell movement, updates, add-ins, summaries ).
• Used reporting software to make reports.
• VBA Automation - inserting Access data into Excel templates
• Used Visual Studio 2008 - created simple VB.net, ASP.net apps.
• Extensive use of Grid controls for sales screens.
• Extensive use of inner and outer nested joins for sql queries
• Used IM(Instant Messenger) for development chat with other engineers.
• Used Visual Source Safe for check-in/check-out of source code.
• End-to-end solution delivery, from analysis, design to implementation, which will include documentation, testing and co-ordination within the rest of the team.
• Developing ad-hoc reports as well as developing scripts for automated and standardized reports.
• Provided functional analysis to assist business users in maximizing SQL reporting capabilities
• I analyzed the results from usability tests, and document findings (i.e., end-to-end user experience, user workflows, specific UI screens and components).
• Experience in running usability tests
• Track and report status of deliverables on multiple key initiatives in excel.
• Performed automated reports generation.
• Performing roll out testing and productions
• Experience in business requirements and functional specifications development with business user interface.
• Responsible for performing unit testing, integration testing, performance testing, functional testing, regression testing, scalability testing, client acceptance testing, user interface testing, batch process testing, and production support testing of these various software products
• Creation of adhoc and canned reports-
• Developed efficient SQL calls in applications.
• Access applications including screen creation and modifications.
• Heavy use of EXCEL 2007 as a work datasheet using VBA. The applications were a customer order calculator, an application to create bilingual orders using mail merge, and an application for human resource tracking. All of these used Excel in combination with VBA to automatically populate cells and rows in multiple datasheets as a department level database.
• Approved Process Validation Reports
• GUI and Screen design background
• Develop data collection strategies, tools and templates.
• Extract data from systems,
• Comfortable with peer code review and testing on applications
• Post implementation activities include troubleshooting, defect management, root cause analysis and problem resolution as needed.
• Capable with complex queries using multi-table joins (inner, outer, and full) and use of scalar and columnar functions.
• Deliver reports to end users, receive feedback to finalize reports
• Design and code screen layouts, graphical user interfaces, printed outputs, and interfaces with other systems
• Strong researching, organization, computer skills, and internet search engine experience (Boolean search strings, etc.

Confidential

SQL Programmer/DataAnalyst

Responsibilities:

• Project involved extensive database conversion coding using Visual Basic 6.0 of a Btrieve medical billing system to a SQL Server 2000 Data center database in Orlando.
• Extensive use of Btrieve calls and ADO connections to a SQL server 2000 database.
• Utilized Access 1997 to do extensive add/update queries for manipulating the data and used Access macros and coding to clean the data.
• Participated in on-line retrieval and testing and end-user testing.
• Used SQL Server Enterprise Manager 2000/2005 for database creation,report writer,medical conversions, backups, restores, stored procedures, T-SQL, DTS imports/exports. Over 300 clients with 1800 databases were converted from 60 different Medical Billing systems to 1 common system. Our data center model was the ASP model using Microsoft Remote Desktop and also involved transmitting SQL Server backups to the AT&T data center over a VPN (Virtual Private Network).
• Performed 100 SQL Database Recoveries for SQL 2000 and SQL Server 2005 databases.
• Extensive use of SQL Scripting for maintenance imports. Set up ODBC connectivity
• Heavy use of SQL Server Enterprise Manager for managing databases, SQL Query Analyzer for running SQL Database recovery scripts and SQL Profiler for tracing Transact SQL on server.
• Used Pervasive Map Designer to map ODBC, SQL, Binary, Btrieve, Clarion databases to Visionary SQL databases. Used Web-ex for customer dial-ins. Good experience in Test Automation, writing test scripts, creating test plans/scenarios
• Experience in running usability tests
• Knowledge of CPT, ICD-9, HCPCS, DRG coding.
• Knowledge of EDI BB coding and EDI 834, 835, 847 transactions.
• Knowledge of HL7 formats.
• Extensive us of Visual FOXPRO 6 for database conversions, extracts, modifications and GUI developement.
• Experience with business data transfer; consolidation and validation techniques.
• Developed system documentation
• Familiar with the database design, development, and normalization using the Microsoft SQL Server database management system (DBMS)
• Develop GUI prototypes using Visual Studio.
• Customized commercial databases to fit specific needs.
• Experience exporting data to flat files for submission to a SQL Server database.
• Created User Interactive screens with checks and balances to ensure proper data is captured.
• Experience extracting data from multiple data sources like flat files, SQL Server, DB2 UDB, etc.
• Hands-on experience with configuring data sources for.
• Heavy conversions of doctor practices that used EXCEL to hold practice information. All of these were demographics conversions from EXCEL to SQL Server.
• Performed referential integrity, Database Definitions
• Data Access Using Microsoft SQL Server 2008.
• Data Formatting, Scrubs and edits
• Claims Configuration Tasks, Setup Tasks, Customer questions, data change requests, enhancements, Requirement gathering.
• Experience in physical structure and functional capabilities of data bases, data back-up/recovery specifications.
• Gather information needed for pre-testing activities, i.e. plan kick-off meetings and gather testing requirements.
• Work with other technical resources to capture and define requirements, prepare testing environment, create data sets for use by automated scripts, perform testing, collate and interpret test results, monitor data findings, etc. Collaborate with development and system engineers on stress test parameters and findings.
• Facilitate meetings to review analysis and present management reports from test results, monitors, logs, etc
• Carefully examines data and reports to make sure conversion is proceeding correctly, runs test scripts with various data to see how new or customized transactions process through the software and verifies and validates accuracy of data through the generation of a variety of reports.
• Provider profiling or episode treatment grouper experience
• Used and coded appointment schedulers
• User access and system configuration
• Designs conversion procedures. connectivity tests
• Utilizing SQL server Management studio
• Responsible for the modeling, definition, creation, and maintenance of the database resource. Works closely with a team of developers and is involved in design decisions.
• Provides developers consulting on performance and ptimizing SQL scripts
• XLSX files in Excel 2007
• Strong technical/development skills in SQL(including jobs troubleshooting)/ VBA / MS Access / Database Reporting
• A fundamental understanding of data models and experience with various databases, inclusive but not limited to Oracle

Confidential, Tampa, Florida

Senior Software Engineer

Responsibilities:

• New development coding and design for a national workmen's comp and managed-care provider company. Using Visual Basic 6 (with OLE documents, ADO data controls and grids and heavy use of server (network) based Access tables) is a complete front-end customer view of manager care providers with all demographics and repricing data. Approximately 40 different modules and approximately 20,000 lines of VB 6 code.
• Utilized SQL Server 7 linked tables and VB SQL commands. Also heavy installation coding using Wise Install Master 9.0. Full Development Life Cycle for this project.
• Created formulas to map data tables to match vendor specified file formats. Encrypt files for secure file transitions between clients. care providers with all demographics and repricing data. Approximately 40 different modules and approximately 20,000 lines of VB 6 code.
• Utilized SQL Server 7 linked tables and VB SQL commands. Also heavy installation coding using Wise Install Master 9.0. Full Development Life Cycle for this project.
• Created formulas to map data tables to match vendor specified file formats. Encrypt files for secure file transitions between clients.