Transportation Security Officer

Posted on: 2017-05-12

SQL Developer with extensive experience in providing database design, testing and support.

Enterprise Reporting Developer with experience fulfilling complex reporting requirements in large-scale multi-platform environments. Full development lifecycle experience in large user-base and terabyte-scale data environment. Self-motivated individual contributor and as an effective team collaborator.

TECHNICAL SKILLS:

Microsoft SQL Server 2005/2014                                                                                         

Microsoft SQL Server Integration Services

Microsoft SQL Server Analysis Services                                                              

Microsoft SQL Server 2005/2014 Reporting Services

Reporting Services Report Manager Administration      

Team Foundation Server

Data Extraction & Transformation                                         

Structured Lifecycle Implementation

Business Objects Crystal Server Administration                              

Business Objects Crystal Reporting Development                

Business User Requirements Analysis                  

JIRA                                                                                                                    

Ralph Lauren Corporation, New York, NY

SQL Developer

October 2007 – Present

• Developed and maintained warehouse operations and analyzed business needs for them.
• Defined and created data model to maximize system potential around reporting needs.
• Created SSIS packages for data extraction & transformation.
• Work closely with business users to define clear requirements for reporting solution.
• Sole person in creating, maintaining and enhancing around 450 cross functional & cross domain levelreports using SSRS.
• Manage 2008/2014 SQL Server Reporting Services Report Manager.
• Supported the Contact Center and Fulfillment Center in terms of leveraging their functions, through insight from reporting to increase customer satisfaction.
• Handles multiple projects simultaneously.
• Lead Agile team using Scrum methodology and Dashboards.
• Built and supported integrations across systems (internal & external). Provided 24/7 operational support for these integrations.
• Created complex stored procedures to fulfill front end requirements.

1199SEIU National Benefit Fund, New York, NY

Reporting Services Administrator and Developer

June 2004 – October 2007

• Lead developer for the creation of daily, monthly, and yearly reporting for the operation of 1199’s core business system.
• Established and administer the server operational environment for Crystal Reports XI.
• Lead for implementation of SQL Server 2005 Reporting Services environment.
• Establish and maintain document hierarchy, security, generation and distribution of reports.
• Develop reporting for 200+ geographically distributed end-users across multiple business lines and benefit areas such as medical, dental, disability, and internal audit compliance teams.
• Work with business teams to capture user requirements, design, and implement reports using reporting tool and stored procedures to achieve the data aggregation and analysis while ensuring performance.
• Implement reports to provide analysis against a complex, highly customized, commercial benefits administration application.
  • Enable consolidated analysis against primary database and multiple specialized lines of business data warehouses.
  • Perform optimizations necessary to ensure performance of reports run against large relational data model databases with complex joins and aggregation logic.

Horizon Blue Cross Blue Shield of NJ; Newark, NJ

Applications Development Group

March 2001 – April 2004

• Developed complex reports for business operations team and 300+ geographically distributed claims processing end-users of Horizon’s Microsoft .Net-based claim engine.
• Implemented stored procedures and DTS packages to construct the criteria for the report data extraction and data manipulation.
  • Database consists of approximately 600 data tables with the largest and heavily used table consisting of 88 million rows, other significant tables on the order of 40 and 16 million rows.
  • Integrated data reporting across multiple databases in high availability environment across heterogeneous servers.
• Designed, coded, and tested application for data extraction and manipulation of data for sales lead handling. Provided integrated application for the modification, searching, and extraction of data to feed other systems and processes.
  • Incorporated BCP, Active X component construction, and Crystal Reports 8.0.
  • Designed and implemented Microsoft SQL-Server 6.5 DB and later migrated to 7.0.
  • Wrote stored procedures to encapsulate business logic
• Worked with the end users to define and refine business requirements as well as to convey work efforts and complexity.                      

December 1998 – November 2000

• Converted legacy-billing system to Visual Basic 6 application.
• Converted from system developed in Q&A to client-server Visual Basic 6.0 application.
• Implemented reporting in Crystal Reports and stored procedures to provide summary information of billing status.
• Developed business requirements to provide for the validation against a large set of business rules for data entered by medical provider data entry clerks.
  • System implemented state regulated fee schedules (CPT and ICD-9 codes) and automatically calculated total payout to the doctor, savings to Insurance Company (based upon allowable billing rates due to specific procedures and doctor locations), and fees imposed by First Managed Care.

Prudential Insurance; Parsippany, NJ

Visual Basic Development Group

February 1996 – December 1998

• Design, development, testing, and support of the Disability Claims Payment Recalculation System (DCRS) to provide insurance claims entry and adjustment. Established data interface with the primary Disability Claims Management System (DCMS).
• Created user interface and implemented extensive data entry validation to ensure data quality and enforce mandatory criteria.

Saint Barnabas Medical Center, Livingston, NJ

Computer Specialist/Data Analyst

1991 – 1995

• Provided modeling, design, and implementation of the Automated Registry System for medical testing.
  • Ensured traceability of user requirements to application functionality.
  • Generated test cases, test data sets, and conducted application verification.
• Implemented reports for standard medical procedures.
• Provided user training on numerous software applications.

BS Management of Information Systems

Odessa Polytechnic University, Odessa, Russia

Professional Training Classes

SQL Server 2005 Reporting Services                                                   

Introduction to .Net Programming

Developing ASP.NET Web Applications                

Visual Basic 2005 Programming

SQL Server Programming