OBJECTIVE:

To obtain an Information Technology/Business position where I can use my experience, skills, and to contribute and grow within the organization.

SUMMARY:

• I have been involved in the conception, design, development, and testing of Windows Desktop Applications, Distributed Applications, and Data Integrations for over 18 years.
• My experience includes using various API’s calls within Dell Boomi, Sales Force, and Anaplan, Visual Basic 6.0/.NET/JAVA (Properties, Methods, Events, and Object Hierarchy) business and data access component development.
• I have developed EXEs, Classes, and DLLs to be used by different applications, which include the presentation, business rule, and data access tier.
• In addition, I have experience with ADO, ODBC, SQL, RDBS design and maintenance.
• Additional experience includes Oracle 8.0/11/12g, SQL Server 6.5/7.0/ 2000/05/08/16 , SQL Server Management Studio (SSIS, SSRS), and Visual Studio SSDT with high - level data services tier skills with database design methodologies for use in data warehousing and transaction-based systems.

TECHNICAL SKILLS:

• DELL Boomi Integration/ Sales Force
• MS SQL Server 6.5/7.0/2000/2005/2008/2016
• Visual Studio .NET Framework
• SSMS (SSIS/SSRS)
• VBA/ VB Script/ Visual C++
• SQL Server Data Tools
• Java8/ JavaScript/ Groovy Script
• Oracle 8.0/11/12g
• Internet Information Server (IIS)
• Crystal Reports 7.0/8.5/9.0
• HTML4 /XM 3 /XSLT
• Microsoft Transaction Server (MTS)

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer/ Data Integration

Responsibilities:

• Design and develop in-house applications systems such as WIL, CSET, Switch Billing, Debit Solution, Purchase Order, Reporting System, PRISM, and AMEX using Visual Basic 6.0 (ADO)/VB.NET on the front-end and SQL Server Management Studio 2000/05/08/16 and Oracle 11/12g on the back-end with the knowledge of SOX controls and PCI compliance.
• Develop VBA (excel and access) applications for the accounting and operation department.
• Develop customize reports using Crystal Reports 8.5/9.0 and SSRS.
• Maintain third party software such as Solomon 5.5, FRx 6.5, ProSystem 3.1, and Peachtree.
• Provide IT support for the fraud, accounting, and operation department.
• Design and develop GUI for users to work off the adjustment items using MS Visual Studio (VB.NET), and store them in Oracle12g database:
• Users would import data file from IBM mainframe and report data from external clients (report scraping).
• Users then can manipulate records based on the PAN such delete or modify.
• Users would click on the UpdateStatus button to update records based on the business logic where it offset transactions based on the total debit v. credit.
• Users can export the data based on Gateway such as VISA, AMEX, CUP to excel file to send to other departments such as Operations or Accounting monthly.
• Developed VB Script/JavaScript to manipulate data files prior to importing to Oracle DB.
• Design and develop GUI for users to enter the billing fees using MS Visual Studio (VB.NET) and store the data in MS SQL Server 2016 database.
• Users would enter the fees such as Connect, Data Warehouse, Respools into the textboxes based on Processor or Intercept.
• Users would then enter the GEN Paperwork fees based on the financial institution via dropdown under each Processor or Intercept.
• Once the fees are entered the manager would validate to approve or disapprove the amount via Approve or Disapproval button.
• After management approval then the users would print out the invoice for each Process or Intercept via Crystal Report which is developed using T-SQL statements such as query, delete, insert, and update, and stored procedure to get the data from the database within the VB .NET code monthly.
• Design and develop GUI for users to enter the tracking data from external clients using MS Visual Studio (VB.NET) and store the data in MS Access database:
• Users would enter the create a ticket for financial institution (FI) that have questions or issues that they own.
• Users can update their own clients FI with how the handle the questions or issues and the system will keep track of all the dialog.
• Management would export a report via excel to see what FIs have the most issues or which questions or issues have been resolved on a weekly basis.
• Design and develop scripts to transfer bank files with different data format between external clients to internal business units using JAVA8 with JDBC Template and store the data in Oracle12g database.
• Received bank data files with various data format and parse the data and store them in the Oracle DB.
• Pulled the stored data and formatted in DFS standard for the internal business units.
• Received the DFS response files, parse and formatted the data, and send back to the external clients.
• Design, develop, and support Confidential (Cloud-based Atom, Local Atom) and Confidential .
• Engage in project planning and delivering to commitments to all projects.
• Perform unit and integration testing and document test strategy and results for audit purposes.
• Performs debugging, troubleshooting, modifications and unit testing of integration solutions.

Confidential

Responsibilities:

• Get monthly data file (1M records) from the Teradata platform via SFTP connector and use the first Anaplan connector to load it and then use second Anaplan connector to process it and check the error response file to see if the upload successful or not.
• Use Sales Force connector to query the objects (parent and child) with parameters to get the data and pass it in the subprocess to map the response data file to the output flat file that includes cross lookup, customize scripting (Groovy Script/JavaScript), map functions, and connector call with the return documents back to the main process so it can be encrypted and send to the Teradata platform via SFTP connector. In one integration I use the Web Services (WSDL) to get additional information to be added to the output file. In another integration I had to use the DataLoader API to manually pull the data from SF due to the size of the records and the timed-out limitation set in the SF connector.
• Get the daily data file (100K-1M records) from Teradata platform via SFTP, decrypt it, parse it via custom scripting and use the business rules I would only process the wanted data and then map it that includes cross lookup, set document/dynamic property, date format, scripting, string manipulating to the SF request file to be UPSERT into SF. In some integrations I’d use the Set Properties to set my variable dynamically and in others I’d use the Document Cache to store the records (documents) for further use throughout the integrations.
• Use SF connector to query the object (parent) and map the response file to the output file that includes character trim, string append, and scripting. I’d encrypt, set the filename, and send it to DFTP platform via SFTP connector.
• Develop a onetime integration to upload legacy data to SF via APEX connector.

Confidential

Responsibilities:

• Pull data files and reporting files from the server using FTP Task, check and send alerts if the FTP Task failed with errors or no files, use the For Each Container to upload multiple data files, use Script Task (VB .NET) to scrap reporting files with different data format to a temp table, use the Merge to combine both data sets to be uploaded, check data integrity using the Check Database Integrity Task and upload the data to Oracle DB.
• Pull data files from the network using FTP Task, check and send alerts if the FTP Task failed with errors or no files, use Lookup to change the upload data, check data integrity using the Check Database Integrity Task and upload the data to SQL Server DB.

Confidential, Houston, TX

Programmer Analyst

Responsibilities:

• Enhanced and developed customize applications (Xtra) build on top of Confidential and Seagate Info software using Visual Basic 6.0 (ADO) on the front-end while manipulating database with Sybase 11.1(Rapid SQL 5.22) on the back-end.
• Created ActiveX DLLs, OCXs, and EXEs for in-house applications that work in conjunction with Confidential software using Visual Basic 6.0, MTS, XML 3.0, and XSLT.
• Participated on a Web application using ASP, HTML 4.0, and Visual InterDev 6.0 that allows users to view reports via the Intranet.
• As part of an Architecture team, developed, enhanced, and supported existing and new customize applications.
• Used Visual SourceSafe (VSS) to centralize all applications.
• Solved various day-to-day problems for end-users.

Confidential, Houston, TX

Software Developer

Responsibilities:

• Designed and developed Drill Management System (DMS) for Confidential using Visual Basic in Access (VBA) and Visual Basic 6.0 on the front-end while using TOAD software along with Oracle 8.0 on the back-end.
• Enhanced existing version and provided support to clients of Drill Management System (DMS).

Confidential, Houston, TX

Developer/Programmer

Responsibilities:

• Designed, developed, enhanced, and supported Risk Management System (RMS) applications for end-users with Visual Basic 6.0 (ADO).
• Manipulated (e.g. create table, stored procedure, and view etc.) database with SQL Server 6.5/7.0 to be used in creating the customize reports.
• Created customize reports with Crystal Reports 7.0.
• Updated new and maintained existing Risk Management System applications (RMS).
• Used Visual SourceSafe (VSS) to centralize all applications.
• Worked with end-users to solve day-to-day problems.

Confidential, Houston, TX

Technical Support

Responsibilities:

• Configured, upgraded, and installed computer software.
• Provided technical guidance and customer service.