SUMMARY

• Combining a unique Technical and Business background my background includes over 20 years of professional technical experience in the Information Technology industry involving, structured application design and development, project management, user training, desktop installations, systems and business analysis, troubleshooting and have successfully designed, developed and implemented numerous time and cost - saving solutions for Clients for many years.
• The last 10 years have been primarily focused on Backend and Business Intelligence development solutions(SQL Server, SSIS, SSRS and other BI Reporting/Analytical Tools)

TECHNICAL SKILLS

Languages/Tools: MS Office 97 /2000/2010 , Crystal Reports, Impromptu, VBA, VBScript, JavaScript, T-SQL, DHTML, XML, Visio, Visual SourceSafe, Visual Studio 2010 (Team Foundation Server), Perforce, DTS, Stored Procedures, VB.NET, C#, PL SQL, XSLT, ASP.NET 2.0/3.5, SharePoint, SSIS 2005/2008, SSRS, SS-BI Development Studio/2008, Tableau 6.1

Databases: Sybase11, MS SQL Server 6.5, 7.0 and 2000/2005/2008 R2/2012, Access97, 2000/2003/2010 , Oracle 9i, TeraData

PROFESSIONAL EXPERIENCE

Confidential

Sr Data Analyst

Responsibilities:

• Creating a 360 View of the Banking Customer via Data Warehouse and templating a customer information file (CIF) across all Lines of Business.
• Reported to the CTO and other Senior Level Executives
• Tools used: Access(SQL),Excel, Power BI, Project, Visio, Office 365, performed data reporting and concept driven BI Analytical reports
• Interrogated Banking system extracts to investigate Data Quality through Data Profiling and provided a clear understanding of the current data state to the Client
• Performed Vendor Backend and GAP Analysis on 8 different Banking Systems (ie Loans, Wealth, Retail, Insurance)
• Completed current Banking Reporting Inventory Analysis for All Lines of Business analyzing 100’s of reports and their usage
• Participated in Project meetings and conducted face to face meeting with the lines of business gathering requirements

Confidential

BSA/ SQL Developer- Data Warehouse

Responsibilities:

• Member of the Data Sourcing Team.
• Performed validation queries in both Tera Data and SQL Server and created queries to update the backend systems
• Created Data Profiles Gap Analysis, and Transformation documents and worked with ETL Team regarding and creating backend SQL code changes
• Performed Source to Target Mappings
• Performed backend analysis for a Claims Billing Audit Project to consolidate Medical Claim error payments

Confidential

Sr. BI SQL Developer

Responsibilities:

• Managed company-wide proprietary reporting interface that gave users the ability to filter and personalize over 500 SSRS reports.
• Migrated over 500 SSRS 2005 reports to SSRS 2008 and integrating those reports into the Clients proprietary reporting interface
• Performed Data analysis on current BI Reporting processes and Workflows and suggest/implement architectural changes to increase efficiencies
• Developed SSRS/Proprietary Reports for the Business Community (meeting with the Users, BA's involved)
• Acted as a mentor regarding SQL coding/Standards to BI reporting Team.
• Created and maintained SQL Jobs within the SQL Server environment to better handle Workflow issues
• Created SSIS ETL packages to test performance and perform data validation on disparate data systems for audit purposes
• Environment SQL Server 2012/2008(T-Sql, Dynamic Sql, Stored Procedures,Views,Functions,CTEs),, SSIS, SSRS 2005 and 2008,XML, and TFS

Confidential

Sr. Business Systems Analyst/ SQL Developer

Responsibilities:

• Architected and built framework for centralized Letter Generation system
• Standardization of all Pharmacy backend processes in multiple terabyte databases using a Common Data Model paradigm
• In process of Implementing standardized reporting system across all database platforms
• Provide mentoring and development of team members

Environment: VBS Scripting, SQL Server 2012(T-Sql, Dynamic Sql, Stored Procedures,Views,Functions,CTEs),VBA,SSIS,Access,Power Shell,MS Project, Sharepoint,Visio

Confidential

Consultant: Tech Lead

Responsibilities:

• Developed requirements, designed, enhanced the DSL(Definitive Software Lbrary) Database
• Customized User Application Profiles to Deploy correct Applications for User Deployments
• Worked with the Application Transformation Leads and Business Partners to maintain the database in support of application rationalization, testing and remediation
• Heavy use of T-SQL, Stored Process, Functions, Views-Developed numerous T-SQL AdHoc queries and Reports using MS Excel.
• Performed SSRS and DB Administrative functions
• Lead DSL DB Training Sessions and Reporting Training Sessions with Shire Users in US and International Offices

Environment: Visual Studio 2008, SQL Server 2008R2,BIDS 2008, SSRS 2008, Systrak, SCCM 2007, SCCM 2012, MS Excel, SAP HR DB

Confidential

Consultant - Software Developer/SSIS/ETL Data Project

Responsibilities:

• Microsoft XBox Project delivering Data Content files through SSIS ETL Processes.
• In addition, as a member of a Project Team, re-writing the entire ROVI 1.1 Product Portfolio to an updated
• Worked in an Agile/Scrum environment using VersionOne using a Jira ticketing system
• Conducted Technical and Business Gap Analysis on ER/Schema Models migrating multiple Content Warehouse Databases into one central Core Model Database.
• Participated in many Data modeling discussions and provided input for enhancements to the Model.
• Worked with Product Owners to verify data content and data quality before product packaging
• Worked with the QA Team to assist with Testing, data validation and data quality based on User Acceptance Criteria

Confidential

Consultant - Software Developer/Project Lead/ Data-Business Analyst /Trainer

Responsibilities:

• Automated numerous manual processes that saved over 40 hours of manual processing thereby allowing Head End Engineers to solely focus on Engineer capacity related activities
• Created other automated BI DataBase Tools (provided Trending and granular level analysis reporting on a weekly basis) without adding any additional manual processing hours.
• Integrated data from numerous backend Confidential data sources to mine other vital sources of information (i.e. Billing, Video, CMTS,VOD)
• Extensively used SSIS (ETL), SSRS along with SQL Server 2005/2010 DB tools and asp.NET/vb.net Web integration through SharePoint. Created some reports in Tableau 6.1.
• Created a Capacity Reporting Dashboard and Scoring System for Engineering

Confidential

Consultant - Software Developer/Project Development

Responsibilities:

• Developed Security Notification Software for the Global SAP environment. Email notified Users of lack of Global Security Compliancy standards being met.
• Users Notified Globally by dynamically creating customized Emails using VS2005, ASP.NET2.0, C#, VB.NET (classes, objects) and JavaScript.
• Once alerted, the Users were pointed to various software tools to install locally to meet security standards. Senior VP of SAP IT was directly involved in this initiative.
• Over 30,000 emails generated to Asia, Europe, and USA.
• Database Development using SqlServer2005, Stored Procedures, Bulk Load, Linked Servers, and importing SAP Global Users from Active Directory into SQL Server database.
• Created Business Intelligence Development Project creating ETL processes moving text based files into SQL Server2005 database.
• Dynamically created tables by way of linked servers consuming data from other countries into a Reporting Database.
• Setup a SQL Server Database, using create scripts to create the new server, databases, tables and migrated the table data.
• Developed Work Status Software for the SAP Client Services Group. Previous Work Status Reporting was done by using a manually static process.
• New Work Status system can now be created dynamically and reports can be generated using Reporting Services.
• Created Console application using c#, scheduled using Windows Scheduler, provided the capability to pass in arguments that would dynamically and specifically refresh the Weekly Reporting Database.

Confidential

Consultant - Software Developer/Project Development

Responsibilities:

• Created custom User Controls that enhanced an eased the Data Entry process for users (created smart text boxes for tax ids, phone numbers, zip codes, and dates).
• Created Console Applications in C# running as a windows service to deliver Email batches to Grant Submission Applicants.
• Enhanced Business Layer Helper Classes and Data Access Classes. Used .NET capabilities for the uploading of files and utilizing MS Excel.

Environment: The following technologies were used in the past twelve months, Visual Studio 2003, Visual Source Safe, Oracle 9i, PL/SQL, VB.NET, ASP.NET 1.1, C#, JavaScript, XML, and XSLT. Used forms based Authentication for the application.

Confidential

Consultant - Software Developer/Production Support

Responsibilities:

• Performed Systems Analysis and created performance metrics for various Servers.
• Set up Application Servers and Biztalk Server for Testing and Development environments.
• Monitored and Administered many Application Servers/Database Servers and Software Applications.
• Wrote VB6 application using the MSMQ Object model to clear and repopulate MSMQ -Private Queues.
• Established timely resolution of Software issues with clients.
• Corrected numerous Software related issues using Visual Studio .NET, ADO.NET and VB.NET.
• Created custom handler using Visual Studio.NET and C# to parse a multi-MB XML file into individual XML files.
• Used the following Biztalk tools, BizTalk Server Administration, BizTalk Messaging Manager, BizTalk Mapper, BizTalk Editor, BizTalk Document Tracking extensively.
• Access Application work includes, MS Access97 and 2000. Modified and enhanced VB Com objects using COM Plus and wrote numerous transact-SQL scripts.
• Database work includes, Stored Procedures, triggers, functions correcting original design flaws. Database tools includes, Query Analyzer, SQL Trace, DTS

Environment: Visual Basic 6.0, MS Access97 and 2000, Visual Studio .NET, VB.NET, C#, XML, Visio, IIS, SQLServer2000, Stored Procedures, HTML, Visual Sourcesafe, ADO.NET, Biztalk Server2002, MSMQ.

Confidential

Consultant - Application/Database Developer

Responsibilities:

• Develop Testing plans and facilitate User Acceptance Testing
• Establish Project timelines and delivered projects on time
• Worked independently with little to no supervision
• Upgraded Visual Basic applications(RDO to ADO)
• Developed, analyzed, and fixed application errors, and enhanced applications for six different departments throughout the organization
• Application work includes, MS Access2000 and 2003, ASP Web Development, Visual Basic 6.0, Crystal Reports
• Data conversion and data manipulation experience
• Database tools includes, Query Analyzer, SQL Trace, DTS, Optimization and Tuning

Environment: Visual Basic 6.0, MS Access2000 and 2003, Visual Interdev, ASP, VB Script, JavaScript, XML, Visio, IIS, SQLServer2000, Stored Procedures, Crystal Reports, HTML, Visual Sourcesafe, ADO and Windiff.

Confidential

Web Application Developer

Responsibilities:

• Evaluated the performance of installed software, analyze application errors and apply fix procedures, prepare documentation, develop or modify software and/or custom applications for the web, review new software designs with platform architects, and review specifications for system compatibility.
• Database work includes, Stored Procedures, triggers, functions, create indexes, DDL and DML.
• Database tools includes, Query Analyzer, SQL Trace, DTS, Optimization and Tuning

Environment: Visual Basic 6.0, MS Access2000, COM, COM Plus, Visual Interdev, ASP, VB Script, JavaScript, XML, Visio, DevTrack, SQL-Programmer, IIS, SQLServer2000, Stored Procedures, Crystal Reports, HTML, DHTML, Visual Sourcesafe, Perforce and ADO.

Confidential

Consultant - Developer

Responsibilities:

• Responsibilities involved upgrading VB4.0, VB5.0, VB4 OCXs, VB4 DLLs, and Access2.0 applications to VB6.0 sp3 and Access2002 to run on Windows XP operating systems.
• Wrote and performed Unit Testing and User Acceptance Testing procedures.
• Created the deployment application packages for the VB applications.

Environment: Visual Basic versions 4.0 to 6.0, MS Access2.0 to 2002, VB OCXs and DLLs

Confidential

Consultant - Business and Data Component Developer

Responsibilities:

• Mission critical Insurance web-based Claims project.
• Responsibilities included the development, implementation and testing of the Data and Business components for this enterprise-wide Claims Account Search project.
• Modified business and technical specs and developed test ASP screens using VB Script and JavaScript.
• Created Test Databases (Tables Indexes, Stored Procedures, Optimization and Tuning).

Environment: Web Development Testing (ASP, VBScript, Visual Interdev 6.0, HTML), ADO2.5, Stored Procedures using SQL, Server 7.0, SQL DDL and DML, VB6.0 Classes, Com Plus, MTS, and MS Access2000(VBA)

Confidential

Consultant - MS Visual Basic Business Component Developer

Responsibilities:

• Responsibilities involved the implementation of the business component for the Invoicing and Scheduled Payments module with emphasis within the module on Date Function manipulations as part of a major financial web-based investment project.
• The current client process involved manual and spreadsheet manipulations. The module developed automated these tasks, decrease data entry errors, add functionality that is currently unavailable, and thereby, increase the overall productivity of the client.
• The technology used involved ADO2.5, Stored Procedures using SQL Server 2000, SQL DDL and DML, VB6.0 (modules, classes), Com Plus and database design.

Environment: Web Development Testing (ASP, VBScript, Visual Interdev 6.0, HTML), ADO2.5, Stored Procedures using SQL, Server2000, SQL DDL and DML, VB6.0 Classes, Com Plus, MTS.