SUMMARY:

• Senior Database Engineer/SQL Developer with experience in high profile critical project development and production support. Many for Confidential with 1000’s of users. Also worked as a SQL Server DBA for backend support of large production SQL Server Databases.
• Expert level development of high performing complex SSIS ETL packages, SQL Server 2012 Analysis Services, BISM Tabular Models, Complex Stored Procedure Development and sophisticated SSRS and Excel VBA reports. Many applications used very large complex databases.
• Full development life cycle - Which included meeting with users and managers to design specifications, Design of Databases, DataMarts and Data Warehouses, Programming and Development of applications, Training of end-users, Creating end-user manuals, Support and enhancement of applications in production.
• Data Analysis - Gathering data rules and requirements, Data Mining, performing data analysis on Large datasets and Data Warehouses.
• Extensive experience Performance tuning complex Stored Procedures/SQL Queries in SQL Server and Oracle.
• Have worked independently and also on small and large teams of IT Professionals.
• Solid experience in SQL Server 2000-2014.
• Data Migration/Conversion, Programming in VB.Net.
• Heavy experience with Financial and Accounting and Brokerage/Trading applications.
• Ability to meet deadlines, quickly learn new technologies/applications, organizational skills, attention to detail, problem solving, creativity, strong work ethic and professionalism.
• Excellent References.

TECHNICAL SKILLS:

O/S: Windows, UNIX

Environment: Visual Studio, VB.Net, ASP.Net, ADO.NET

Languages: T-SQL, PL/SQL, C#, VB 6, VBScript, UNIX Shell, JavaScript, HTML

Databases: SQL Server, Oracle, DB2, MS Access, Sybase

Tools: SSIS/SSRS/SSAS, Informatica ETL, DataStage, PeopleSoft, Control M, Investran 4.4-5,2, Adobe Acrobat 5-6, IIs 4-5, COM, DCOM, ASP, XML, VBA Excel/Access, Windows API, OLAP, Visual InterDev 6.0, Visual Source Safe, Installshield 5-7, MTS, FileNet, Crystal Reports 6 - 11.0, SBT Acct Software, Visio 5.0, MS Word, Excel, Btreive, R&R Report Writer, Blinker, Outlook

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer/DBA

• Development and Support of a very large application for government subsidized cellular phone sales and management - The Application manages customers phone and sales information for Sprint and Xerox. I designed new and enhanced existing stored procedures and SSIS packages for the application. This included development of new functions and stored procedures, modifications to existing stored procedures, Investigation and remediating extensive complex bugs and issues that existed in the application.
• Extensive performance tuning of existing stored procedures in the application.
• 24 hour On-Call DBA production support of the application.
• Large New Automation Project - Tasked to develop a major new application to sync their data between Xerox and Sprint and to eliminate many of the issues that they were having related to this. The development included SQL agent job creation, Design and development of complex stored procedures, new functions and new tables, triggers and indexes for the application.
• Worked on many SQL Server DBA functions and full access Production support for the application. - Developed many different TSQL scripts for production support and administration functions. Fixed many various day to day issues in their production environment some of which were very complex critical and time sensitive issues.
• Completed design and development of daily complex T-SQL scripts for “Backdoor” updates of various tables for the application to resolve problems and bugs that occurred frequently. Also was on call for 24-hour full access production support to fix critical production issues as they occurred sometimes late at night. Also completed tasks to fix problems with SSIS packages, ftp processes and T-SQL scripts in production.
• Various smaller SQL Server Miscellaneous projects. Which included new development and enhancement of SQL scripts and stored procedures for various purposes.

Lead Developer

• Several complex SSRS Report Projects and associated SQL stored procedures to be used by high level managers to track various business functions. Automated reports to be delivered by email to users using SQL agent jobs. Created complicated SQL stored procedures to provide data for the reports.
• SSIS Package Development - Created many packages to transform data from different sources to Staging tables to be used for SSRS Reports.
• SQL Server 2012 Analysis Services BISM Tabular Model Architect. Created large SSAS BISM Tabular Model for a Database Warehouse model in SQL Server 2012 SSAS. Then used this SSAS database model to create sophisticated Excel PowerPivot dashboards and reports with charts to display various Sales and Business specific information which can be filtered in various ways using Excel slicers. The reports are accessed threw SharePoint. In addition, some of the Excel reports used MDX and DAX queries to bring tabular data into Excel.
• Major Highly visible VBA Word project which created a sophisticated report used in RRA offices all around the world. The application combined information from a large in house job recruiting management application into an extensive detailed report in word regarding the status of there job recruiting projects. VBA was used to sort and display the data in a very specific format in word. The report can also be displayed in all major languages,
• Developed SSIS packages to load a Neo4j Graph database on Windows Azure. Created SSIS packages to transform data to be used in an Neo4j graph database for employment candidate’s connections and relationships in a graphical format
• Various SQL Server Miscellaneous projects. Which included SQL query development for various tasks.

Lead Consultant

• SSIS package development to transform data from various SQL Server and Oracle databases into staging tables for SSRS reports and other functions. SSIS included complex script tasks in VB.Net and C#. Created SQL Server Agent jobs to run SSIS packages according to specific schedules needed.
• Developed several SSIS packages to migrate data from Oracle to SQL Server databases.
• Developed SSIS packages to facilitate the integration of companies that Gain Capital acquired.
• Design/development of very complex SSRS Currency Trading and Accounting Reports used by high level accountants and staff. Many reports developed are used for Critical Regular Audits for significant financial trading and Accounting regulations and rules. Deployed reports to website and created SSRS report subscriptions.
• Developed, modified and performance tuned complex Stored Procedures in SQL Server and Oracle.
• Created triggers, functions, tables and indexes in SQL Server and Oracle.
• SSIS packages developed include extensive logging and error handling functions
• Development work in SSAS for developing cubes for reporting purposes.
• In house support tasks, ad-hoc SQL development and production issue resolution tasks.

Lead Consultant

• Developed/enhanced high level sophisticated customized Financial and Accounting Visual Studio SSRS reports.
• Created SSRS report subscriptions used by high level managers for many business critical decisions and included reports that analyzed performance of different PIMCO financial trading products, performance of Sales Analysts and effectiveness of different marketing techniques. Data for reports came from real-time customized Database in SQL Server using the MS CRM Management platform and a historical Data Warehouse database in Oracle.
• Developed complex SQL queries and Stored Procedures for reports in PL/SQL and T-SQL.
• HTML modification and enhancements of customized Microsoft CRM menu interface.
• Developed extensive and complex SSIS packages to transform data from various sources into SQL Server Databases and SQL Server Data Warehouses
• Developed Excel VBA reports/interfaces for business users.

Lead Engineer Consultant

• Oracle PL/SQL Stored Procedure development to pull data from servers to local tables for reporting.
• Developed new and modified complex SSRS Reports for Globalization project using PL/SQL to access Oracle data.
• Designed/developed a Data Warehouse using a Star Schema Data Warehouse design with dimension and facts tables related to Weightwatcher sales, food and other specific data related to programs in SQL Server 2008.
• Developed extensive SSRS reports for the Data Warehouse and used in Oracle and SQL Server Data Warehouses.
• SSIS ETL development, designing complex applications to load real time data from Oracle to the SQL server Data Warehouse.
• Excel VBA applications for several complex accounting and sales reports.

Lead Developer

• Informatica ETL Development - developed and supported many major Informatica ETL workflows/mappings projects to load data to Data Warehouse from 3rd party vendors.
• Involved in major Version 7 to Version 8 upgrade. Developed using large data warehouse for analysis and reporting and also OLTP Oracle and SQL Server databases standalone databases for real time reporting.
• Extensive work in Visual Studio 2005 and 2008, VB.Net and Visual Basic 6.0 development of front-end applications.
• Heavy development work in T-SQL (SQL server stored Procedures / triggers / views / database design.
• IBM DataStage development - Modified and created several DataStage ETL workflows.
• SQL Server 2005, 2008. Developed complicated DTS and SSIS ETL to import flat files and perform data cleansing and manipulation from various vendors into a Data Warehouse and other standalone databases.
• Heavy development work in Oracle 9i-10g PL/SQL.
• Designed many different Access/VBA and Excel VBA applications.
• Crystal Reports development work and support
• Sybase support and query development work
• Web application ASP/VBScript development work and support.
• Some SQL Server DBA work.
• PeopleSoft Nvision reporting development.
• PeopleSoft AP, GL, TR, PeopleCode, Application Designer, Peopletools and SQR work.
• Heavy query development using Oracle PL/SQL for PeopleSoft and other applications.
• Testing/QA support for PeopleSoft modifications that are made by our PeopleSoft development team.
• Control M scheduling support and development for Mainframes.
• UNIX scripting and parameter file development.

Northport Financial Portfolio Management

• Full development life cycle development of complicated Brokerage Hedge Fund and Equity, Bonds, and Derivatives Portfolio Management accounting reports for various clients of Northport and internally.
• Development tools used were Informatica ETL, VB6/VB.Net, VBA, and SQL Server 2000.
• Complicated T-SQL Stored Procedure work and triggers. Crystal Reports 8.5-11 where used for reporting and Excel. All reports where done using the Investran Accounting Software backend database. In addition, extensive VBA work in Excel for various accounting type reports. SQL server DBA functions and support and SQL Server. Developed complicated DTS packages for various functions.

Developer

• Worked on projects which used Informatica ETL. The systems developed encompassed various reports, import and validation routines for Hedge fund derivative transaction and trading data.
• SQL Server was used on most projects and developed T/SQL Store Procedures. Data came from Brokerage firm’s Hedge Fund Divisions i.e. Goldman Sachs/Morgan Stanley reports were used to audit Hedge Fund trading operations and computerized daily data streams.
• At USB Corp, developed an Informatica ETL Oracle system with PL/SQL Stored Procedures.
• At ABM Amro developed a T-SQL Stored Procedure for Informatica ETL workflows application for financial reports from SQL Server 2000 tables. Another project entailed reports in Crystal Reports 9.0 using ASP.Net to pass parameters to Oracle 8i store procedures (PL/SQL) for financial reports in Crystal Reports.
• Completed an Invoice Reporting System in Crystal 8.5, using SQL Server 7.0 Stored Procedures for ABM Amro. Designed an ASP.net website and created complex Oracle PL/SQL Stored Procedures. The final result of this is a parameter driven financial report generated in Crystal Reports on the web called by an ASP.net web page.
• For Daikin, used VBA Excel for a timesheet entry and reporting system using VB to generate an Excel timesheet with macros.
• Completed a complex critical application for Mitsubishi, which uses s. The system is used to generate several heavy-duty financial type forms and schedules required to be filed to the government on a regular basis by the bank. Very complex T/SQL Stored Procedures were needed to do the various financial calculations needed.