Objective

Software Developer professional seeking to provide software development skills in business application, database development and support for your company's IT and data processing needs.

Profile

• Over 10 years of hands-on experience in designing client server development, systems analysis and technical support of business applications in a multi-platform environment.
• Proficient in application programming in VB, Access/Excel VBA T-SQL and PL/SQL.
• Experience in building and supporting SQL Server 2000/2005 and Oracle databases servers as well as provide Business Intelligence reporting and ETL processing.
• Highly skilled in project development life cycle, providing application database design, modeling
• Strong background in Software Development Lifecycle, Systems Analysis, Performance Tuning and overall systems implementation and support.
• Works well within a diverse team structure as well as independent projects.
• Strong interpersonal communication skills

Professional Experience

Confidential

Developer

• Developed application enhancements, custom reports and database stored procedures improving the processing and ETL processing and monitoring for Global IS back office data warehouse and back office billing operations.
• Streamlined custom reports processing utilizing SQL server DTS packages and stored procedures for producing analysis reporting for telecom mobile customers and call center activities by performing SQL database tuning and optimization of stored procedure code.
• Spearheaded project planning of enhancements and provided support to corporate back office billing and reporting tasks and deliverables.
• Communicate with both the business and technical managers and facilitate the development of enterprise reporting project producing requirement specifications and systems analysis documents.
• Developed and directed software system testing and validation procedures, programming, and documentation for assigned projects.
• Used object-oriented programming languages, as well as client/server application development and database programming skills to modify and enhance data warehouse processing.

Data Analyst Confidential

• Restructured and improved the data feed reconciliation processing tool by integrating Cognos -VB COM object service as an ETL service to fetch DB2 mainframe data into an excel spreadsheet data format.
• Developed and directed software system testing and validation procedures.
• Defined the goals of the system and devised flow charts and diagrams describing logical operational steps as well as user manuals for the defined benefits group personnel.
• Developed training materials and procedures, and trained users in the proper use defined benefits data export procedures.
• Trained and managed 12 defined benefits coordinators and achieved significant improvements in their productivity in participant data analysis tasks.

Confidential

Programmer-Analyst for

• Responsible for complete life cycle development from requirements gathering, programming, testing and documentation through deployment and user training.
• Code and develop ETL Access and Excel automation and analysis tools for incorporating IRI and Neilson product marketing information.
• Code and develop custom Access billing application implementing new business and security rules, which improved overall processing and user interface and functionality by 80 .
• Served as a VB/Oracle 9i developer/analyst in the development of an energy trading report and decision support application for the energy/gas marketing and financial departments. The system enabled an increase in workflow productivity through supplementing the front and back office divisions with market analysis reporting tools.
• Implemented code enhancements and resolved data issues on current stored procedures. Utilized Oracle PL/SQL and TOAD for code development.
• Design and development of a contract settlement application utilizing Access as the front end interface and custom Excel spreadsheet reporting.
• Implemented data transformation techniques to render on demand bill settlement report requirements in spreadsheet format.
• Developed marketing analysis and forecasting application to improve tracking and forecasting of new and existing product sales results.
• Developed cost-effective software solutions integrating several locations running a proprietary application.
• Resolved a system implementation hurdle providing a seamless cost effective interface solution automating a proprietary system in order to accommodate all fieldwork data into a custom order fulfillment system utilizing Access, Oracle PL/SQL, UNIX scripting, database design and application testing knowledge. Resulting in a 50 jump in field work efficiency, schedule assignment and emergency and routine call resolution.
• Designed and developed custom reports using Crystal Reports, Access and Excel.
• Conducted application testing and quality control for issues using Mercury Test Director and Load Runner.
• Modified existing in-house software using dynamic web programming technologies.
• Created system and user documentation for each application developed.

Confidential

Software Engineer

• Accomplished daily database maintenance operations for both production SQL Server and Oracle database environments maintaining the smooth operation of customer databases.
• Selected and entered codes to monitor database performance and to create production database.
• Structured and maintained DTS packages for migrating data from one database schema to another which provided a clean data migration processing.
• Created database schema for testing and production of the various J2EE products implemented on a SQL Server database platform.
• Specified users and user access levels for each segment of database.
• Responsible for creating and maintaining core database entities in both test and production environments.
• Facilitate project enhancement solutions with both project managers and developers resulting in issue resolution and patch fix update implementation.

Technical Experience

VB/VBA, MS Access/Excel, SQL Server 2000/2005 T-SQL, Oracle 9i/10g PL/SQL, Visual Studio 2003/2005, MS Office, Visio, MS Project Manager, PVCS, Visual Source Safe, Mercury Test Director, TOAD, Cognos, Crystal Reports XI, Visual Source safe, MS SharePoint