Transportation Security Officer Resume
LOG IN OR REGISTER TO CONTACT ME
This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.
Resume:
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 /
Microsoft SQL Server Integration Services
Microsoft SQL Server Analysis Services
Microsoft SQL Server / 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 – 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 cross functional & cross domain levelreports using SSRS.
- Manage / 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 / operational support for these integrations.
- Created complex stored procedures to fulfill front end requirements.
SEIU National Benefit Fund, New York, NY
Reporting Services Administrator and Developer
June – October
- Lead developer for the creation of daily, monthly, and yearly reporting for the operation of ’s core business system.
- Established and administer the server operational environment for Crystal Reports XI.
- Lead for implementation of SQL Server Reporting Services environment.
- Establish and maintain document hierarchy, security, generation and distribution of reports.
- Develop reporting for + 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 – April
- Developed complex reports for business operations team and + 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 data tables with the largest and heavily used table consisting of million rows, other significant tables on the order of and 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 ..
- Designed and implemented Microsoft SQL-Server . DB and later migrated to ..
- 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 – November
- Converted legacy-billing system to Visual Basic application.
- Converted from system developed in Q&A to client-server Visual Basic . 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- 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 – December
- 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
–
- 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 Reporting Services
Introduction to .Net Programming
Developing ASP.NET Web Applications
Visual Basic Programming
SQL Server Programming
