PROFESSIONAL SUMMARY:

• Highly motivated Software Developer Professional with 17 years of experience in Application Development & Analysis as well as cutting edge technologies, such as; .Net and SAP/Business Objects Crystal Reports (up thru 20011),Data Warehousing. SSAS Recent development work includes; specializing in Object Oriented based programming utilizing; VB.Net, ASP.Net, C#, Oracle, Access, VB Microsoft SQL Server SQL Reports, Crystal Reports and SQL Server Report Services (SSRS).. Hands - on experience leading all stages of system development efforts, including requirements definition, design, data architecture, testing, and support.
• Net Framework with Visual Studios, BI STACK, Crystal Reports, Sequential Query Language, Database Architecture and Analysis

TECHNICAL SKILLS:

Platforms: UNIX (Solaris, HP-UX), Windows 2000/XP, IBM 370/OS2, Oracle11g

Languages: VB/ASP .NET, C#, VISUAL STUDIO, LINQ,2013, SQR, SQL-Server, Oracle, MF-Cobol, Access

Tools: Visual Studio, Excel, Tableau, SSRS, CRYSTAL REPORTS

Query Languages: T-SQL, MDX, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Mashantucket, CT

BI/SQL Stack Business/Data Analyst/Developer

Responsibilities:

• My assignments were to analyze and developing a variety of BI stack projects. The SSIS projects that I developed contained various Health Plan carriers claims and eligibility data for Foxwoods employees in both transferring data files and maintaining data warehouse tables. Developed procedures that used queries with advanced joins/unions created in SQL Server 2014. Created a VB.net form that would display the various carrier insurance coverage enrollee status codes and other data. I used Visual Studio Community 2013 to develop the VB.net form which was set up to accept the group and plan search criteria (text/search button types)to be displayed in a grid using a binding source/navigator
• Overall Project result, I kept analyzed the current Access Health plan projects and corresponding modules, build events in developing the new SQL Server SSIS packages, stored procedures, views and queries.
• Developed Tableau 10 workbook Data warehouse reports and dashboards with charts, graphic and parameters showing various member deductibles, out of pocket expenses by insurance carrier, elevator operations with parameters.

Confidential, Bloomfield, CT

Senior SQL Data Analyst

Responsibilities:

• Developed SSRS BI Data warehouse reports and dashboards showing elevator operations with parameters.
• Developed User Acceptance test plan with the internal Business analyst.

Confidential, Hartford, CT

Software Engineer 2 BI/SQL Tableau/SSRS Lead Developer/Senior Business Analyst

Responsibilities:

• My primary position as the Senior Software Engineer was as a Business analyst gathering business and technical requirements and mentoring a junior business analyst, ETL (SSIS) developer and report developer in analyzing and gathering the business requirements and writing the technical specifications and test plans in developing from various Access 2010 DDS applications to SSRS reports in Visual Studio 10 and ASP.Net C# using report viewer object. The Database was SQL Server 2012 for processing the daily and historical data warehouse DDS Providers, Programs and Customer reports.
• Transferred the access data by writing SSIS jobs in developing 67 Hold Billing, Quality Review, and other demographic/financial SSRS reports.
• Developed the first Tableau 10 series of workbook and workbook packages and dashboards that utilized interactive filters.
• Developed the database model relational diagrams using the SQL server data diagram tool which was used to confirm the database data table mapping used to create the reports SSAS cubes with dimensions and facts, SQL query, functions and stored procedures.

Confidential, East Hartford, CT

BI/SQL SAP Business Objects Universe Lead Developer/Business Analyst

Responsibilities:

• Developed the database model relational diagrams using the SQL server data diagram tool which was used to confirm the database table row cardinality generated for the adhoc reporting reports portion.
• Created BO universes using the IDT tool to build the Data foundation derived tables, business layer folders that connected the individual universe with an ODBC type connection to the SQL server.
• Categorized the dimensions, details and measures data fields for the business layer.
• Produced over 28 Power BI high quality Time-Cost reports for aircraft engine Inventory, labor tasks and parts that the customer appreciated with expressions.
• Utilized Oracle Explain plan (execution plan) on queries in generating materialized views.

Confidential, Stamford, CT

BI/SQL Business Analyst

Responsibilities:

• Created eight new SSRS Service delivery reports in particular a series of phone Carrier reports under the same category named the ”Not Done” reports. The focus of each of the four reports was to prevent dropped Carrier phone lines from occurring on an installation calls by showing the appropriate Service Delivery managers the drop dead times of those installations still in progress through listing the order info, schedule with the Carrier information.
• Most SSRS reports used advanced SQL joins, date functions, drill down and grouping techniques for rows and column grouping within Pivot tables and Charts.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Involved in the designing, development, modification and enhancing the database structures and database objects

Confidential, Hartford, CT

SSIS/SQL Business Analyst

Responsibilities:

• My primary position as an ETL developer was to work on Bank NEC data transfer jobs for the in-house EMR systems tracking account benefits payable creating individual SSIS ETL jobs for which I attended WebEx online project meetings conducted by Business Systems analyst in proofing their functional specification for each ETL file.
• ETL package utilized lookup, derived, input/output (ODBC and excel), error handling object sources
• Developed SQL Server 2008 stored procedure for transferring any generic tables data from a staging table to report table used in the reporting system.
• Created SSRS Bank reports using Visual Studio 10 and SQL Server 2008 Management Tools such as Query Analyzer. These reports used advanced grouping techniques for rows and column grouping within matrix tables.

Confidential, Hartford, CT

Microsoft Application Developer/Analyst

Responsibilities:

• My primary position as a Microsoft Application Developer/Analyst was to replace an existing Excel based report system using an SQL Server 2008 database with a new Report Builder 3 (SSRS) written report system for the BIRS (facility access control) application system on a daily basis. The real estate portfolio data (space, people and cost dimensions) is linked to a SQL Server 2008 R2 database using report objects such as list parameters, expressions, VB code, sub reports and charts.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• These reports used advanced grouping techniques for rows and column grouping within matrix tables.
• Developed SQL Server 2008 queries, views, T-SQL functions and stored procedures.
• Created six new Real Estate Statistical Reports using Report builder 3 and SQL Server 2008 Management Tools such as Query Analyzer and SQL Profiler...
• Developed user tests in meeting with internal clients and gathering requirements.
• Performed DBA analysis with explain plans in implementing performance tuning query measure such as optimizer index hint, view, created clustered/non clustered indexes for 30 million row table in order to traverse table quicker.

Confidential, East Hartford, CT

SQL Database Specialist and Data Metrics (BI) Analytics Specialist

Responsibilities:

• My primary position as a SQL Database Specialist was to develop and maintain an existing Microsoft SSRS reporting platform system on a daily basis. The classified reports data were linked to a SQL Server 2008 R2 database using parameterized on-demand SQL procedures and pivot tables inside a SQL procedure. Development tools included Visual Studio.
• Developing stored procedures to enforce business rules
• Developed SQL Server 2008 queries, functions, stored procedures and views
• Created new Tableau workbooks, facts/dimension tables and web dashboards on a highly classified Data Analytics project.
• Developed a data cube analysis (SSAS) project using Visual Studio (BIDS).
• Added Statistical formulas and Predictive forecasting to SSRS reports and dashboards.

Confidential, Stratford, CT

Senior Marketing Business Analyst Contractor

Responsibilities:

• Experienced technical and analytical in-house IT resource for supporting a variety of in-house and vendor software systems.
• Responsibility is to develop and document existing or proposed online systems based on in house client requirements communicated from the directors of these systems.
• Vendor systems supported was the Epicor ERP manufacturing system.
• Developed SQL Server 2008 SSIS packages to import the data files into the Inventory Scheduling
• Developed SAP/BOU 3.0 BI Sales Reports and Dashboards for the US and Canada based on product and year parameters. Developed a web dashboard using objects like cross tabular matrix tables. Added charts with variables to link behaviors between filters and data objects.
• The other major project was building inventory intake web forms built upon an ASP/C#, JavaScript, XML and CSS and to print out the reports using SSRS matrix tables objects.
• Took in inventory data for inventory auditing purposes in reporting the data using Crystal Reports 11.3 plus web intelligence in sub-detailing by regions-country-locations.

Confidential, Middlebury, CT

VB.Net/VB Web Developer

Responsibilities:

• Maintained SAP/BO 2011 Crystal Reports with a SQL Server 2008 database platform.
• Extensively worked on constructing complex quantitative data models to answer questions by gathering and structuring data, creating formulas or queries to manipulate data, validating data accuracy and integrity and insuring the models output answers the intended questions.
• Created drill down SSRS Ad-hoc reports as needs arise.
• Built a document retrieval system for them in ASP/VB.Net/C# & SQL Server 2008 and trained employees how to use it. Developed a Tableau 7.0 dashboards and books with quick filters.
• Additional benefit to client was to use Blackberry to log into the internet in order to search and retrieve desired documents for court.

Confidential, Hartford, CT

Senior Business Intelligence Report Analyst

Responsibilities:

• In the dual roles as a Data Analytics analyst, application tier 2 support and a report developer, I am the most experience technical and analytical in-house IT resource for supporting a variety of in-house and vendor Software systems.
• The other major systems that supported are a AMS based EMR system for medical claims, scheduling, immunizations and records, an in-house Facilities system (BIDS Cube based) and an outside vendor Finance system named American Fundware (updating SAP/BO Crystal based reports.). In addition, developed an online system based in ASP.Net/C#/Visual Studio for storing and reporting Agency and Services for CRT
• Maintained the various EMR lists such as the transaction types using SQL queries.
• In accounting Systems covered are the Universal Intake system called Captain for registering new clients in which developed a series of state mandated DSS-CT Department of Social Services reports in Crystal Report XI R2 on a SQL Server 2005 Database with dynamic parameters.
• In conjunction with CRT’s Planning department, I worked on the Business Intelligence future funding project with the Assistant Planning Director. Developing new SSAS based cubes (facts, dimension tables) and MDX queries in trying to forecast the organizations future budgets from variable factors (client intake, grants, cost of services, etc.) that were fed into statistical forecasting predictive models and formulas.
• Put together a series of SSIS packages to transfer the data from FoxPro to SQL Server 2008.
• Primary responsibility is to develop business requirements for existing or proposed online systems based on in house client requirements communicated from the directors of these systems.
• Developed new Remedy tracking of application issue reports and submitted business requirements for adding new data field requirements for the vendor online forms.
• Maintained and developed new Cognos reports on a SQL Server 2008 platform for HR grouped by agency services and/or CRT regions in CT. Used list prompts with queries and parameters.
• Rewrote a new VB.Net Nutrition system for the Meals on Wheel program with online SSRS reports,
• This new Scheduling and Food ordering System consists of 10 menu-driven screens utilizing the latest window components like grids and lists plus database binding source programming techniques.
• This new VB.net system’s purpose is allow daily online meal lists while producing Driver routes, schedules and a list of the total food preparation (breakfast, snacks and lunch) ingredients for 39+ communities and 5000 meals.

Confidential, Naugatuck, CT

Senior Application Developer

Responsibilities:

• As a developer on the Deposit Accounting System (DAS), my primary responsibility is to manage/support the current Billing/Accounting based software and develop new DAS (Deposit Account System) software.
• Provided SQL Server 2005, NET (#3.5), Clear case and Visual Safe Source and supporting end users.
• Designed the ASP.NET/C# Online Pickup Count and Sample project specifications, menus, grids, components as needed to add, change and update data.
• Worked on SSIS packages using task logic control flow modules for identifying data field errors for reprocessing.
• This project was an effort to coordinate the field processing of machine counts through data entry on the Intranet utilizing Tableau web dashboards.
• On a daily basis worked with internal clients on gathering analysis in developing
• Created a MS PowerPoint presentation with pictures and video graph new recycling system invoice written in SSRS including reports having table structures, command Objects, SQL expressions, and sub-reports(drill-thru)
• Diagrams, SSIS packages and new SQL procedures. Experience in writing ADO/OOP methodologies.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2005
• Created Cognos reports for Billing and Collections, tabular with parameters displaying Client Account information.
• Constructed cubes based on data volumes mostly adhering to Star Schema

Confidential, Hartford, CT

Senior Business Analyst Programmer Contractor

Responsibilities:

• Provided expert SQL skills and consulting to management, developers, and end users.
• Designed the ETL project specifications, file types, record layouts, field specifications as needed to exchange electronic data compatible to both our and the recipients data systems under a Unix Korn-shell job environment.
• Created new Online Interagency Revenue Collection system utilizing VB.Net forms and Crystal Reports.
• Develop new SQL Server 2003 DTS packages, procedures, functions and triggers.
• These programs primarily focused in corporate and sales tax returns.
• Authored and updated program specification, Crystal reports, file layouts, and test documentation using Microsoft Excel, Visio and PowerPoint for publication on the Accenture website portal.
• Analyzing and system testing the background procedures and functions involved in processing. In general, this would involve entering the data into a form and testing the data flow as it passes through to the batch programs.
• Tested numerous scripts with hundreds of test conditions. A typical script will require the insertion and filtration (utilizing SQL) of tax demographic conversion data from the existing revenue system database system called MBDB to the SQL Database tables.
• Production support and new report development using SSRS.
• Created a variety of DRS notification reports where the data was formulated using data modeling.
• These reports called upon background SQL procedures which had to be modified and tested.
• As a reward for delivering all my deliverables on time or below budget and putting in over 300 overtime hours, Accenture. Sponsored a banquet and an overnight stay in Boston in February 2004.

Confidential, Avon, CT

Data Analyst/Conversion Developer

Responsibilities:

• INSIGHT application development of Mortgage Loan System for eight Northeast Savings and Loan Banks.
• Converted 8 new banks to the COCC Oracle database application system by writing (custom procedures, PL/SQL).
• In a team of two developed an online parameter driven Mortgage Property Crystal and Crystal reports as part of the Insight Loan application.
• Legacy data mapping and conversion Business requirements validation and updates.
• Quick learning curve of the Insight component framework Oracle server with Cognos data warehousing backend and client side development of a separate function within application.
• Rapid and quality application development to meet customer need.
• BO Crystal Reports and support to internal programmers.
• During development process developed, deployed, debugged, and tested data conversion procedures and functions. For T-SQL stored procedures and functions we have employed SQL navigator. SQL cursors with
• Performance tuning enhancements (outer joins, exists, unions) at times were used to obtain maximum data processing efficiency.
• In order to achieve near zero errors data conversion levels a strict pre-mock implementation test script was followed and applied.

Confidential, West Hartford, CT

Senior Programmer Analyst Contractor

Responsibilities:

• Analysis and validation of current SCT-Financial and Accounts Receivable Business architecture, data model, tools and technologies on an ORACLE-UNIX client server platform.
• Tracked, resolved, and explained how the Banner financial system applies general ledger fund transfers as part of the finance customer service team.
• Lead analyst and Oracle Reports writer for the Data Warehouse Archive application project team.
• Documented and evaluated the proposed Banner system inventory selection committee team.
• Research and specification design for AR project concerned with nightly EDI data transaction file with the State of CT’s Comptroller office.
• Solely responsible for communication to the Oracle 2000 application development team and SQR report maintenance.
• In order to appropriately select the Inventory Financial Banner module application we compiled, categorized, and prioritized requirements for selection process.
• Developed an AR project for funds transfer -redesigned forms with Oracle 2000 layout editor - to demonstrate the outcome of using the proposed system.
• Object design envisioned list of values, block-item triggers, and other OOP technologies.