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

Confidential

Application Developer

• 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

Data Analyst

Confidential

• 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 training and support Extensive experience with Sharepoint 2010.
• Design dashboards reports that display key performance indicators KPIs , scorecards and drilldown details
• Oracle Financials General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Procurement.

Confidential

QA Analyst

• 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

Consultant

• 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.
• QA Analyst - Manual Test Writer
• Used a Remedy Trouble Ticketing System
• Creates test transactions

DataAnalyst

Confidential

• 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 Verizon Wireless 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.
• MS Access Report/Query Optimization

Confidential

SQL Programmer/DataAnalyst

• 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
• optimizing 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

Senior Software Engineer

• 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.

Confidential

Analyst/Programmer

Confidential

• Design and develop end-user documentation. used of GUID data type for some index fields
• Prepared detailed workflow charts and diagrams that described input, output, and logical operations.
• Experience with functional system, integrated, regression, and security testing. Developed system documentation.
• Also Used IM for contacts/chats.
• Extensive use of Visual Source Safe VSS for source check-in and Visio for Flowcharts, diagrams.
• Also I developed an Engineering Tracking system in Visual Basic 6.0 that interfaced with a server-based Clarify database.
• I used Visual Basic 6, Visual Basic 4 Sheridan, Videosoft Controls , InstallShield and Crystal Reports 7 extensively with some light VC . I also developed installation programs using Wise Install Master to test/install the software on all variants of Microsoft Windows from Windows 95, 98, NT 4, 2000.
• I also developed communications software for both serial and modem communications between a PC and the POS terminal.
• In charge of designing, coding, testing, POS point of sale PC-based systems for the convenience store and gas-station industry.
• Senior Software Engineer - laid off due to merger
• Crystal report design and development

Confidential

Oracle Database Engineer/Internet Engineer -downsized

• This job entailed creating dynamic HTML web sites using Platinum SQL Station embedded inside of HTML, CGI and JavaScript. Our clients included Lucent Technologies, Paradyne and Spiegel catalogues. We used extensive data modeling S-Designer using physical data models and Oracle packages. These web sites allowed customers to place orders using shopping carts for telephone, routers, etc using an extensive search of online database with graphics images and catalogues. The web site ran on Sun Solaris servers. Trained subordinates in programming and program coding.
• Developed web site maps, application models, image templates, or page templates
• that meet project goals, user needs, or industry standards.
• Wrote, designed, and edited web page content, and directed others producing content.

Confidential

• 3 month cont temp position
• Senior Programmer Analyst, Systems Development
• Utilized MS Access 2.0 tied in with Oracle databases on Windows NT 3.51 servers.
• Programmed graphs of Florida Power loads and temperatures, and performed maintenance changes on existing systems.

Confidential

Oracle Developer 2000 Programmer

• Developed conversion/load procedures for Oracle Accounting Software for the Nursery/Greenhouse Industry. Extensive use of Oracle 7.1 Developer 2000 in Windows 95 environment. Interaction with Novell Netware 4.1 and SCO Unix Servers.
• Extensive SQL Conversion coding using SQL Plus and PL SQL scripts, SQL Loader, Procedure Builder Triggers , and Oracle Browser.
• Some Oracle forms 4.5 development and also Delphi 2 development.
• Design and development of scalable queries, stored procedures and functions in support of interactive and batch application systems.
• Extensive use of cursors and stored procedures.
• Used Veritas Backup Exec for storage backups.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Form level PL/SQL Procedures, Functions, Packages, Triggers
• Ensure design code reviews of stored procedures, schema design
• Referential constraints
• Assist in the Physical and Logical Architecture and Design of relational database schemas
• Constructing database normalization
• 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
• optimizing SQL scripts
• Managed client Apps and Non-Apps Oracle databases.

Confidential

Micro Computer Analyst

• Designed, developed, and implemented three complete financial applications for the Home Health subsidiary of Morton Plant. The applications were Payroll, Purchase Orders, and Human Resources.
• All applications were written in Borland Paradox for DOS, and were installed on both Novell 3.1 networks and stand-alone . Symante/PcAnywhere was used extensively to communicate data from office to office. .I designed gui interfaces and toolbars and menus
• Developed employee wellness database using Microsoft Visual 3.0 and VB. 4.0 Prof. Edition and Microsoft Access 2.0. We used Crystal Reports for reporting. Also used Novell Network.
• Wrote a payroll interface using Quickbooks.

Confidential

Senior Programmer Analyst - laid off due to merger

• Maintenance of Marshall Isley banking code and conversion of correspondence banks to this vendor's system.
• Converted seventeen banks from different vendors: C S, NCR, FIS, Burroughs,
• Extensive use of CICS, IMS DB/DC, Roscoe, Intertest, Easytrieve with IBM 3090 system.
• NAFS to M I deposit systems.
• Extensive use of FOXBASE for PC reports and extracts.
• Converted 110,000 accounts and 600 million in balances for DDA, Savings, CD, IRA
• Heavy use of GL, Accounting for banking conversions.