SUMMARY:

• Multi - disciplined IT professional with e xtensive experience on SQL Server database platform.
• Demonstrated excellence in database development and reporting services.
• Strong background of successfully developing applications and systems in deadline-oriented environments.
• Able to collaborate proactively with business users and IT staff to analyze, design and implement changes that will improve reporting efficiency and/or improve data quality in source systems.

TECHNICAL SKILLS:

Operating Systems: Windows 7/XP/Vista, Windows Server 2012 R2/2008 R2, UNIX(HP-UX), IBM OS/MVS

Databases: Microsoft SQL Server 2012/2008 R2/2005, Oracle 9i, Sybase ASE 12.5, IBM AS/400, DB2

BI Tools & Utilities: SQL Server Management Studio, SQL Server Data Tools (SSDT), Visual Studio 2010, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), IBM Websphere DataStage 7.5.2, Oracle SQL Developer, TOAD for Oracle, Embarcadero Rapid SQL, PuTTY

EDI Tools & Utilities: Websphere Transformation Extender 8.0.1, Ascential DataStage TX 7.5 Mercator Integration Broker 6.7, Emanio Trading Partner PC/32, EDI ANSI X.12 Transaction Sets (301, 315, 810, 855, 865,870,997)

Database Management Skills: Advanced T- SQL Querying & Programming, Stored Procedures/Views, Triggers, Query Performance Tuning, DB Security and Encryption, Scripting & Custom Components, Data Modeling, Normalization, Error Logging & Handling

(SSIS) - Integration Services Skills: Control Flows, Data Flows, Integration of T-SQL code and Stored Procedures with SSIS, Variables/Configurations/Logging, Event Handlers, Package Management and Deployment, Running SSIS scheduled jobs using SQL Server Agent

(SSRS) - Reporting Services Skills: Tabular, List, Matrix Reports & Charts, Managing Report Services, Snapshots and Subscriptions, Package Deployment & Management, Reporting against Relational and OLAP Databases

(SSAS) - Analysis Services Skills: OLAP Databases, SSAS Cube Editor, SSAS Dimension Editor, Report Actions, Creating OLAP Perspectives, Partitions, Aggregations, Integrating SSAS with SSIS, Security Roles, MDX Calculations, and KPIs

MDX Programming Skills: MDX syntax, Hierarchical functions, Date-based functions (ParallelPeriod, PeriodsToDate, LastPeriod), Ranking and TopN retrieval, Named Sets, Aggregation functions, and KPI programming

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Responsibilities:

• Developed SSIS ETL packages that imported Panelist data from 3rd party data providers SFTP sites, applied cleansing rules and loaded into Passive Meter database tables.
• Developed TSQL stored procedures and scripts that filtered, segmented, and categorized Behavioral Panelists.
• Developed key Media consumption metrics focusing on (App usage across mobile devices, Websites visited, Frequency and duration of visitation, Calls placed/received, Texts/MMS, Device/ system info, and Weekly / Monthly reach among Social Media).

Environment: Windows Server 2008, Microsoft SQL Server 2012, SQL Server 2008 R2, SQL Server Management Studio, SQL Server Integration Services(SSIS).

Confidential, Rolling Meadows, IL

BI SQL Developer

Responsibilities:

• Developed ETL packages to extract, transform, and load data from legacy AS/400 database(s) into the Competitive Performance Continuous Surveillance Data Mart. Data was initially loaded into a base Staging environment and then subsequently loaded into (CPCS) Data Mart fact and dimension tables.
• Reviewed and documented data mappings, data rules, and data transformations for reporting.
• Developed KPI reports utilizing (SSRS) that allowed management to monitor the Daily/Weekly/Monthly performance of Default Resolution Counselors.
• Spearheaded effort to upgrade and migrate (SSIS) packages and (SSRS) reports from SQL Server 2008 R2 to SQL Server 2012.

Environment: Windows Server 2012 R2, Windows Server 2008 R2, Microsoft SQL Server 2012, SQL Server 2008 R2, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), IBM AS/400

Confidential

SQL Server 2008 Analyst

Responsibilities:

• Developed an end-to-end OLAP solution, from OLAP design to ETL to Cube with dimension processing utilizing SSAS and SSIS
• Developed ETL packages for SQL Server 2008 Integration Services(SSIS) solution, to create the Staging Environment, ETL packages to populate Fact and Dimension tables in staging area utilizing source CSV files, and a set of ETL packages to load and perform updates to the OLAP environment.
• As part of requirements for SQL Server 2008 Analysis Services(SSAS) solution, defined (Data Source, Data Source Views, Cubes, Dimensions, Measures, Relationships, Hierarchies, and Roles).
• Created calculated members utilizing MDX programming to support KPI functions.
• Output from OLAP database was deployed to an Excel spreadsheet pivot-tables.
• Provided capability to filter on any date in the Date Hierarchy - (Year/Quarter/Month/Week Ending Date/Day).
• Also provided users ability to view Key Performance Indicators and trend analysis of Customer Return Percentages.
• Developed an ETL solution utilizing SQL Server 2008 Integration Services(SSIS), which read Product, Vendor, and Order data from .CSV files on a network share and loaded into a SQL Server Database. Solution consisting of multiple packages, validated incoming data, performed various data conversions and lookups and issued notifications when jobs completed. The order data thus loaded into SQL Server and was used to generate reports utilizing SQL Server 2008 Reporting Services(SSRS) including the new (Tablix control). Reports were set up for automatic email delivery based on standard report subscriptions.

Confidential

Responsibilities:

• Per project requirements, developed a custom Product Listing report, which also incorporated Sub reports for Purchase listings and Inventory listings. Each Sub report was built as a stand-alone report and then linked with the main report.
• Created a Matrix/Pivot table report with drilldown capabilities.
• Created an OLAP report that utilized a trend line chart with a 12-month moving average using MDX.
• Created an OLAP report that generated a nested MDX TOPCOUNT and a MDX Ranking over a user-defined date range.
• Created a report that retrieved KPIs and handled dynamic images.
• Created an OLAP report that was implemented utilizing Cascading input Parameters.
• Created an OLAP report that showed data for current or prior quarters and annotations for both dates.
• For an Advanced SQL project, individually designed and developed a banking database application utilizing multiple stored procedures and XML that satisfied business requirements for Adding/Updating New Customers, Account Procedures (Deposits, Withdraws, Transfers, OverDrafts, etc). Solution included database design/normalization, scripting for views, triggers, Input parameters validation, error handling, and test scripts
• For the SQL Server Master’s program capstone Project - systematically analyzed the business requirements and designed a database for an online-movie (DVD/Blu-Ray) rental company working as a team. In a project lead role, employed best practices in designing and creating a complete database schema including entity relationships, tables, stored procedures, views, indexes, triggers, and implemented the import and export of data using SQL Server 2008 Integration Services(SSIS) .
• Collaborated with team member to develop reporting solution utilizing SQL Server 2008 Reporting Service(SSRS) per business requirements for reporting on (Most rented movies, Most active customers, List of lost/damaged movies, and list of customers by membership types).

Confidential, Norfolk, VA

Responsibilities:

• Handled type tree customization and pruning; supported development of consolidated Outbound EDI translation maps.
• Maintained integration testing with client Trading Partners and support staff.
• Environment: IBM Websphere Transformation Extender 8.0.1, Oracle 9i, MUMPS

Confidential, Naperville, IL

Senior Programmer Analyst

Responsibilities:

• Provided first level application and production support to over 370 branches nationwide.
• Successfully maintained and enhanced a Web-based mileage reporting application, and several integrated legacy database interfaces. Developed a back-end process utilizing multiple stored procedures to interface with legacy Procurement, Accounting (JDE), and Vehicle Fleet Management/Maintenance systems.

Environment: PowerBuilder, Visual Basic, Sybase ASE 12.5, SQL Server 2000/2005

Confidential

ETL Developer

Responsibilities:

• Provided source system analysis and identification of business rules for data transformations.
• Developed detail source to target data mapping specifications.
• Developed ETL interfaces to extract, transform, and load Vehicle, Employee, and Financial data into legacy databases utilizing DataStage Server Edition 7.5.2
• Designed job batches, developed job sequences, and setup job schedules utilizing DataStage Director.
• Provided data warehouse ETL production support, troubleshooting, and SQL performance tuning.

Environment: DataStage 7.5 Server Edition, Oracle 9i, Sybase ASE 12.5, PeopleSoft, JD Edwards, Unix

Confidential

EDI Administrator, Database Developer

Responsibilities:

• Led major effort to implement an EDI-based application that automated transmissions with Laidlaw’s major trading partners and streamlined Procurement workflows resulting in 30% reduction in overhead.
• Managed the setup and configuration of transmissions between Trading Partners and Value Added Network.
• Conducted meetings with business/system owners and various stakeholders to clarify functional requirements and validate changes to business processes.
• Handled systems analysis of legacy applications and development of source/target data mapping documents.
• Responsible for map development, translations, inbound/outbound processing, and schedule setup.
• Developed back-end process utilizing multiple stored procedures to interface with legacy Procurement, Accounting (JD Edwards), and Fleet Vehicle Management/Maintenance systems.
• Provided Change Management, version control, and on-going production support.

Environment: Sybase ASE 12.5, DataStage 7.5, Mercator Design Studio v6.7, Trading Partner PC/32,EDI ANSI X12 (810, 855, 865,870,997).

Confidential, Chicago, IL

Senior Programmer Analyst

Responsibilities:

• Assisted with successful implementation of their Customer Management System. This N-tier client server based system replaced a 29 - year old mainframe Customer Activity System application.
• Provided panel maintenance, troubleshooting of issues related to slow transaction response time and resolution of problems uncovered during user acceptance testing.

Environment: PowerBuilder, Cobol/DB2, IBM OS/MVS JCL & Utilities

Confidential, Downers Grove, IL

Senior Programmer Analyst

Responsibilities:

• Assisted with the implementation of their Eddie Bauer (CIS) - Customer Information System Data Warehouse.
• Performed data mapping of logical data model to legacy source systems.
• Designed, developed, and implemented source system extracts which were used to load and update (CIS) Data Warehouse.
• Performed extract verification and reconciliation.
• Provided Ad-hoc (KPI) reporting, and on-going production support.

Environment: CICS, Cobol/DB2, IBM OS/MVS JCL & Utilities