SUMMARY:

• SQL Developer and Application Integrator with over 12 year’s experiences with industry - leading organizations, who has performed full life cycle of design, development, implementation, maintenance and analysis while utilizing strong business and programming skills towards every assignment. Responsibilities have included: database administration, optimization and development including stored procedures, tables, relationships, triggers, indexes, keys, batch processes and various data conversion tasks.
• Also, responsible for Integration, development and maintaining of Web Based Application and Middle Tier (business rules, logic, and constraints) while employing various trends of technology.
• Especially strong at dealing with financial, accounting and business needs.

TECHNICAL SKILLS:

• Strong SQL Server Programming Skills - stored procedures, user defined functions, creating Indexes, SSIS Packages and DTS Packages.
• Extensive Application Skills - debugging, data fixes, Integration and conversion.
• Excellent Pentaho and Crystal Reporting Skills - developing and designing reports, building queries.
• Microsoft SQL Server 2012, 2008, 2000, Oracle Database 12c/11g
• Pentaho - Data Integration Tool and ETL Processing and Aqua Studio
• Proficient with Oracle Financial, Epicor, Active Planner
• Familiarity with GitLab version control and Visual Source Safe
• Biz Talk Application, Short Web Based Application, XML, HTML, JavaScript
• VB Script, Visual Basic 6.0 (Enterprise Edition)
• Crystal Reports 9.0, 8.5
• MS Office 2016, 2010, 2007- Proficient with MS Excel and MS Access
• Windows 10, 8.1, 7, Windows NT 4.5
• Familiarity with Unix

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL Application System Developer

Responsibilities:

• Responsible for day to day operations and support and interact with Sponsor Project Group for business to Grant management.
• Maintain and improve existing interface and processing data from InfoEd Vendor application to ARC Financial using Pentaho ETL with Oracle database.
• Debug, improve and find solution fix for interface based on project needs.
• Design and modify Pentaho reports upon demand which are utilize daily for comparison between InfoEd and ARC Financial for Awards used by researchers and processed to appropriate financial accounts.
• Execute perform and assist integrations, regressions and user acceptance testing for new and existing processes.
• Create and develop SQL queries to update and upload data to vendor application for Sponsor Projects accounts on demand with Aqua Studio.
• Debug and optimize stored procedures related to daily interface due to project demand and upgrade of Window Servers
• Complies with Confidential architecture standards and use GitLab version control to place modified and new changes for interface and reporting and compare prior and current version for successful testing in GitLab before merging to master version.
• Install new version of Pentaho and participate for Oracle upgrade from 11g to 12c and Window Server Upgrade from 2008 to 2012R2
• Interact with vendor and technical resources for infrastructure and integration issues that are complex and multiplatform.
• Documents all processes and create a shared link for other developers to access and showed excellence in a variety or competencies including teamwork/collaboration, analytical thinking and technical expertise.

SQL Developer and Application Integrator

Responsibilities:

• Convert acquired club’s data into current in-house application. This involves data analysis, data populations, mapping contracts, transfer account balances and deferred balances, services and corporate clients.
• Develop scripts for converting services, agreements and revenue from in-house Clubnetworks application to out-house Moso application by populating data in tables, mapping GL accounts, and generating journal entries scripts to deactivate services and agreements and net zero balances after conversion in the in-house application.
• Integrate and maintain via BizTalk members data for addresses, agreements update and changes in balances and resume instances in BizTalk via researching and troubleshooting data in both in-house and out-house application.
• Code and develop stored procedures to transfer daily activities from Clubnetworks to Oracle Financial General Ledger. This involves automated process of data populating, mapping department codes, writing scripts for creating flat files and develop SSIS packages to upload to the respective accounts in Oracle Financial.
• Create interface for accounts payable refund checks from Clubnetworks to Oracle Financial Accounts Payable. This involves creating exceptions for duplicates data processed, uploading data into tables, coding scripts for creating flat files for three company databases for Oracle Financial and DTS the data creating automated process.
• Develop desktop application to create Pitney Bowes mailing files for members for their returns and chargebacks. This involves writing several stored procedures, using visual basic functions and outputting text files.
• Code and develop in-house and out-house projects for monthly usage charges based on business requirement bringing in two million of yearly revenue for the company. Generate invoices in out-house application via making API calls in the Web based application.
• Design, create and enhance stored procedure to charge Rate Lock charges to members generating around seven million revenues yearly for the company.
• Communicate with the end-user directly to develop and enhance stored procedures and design and modify reports to be placed on the Web based application. This involves various accounting reports for returns and chargebacks, which assist accounting department in the reconciliation of the bank statement for various clubs of the entire company and in the reconciling of revenue for the company.
• Develop and optimize stored procedures to be executed monthly for various deferred income products and outstanding account receivable balances for members and corporation. These show the aging amount at different periods.
• Create scripts to compare and analyze the members charged for payment method invoice, and member statuses such as freeze for current and previous months. This information would be transmitted directly to the Senior Executive Committee of the company.
• Interact with users to create scripts for the write off members, returns and chargebacks. This information would then be transmitted to a collection agency and create reports to show amounts collected and outstanding account receivable balances.
• Create and develop ad-hoc queries to complete data fixes for members and corporations to change their dues amount, update their member status and change the start and end date of their contracts. The created scripts would be executed and the data verified in test environments and then sent to the DBAs to execute in production.

Bookkeeper Coordinator

Responsibilities:

• Design and formulate new Excel spreadsheets and assist in modifying Visual Basic macros.
• Train new bookkeeper to input and verify collection of revenue and perform monthly bank reconciliation and post journal entries.
• Communicate effectively with club managers for collection of revenue and suggest method of correction.
• Verify commissions of sales consultant and produce weekly sales payroll commission reports in Access.

Account Assistant

Responsibilities:

• Prepared monthly asset allocation reports for clients reflecting the current valuation of their securities holdings.
• Determined accurate commission for brokers and reconciled data with broker’s ledger statements.
• Interfaced with brokerage firm and mutual funds companies to execute purchases and sales of securities.
• Actively initiated new business through verbal and written communication and organized record keeping of office files.

Jr. Database Analyst

Responsibilities:

• Prepared and analyzed monthly income reports for management and reconciled to general ledger.
• Produced payments schedules for corporate clients using specialized fee schedules and information sheets.
• Processed daily payment transactions to generate daily income report and researched and resolved customer inquiries.