SUMMARY:

• Senior SQL Developer with twenty years experience working in SQL Server, Teradata, and Oracle databases
• Expert level TSQL, PLSQL, and Postgre SQL noledge, including writing complex queries, stored procedures, triggers, and functions
• Intermediate DBA experience, including creating databases, setting up various levels of security, optimizing database performance through proper schema design and indexing, and performing regular backups
• Seven years experience with ETL, including SSIS data flows from various data sources and flat files
• Twenty years developing applications and reporting solutions in Access and Excel, using SQL and VBA
• Over ten years developing reporting solutions in SSRS, Crystal Reports, Cognos, Power BI and Tableau.
• Exposure to various industries, including finance, banking, health care, energy, and law
• Exposure to multiple areas of banking and finance, including risk management, portfolio management, creditrisk, equity derivatives, credit derivatives, client onboarding, and middle and back office support, among others
• Serve as a liaison between business and IT, with a solid understanding of both
• Experience as a business analyst, gathering end user requirements, writing business requirement documents andfunctional specifications
• Report automation expert, with the ability to fully automate reporting end to end from various data sources(databases, flat files, excel files, etc.) to a fully formatted end product, with no user intervention

TECHNICAL SKILLS:

Languages: - SQL, PLSQL, TSQL, PostGre SQL, VBA, Python, HTML

Databases: - SQL Server (2005, 2008, 2008r2, 2010, 2016, 2017, 2019), Oracle (9, 10), Teradata, DB2

Software: - SQL Server Management Studio - SSIS, SSRS, SSAS, ETL, stored procedures, triggers, indexes, performance tuning, Sql Agent Jobs, backups; Teradata Design Studio, Oracle Developer; Cognos; Microsoft Access, Excel, Word, Powerpoint, Frontpage; TOAD; SQL Plus; SQL Navigator; Query Analyzer; BRIO; Crystal Reports; Sharepoint; Tableau; Power BI; Python; Batch Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Contractor / Data Analyst

Responsibilities:

• Utilizing Teradata Studio to pull and analyze data to compare eCommerce performance vs other lines of business
• Preparing executive level reports via Excel and Powerpoint
• Reviewing and correcting current SQL to ensure accuracy of reporting
• Creating high level data visualizations via Tableau
• Interfacing with upper management to gather data and reporting requirements and present findings

Confidential

Proprietor / SQL Developer / Application Developer

Responsibilities:

• As me had to leave my previous role to care for a sick family member full time, me started my own consultancy where me developed data solutions for local small businesses.
• Developed an application in SQL Server / Access to collect data and produce reporting on inventory management, online presence, cost of goods sold / cost of listing, product listing duration, profitability and other metrics for an online reseller
• Developed an application in SQL Server / Access to collect data and produce reporting on inventory management, online presence, cost of goods sold / cost of listing, product listing duration, profitability and other metrics for an online reseller
• Accepted donations of unused desktops and laptops, refurbished them, and distributed them to underprivileged families for remote learning and job seeking

Confidential

Senior Bunsiness Intellegence Developer

Responsibilities:

• Served as the sole resource for all data and reporting needs across all business lines and functions, ranging from Patient Intake to Human Resources to Marketing to Upper Management Financial Reporting.
• Managed all internal data applications across business lines, which range from Psychiatry/Telepsychiatry to providing medical staff for jails.
• Developed multiple fully encapsulated user friendly applications for recording data from various business functions into SQL Server databases and producing meaningful reports from that data.
• Facilitated the transition from the legacy UltiPro HR and Payroll application to the new Kronos HR and Payroll application by mapping all data from old format to new format, extracting all data from legacy system and loading into new system with appropriately mapped data layout.
• Functioned as the DBA, managing several databases across multiple servers, both maintaining existing databases and designing/creating new databases. Ensured performance optimization including proper indexing and query optimization, managed user security, set up backups, created and managed Sql Agent jobs.
• Created and modified reports in CareLogic / Pentaho utilizing PostGre SQL.

Confidential

SQL Server Developer

Responsibilities:

• Worked with Law firm clients to implement LexisNexis' legal back office time and expense software, Redwood Analytics.
• Created and customized data warehouses for various Redwood products (tables, stored procedures, functions, triggers, indexes).
• Set up SSIS data flows to update data warehouses daily.
• Created and customized SQL Server MSAS cubes and Cognos cubes, and configured web applications to ensure all reporting was displayed correctly.
• Collaborated with project management, development, quality assurance, and other team members to ensure quality implementation, upgrades, and ad hoc work products across all platforms.
• Optimized processes, queries, and indexes to ensure fast data loads and product performance.

Confidential

SQL Server Developer / Reporting Developer

Responsibilities:

• Designed and developed a SQL Server database to store all company data.
• Created daily, weekly, monthly, and quarterly reports of various analytics, including sales reports, expenditure reports, new customers / vendors, demographic TEMPeffectiveness, among other aggregates.
• Created a front end user interface for recording all transactions and data, and producing aforementioned reports.

Confidential

Production Support

Responsibilities:

• Served as a helpdesk supporting the EnSIS trading platform and over 50 end users.
• Investigated any discrepancies or inaccuracies in data between platforms, and executed live changes to correct such discrepancies
• Prepared testing, UAT, and development environments for BAs and developers
• Maintained user privileges across environments, which involved creating user accounts, assigning access privileges and server roles, resetting passwords, locking or unlocking accounts, and deleting inactive accounts
• Recorded all issues handled in JIRA and created Remedy tickets for incidents that required escalation
• Primarily utilized SQL Server Management Studio and the EnSIS application for data analysis / investigation and account maintenance

Confidential, New York, NY

Analyst / Developer

Responsibilities:

• Utilizing MS Access, Excel, SQL and VBA, automated all existing reporting activities that were performed manually in Oracle Discoverer.
• Created various new meaningful reports to provide more insight into productivity and performance
• Created multiple end user platforms for data entry, storage, reporting, and analysis.
• Created end user platforms to automatically produce mailings to insurance companies, patients, and doctors, to notify them of escalation actions. These mailings were all set off by automatic triggers (non responsiveness within a certain time frame, etc)
• Produced various analyses for organizational, departmental, and individual performance
• Tested varoius metrics produced by IT to house in our data warehouse

Environment: - Oracle back end / Access and Excel front end

Confidential, New York, NY

Assistant Vice President - Project Manager / Analyst / Automation Expert

Responsibilities:

• Served as an integral part of a highly visible Six Sigma initiative to measure the bottlenecks in the equity derivative trade capture process and find areas for improvement. My responsibilities were to act as a liaison between the business users / SMEs and IT to establish goals, define requirements and data definitions, and to query our Oracle databases to prepare metrics, reports, and analysis.
• dis involved conducting interviews with traders and SMEs to develop process flows, interviewing IT to develop data flows, and examining the equity derivative trade life cycle from end to end to determine where amendments and cancellations were occurring, determining wat attributes were being amended, calculating the downstream TEMPeffect of the amendments on confirmation and settlement rates, and recommending solutions to limit the number of amendments and boost straight through processing.
• Utilized Access, Excel, and VBA to automate multiple manually prepared daily, weekly, and monthly reports, TEMPeffectively saving hundreds of hours per week of manual work and ensuring accuracy of reporting.
• Developed Access databases to centralize various data sources, validate that data is accurate and adheres to business rules, and improve process efficiency.
• Primarily utilized Oracle, SQL, MS Access, Excel, VBA, TOAD, and SQL Navigator for analytics and automation.

Environment: - Oracle and SQL Server back end / Access, Excel, Crystal Reports front end

Confidential, New York, NY

Assistant Treasurer - Analyst / Developer - Portfolio Management / Credit Risk

Responsibilities:

• Responsible for performing data reconciliation on a new consolidated Credit Risk data warehouse to ensure consistency with the various sources and adherence to business requirements
• Implemented various stored procedures, functions and triggers in PL/SQL to enforce database integrity, business rules and security in our data warehouse.
• Gathered end - user requirements for and designed and created various MS Access reporting applications with user friendly interfaces
• Utilized Access, Excel, and VBA to design and produce various monthly and quarterly reports for the Board of Directors and other upper management regarding Portfolio Management and Credit Risk
• Primarily utilized MS Access and MS Query Analyzer to access data on SQL Server, DB2, and Oracle databases
• Created various stored procedures and triggers in MS SQL Server to ensure accuracy of reporting data

Environment: - SQL Server, Oracle, and DB2 back end / Access and Excel front end

Confidential - New York, NY

Data Analyst - Consultant

Responsibilities:

• Decision support using Access and Excel, developed regular and ad hoc reports for various business functions
• List management pulled lists for marketing campaigns and performed quality control on lists pulled externally
• Utilized Access, Excel, and VBA to streamline and automate existing daily and monthly reporting to free up company resources
• Ensured continuous improvement within decision support by educating and assisting peers to improve departmental TEMPeffectiveness
• Primarily utilized SQL*Plus, MS Access, and Brio to query databases on SQL Servers and present the data in readable format via MS Excel pivot tables

Environment: - SQL Server back end / Access, Excel, and Brio front end

Confidential, Spring Valley, NY

Data Analyst

Responsibilities:

• Report preparation, ranging from detailed collection reports such as customer account aging to upper level business reports such as profitability trend analysis
• Access Form building for improved efficiency and accuracy of data across departments
• Setting up various time sensitive triggers for customer contact, e.g., collector calls, direct mailings, account termination, etc.
• Primary use of MS Access, SQL and Excel in report querying and presentation.

Environment: - SQL Server back end / Access and Excel front end

Confidential, NY

Financial Analyst / EDI Billing Specialist

Responsibilities:

• Led implementation of and monitored EDI project for consolidated Utility/ESCO billing
• Assured data integrity through reconciliation of internal billing system and EDI transmissions
• Prepared competitive bids for commercial electric supply based on historical usage and forecasted market prices
• Prepared commission reports for our internal and external sales staff
• Predominantly used MS Access for most data tracking and reconciliation activities. GUIs for data access were Banner Billing Software and Henwood Forecasting Software

Environment: - SQL Server back end / Access and Excel front end

Confidential, NY

Instructor

Responsibilities:

• Taught quantitative, verbal, and analytical skills as well as general test taking strategies for the GMAT and GRE Graduate Admissions Tests
• Typical class size was between 10 and 20 students

Confidential, NY

Webmaster

Responsibilities:

• Designed new look for the City of Binghamton web page
• Transferred existing content to new design and added much new content