PROFESSIONAL SUMMARY:

• Over 15+ years of progressive IT experience including:
• 15+ yrs SQL Server DBMS design and development, utilizing SSIS/IBM - CASTIRON for ETL, SSRS for Reporting, SSAS for OLAP cubes.
• Experience with Oracle DBMS, PL/SQL with Oracle SQL Developer, Linux, SharePoint 2007/2010, and SalesForce. CRM. 9 years experience with Visual Basic.
• Programming in C# and Java.
• Extensive experience of meeting with business end users, gathering requirements and then transferring requirements into technical specifications.

TECHNICAL SKILLS:

Analysis/Design: Extensive analysis, design and coding of applications for mission critical complex Database, ETL, business, accounting, and financial applications, excellent oral and written English communication skills.

Built task lists: estimates and work schedules to help ensure timely completion of tasks and projects. Worked closely with end-users, sponsors, and functional experts in developing system requirements and translating requirements into technical specifications/tasks.

Languages: SQL, T-SQL, PL/SQL. SOQL, Visual Basic 4/5/6; C#. Java, PL/SQL, VBA, VBScript, JavaScript, XML, HTML

Databases: SQL Server 2000/2005/2008 R2/2012, Oracle 10x, 11G; MySQL, IBM WebSphere-CASTIRON Integration Tool, Sybase, MS-Access, dBase

Reporting Tools: SSRS, SHAREPOINT Business Intelligence Sites, Crystal Reports 7/8/9/10, Jasper Reports, IReport

Other: ORACLE SQL Developer, SSMS, SSIS(ETL) Visual SourceSafe, Tortoise/SVN, Tomcat Web Server, JSP, Struts, ASP, Visual Studio, ERWIN, Visio, UML (use cases, test cases), SAP, SALESFORCE CRM.

WORK EXPERIENCE:

Confidential

SR DATABASE-BUSINESS INTELLIGENCE DEVELOPER/CONSULTANT

Responsibilities:

• Used Oracle 11G PL/SQL, SQL Server 2008R2, JASPER Reports/JAVA, and TOAD, and to develop a web based reporting system for Confidential and Finance project.
• Utilized Oracle 11G DBMS, TOAD development tool, and JASPER BI Reports for BI reporting from Confidential ERP System.
• Created and/or modified complex Stored Procedures and Views in ORACLE 11G DBMS using Toad for Oracle development tool.
• Created or modified views in ORACLE 11G. Created reports using JASPER BI Reporting Suite for web based reporting system.
• Used JAVA for Jasper reporting.
• Assisted less experienced staff with SQL Server SSIS package creation testing and debugging.
• Analyzed and documented large complex ORACLE Database schema with over 800 tables using MS-VISIO.

ETL: SQL 2008 SSIS, C#, PL/SQL

Reporting: JASPER BI, SSRS

DBMS: ORACLE 11g, SQL 2008 R2

ERP: Confidential Advantage

Other: PL/SQL Queries, Views, and Stored Procedures, Toad for Oracle, Java

Confidential, San Diego

DATABASE-BUSINESS INTELLIGENCE DEVELOPER/ADMINISTRATOR

Responsibilities:

• Database And Business Intelligence Developer/Administrator - with Confidential
• Responsible for designing, building, and maintaining multiple OLAP data marts/data warehouse in SQL Server 2008 R2 that received and consolidated data from a wide variety of external ORACLE, SQL Server, and Mainframe-based OLTP systems.
• Created SharePoint Business Intelligence Websites.
• Designed and implemented complex processes to import data from Mainframes, Oracle databases, Excel files, and text files using ETL tools (SSIS), SQL, TSQL, and PL/SQL.
• Designed and implemented Star Schema models of OLAP databases and data marts.
• SSRS and Business Objects report creating, modification/scheduling, exporting reports.
• Consulted with Sr. managers and technical development staff for requirements and support.
• Created logins, database backups, granted/removed access to database objects and processes.

DBMS: SQL 2008 R2

ETL: SSIS, C#

Reporting: SRSS, Business Objects 4.0

Data Warehousing: SSAS, SSAS OLAP cube development, and Data Warehouse/Mart design.

SharePoint: Developed SharePoint 2010 Business Intelligence and Reporting websites

Other: SQL/PL/SQL Queries and Stored Procedures, DBA tasks.

Confidential

SOFTWARE ENGINEER/DATABASE DEVELOPER

Responsibilities:

• Database Development/ETL using SQL Server 2005/2008r2, ORACLE 11G, ORACLE SQL Developer, PL/SQL, TSQL, SQL Server Stored Procedures, SSRS (Reporting), SSIS (ETL), and C# for capturing wireless telecommunication performance and customer call records in an AGILE/SCRUM environment.
• Built new ETL libraries using ETL/CASE Telecommunications-specific Database tool (NETRAC) for capturing and consolidating critical performance data into Oracle 11G databases from remote sensors. Databases were used by Radio Frequency engineers for near real time analysis and troubleshooting/monitoring of large scale (nationwide) wireless telecommunications network.
• Maintained legacy ETL system using SQL 2008 SSIS, SQL SERVER database objects, SQL, and C# to capture Large amount (terabytes per week) of critical performance data generated by remote sensors used by Radio Frequency engineers for Reporting, Near real time analysis, and troubleshooting/monitoring.
• Developed and enhanced reports for Engineers and Management.
• Used SQL Stored Procedures, Oracle 11g PL/SQL, SQL Developer and Linux scripts/commands. Used SSMS, SSRS for Reporting, NETRAC/SSIS for ETL, and Ad-Hoc SQL and PL/SQL queries. Provided Database Support to Engineering, DBAs and Mgmt staff. Resolution of database-related issues with DBA’s and SME’s. Also used MS-Excel, SVN, Excel VBA, and MySQL

Confidential

LEAD DATABASE DEVELOPER

Responsibilities:

• Complex Large-scale Database Design, Development and support utilizing ETL with SSIS, SQL Stored Procedures, SQL Queries, Web-based SQL Reporting systems and advanced DBMS tools. Built and enhanced SQL 2005 SSRS web-based reporting systems. Backup to Java/JSP developers.
• Designed and Built Bi-directional synchronization of SALESFORCE CRM with ORACLE backend database connected to SQL Server 2005 database using SALESFORCE CRM web services, SQL scripts, stored procedures, and CASTIRON (ETL) CASE tool.
• Completed backend Database design, Stored procedures, and Implementation of Large-Scale University wide Java/JSP/Tomcat web-based Grading Application used by thousands of Confidential professors to capture and transmit grades for tens of thousands of students to secure legacy grading system. ETL with SQL and Stored Procedures.
• SQL SERVER 2005 DBMS Analysis, design, SSRS reports, ETL with SSIS, and SQL coding. Supported, maintained and enhanced existing databases/warehouses/marts and database processes utilized by critical, large-scale Confidential applications.
• Backup to Confidential production DBAs. Assisted/led QA staff/junior staff/interns. Consulted with other Confidential departments as subject matter expert. Developed standards for coding, error-trapping, reporting, object naming, and other IT processes with Confidential software architects and management.
• Applications supported: Large-scale JAVA and .NET Web based applications, SALESFORCE CRM, ETL, BI/BW, other web based and cloud computing, Excel VBA, academic, and business/financial applications.
• SQL Server 2005, ORACLE, TSQL, SSRS, CASTIRON, SSIS, SOQL, ERWIN, SALESFORCE CRM, Languages/Technologies: SQL, Java, ASP.net, C#, VB, VBA, JSP, HTML, XML.

Confidential

SENIOR CONSULTANT (SR. DEVELOPER-INTEGRATION)

Responsibilities:

• Create, modify, and deploy complex SQL SERVER 2000 stored procedures, SQL Queries, and other SQL database objects used to integrate large Confidential scheduling and payroll systems. Analysis of existing SQL database structures.
• Create and modify SQL, FTP, and CMD scripts. Enhance existing forecasting system capabilities to accommodate new requirements using SQL and Delphi (Object Pascal). Worked directly with Sr. Confidential IT/Database and Labor/Payroll staff and managers to elicit requirements.
• Testing of fixes and modification with users.

Confidential

SENIOR CONSULTANT (SR DATABASE DEVELOPER)

Responsibilities:

• Maintained and enhanced complex JAVA/SQL large scale web testing applications
• Designed, Created, and modified complex Stored Procedures and SQL queries for large critical Web-based application using SQL Server 2000 DBMS.
• Served as Backup to SQL Production DBA.
• IReports and Jasper Reports (Java-based reporting) creation/modification.

Confidential

SENIOR CONSULTANT (SR DATABASE PROGRAMMER-ANALYST)

Responsibilities:

• Designed, Created, and modified complex Stored Procedures and SQL queries for critical Web-based reporting application using SQL Server 2000 DBMS, Crystal Reports. Designed, built, and modified ETL process utilizing complex stored procedures to pull large amounts of data into aggregated data objects used for strategic pricing applications.
• Visual Basic and Excel VBA programming for advanced loan portfolio pricing application.
• Crystal Reports creation/modification