Bina Lokhandwala

**** ********** ******, *** **, North Bergen, NJ 07047

Phone: 201-***-****

Email: ac344c@r.postjobfree.com

SQL / ETL Developer

Career Summary:

SQL / ETL 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

Experience:

Columbia University, NY, NY

Oct 2015 to Aug 2017

Application System Developer / Pentaho Developer

Worked as part of IT Application System Developer / Pentaho Developer for Info-Ed that supports Web-Based, PL/SQL, Pentaho ETL which supports Researchers at Columbia University for grant portfolios and technical support for InfoEd grant management system.

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 Columbia University 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.

Town Sports International, NY, NY

Sept 2001 to Aug 2015

SQL Developer and Application Integrator

Worked as part of IT Application Development Unit that supports Web-Based, XML, HTML, Visual Basic, SQL, Microsoft Access based in-house developed systems for a company that spans five states with over one hundred and fifty (150) disparate locations. This involves dealing with several accounting and financial issues, producing data to fulfill SEC reporting requirements and creating reports to satisfy ad-hoc financial and accounting requests. Actively involved in creating SSIS packages and DTS packages, support and integrate via BizTalk out house developed system.

Integrate and Interface Projects

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.

Visual Basic Projects

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.

Stored Procedures, Crystal reports and Data Fixes

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.

Town Sports International, NY, NY

April 1998 to Aug 2000

Bookkeeper Coordinator

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.

Ben Lipschitz & Associates, New York, NY

Dec 1994 to July 1997

Account Assistant

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.

Bankers Trust, NY, NY

Oct 1987 to Dec 1990

Billing Coordinator (June 1989 - Dec 1990)

Jr. Database Analyst (Oct 1987 - June 1988)

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.

Education:

New Horizon Computer Learning Center, New York, NY. Aug., 2005

Certificate Programming with MS VB.Net

The Chubb Institute, New York, NY. Nov., 1999

Diploma in Computer Programming

(Additional courses studied from Dec. 1999 to Sept. 2000)

MAHARAJA SAYAJIRAO UNIVERSITY, Baroda, India.

B.S. in Accounting

Contact this candidate