PROFESSIONAL SUMMARY:

Seasoned professional with vast experience in information technology (IT) and many years of SQL Server and Oracle experience utilizing metadata. Exceptional success in driving business value and mitigating business risks on or below budget. Experience includes design specifications, development, testing, Q/A testing, implementation, and support. Extensive experience includes TSQL, SQL/SERVER 2012/2014/2016 , HADOOP and Amazon Web Services (AWS).

TECHNICAL SKILLS:

Software: AWS, CLOUD, ABINITIO, HADOOP, POLYBASE COGNOS, SSRS, SSIS, SSAS, XML REPORTS, ORACLE REPORTS, ORACLE 11g/12c, STORED PROCEDURES/PACKAGES, FUNCTIONS, TRIGGERS, EXCEPTION HANDLING, ETL, SQL/SERVER 2008 R2/ 2012/2014/2016 , PL/SQL DEVELOPER, PVCS, HYPERION BRIO, UNIX/LINUX, MSOFFICE, TIVOLI, JSP, TOAD, VMWARE, SILVERLIGHT, HUMMINGBIRD, FTP/CLIENT, TLPE/CLIENT, PC ANYWHERE, INFORMATICA, CLEARCASE, SQL SERVER MANAGEMENT STUDIO, SHAREPOINT 2010, TEAM FOUNDATION SERVER, MS VISUAL STUDIO 2008/2010/2012/2015 , BIDS/SSDT, DATABASE MONITORING,OBIEE, ODI, TABLEAU, TIBCO/SPOTFIRE, CONTROL - M, JIRA, CONFLUENCE, JASPERSOFT(TIBCO).

WORK EXPERIENCE:

Confidential, Nashua, NH

Sr. SSIS Consultant

Responsibilities:

• Designed, developed, tested and implemented numerous SSIS packages that load Oracle data to the MSBI platform.
• Data modeling includes building facts and dimension tables for the data warehouse.
• The packages are developed on Microsoft PDW and are full load packages.
• Working with users to produce dashboards in PowerBI. Designed data
• Warehouse schema fact and dimensions tables from OLTP databases.
• Working within .NET environment encompassing Visual Studio and TFS.
• Extensive TSQL experience in SSMS including dynamic SQL and stored procedures.

Confidential, Boston, MA

Sr. SSIS Consultant

Responsibilities:

• Designed, developed, tested and implemented numerous SSIS packages that replicate the ETL loads that were previously done by Abinitio ETL loads.
• Reverse engineered the process, designed and architected the flowstested with the users and provided demos to staff.
• The staging data is now stored in Hadoop with a Polybase front end.
• Data mining activities in Hadoop/Polybase include data exploration into BIG DATA and predictive analysis.
• Coded nested complex ternary stacked derived columns which include switch case expressions.
• The reporting end will continue to exist on SQL Server 2014/2016 servers.
• Utilized metadata to develop/debug packages.
• Participated in setup of Hadoop/Polybase cloud databases.
• Extensive experience in TSQL queries and stored procedures.

Confidential, Boston, MA

Sr. Data Warehouse Consultant and DBA

Responsibilities:

• Architecting, designing, developing a brand new EDW comprised of data from EPIC/Clarity, Oracle PeopleSoft and our own data to be utilized by all non IT departments across the organization.
• The packages are being developed in SSIS with SQL Server Stored Procedures and SSRS reports.
• Utilized metadata to develop/debug packages.
• Developed Full and incremental loads for ETL sourced data. Created indexes on EPIC sourced tables.
• Developing adhoc reports utilizing SQL Server 2012, Stored Procedures, and model templates.
• Redesigning the reporting structure for the clients to standardize reporting across the platform.
• Reverse engineering the data base and rearchitected it to standardize the platform.
• Analysis of SQL Server databases for performance improvements.

Confidential, Southboro, MA

Sr. Data Warehouse Developer

Responsibilities:

• Gateway and SSRS Reporting responsibilities. Migration to ODS environment which included rewriting reports.
• Maintained, supported and enhanced Data Warehouse denormalized tables built from normalized Oracle/SQL Server tables and views.
• The packages in PL/SQL include extracting the data from the Gateway, loading them into Oracle staging, creating additional views, inner and outer joins, and merge/insert data into the applicable fact/dimension tables. (ETL)
• The data warehouse is incrementally loaded daily then the SSRS reports pull the data from the warehouse utilizing Oracle PL/SQL packages, dynamic SQL and generate the reports and files from the Star Schema.
• Experience in assisting SQL Server DBA setting up new clients, backups and restores and setting up replication.
• Experience utilizing Agile/Scrum methodologies.
• Experience in JIRA/Confluence to create/modify/delete and change workflow of assigned tickets.

Confidential, Westwood, MA

Sr. Database/Implementation Consultant

Responsibilities:

• Responsible for code reviews, implementations, testing and coordinating the applications into the various environments.
• Investigate and resolve problems/issues in DEV and UAT as part of development process. Build/deploy C#, ASP.Net code to test, prod environments.
• Analysis of explain plans and database monitoring.
• Extensive utilization of Oracle Schema, SQL Compare and TOAD and COGNOS Reporting.
• Developed implementation and execution project plans acting as project leader/team lead
• In a global and matrixed environment, partnered closely with colleagues to craft solutions and gain key stakeholder support (including Executives) thru online meetings and in person visits to the individual campuses.

Confidential, Ashland, MA

Software Engineer Consultant

Responsibilities:

• Developed SSIS, SSAS, SSRS packages to resolve customer issues that include enhancements, fixing bugs and creating new packages for new customers as the organization was growing rapidly.
• Developed complex stored procedures, package variables, reports, functions, triggers and TSQL scripts in SQL Server 2008 R2 environment.
• Converted COGNOS reports to SSRS reporting tool.
• Experience includes architecting and implementing complex BI solutions.
• Developed and designed SSAS cubes to store KPI’s, aggregated amounts and other dashboard information.
• Created the star schema design that was utilized by identifying the facts and dimensions sourced from the database

Confidential, Boston, MA

Database Administrator Developer Consultant

Responsibilities:

• Backup and restore of databases, creating indexes, foreign, alternate keys, provide authorization to users.
• Created SSIS packages that take flat excel files transform the data and load the data to the database.
• Developed and designed SSAS packages to store KPI’s and aggregated amounts on cube from transactional database so legal assistants could slice and dice their data in Excel for senior management dashboards.
• Design and implementation of dimensional data models along with analysis of requirements and production of specifications for business intelligence functionality with ETL and reporting components.

Confidential, Manchester, NH

Business Intelligence Consultant

Responsibilities:

• Developed SSIS packages utilizing Configuration Manager. Created Actuarial ITD Paid Loss reports from SQL server tables which included creating the queries, subtotal by treaty and risk state, then produce a grand total for the entire report.
• Developed SSRS packages that extract loss run information from reporting databases and produce monthly detail and quarterly summary reports. Created scripts in VB.net for SSIS to utilize in package.
• Designed control flow and data flow components in SSIS which included stored procedures, transformations, conditional splits, derived columns, fact and dimension tables.

Confidential, Mansfield, MA

Business Intelligence Software Engineer Consultant

Responsibilities:

• Designed, architected new data warehouse platform which included SSIS, SSRS, SSAS, data mining, data feeds and extracts, cube design, model design, star schemas, staging tables, ETL processes such as control and data flow and full reporting capabilities and features.
• Utilized and developed CLR and TSQL stored procedures, LINQ for database inquires and updates, Silverlight and C# for the UI, VMWare to develop and test multiple operating environments such as Windows Server 2008, Server 2003, Windows XP, and Windows 7.

Confidential, Augusta, ME

Business Intelligence Developer

Responsibilities:

• Developed ETL process that takes information from several sources and loads them to a cube that is utilized statewide.
• Developed trial balance reports in T-SQL with chart and graph info which contains rolling totals from prior years thru current year.
• The T-SQL was imported and utilized in the final development of SSRS reports.
• Developed SSRS reports that prompts user for document ID instead of date to save time and money.
• These documents are scanned on paper later on after they become reports.

Confidential, Marlboro MA

Business Intelligence Developer

Responsibilities:

• Modified SQL/SSIS control flow and data flow to load parking noticing data from UNIX to SQL Server 2005/2008. Created/updated/altered SQL Server 2005 tables with new municipality information.
• Created and modified ETL’s in SSIS to load updated information that included name and address and any tickets outstanding from other states. Data sources included staging tables, fact tables, dimensions, cubes and star schemas. Converted Cognos reports to SSRS reports.
• Created and modified reports thru SSRS and converted Crystal Reports to SSRS for end user reports and PowerPoint presentations. Loaded extracted data into cubes for fact and dimension tables utilizing Star Schemas and SSIS transformations. Data originated from SQL server tables, Excel spreadsheets, and UNIX flat files.

Confidential, Tewksbury, MA

Migration consultant

Responsibilities:

• Migrations from legacy systems to HP/UX environment.
• Code/test UNIX scripts, programs that produce reports and files for various departments within the organization.
• Modified shell scripts to split report files into numerous report files for other departments utilizing AWK and PERL.
• Create UNIX shell scripts to modify test data for seed expansion testing.
• Modified SQL Server 2005 tables utilizing T-SQL, database tuning advisor, and UNIX shell scripting to create and modify test data for jobs that contained no test data.

Confidential, Braintree, MA

Sr. Programmer/Analyst

Responsibilities:

• Designed, coded, tested and implemented various enhancements and maintenance projects to legacy reservation system.
• Problem determination, debugging and tracking via ClearQuest tickets, on call production support duties.
• Responsible for hotel property conversions in UNIX, HP-UX, ORACLE, Windows and legacy environments.
• Entails creating, modifying and executing scripts and ISQL queries on UNIX that upgrade and convert front end property systems.

Confidential, Quincy MA

Programmer/Analyst

Responsibilities:

• Developed ETL’s for the ODS to meet business reporting requirements.
• Modified existing ETL’s to add new columns and develop staging tables to simplify and improve efficiency for BRIO reports.
• The staging tables were derived from a combination of the ETL and customized PL/SQL.
• Created and modify the mapping procedures that are utilized in the ETL extraction process.
• Changed the renewal diaries which encompassed modifications to DB2 tables and desktop code.
• Developed numerous PL/SQL procedures for corporate reporting utilizing ORACLE 8.17 and BRIO 6.5.
• Utilized BRIO and Tivoli scheduling facilities to run regular reports and to verify if the previous night’s reports had executed successfully.