OBJECTIVE

To obtain a position in information technology that will utilize my advanced database, computer programming, and business skills.

TECHNICAL SKILLS

• Database Knowledge: SQL Server 2012 Sybase 15 and 12 Oracle 10g SQL Stored Procedures, and Triggers Indexes Temp Tables Normalization Forms Teradata
• Programming Languages: over 15 yrs exp with PowerBuilder v12.5 to v4 PFC working knowledge of Unix 1 yr of exp. with Java Swing 1 yr of exp. with VB and C .Net COBOL and C.
• Around 20 years of strong SQL Developer experience in Banking, Retail, Government, and Health Care. Strong leadership, communication, customer-oriented, problem-solving, and multitasking abilities, expert in estimating, planning, modeling, designing, developing, implementing, administering, and maintaining SQL. Some experience with Oracle and Sybase 15 and 12 Databases.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
• Experience with all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• Excellent experience in creating Indexes according to business rules and creating appropriate Triggers to assist efficient data manipulation and data consistency.
• Experienced in the creation, and support of accurate, meaningful, and timely reports.
• Experienced in Logical and Physical Database design development, Data Conversion, Normalization and Data modeling using ERWIN.
• Experience in Data Extraction, Transforming and Loading ETL process using SQL Server Integration Services SSIS , and BCP.
• Experience in SQL Server SSIS package development using SQL 2012 features in control flow, and data flow.
• Involved in normalizing databases for OLTP environments and de-normalizing tables for use in production environments.
• Extensive experience in database performance optimization, reducing load time, debugging and tuning using tools like SQL Server Debugger, and SQL Server Profiler.
• Adept at multitasking, working under pressure, consistently meeting deadlines and fulfilling business needs, objectives, and goals.
• Attentive to detail while gathering requirements, and completing projects under a timeline
• Proactive team player with strong organizational, analytical, and logical skills
• Customer-oriented, able to learn new skills quickly, able to take direction, and good communication skills.

RELEVANT EXPERIENCE

Confidential

Software Engineer

• McKesson Corporation delivers pharmaceuticals, medical supplies, and health care
• information technologies to the healthcare industry in the United States and
• internationally. The McKesson Technology Solutions segment delivers enterprise-
• wide clinical, patient care, financial, supply chain, and strategic management
• software solutions and connectivity, outsourcing, and other services, such as
• remote hosting and managed services to healthcare organizations.

Responsibilities:

• Supported Accounts payable, and Payroll financial applications for hospitals to be compliant with state laws.
• Modified and peer reviewed Stored Procedures, Triggers, SQL queries that involve parameters, sub queries and left joins using T-SQL.
• Created stored procedures in SQL Server 2012 to pass data between applications residing on different databases.
• Corrected data relevant to Medical Records, Order management, Pharmacy, and Radiology.
• Troubleshot slow database retrieval, and updates.
• Revised reports for improved sorting, grouping, data conversion, or fonts
• Learned SSIS to more easily recreate a testing database
• Communicated with hospital administration, and McKesson management to troubleshoot slow application response times, and to improve meaningful application alerts of user errors.
• Documented steps to test and changes to GUI for audit and customers.

Confidential

Senior Programmer/Analyst

The Confidential Department of Taxation administers the tax laws of the Commonwealth of Confidential for individuals and businesses

Responsibilities:

• Supported Taxpayer Information and Correspondence Subsystems on Oracle.
• Created reports to identify non-filer taxpayers using SQL sub queries
• Rotated to provided on-call support for resolving issues

Confidential

Programmer/Analyst

Confidential, operates as a retailer of used vehicles in the Confidential sells vehicles that do not meet its retail standards to licensed dealers through on-site wholesale auctions, as well as sells new vehicles under franchise agreements.

Responsibilities:

• Reduced 6 hrs/wk of accounting dept. duties by writing and documenting Sybase stored procedures to automate easy, and repetitive processes.
• Enhanced and corrected PowerBuilder auction application windows, datawindows, functions for type-ahead searching and sorting, and reports to reduce over 2,000 service issues per week related to tendering transactions.
• Formulated the dealers' remaining and available credit calculation to not exceed their limit, to be up-to-date, and to be consistent for each situation.
• Recognized by management for quality standards, savings, service, and teamwork

Confidential

Senior Systems Analyst/Programmer

Confidential, Inc. provides industrial automation power, control, and information solutions. The Control Products Solutions segment provides low and medium voltage electro-mechanical and electronic motor starters, motor and circuit protection devices, AC/DC variable frequency drives, push buttons, signaling devices, termination and protection devices, relays and timers, and condition sensors and packaged solutions, such as configured drives and motor control centers to automation and information solutions, as well as life-cycle support services. The company sells its products, solutions, and services primarily to customers in the food and beverage, transportation, oil and gas, metals, mining, aggregates, cement, metals, energy, home and personal care, pulp and paper, water/wastewater, and life sciences.

Responsibilities:

• Ran BCP to extract and load tables
• Utilized Engineering skills to more easily prepare the motor Bill of Materials
• Increased user productivity, by presenting data in easy-to-read, and intuitive formats, and allowing data to be saved in PowerBuilder V9 pdf format.
• Streamlined existing calculations inside stored procedures and the application by replacing redundant calculations with well documented, structured stored procedure calculations on the server, thus allowing maintenance to be easier, and allowing results to be consistent throughout the application.
• Improved the design, documentation, and implementation of a PowerBuilder Client Server engineering app that records motor parts, notes, and specifications
• Created and modified html, Java applets, servlets to price motors.

Confidential

Application Systems Analyst/Programmer

Confidential, a financial holding company, provides various financial services. The Consumer Community Banking segment offers deposit and investment products and services to consumers lending, deposit, and cash management and payment solutions to small businesses

Responsibilities:

• Rewrote and enhanced a Client Server Application that calculates bank manager profits to an n-tier application for 1,000 users using Visual Studio.
• Improved Stored Procedures that perform data loading and calculations for a database conversion by reducing data processing time from 6 hours to 15 min.
• Developed a C program to read a file, filter needed data, and write another file to save the company 9,000 in consulting expenses.
• Documented and tested a few PowerBuilder applications using SQA TeamTest, Crystal Reports, and Robohelp.

Confidential

Credit Development Programmer

May Department Stores operates department stores in the United States. It offers national brand apparel, footwear, accessories, beauty, and soft home products to children, men, and women customers.

Responsibilities:

Developed, debugged, and tested COBOL II programs for Accounts Receivable.