CAREER OVERVIEW

Software Engineer / Developer /Consultant with many years of Experience in Analysis, Design, Development, Testing, Deployment and Support in MS Business Intelligence 2008 R2, 2008, 2005 SSIS, SSRS, SSAS, Dashboards, Scorecards, KPI's Client / Server Applications Visual Basic 6.0/5.0/4.0, Oracle 9.2i, 10g PLSQL/SQL, Oracle Builder Reports, Discoverer, Web Programs using Embedded Oracle, JavaScript, HTML Project Development / Management, Business Analysis, Technical and Customer support Have been involved in all phases of SDLC Project Development, working on multi-member inter-departmental teams as well as on individual assignments dedicated to successful project completion and company goals achievement.

TECHNOLOGY

• Microsoft Technologies SQL Server 2008, 2008 R2 SSIS, SSAS, SSRS, SQL Server 2005 SSIS, SSRS, SSAS,
• Microsoft Office SharePoint Server 2007 MOSS , Microsoft Visio
• Databases SQL Server 2008, 2008 R2, 2005, Oracle 9.2i, 10g, SQL Server 2000, MS Access
• PL/SQL, SQL, SQL Plus, SQL Loader
• Oracle Discoverer Desktop / Administrator, Oracle Reports Builder
• TOAD / SQL Developer
• Software Visual Studio .NET 2005, SQL Server Business Intelligence Development Studio
• MDX, Visual Basic 6, 5, 4 JavaScript, VBScript
• Excel, Crystal Reports, XCelcius Reports
• CORE STRENGTHS AND COMPETENCIES
• Visio, Embarcadero
• HTML, ASP, Visual Source Safe
• Business Intelligence Development ETL, Analysis, Reporting
• Complete Solution Management Resource management, Specifications Analysis, Technical Development
• Database Modeling / Development
• Reports Development MS reporting Services, Oracle, Crystal, XCelcius
• Product Development / Management
• Strong analytical and problem solving skills with effective communication and presentation skills.
• Business Analysis
• Customer / Product Support
• Client / Server, Web Applications Development

PROFESSIONAL EXPERIENCE

Confidential

MS BI Developer SSIS

• Converted an MS Access legacy system to an SQL 2008 R2 DB / Reporting system
• Analyzed and re-engineered Access databases, queries and macros

• Created SQL Tables, stored procedures, functions and other SQL 2008 R2 DB objects
• Created SSIS packages to load table data into Excel templates
• Created SSIS packages to run Excel macros and generate graph reports
• Worked with Business Analysts and engineers to define report requirements

Confidential

MS BI Developer SSRS Reporting, SQL Development

• Architected SSRS Reporting solutions specifications, design, implementation, testing and deployment
• Wrote complex SQL Stored procedures to generate data for SQL 2005 SSRS reports.

• Assisted Business Analysts and Report Sponsors in developing complex report requirements
• Assisted DBA's to re-model efficient database schemas and resolve data issues
• Collaborated with IT engineers to resolve deployment configurations problems
• Mentored and shared technical knowledge with project managers for effective decision making

Confidential

MS BI Developer Data Warehouse, SSIS, SSRS, Business Analysis, SQL Development

• Worked on a Data Warehouse design using MS SQL 2008 R2 tools
• Wrote SSIS packages to process EBCDIC data type Flat files and other sources
• Created SQL 2008 R2 database to accept transformed and cleansed EBCDIC data
• Wrote SSIS packages to transfer Flat files from an FTP server to a local directory
• Wrote SSIS packages to cleanse and transform data from MS Access DB to an SQL 2012 Database
• Created SQL 2012 Database to accept SSIS transformed data
• Developed SQL 2008 R2 SSRS reports
• MS SQL 2008 R2 Database development tables, stored procedures, functions, etc

Confidential

MS BI Developer SSIS, SSRS, Business Analysis, SQL Development

• Developed SSIS packages to provide data for SSRS Reports

• Wrote SSIS packages to process data from/to SQL, Oracle, Flat files and other sources

• Analyzed data sources for MS ETL and SSRS Reporting
• Analyzed and developing SSRS 2008 R2 reports
• SQL and MySQL / Oracle Database development tables, stored procedures, functions, etc

Confidential

MS BI Developer SSRS Reporting, SQL Development

• Designed and developed SSRS Reports

• Wrote SQL Stored procedures, creating tables and scheduling jobs to generate data for SSRS reports.

• Developed complex-requirements SSRS 2008 Reports
• Worked with Business Analyst to define report specifications
• Collaborated with Systems and database engineers to prepare report datasets

Confidential

MS BI Developer SSRS Reporting, SSIS Integration, SSAS Analysis

• Wrote SQL Stored procedures, created tables and generated Crystal reports.

• Developing SSRS 2008 Reports
• Researched Power Pivot Tabular Data Models
• Worked on Data Warehouse design using SSIS ETL tools, to combine data from multiple databases
• Researched SQL 2012 Power View report designs

Confidential

MS BI Developer SSRS/Performance Point Server / Reporting, SSIS Integration, SSAS Analysis

• Worked on the development of a Business Intelligence Solution: Data Warehouse, SSIS ETL packages, SSAS Cubes and SSRS Reports
• Designed, created, tested and loaded SSIS ETL packages, tables and views for a Data Warehouse
• Designed dimension tables and Fact tables in the Data Warehouse
• Designed, created, tested and deployed SSRS reports based on Analysis Services cubes
• Designed, created and loaded SSAS cubes
• Worked with report users and Business Analysts to gather and analyze system requirements, and provided system solutions

Confidential

MS BI Developer/Manager SSRS/Performance Point Server / Reporting, SSIS Integration, SSAS Analysis

• Working together with Lead Architect managed the development of an MS BI Solution system
• Worked on the architecture and development of an enterprise level Data Warehouse and reporting solution
• Provided technical designs and coordinating the efforts of all technical teams ETL Integration, Analysis, Reports, Testing and Deployment
• Interfaced with Business Analysts to collect and analyze users requirements and design system solution
• Synchronized activities with multiple teams in a distributive operations development environment
• Integrated multi-phased solution by managing HR resources, analyzing requirements and developing technical designs

• Used MS Business Intelligence tools such as 2008 SSIS, SSAS, 2010 PPS and Share Point server

Confidential

MS BI 2008/2005 Developer SQL Queries, SSRS Reporting, SSIS Integration, SSAS Analysis

• Designed and developed SSRS Reporting solution system

• Developed /coding SQL Queries, Stored Procedures and Functions for 2008/2005 Reports

• Analyzed user requirements and defining project specifications.
• Developed several Detail Drill, Down /Drill Through, Multi-groups and Summary reports including Parameterized and Sub-Reports, using SQL 2008/2005 Reporting Services SSRS .
• Tuned queries and SQL code for improved report performance and execution.
• Created SQL scripts for deploying reports to Development, Testing and Production servers.
• Evaluated Report Builder, Report Models and AdHoc Queries designs.
• Developed SSIS ETL Packages to process data form relational tables into data Warehouse Databases and deployed solutions to SQL server.
• Created OLAP cubes, Analysis objects and processes KPI's, Dimensions, Partitions, Aggregations, MDX Queries, etc.

Confidential

MS 2005/2008 SQL Queries / SSRS Reporting Development

• Developed /coded SQL Queries, Stored Procedures and Functions for 2005/2008 SSRS Reports

• Analyzed the user requirements and defined project specifications.
• Developed several Detail Drill, Down /Drill Through, Multi-groups, Summary reports, and Sub-Reports, using SQL 2005/2008 Reporting Services SSRS .
• Tested and Deployed SSRS reports in the Reports Server.
• Created Subscriptions for report distribution.
• Created SQL Agent schedules for automated report execution

Confidential

MS Business Intelligence / Oracle, Research Development

• Worked on the development of an MS BI Solution system
• Gathered system requirements through discussions and meetings with users.
• Extracted and Transformed ETL data from diverse Data Sources such as SQL 2005 Database tables, Flat Files .csv , XML Files and other sources, using SSIS Data Flow and Control Tasks.
• Created Packages to Process data Imports and send Success/Failure emails.
• Implemented SSIS data updating using tools such as SSIS Slowly Changing Dimension Task controls.
• John Harisiadis, Page 4
• Designed Error Handling processes.
• Tested and Deployed SSIS Packages to MS SQL 2005 Servers.
• Scheduled Jobs in MS SQL 2005 to run SSIS packages.
• Designed Dimensional Databases in MS SQL 2005 Server, using MS Visio.
• Created Star Schema Cubes, KPI's, MDX Queries, Hierarchies, Data Partitions using MS SQL 2005 SSAS.
• Analyzed Dimensional Relationships and designed Data Aggregations to improve system performance.
• Created several SQL 2005/2008 queries to provide data for SSRS reports
• Developed several Detail Drill, Down /Drill Through, Multi-groups, Summary reports including Line and Pie charts, Trend Analysis, Matrix and Sub-Reports using SQL 2005/2008 Reporting Services SSRS .
• Tested and Deployed SSRS reports in the Reports Server.
• Created Score Cards and dashboards using MS Office Performance Point Server 2007 PPS Dashboard Designer, and deploying them to MS Office SharePoint Server 2007 MOSS Dashboard Designer.
• Published KPI's, Reports, Dashboards and Excel Reports to SharePoint Server 2007

Confidential

Sr. Oracle PLSQL Developer, Sr. Software Applications Developer

• Client/Server application, run on an Oracle 9.2i IAS Server, using an Oracle 10g at the Back End and embedded HTML for designing the system GUI. There is a separate Development and a Production environment.
• Worked on the development of an Oracle Web Application that manages all the Construction Operational and Accounting transactions for the two major airports of the Department of Aviation, City of Chicago. It is a
• Analyzed customer requirements and authored Functional Specifications, High Level Design documents, Low Level Design documents, Technical Design documents and Business rules BR .
• Assisted users in determining Data requirements, created Oracle Discoverer Desktop/Plus custom Views, Queries, AdHoc reports, and configured user profiles to manage user Security Access Rights.

• Designed Database structures and Client/Server applications programs to process construction activities such as project creation, contract, budget, inventory, cost, scheduling and other tasks.
• Create Oracle / PLSQL Stored Procedures, Packages, Functions, Triggers, Views, Cursors, Joins, User-defined Types, and Used TOAD and SQL PLUS to develop and test Oracle programs and structures.
• Provided prompt and on-time customer support / assistance for quick problem resolution and correction, created user Documentation files.
• Created multiple and complex Oracle Reports
• Created Crystal Reports and graphical XCelcius dynamic interactive reports.
• Written HTML and JavaScript programs to develop system GUI and developed Visual Basic programs to upload data from Excel tables into Oracle Tables
• Discussed customer Business and offered solutions for enhanced system functionality.

Confidential

Sr. Oracle PLSQL Developer

• Worked on the development of an Enterprise Level Vendor Management Application to track and manage the Sales activities of medical products, using Visual Basic and Oracle 9.2i database for data storage and management. Data from multiple vendor files are uploaded into Oracle Tables and processed. Crystal reports were also generated and modified data were supplied to other vendors for further analysis.
• Worked extensively with Oracle PL/SQL Procedures, Functions and Packages to upload data from multi-format files into Oracle Tables, and to restructure SQL code for increased performance efficiency.
• Provided technical support to the Applications staff and resolved database problems.
• Analyzed Business Rules among Oracle Entities and developed Logic Flow documentation.
• Created Views for resolving Query Complexity and Data Security
• Worked with multiple departments to resolve system problems and increase Workflow productivity.
• Involved in Code Reviews to comply with company Best Practices code development policy.

Confidential

Sr. Visual Basic, MS SQL Server 2000 Developer

• Worked on the development of a Client/Server Application for a taxi company customer information, driver assignment, routing, payments, etc. , using a Win2000 platform, Visual Basic 6 and MS SQL 2000.
• Worked on the design of the SQL Server 2000 Tables.
• Worked on the complete SDLC process of the system development, writing VB program Modules to implement the Business Logic and the GUI interface.
• Created Crystal Reports and Documentation files.

Confidential

Sr. Applications Developer, Oracle PLSQL Developer

• B. Developed a Win2000 Application that automates the calibration of sensitive medical equipment. The user interface and Business Rules were implemented using VB 6, and an Oracle 8.1.7 database was used for storing the data. Created Crystal Reports.
• A. Worked on developing a Quality Assurance Web Application that documents Vendor medical equipment problems according to FDA required regulations. It keeps track of problems frequency, type and required repairs. It is a VB Object-Oriented system that uses an Oracle 9.2i Database and it generates Crystal Reports.
• Developed of Oracle PLSQL Stored procedures, functions and PLSQL Packages.
• Written triggers for Audit Trail documentation
• Analyzed Table relationships and written TSQL stored procedures, functions and scripts.
• Designed Oracle Stored Procedures for querying and generating data for Crystal Reports.
• Analyzed and designed the Oracle Entities relationships.
• Designed the Logical Tables using Embarcadero Erwin Modeler.
• Created the Physical Tables for an Oracle 8.1.7 database.
• Written PLSQL Procedures Functions for DML operations and PLSQL Script programs for Unit Testing.
• Written VBScript programs and PLSQL code for the Control file of the SQL Loader, to download data from an FTP server into Oracle 8.1.7 tables, logging errors and emailing status info to designated recipients.

Confidential

Software Development

• Worked on the development of a Client/Server application program for tracking real-estate transactions property renting/leasing, bonds, security deposits, tax payments, report generation, etc.
• Win98, WinNT 4.0, VB 6.0, MS SQL Server 6.5, MS Access97, ADO, ODBC

Confidential

Software Development Engineer

• Worked on the development of custom Client/Server application programs for real-time label printing, interfacing I/O devices such as printers, weight scales and databases.
• Tasks included:
• Project Management and Full Life Cycle development: initial specifications, design and coding to completion, testing, installation, and additional feature modification.
• Project Leader, specifying project requirements, assigning projects to other team members, supervising and assisting them.
• Redesigned/Upgraded existing systems for enhanced efficiency, provided inter-departmental and customer technical support, and completed projects before scheduled deadlines.

Confidential

Software Development

• Worked on the development of a custom application that tracks the jobs for a Package Shipping / Delivery business - provided customized solutions and program enhancements
• Successfully achieved MS Certification in programming.

Confidential

Lead Software Engineer / Team Leader / Acting Manager

• Developed software programs, Windows, MSDOS, and MultiBus platforms , to collect data from real-time mail-sorting machines, for statistical analysis and report generation. Projects included system integration of readers and printers, database design, data collection and analysis, and design of Crystal Reports
• Worked as a Team Leader defining project requirements, assigning tasks to group members both company and contracted engineers , supervising their work, preparing system installation requirements, and providing technical support to field engineers and system users
• Worked as a Project Manager in the development of new Help Desk system