SUMMARY

• Innovative, Business & Operations minded wif over 15 years of experience building state - of-teh-art technology solutions for high-value organizations. Quick Learner,
• Talented Team Player and Technology Trainer who delivers user-friendly technology solutions that achieve/surpass user expectations and business goals.
• Helped Save Companies hundreds of thousands of dollars in technology costs through strategic automation, collaboration and technical innovation.
• Trusted Advisor to senior executives. MBA Graduate, linking Technology wif Business Organizations to Build Performance-Driven, Quality-Focused, Customer-Centric and Fiscally Responsible Operations

PROFESSIONAL EXPERIENCE

Data Quality Manager

Confidential, Bronx, NY

Responsibilities:

• Successfully led Data Warehouse Optimization project to reduce daily data load time from 27 hours to less than 12 hours per day.
• Implemented Weekly Data Reconciliation processes wif third party vendors, ensuring data synchronicity and accuracy, ultimately improving service levels (99.5%) to customers.
• Worked wif Data Reporting to design and publish Tableu dashboard reports, displaying Data Quality Matrices including Timeliness, Completeness, and Validity.
• Managed a team of 7 (3 Sr. Data Analysts and 4 ETL Developers), assigning tasks and tracking progress daily/weekly as needed.
• Regularly meet wif teh CIO and VP of Data Science to communicate project status, set monthly/quarterly goals, and provide feedback regarding upcoming initiatives.
• Regularly meet wif Data Science and Analytics team to benchmark and improve data quality in teh Data Warehouse.
• Chaired teh Bi-Weekly Data Governance Committee meeting; setting agenda and following up wif Data Stewards to solicit, evaluate, and resolve data quality and/or security related concerns.
• Implemented TFS to store code repository for SSIS packages.
• Worked as a liaison between senior leadership, internal ETL developers and third party business partners to complete an outstanding data-sharing project; ensuring compliance, timeliness and security of data transferred.
• Worked wif ETL developers to regularly address data discrepancy and data warehouse architecture issues.
• Regularly worked wif Data Analysts to investigate and troubleshoot issues pertaining to data quality, including tracing source of issue and recommending solutions.
• Utilized SSIS and SQL queries to QA data transformation and validate business rules.

Application Development Manager

Confidential - Bronx, NY

Responsibilities:

• Successfully brought in-house teh previously outsourced members effectuation and payment collection process in collaboration wif NYS and J.P. Morgan Chase wifin 5 months, serving 20,000 members and saving teh company over $1.5 million per year in servicing fees.
• Successfully launched teh $8 million/year “HARP” new line of product accessed by 4000 members to meet NYS regulation wifin 4 months, meeting teh state-mandated deadline and delivering teh project 40% under teh estimated budget.
• Worked wif vendors, department heads, and SMEs on a daily basis to resolve issues and discuss enhancements to current features.
• Regularly planned, organized, coordinated and evaluated staffing requirements to meet operational goals, working wif Sr. Managers, Sr. Business Analysts, and Sr. Programmers.
• Oversaw day to day support and development projects, managing a team of 30 programmers.
• Represented teh IT department in Steering Committees and State audits.
• Led teh effort in changing teh existing documentation process to include traceability matrices, change controls, and put in place processes and procedures to enable enforcement of quality gates.
• Worked wif developers to launch teh redesigned Member Portal wif ability to accept monthly payments, track authorizations, claims, payments, and request ID cards and PCP changes.
• Utilized Waterfall SDLC methodology in developing applications, maintaining extensive documentation including FRD, TDD, Unit Testing results etc.
• Designed Compliance department’s sensitive internal database and application’s migration project to migrate data from MS Access to an encrypted SQL Server 2008 environment.
• Reviewed existing processes and standards and implemented appropriate changes.
• Worked wif Business and Data Warehouse team to aggregate, store, merge and accurately report data from various vendor sources.

Project Manager/Sr. Programmer/Reports Analyst

Confidential, Long Beach, NY

Responsibilities:

• Delivered user-friendly and business-centric dashboard solution for executive management, supporting a multi-site $5 billion organization.
• Gathered business requirements and worked hands-on to identify bottlenecks, streamline and automate over 40 manual-labor-dependent business-operations, billing and finance related processes, eliminating 60 labor hours per week.
• Designed & built a highly scalable complete end-to-end prescriptions return & recall solution.
• Work wif vendors of proprietary systems (HBS/Framework/Docutrack) to troubleshoot work-flow-related issues and recommend changes to be made to teh business procedure including streamlining processes and verifying integrity of current systems.
• Designed UI for alert system used to send encrypted messages to clients and internal officers based on predefined alert criteria in .Net and JavaScript.
• Responsible for teh company’s internal and client-facing applications including troubleshooting and enhancing applications, database stored-procedures, SSIS packages, DTS Packages etc.
• Automated over 60 daily/weekly/monthly/quarterly reports, reducing cost and increasing efficiency using SSIS and Crystal Reports.

Systems Analyst/Programmer/Database Administrator

Confidential - Mitchel Field, NY

Responsibilities:

• Review annual contracts and managed outsourced off-shore database maintenance efforts.
• Successfully co-ordinated teh $2 billion company’s production ERP system upgrade project, working wif various department heads and offshore vendors.
• Worked wif finance and purchasing departments to understand business processes and deliver various financial & management reporting solutions.
• Delivered highly customizable Kronos-integrated HR solutions.
• Acquired & Implemented powerful .Net plugins to speed up development time as well as security & web-traffic monitoring & reporting solutions.Technological Achievements
• Responsible for all of teh critical in-house ASP.NET applications’ user interfaces, databases and back-end IIS 6 and IIS 7.5 functionalities.
• Responsible for teh daily/monthly/yearly analysis of teh company’s production servers including blackberry, exchange & SQL Servers. Ensuring all SQL DTS packages, procedures and backup jobs run smoothly on a daily basis.
• Developed teh company’s timesheet/e-LaborTickets application including teh ability to assign time-sensitive tasks to employees, tying into teh ERP system and reporting via SSRS. Interface designed wif Telerik.
• Developed dashboard and reports for various departments wif Visual Studio .NET, stored procedures and Crystal Reports, utilizing data from Visual ERP system.

Sr. Project Manager

Confidential - Plainview, NY

Responsibilities:

• Managed programming projects and working hands-on wif junior IT personnel in order to meet deadlines set by teh State of NY for various fire-houses across long island.
• Implemented employee & fire-truck inventory tracking module into existing fire incident management application.
• Setup a multi-user, single database, real-time data sharing environment for a recruiting firm in NYC wif workers dialing into teh network from remote locations.
• Resolved company’s financial application, correcting issues wif several accounting interfaces and reports, and implementing new software solution for tracking employee’s labor-tickets.
• Developed a web-based 911 call dispatching program to replace teh old AS400 based system, making it more user-friendly and highly customizable.
• Troubleshoot company’s financial application correcting issues wif several accounting interfaces and reports and creating a module used for tracking employee’s labor-tickets.
• Setup & Installed Network Infrastructure at a constructions supplies retail store utilizing Quickbooks Point of Sale software wif daily sales data integrated seamlessly wif teh company’s Accounting software over a network, also viewable to teh accountants over a secure remote connection
• Designed various complex reports and reporting services based on data stored across multiple databases, tables, queries and views, in both MS Access and MS SQL Server 2005.

IT Manager - Finance Department

Confidential - Syosset, NY

Responsibilities:

• Managed teh finance department’s IT development, working closely wif teh COO, CFO, and Controller.
• Prepared weekly and monthly production forecast utilizing statistics & empirical data from several databases including in-depth analysis of mortgage product volume, revenue & ROI.
• Successfully implemented conversion project of manual Excel based commission calculation to a fully automated and highly versatile system based on MS SQL Server.
• Successfully integrated teh process of daily funding and settlement activities across multiple systems including teh custom-built ERP system, teh accounting system (AMB), and teh CRM system (Encompass).
• Worked wif Secondary Marketing Department to deploy a system of tracking, reconciling and calculating teh revenue generated from hedging loans based on teh mark-to-market pricing obtained from Wall Street.
• Trained & managed a team of 3 accounting staff to use teh developed data ETL applications and ERP system.
• Developed teh process of daily loan-level reconciliation of cash generated wif teh warehouse banks.
• Resolved technical and accounting related issues in person and over teh phone.
• Automated teh labor-intensive task of preparing a daily Corporate Report. Making a 6 hours task possible in 1.5 hours utilizing VBA and Macros.
• Ran ad-hoc reports, graphs and analytical data needed by executive management in a timely and accurate fashion using MS Access and SQL Server Query Tool.

General Manager

Confidential, Farmingdale, NY

Responsibilities:

• Responsible for daily bookkeeping, billing, and daily production reports from QuickBooks
• Oversaw daily operations of teh facility including working wif vendors & customers, reporting directly to teh CEO.
• Ran daily meetings and facilitated in teh interaction of teh manufacturing, packaging & shipping departments.
• Oversaw designing of product labels and brochures, and general marketing schemes.Technological Achievements
• Designed and maintained company’s inventory database system wif VB6 and MS Access.
• Developed & maintained teh company’s website as well as managed teh company’s online advertising campaigns wif MSN, Yahoo and Google.