CAREER OBJECTIVE:

Obtain a position as a team-player in a people-oriented organization where I can maximize my 20 plus years of systems development experience in a challenging environment to achieve the corporate goals.

CAREER SUMMARY:

I am an accomplished Database and Systems Designer, Data Modeler, Data Analyst, Business Intelligence Specialist, and Report Writer with over 20 years of experience in developing systems for several business sectors in the Connecticut area including Health Care, Insurance, Banking/Financial and Government Contractor firms. I am a dynamic, detail-oriented systems professional known for delivering high quality database and B.I. application solutions and designing and building complex database solutions and multi-dimensional Data Warehouse Systems.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server System Data Integrator and Report Developer

• I worked as the technical lead and database developer on the Operational Excellence computer Inventory and Reporting System.
• This involved coordinating and integrating data from different United Technologies Systems and database into a new database to track, record, and report on computer inventory and software compliance.
• I also created a new database and tables for this data and wrote ETL Extract Transform and Load scripts, as well as creating complex reusable SQL Queries and Report Programs.
• Software Utilized: Microsoft SQL Server 2012, Access, ANSI SQL, Excel, Microsoft Office Suite

Confidential

SQL Server System Data Integrator and Report Developer

• I worked as the technical lead on the Healthiness Together Employee
• health incentive system. This involved coordinating and integrating
• data from different Hartford Hospital Systems into a new database to
• track, record, and report on Employee's compliance with Wellness
• incentives and determine qualifications for financial rewards based
• on the completion of wellness based incentive activities.
• I wrote extensive ETL Extract Transform and Load scripts, as well as creating complex
• reusable SQL Queries and Report Programs.
• Software Utilized: Microsoft SQL Server 2012, Access, ANSI SQL, Excel, Microsoft Office Suite

Confidential

SQL Server System and Report Developer

• Met with business users to gather and document their requirements for changes and corrections to production reports that had errors.
• Corrected Crystal Reports with SQL/Oracle backend databases to correct errors and enhance them according to business requirements.
• Developed complex SQL and stored procedures to extract data from the databases, and created extract files and reports to deliver data to the business users.
• Software Utilized: Microsoft SQL Server 2010, ANSI SQL, Oracle10G, Crystal Reports, Excel, Microsoft Office Suite.

Confidential

SQL Server System and Report Developer

• Met with business users to gather and document their requirements for data from various sources and systems from within the organization to be and loaded into databases for corporate security analysis and reporting.
• Created databases, tables, and ETL processes to house corporate data to meet the corporation's business requirements.
• Developed complex SQL queries and stored procedures to extract data from the databases, and create extract files and reports to deliver data to the business users.
• Software Utilized: Microsoft SQL Server 2005, 2008, 2010, ANSI SQL. Crystal Reports, Excel,
• Microsoft Office Suite.

Confidential

Senior Programmer/Analyst

• Developed complex programs to extract data from DB2 databases, create extract files and Excel files using SAS.
• Analyzed programs that other programmers wrote and created application design specification documents for the team.
• Software Utilized: SAS 9.2, ANSI SQL, Unix, and MS Word.

Confidential

Database/Data Warehouse Developer/Analyst

• Performed database and Database Analysis with large corporate databases.
• Created complex queries and stored procedures to produce extract files, data feeds, and reports.
• Met with business users to gather and document new data, report, and cube requirements. Wrote new reports utilizing Crystal Reports, Excel, and SQL.
• Performed troubleshooting and correcting of data, database, and reporting issues.
• Software Utilized: SQL Server 2008, ANSI SQL, Microsoft Query Analyzer, Analysis Manager, SSIS, DTS, Crystal Reports, and Business Objects.

Confidential

Data Warehouse Developer/Analyst

• Met with business users to identify system and data resources to fulfill business requirements. Conducted requirements gathering sessions, weekly status meetings, and technical walkthroughs with various business and technical team members.
• Performed database analysis and write complex SQL queries to deliver data to statistical analysts for forecast modeling projects.
• Hardware Utilized: IBM UNIX servers, IBM workstations.
• Software Utilized: Informatica 9.0.1, MS SQL Server 2005/2008 DTS SSIS SSRS SAS SQL ANSI SQL , Oracle, DB2, Transact SQL AQT SAS 9.

Confidential

Senior Database Analyst/Developer

• Met with business systems users to identify system and data resources to fulfill business
• requirements.
• Conducted requirements gathering sessions, weekly status meetings, and Technical walkthroughs with various business and technical team members.
• Senior Relational Database Designer/Modeler/Programmer for the Everyday Points Multiplier project.
• Performed database modeling, design, and implementation for the DataMart.
• Wrote SSIS packages and complex SQL queries to extract and move data in the data warehouse storage facility to provide reports to meet the business partner's requirements.
• Produced technical documentation for the project.
• Also served as a Data Quality Analyst for the KPF Data Mart project.
• Reviewed and analyzed data after it has been loaded into the staging layer of the data mart to ensure data quality standards were being met. Took note of data integrity issues and informed the ETL developers and technical project managers of anomalies found between different database tables in the data mart.
• Hardware Utilized: IBM UNIX servers, IBM workstations.
• Software Utilized: MS SQL Server 2000/2005 DTS SSIS SSRS SSAS SQL Transact SQL, ANSI SQL, Toad SAS.

Confidential

Database Developer and Data Strategist

• Lead the QA, testing, and development effort to upgrade a large database application from Microsoft SQL Server 2000 to 2005. This involved converting many complex DTS jobs and stored procedures to SSIS packages as well as converting the data into the 2005 database platform, database testing/quality assurance.
• Created and executed test plans and test cases as a quality assurance team member. This included Database, Data Mart, and White Box testing.
• Built and managed test data for enterprise wide database applications.
• Database design, modeling, and implementation.
• Developed complex SQL queries/procedures with MS SQL Server.
• Maintained communications between quality assurance and development teams.
• Hardware Utilized: IBM UNIX servers, IBM workstations, 390x mainframes.
• Software Utilized: MS SQL Server 2000/2005 DTS SSIS SSRS SSAS Oracle 8.0 DB2
• QMF Mainframe/Windows for DB2 Stored Procedures, PL/SQL, ANSI SQL.

Confidential

Senior Data Warehouse Developer/Analyst

• Completed a large Business Objects report migration project. Responsibilities were to revise and test corporate reports to run off a new database platform. Also responsible for tracking the detailed progress of the project and communicating this to project management.
• I also created and modified many Business Objects Webi reports.
• Hardware/Software: Business Objects 6.5, Webi, Oracle9i, Embarcdero Rapid SQL,
• Oracle PL/SQL, ANSI SQL.

Confidential

Senior Data Warehouse Developer/Analyst

• Wrote many complex reports using Business objects Reporter. Created new data warehouse databases and performed data modeling and created database objects including tables, keys, and indexes. Developed SQL transact-sql stored procedures to Extract, Transform, and Load data into this new data warehouse database.
• Created reports and data extract programs to provide data per business user's requirements.
• Hardware/Software: Business Objects, Microsoft SQL Server, Microsoft DTS, Transact-SQL, DDL, and SQL Stored Procedures, ANSI SQL. Also, I had heavy usage with Microsoft Enterprise Manager, Query Analyzer, and Visual Source Safe.

Confidential

Senior Data Warehouse Developer/Analyst

• Created a new data warehouse database platform for a new business application. This involved data modeling and database creation including creating tables, keys, and indexes.
• Wrote SQL transact-sql stored procedures to Extract, Transform, and Load data into this new data warehouse database.
• Served to monitor and ensure data quality for the daily processes that obtain, process, and load new data into the database. This involved focusing on the quality assurance and data integrity aspects of the database and I also wrote several processes to cross-check and verify the database after each daily refresh. Served as a code quality assurance specialist and reviewed and corrected other developer's programs to keep them up to the client's standards and expectations.
• Hardware/Software: Microsoft SQL Server, Microsoft DTS, Transact-SQL, ANSI SQL, DDL, and Business Objects. Also, heavy usage with Microsoft Enterprise Manager, Query Analyzer, and Visual SourceSafe.

Confidential

Senior Developer/Analyst

• Modified an existing Query and Reporting System to move it into Production and make it run correctly and more efficiently according to the business user's requirements. This involved modifying test code within VBA/Macros and report programs and moving reports onto production servers.
• Educated and trained Kodak production staff on how to run the system for different reporting cycles and parameter requirements as requested by the user community.
• Hardware/Software: Cognos Impromptu 7.x, Oracle 7.3.4.2.0., Oracle SQL, Oracle DDL, PL/SQL, ANSI SQL, Excel VBA/Macros.

Confidential

Senior Data Warehouse Report Developer

• Analyzed and documented business requirements for reports and queries required from the Disability Claim Data Warehouse. Develop reports and queries utilizing Business Objects 5.1 against an Oracle Database platform. Perform testing and obtain business customer sign-off of queries and reports created.
• Provided technical assistance to power users for Business Objects ad hoc queries and reports.
• Reviewed repositories to analyze data flow and data content issues within the data warehouse using Informatica Powercenter Designer and Repository Manager.
• Hardware/Software Utilized: Business Objects 5.1Reporter/Designer, Oracle SQL, Oracle DDL, Oracle PL/SQL, ANSI SQL, Informatica Powercenter, Microsoft DTS.

Confidential

Senior Data Warehouse Developer/Analyst

• Analyzed the current data warehouse environment and performed gap analysis that identified several elements that needed to be added or corrected within the data warehouse in order to adequately meet the customers reporting requirements.
• Wrote several new reports for the Sales Department utilizing Business Objects and SAS against a Microsoft SQL Server database.
• Hardware/Software: Business Objects, SAS, SQL, Erwin, Excel, M.S. Office.

Confidential

Senior Data Warehouse Developer/Analyst

• Provided reporting platform conversion consulting on a project to move reporting from a mainframe based legacy database to a new data warehouse platform. This served to reduce overhead expenses and provide a better decision support query and reporting system to the business decision makers. The realized projected savings totaled over 1MM by removing dependence on mainframe platform.
• Converted mainframe SAS and QMF reports using DB2 warehouse to Business Objects 5i using the Teradata database/data warehouse platform, leveraged universes, wrote free-hand SQL, and Teradata stored procedures.
• Provided technical assistance to independent consultant team members that encountered technical difficulties and required assistance to complete their analysis and programming tasks.
• Provided individual tool set training and assistance for novice Business Objects and SAS users. Identified, communicated, and assisted in resolving gaps in the data warehouse model, and data content that needed to be corrected within the data repository to the client's I.T. personnel. This provided improvements to the data model, metadata repositories, and ETL processes to better satisfy the end users reporting requirements.
• Hardware/Software: Business Objects, Teradata, ANSI SQL, SAS, QMF, Microsoft DTS.

Confidential

Senior Systems Development Analyst

• Performed development work including database modeling and design, creating data extract, transform and load programs, and creating scheduled jobs to bring new data into the data warehouse. Designed and created catalogs, cubes and reports with the Cognos development tool set. Performed some Web Server/ASP development for Web-based applications.
• Lead specifications gathering meetings with business personnel to outline requirements for new data warehouse applications and data marts. Performed project leadership for several new projects and enhancements to the business intelligence environment.
• Facilitated work flow management for the Information Architecture and Development team including project, enhancement, and production problem activities.
• Created a requirements gathering and testing database with M.S. Access and Visual Basic. This system allowed for the input of customer requirements and sign-off criteria. This system provided progress and status reports, recording of all testing performed, and facilitated customer sign-off upon completion of new project and/or modification activities.
• Responsible for the overall customer acceptance of the Corporate Accounting Data Warehouse Application. Lead meeting to gather and document the data integrity requirements from the business customer base. This also involved the creation of test data for the Corporate Accounting database application.
• Created and implemented data strategies that included importing data loads into the Corporate Accounting Data Mart environment. This included writing SQL data load programs that loaded data into the Microsoft Server database.
• Responsible for documenting the test result cases and reporting back to the Data Stewardship Committee on the status of the customer acceptance testing.
• Hardware/Software Utilized : Cognos Toolset Impromptu, PowerPlay, Transformer, Decision Stream , Microsoft SQL Server 7.0 Enterprise Manager, SQL Query Analyzer , ANSI SQL, Erwin, Visual Basic, Microsoft Access, Microsoft Project.

Confidential

Systems Analyst/Developer

• Lead specifications gathering meetings with business personnel to outline requirements for a new data warehouse. Prepared specifications documentation for the Director of Data Warehousing that detailed the deliverables that were to be met by the data warehouse.
• Conducted vendor selection sessions to obtain quotes from various vendors on software and consulting services that will be required to install and setup a new data warehouse. Created summary documents to inform upper-level management of the results and progression of the specifications gathering and vendor selection processes.
• Wrote several new applications to meet business user's immediate needs including the Tower Square Securities Annual Renewal Fee Statements and the Tower Square Securities Annual Representative Agreements. Also performed Project Management functions for the Tower Square Securities I.T. Department including: personnel assessment, assignment of work, team status reporting, and team representation at management meetings. Also assisted in hiring functions by reviewing resumes and interviewing candidates for hire for the Travelers
• Hardware/Software: Oracle SQL, ANSI SQL, Cognos Toolset Impromptu, PowerPlay, Transformer, Decision Stream , Impromptu, Crystal Reports, Microsoft Access, Microsoft Project, Microsoft DTS.