TECHNICAL SKILLS:Languages: VB.NET, Visual Basic 6, VBA, VBscript, ASP.NET, Javascript, HTML, DHTML, C, C++, SQL, XML, .NET, Web services, Crystal Reports formula syntax, SAP Business Objects Webi Reporting syntax, SAP Business Objects Universe syntax, T - SQL, Abobe Flex script, DataStage ETL transformation syntax, Unix Scripting, Oracle PL SQLTools: AutoSys scheduler, Dreamweaver, FrontPage, Visio, MS Project, SAP Crystal Reports 8.0 - 14.0, Macola, SSRS, SSIS, OLAP, VSS, ClearCase, SAP Business Objects BI 3.1 - 4.1, DataStage ETL 8.7 - 11.7, Visual Studio .NET 7.0 - 14.0, VB Studio 6, SAP Business Objects Business Intelligence Development Studio versions 3.1 - 4.1, SQL Server Enterprise R2,WordPress 4.0, Hadoop Hue, Hadoop Hive

SDLC methodologies: Waterfall, Agile and Agile for BI and data warehousing

Databases: MS SQL Server 6.5, 7.0, 2000, 2005,2008 R2, MS Access, Oracle SQL Plus 8.0

Operating Systems: MS Windows 2000, NT, XP, MS DOS, UNIX and Linux

PROFESSIONAL EXPERIENCE:

Confidential, CA

Consultant (HCTEC) Senior DataBase Engineer

• Designed and developed SSIS job to pull from formatted files and bulkload into a DataLake target.
• Designed and enhanced VB.net program to pull from multiple data sources and output to pdf documents.
• Designed and developed a SSIS jobs to pull from Excel Files and push to a SQL database used for reporting.
• Wrote SQL queries to pull data from any given data source.
• Designed and developed SSIS Scheduling jobs that run SSIS packages.

Confidential, CA

Consultant (Global Insights) Senior Business Data Analyst/Developer

• Designed and developed reusable Data Stage framework (sequences and jobs) that can pull from multiple data sources and push data to Hadoop.
• Designed and developed reusable framework to poll status tables to determine if a given data source has loaded for a given day.
• Designed and developed a framework that can pull data from multiple data sources in chunks of data when the data source is rather large.
• Wrote Numerous SQL and PL SQL queries to pull data from any given data source.
• Designed and developed numerous Unix scripts to create run time SQL for digestion by DataStage jobs.
• Designed and developed numerous Autosys Scheduling jobs that run DataStage sequences.

Confidential, CA

Senior Business Data Analyst/Developer

• Designed and developed numerous SQL stored procedures, functions, statements, partitions, tables and indexes.
• Designed and developed numerous PLSQL stored procedures, packages, function, statement, partitions, tables and indexes.
• Designed and developed Data Services ETL jobs to move banking data from ODS staging area to data warehouse
• Fixed and enhanced existing Data Services ETL jobs as they developed issues.
• Assisted in major upgrade to latest version of ETL application. This required hundreds of jobs being enhanced and upgraded to the latest version.
• Trouble shot hundreds of issues with existing ETL jobs as some would fail daily.
• Designed and developed processes for tracking ETL job issues.

Confidential, CA

Senior Business Intelligence Developer

• Designed, developed and enhanced applications for aiding in cost accounting for the movie and television productions using flex, java script, SAP Crystal Reports, SAP Business Objects Web Intelligence Reports and Universes, Data Stage ETL, SQL and T-SQL
• Designed, developed and released to production over 100 crystal reports for cost accounting with TSQL back ends.
• Designed, developed and released to production hundreds of views and stored procedures supplying data to Crystal reports.
• Designed and developed a star schema data warehouse database for storing cost accounting data from a relational database (ODS) for a major TV network.
• Designed and developed DataStage ETL jobs and sequences to move data from legacy storage to a data warehouse for a major TV network.
• Designed and developed DataStage ETL jobs and sequences to daily move data from operational data stores to a data warehouse for a major TV network.
• Designed and developed a Webi Universe and reports for reporting from cost accounting data stored in a data warehouse.

Confidential, CA

Senior Programmer/Analyst

• Wrote specifications, designed, developed and enhanced applications aiding in financial, sales and inventory analysis using VB.net, Visual Basic, SQL and T-SQL.
• Developed and released to production four major applications to process financial, sales and inventory data using TSQL, VB.net, AJAX, SSIS, SSRS and Web services.
• Developed and released to production five minor applications to process financial, sales and inventory data using TSQL and VB.net.
• Provided working fixes and enhancements for over 90 reported issues. Many of these issues involved troubleshooting VB6, VB.net and TSQL code.
• Created Source Code repository for storing and securing all source code.
• Monitored and enhanced SQL Database performance for key production databases.
• Provided technical support for team and IT staff on key projects and initiatives.
• Conducted training seminar on the use of SQL Server Reporting Services.

Confidential, Valencia, CA

Senior Programmer/Analyst

• Wrote specifications, designed, developed and enhanced applications aiding in legal electronic discovery using Visual Basic, VB.net, XML, SQL and T-SQL.
• Developed and released to production six major applications to process the data of a number of Fortune Five Hundred Companies using TSQL, VB 6 and VB.net.
• Designed and developed two databases to hold a large volume of data, with numerous tables and TSQL stored procedures.
• Provided working fixes and enhancements for over 200 reported issues. Many of these issues involved troubleshooting TSQL stored procedures.
• Took over the development of 2 major applications that were not progressing and got them released into production. One of these applications takes a large database and supporting data offline for archiving. The same application can also restore the database and supporting data using complex TSQL stored procedures and VB .net.
• Provided technical support for development team and technical leads in troubleshooting issues with processing large volumes of data in SQL.
• Developed applications to validate complex cutting edge data analysis tools used in filtering Fortune Five Hundred company’s data.

Confidential, Valencia, CA

Senior Programmer/Analyst

• Developed and maintained a payroll application to pay thousands of shipboard employees using Visual Basic, XML, SQL, T-SQL and Crystal Reports.
• Enhanced pre-existing payroll application using Visual Basic, SQL, T-SQL and Crystal Reports which allowed application to go into production on time.
• Developed additional modules for pay calculation of a number of payroll exceptions using Visual Basic, SQL, T-SQL and Crystal Reports.
• Provided working fixes and enhancements for over 400 reported issues.
• Designed and developed data warehousing database and application with reporting capabilities to pull from the warehouse.
• Reduced payroll processing times, using SQL tools, from eight hours to a mere one hour thus ensuring shipboard employees are paid on time.
• Successfully delineated production, UAT, QA and development environments for compliance to SOX (Sarbanes/Oxley) demands.
• Successfully created and implemented code sourcing protocols using Visual Source Safe.
• Designed and developed 50 complex payroll reports for payroll accounting using Crystal Reports and SQL.

Confidential, Burbank, CA

Contract Programmer

• Developing a fleet maintenance and inventory ordering application using VB.net, XML.net, ASP.net, SQL, T-SQL and Crystal Reports.
• Designed and developed a fleet maintenance application using VB.net, XML.net, ASP.net, JavaScript, SQL, T-SQL and Crystal Reports.
• Designed and developed the Database for the fleet maintenance application

Confidential, Thousand Oaks, CA

Contract Programmer

• Using Crystal Reports 8.0, developed, designed and implemented reports based on legacy report selections.
• Designed and developed over 100 reports using Crystal Reports and SQL in just a couple of months.
• Enhanced reporting methodology by creating multi-dimensional reports with extensive drill-down capabilities.

Confidential, Northridge, CA

Lead Programmer

• Lead the development and implementation of applications that allow for job building, scheduling, payroll processing and client billing of employees working for a number of branch operations.
• Designed and developed a web-based payroll application for calculating pay and hours in all 50 states using SQL, ASP.NET, XML, .NET, JavaScript and VB.NET.
• Designed and developed a web-based hours processing application for inputting employee hours before payroll processing using SQL, ASP.NET, XML, .NET, JavaScript and VB.NET.
• Designed and developed a billing application for billing clients using SQL, ASP.NET, XML, .NET, JavaScript and VB.NET.
• Designed and developed reporting tools for tracking hours, pay, billing and employee turnout using SQL and Crystal Reports.
• Identified key user requirements and discovered errors in existing design. Supplied fixes and updates to existing code.