PROFESSIONAL SUMMARY

Senior Software Developer with 15 years database development experience in the financial service industry. Technical expertise with Oracle and Sybase. Utilize experience in strategic thinking, leadership, communication and technical skills to reduce costs and meet business goals.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

• Created procedures with IT experts, project managers and subject matter experts for data collection and analysis.
• Led meetings with various groups across company to identify database/web service data elements.
• Created EDD utilized by Data Analysts, Business Analysts, Designers, Developers and Administrators to improve cross application understanding, re-use and reduce redundancy.
• Developed requirements for .NET application hosted on SharePoint site which provided users various abilities to search for information.
• Presented new EDD Search Tool application .NET/Oracle to various groups including the Enterprise Architect group.
• Published generic definitions and acronyms on AskIT and Data Architect Paychex's Intranet sites.

Confidential

Senior Database Developer

• Converted applications: Client On Boarding, Client/Legal Entity, Sub-Account, Settlement Instructions Provisioning, Party, FX
• Extracted data from existing Sybase database and translated into new Oracle model, creating and modified complex / optimized SQL queries
• Integrated, cleansed, transformed, and warehoused data and enforced referential integrity
• Created UNIX shell scripts to automatically extract, translate and load data from database platform to another, including conversion report.
• Ensured design and implementation meet: client / performance requirements, government regulations.
• Worked with data mapping documents guide was mapping document XLS, Word, Email , data model
• Performed data system analysis for legacy systems
• Collaboration with team members: Microsoft IM, Email, team meetings, Live Meetings, conference calls
• Interacted with project management, business analysts, management, data modelers, middleware developers, database administrators

Confidential

Distributed Application Developer

• Designed and implemented logical / physical data models for new applications. Created and modified complex / optimized Sybase Oracle SQL queries into existing systems, meeting: technical specifications, client / performance requirements, government. Reviewed and executed unit / system integration test plans in several test environments before promoting software to production. Supported application databases in both test and production environments.
• Designed stable, flexible and high performance database solution to load, process, and generate feeds in a timely and efficient manner.
• Reviewed designs, documentation and code, while managing work schedules as Database Team Lead of three developers. Executed full software development lifecycle.
• Enhanced existing requirements and stored procedures for BNYConnect investment user conversion to Private Workbench as a part of merger acquisition and consolidating applications.
• Exceeded performance expectations. Converted from consultant to employee.
• Managed the migration of all files from PVCS to StarTeam version control.
• Reversed engineered database to create physical data models.

Confidential

Application Systems Developer

• Created optimized complex Sybase SQL queries for existing systems per technical specifications to meet specific client requirements and government regulations. Reviewed test plans and performed unit testing.
• Created and maintained custom coding, while supporting the daily activities of Pension DB and Health Welfare HW departments or possibly organizations. Result: error free code for over 300 clients.
• Assisted the company in obtaining CMM Level 3 certification. This certification brought new clients and enabled the company to charge additional fees for better-structured services.
• Provided client support through software fixes and upgrading current products, assuring a dynamic product that resulted in greater customer satisfaction and growth.
• Developed a UNIX shell script to execute specific stored procedures in sequence and exported to the data to mainframe. Improved performance by automating processes that are performed frequently.

Confidential

Database Administrator/ Sybase Developer

• Resolved database performance, database capacity and other distributed data issues. Led database administration for all environments, requirements Design Reviews, Schema Maintenance DDL , Performance Monitoring and Tuning, Disaster Recovery, Database Utility Processing, Provided security administration, production support, and maintaining existing DBMS environments. Coordinated rollout of new versions and patches of DBMS software. Participated in the full life cycle of database design.
• Analyzed server performance, identified problems and made necessary fixes, fine-tuning servers to ensure balanced loads.
• Performed and scheduled database backups and recovery planning. Moving databases from one machine to another as needed.
• Solely responsible for setting up the PowerSeller application database from bottom up, including logical and physical modeling, created system diagram and data dictionary using Designer 2000. Created objects tables, views, constraints, indexes, triggers after discussing the application design with analysts.