TECHNICAL SKILLS:

SQL Server: 2000/2005/2008 , Oracle 8i,9i and 10g SSRS 2012, SSIS 2012, Crystal Reporting 9/10, Cognos Report Studio10, IIS5 - 7 JavaScript, VBScript, Visual Basic, HTML, CSS

Windows: 98-2012 Server, Windows XP, Windows 7/10

MS Office: 2010, Visio, Project Visual Studio, TFS, Source Control

PROFESSIONAL EXPERIENCE:

Confidential

Business System Support Analyst

• Develop Reinsurance reports for Claims, Technical Accounting, Reserving and Financial using SSRS and BOE Crystal reporting tools.
• Performed requirements gathering and wrote requirements documentation for the off shore development team to develop and enhance reports.
• Developed Power BI Data Architecture as a POC for CIO to determine usability for finance team.
• Performed data analysis and troubleshooting for various reporting solutions and Reinsurance data warehouse.
• Utilize SQL 2005/2008 to develop stored procedures, TVF, views to create result sets to meet varying reporting requirements.
• Responsible for directing tasks of offshore development team and allocate resources to complete tasks for high impact reporting projects.

Confidential

BI ReportingAnalyst/DEVELOPER

• Develop Insurance, Reinsurance, Claims and Financial reports using SSRS, Cognos and BOE Crystal reporting tools
• Utilize SQL 2005/2008 to develop stored procedures, TVF, views to create result sets to meet varying reporting requirements.
• Responsible for directing tasks of offshore development team and allocate resources to complete tasks for high impact reporting projects.
• Designed and developed Aged Debt Automation report to provide a high level view of cash activity containing visualizations, to CEO CFO and finance leaders.
• Redesigned, optimized and enhanced high level view (snapshot) of monthly business activity such as Claims Loss, Gross Written Premium, Earned Written Premium, New, Renewal and Expiring policy counts by Month, Region and Broker, distributed at Month End Close to business leaders.
• Redesigned Monthly Statement of Account/Account Current reports and automated distribution to brokers outside organization using Excel, DDS and SSIS.
• Initiated and completed hand-off of Monthly Statement of Account Current statement distribution to the business group responsible for it, freeing up the Data team to support other Month and Quarter end close tasks.
• Migrated suite of Claims reports from SSRS to Cognos platform.
• Provided production support for existing SSRS, Cognos, Business Objects Crystal reports and underlying data.
• Worked in conjuncture with the ETL team to resolve data issues in the Data Warehouse.
• Designed Daily Written Premium report for lines of business within US and International Insurance, created data driven subscription to distribute to business leader daily within the SLA time frame.
• Developed, managed and documented operational processes for the reporting team such as: UAT, Change Management, Deployment scheduling and deployment processes.

Confidential , Tarrytown, NY

Systems Development Specialist

• Used SSIS to automate file maintenance on several different servers (web server, report repository, batch file storage server) with different log file naming conventions, so the SSIS packages would examine a directory tree for log files older than 6 months and purge them. This replaced the manual process of deleting the old application log files. In the instances of the web server and report repository, space was a premium. When available disk space became low, the web applications would stop responding to requests.
• Utilized SSIS data flows to move data in Oracle schemas from OLTP source to OLAP. SSIS was used to clean and integrate data multiple sources from Oracle, Flat files, Excel and so on.
• Integrated two incongruent data sources (handwritten issuance and electronic issuance) into a single storage system for Officer Management System. SSIS was used to integrate/import data, create derived columns and perform data conversions.
• Created ad-hoc summations of officer, squad, and agency productivity across ranges of time. The solution; presented as an additional functionality to the Officer Management System; has been adopted by other OMS clients.
• Modified Officer Management System (OMS) web application to include a BPA solution that correlates officers’ daily hours to duties, handwritten citations issued throughout the workday, a segment of the automated process depended on SSIS to pull data, and change status of records.
• Used SSIS SQL to execute stored procedures that contained business rules and logic to make the associations between officers, duty, and tickets. Stored procedures and Crystal Reports were used to track percentage of records successfully processed, and incomplete records that would not meet the business rules determined by the client.
• Performed analysis used to create design mock ups and developed time management and productivity tracking reports, delivered via web-based interface utilizing tools such as Toad, SQL, Oracle 9i and 10g views, stored procedures and cursors.
• Collect client requirements, perform analysis, modify according to specifications and implement web-based data entry interface and data export to mainframe using VBScript, VB 6, and SQL 2005.
• Developed a data integration service that extracted data from client’s Abandoned Vehicle Access database, processed and exported to a third party vendor’s SQL 2005 implementation using VB 6.
• Provide third tier web-based application support to company’s regional offices and government clients in the parking, moving violations and patrol officer management sector.
• Create and maintain system design documents, user and administrator guides and distribute to regional office technical support, provided detailed training to new field office project managers to expedite their understanding of the applications enabling them to better serve the client.

Confidential, Nanuet, NY

Network Engineer II

• Provide remote (phone and e-mail) and hands-on technical support for one of company’s largest clients, working on-site at client facility.
• Carry out special projects, including installation, configuration, and upgrade of PC and server hardware, operating systems, antivirus software, Windows software, Ghost, and more.
• Perform troubleshooting. Analyzed and resolve user issues, ranging from password and connectivity problems to major system crashes.
• Monitor and run daily and weekly system maintenance and backups using Veritas Backup.
• Conduct hands-on training for end users in operating system and software usage.
• Improved efficiency by creating catalog of images to restore PCs as needed, using Ghost.
• Played key role in implementing disaster recovery procedures and maintaining documentation.

Confidential , Chappaqua, NY

Data Analyst /Database Programmer

• Gathered and analyzed client requirements in order to meet constantly changing needs of customer base.
• Communicated extensively with stakeholders and various levels of management to fulfill requirements.
• Utilized SQL Server 2000 and Access SQL to create/modify stored procedures, triggers; perform data cleaning/formatting. Organized and prepared data for database inclusion.
• Maximized productivity by developing and leading successful employee training program for the utilization of custom database and off-the-shelf software applications.