SUMMARY:

• Accomplished IT professional. Diverse background that include SQL Development, Process Improvement, ETL Processing, Business Analyst, Quality Assurance, Help Desk Management, Documentation, and Training.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Consultant - Technical Team Lead - ETL / Lead Application Developer (SQL)

• Manage the ETL process for importing new data into an Confidential data warehouse. Lead SQL developer. Verify queries developed by Jr developers are optimized and effective. Developed queries to expedite the input and extraction of data. Developed and implemented Pre Go Live queries and procedures that will verify data load against business rules and continuity versus records already loaded. Developed and implemented Post Go Live procedures that ensures data loaded during prior phases of the project has not been corrupted. Responsible for verifying data consistency for each new implementation (import) of data. Developed an Access applications that takes the data received from the field (via other access tables, excel spreadsheets or legacy Confidential tables) that alerts the user if a piece of equipment is not currently in use or if the data from the field is not reporting the new equipment is the prescribed specification. The application will also convert known discrepancies and change them to the proper specification. (Example would be a model type provide by the field not formatted correctly. Field would give me 123456 when it should be 12-345-6). Application will also provide and exception report of all issues found to supply to the field for verification. Application will also remove duplicate entries and export all correct records for loading into the Maximo Production tables. Create verification and post-implementation scripts (SQL) involving joins and correlated sub queries to monitor data consistency. Create data outputs (SQL) to assist data miners in preparing data for implementation. Maintain documentation and develop reports for management, business analysts and end users.

Confidential, Horsham, PA

Consultant - SQL Developer (Warehouse Maintenance)

• Provide data maintenance support for the sales and marketing department. Maintain data related to the demographics of prospective and current customers. Verify that demographics related to the prospects and customers are up to date. Tasks include the consolidation of duplicate prospects. Maintain data related to customer preferences for solicitation.

Confidential, Philadelphia, PA

Consultant - Application Developer/Project Coordinator

• Though extensive use of SQL and Excel, create complex Ad-Hoc reports that span multiple tables from data stored in Confidential 11g data warehouse. Modified code and procedures for producing Monthly/Quarterly/Yearly reports to reduce turnaround time. Define new procedures to expiate the report request process. Manage incoming requests, delegated assignments to other developers. Work with requester to scope and define reports Evaluate report request to determine if the request should be a funded project. Assign tasks and coordinate the efforts of Business Analysts/Developers/and QA staff to convert “ad-hoc” reports to regular scheduled reports. Responsible for selecting the most qualified personal to achieve objectives.

Confidential, Chester, PA

Sr. Business Analyst/Quality Assurance Analyst

• Define customer requirements and functional specifications. Develop test matrix. Automated testing results by creating macro and Excel formulas to read actual results vs. expected results baseline and regression testing. Assist R&D with development of new, user friendly, configuration tool. Subtasks included organizing language translation spreadsheets to determine phrases needed to complete “internationalization” of product.
• As the only BA with SQL and Development experience, I would be assigned to projects where the customers required extensive new reporting. Duties included verifying the SQL logic. Ensure that the developers used best practices to optimize their queries.

Confidential, Horsham, PA

Sr. Business/Systems Analyst, Field Technology - Sales and Marketing

• Create reports using a report generator included in EZ-DATA’s Client Relation Management system. Report creation includes composing SQL statements to enhance system reporting performance. Create reports pulling data from databases using MS Query (through ODBC) and MS Excel. Reports include extensive macro programming. Responsible for testing and documenting system upgrades. Develop training documentation and training guides for new or updated software. Organize and conduct training for field personal. Create user guides for non-technical personal. Support product development, sales concepts, and legal requirements to guide programming by IT staff and vendor relationships. Develop test plans, objectives and benchmarks for applications that will be used by the sales force. Test application, calculations, and output for design and actuarial compliance. Test validity of installation programs. Ensure that all software, including vendor designed software, performs properly on the PML field network. Provide technical sales support to home office and field office associates on all illustration systems with regards to hardware, software, product information, new business & underwriting guidelines and sales concepts. Assist with training classes in use of sales illustration systems to home office and field office associates.

Confidential, Bristol, PA

Client Relations Manager

• Worked with project managers to fully understand and document a customer’s need and requirements. Worked with developers and quality assurance to ensure projects were proceeding on schedule, designed to specifications, tested thoroughly, and delivered to customer on time. Provided phone and on-site training to customer IT managers and help desk personal on delivered enhancements. Worked with the customers’ IT personal to help them understand the standard product. Coordinated training for 1st and 2nd level help desk to enable them to help customers more efficiently. Team Leader for group of Technical Analysts assigned to 3rd level help desk in support of Point-of-Sale (POS) Applications. Served as liaison with customers to ensure that ongoing service commitment was achieved. Performed hands-on assistance with support issues when volume warranted. Identified, communicated and coordinated best practices throughout customer service group.

Supervisor

Confidential

• Supervised staff of Technical Assistance Specialists assigned to 2nd level help desk. Developed Issue Escalation plan for level 1 help desk. Provided leadership, coordination, technical strategy and direction for all software support issues. Documented best practices to ensure customer satisfaction, and timely call resolution. Tracked timeliness of problem resolutions. Identified and coordinated training needs for customers and help desk technicians. Organized customer service training classes for the level 1 and 2 support technicians. Developed and taught FoxPro for Windows training for levels 1 and 2 support technicians.