BUSINESS INTELLIGENCE SPECIALIST / ACCOUNT EXECUTIVE
Innovative business intelligence professional and analyst with 10 years of experience in report development and analysis as well as database development. Skilled in all facets of product development life cycle from analysis and design through development, implementation, documentation and user training. Excellent problem solving skills with ability to effectively communicate complex technical information to non-technical audiences. Recognized for "Bridging the gap" of technical expertise which contributed to meeting organizational goals.
AS400, IBM OS/390, Windows (95, 2000, XP,7), Unix
Microstrategy, Tableau, SQL Server Reporting Services(SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) Maplelake Merchandise Planning, SAS Size Optimization, Microsoft Visio, PowerPoint, Word, Excel, WinAutomation,
Databases:IBM DB2, Microsoft Access, SQL Server,Languages:SQL ,Python, Visual Basic, Visual Basic for Applications (VBA), JCL, COBOL, CICS, WebFocusSoftware:
Business Intelligence Specialist / Account Executive01/2016 to CurrentInform ApplicationsHauppauge, New York
Developed claims reports in WebFocus/Focus system based on clients' requirements using Focus and WebFocus.
Analyzed clients claims based on coverage (Worker's Comp, Auto Liability), claim type (medical, incident only or loss time).
Created reports and dashboards for my clients to analyze loss and loss stratification by coverage.
Monitored and analyzed collective claims datasets from different insurance carriers & third-party administrators.
Business Intelligence Report Developer/Lead Analyst01/2014 to 01/2016PerfumaniaYaphank, New York
Spearheaded the conversation of all operational reports to be developed in SSRS against the analysis cube Engineered a productivity report to track and measure our employee effectiveness in the following KPIs (Sales dollars, ADS, UPT) Built a tax jurisdiction report for our finance team so that record and pay each state/county the sales tax each location was collecting on a monthly basis.
Created over 200 data-driven subscriptions to post all of our operational & analytical reports to Google drive.
Developed web-based dashboards using EPICOR's Information Center, creating new data views and drill-down link capabilities.
Validate historical loads sales and inventory loads into our Datawarehouse/CUBE against our legacy iSeries.
Tableau - Evaluated as a viable BI and analytic business user-centric platform to replace SQL Server reporting services.
Tableau - Created sample dashboards to show product penetrations by region, district and location.
Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
Application Developer01/2011 to 01/2014BloomingdalesNew York, New York
Developed and implemented a curriculum for beginner, intermediate and advanced level Excel classes to teach entry level and advanced skills, key formulas and pivot table knowledge.
Create an application to standardize the merchant order sheets using historical sales data by size/location to optimize orders.
Created and deployed a "Top 50 Brands" report for the executive team to analyze sales growth shifts and changes in vendor margin.
Create multiple SQL Server DTS packages to extract Bloomingdale's data from MST's Teradata EDW into local SQL Server.
Converted screen scrapping Microsoft Excel based reports to use local SQL Server database.
Business Analyst/ Merchandise Systems Administrator01/2007 to 01/2011AéropostaleNew York, New York
Conceptualized, designed, developed and led development of Excel based applications to support the merchandise planning, allocation, production and merchant teams.
Introduced training documents, tested upgrades and problem solved any issues related to the merchandise planning system.
Built key user reports to support organizational goals using business intelligence software.
150K/year) by developing and publishing an Excel VBA application to auto generate all international purchase orders.
Developed and implemented a curriculum for beginner, intermediate and advanced level Excel classes to teach key formulas, security and macro knowledge.
Conceived, initiated and implemented a Microsoft Access size optimization module for the merchandise planning team to accurately identify size selling by store and select the most cost-effective pack configuration.
Created a Microsoft Excel VBA application to validate all purchase authorizations and improve user efficiency by over 100%.
Programmer Analyst01/2007The ReserveNew York, NY
Programmer Analyst01/2006ADIMelville, NY
Programmer Analyst01/1999 to 01/2006ADP - Automatic Data ProcessingEdgewood, NY
Certificate, Mainframe Re-skilling ProgramChubb InstituteNew York, New York
Masters: Business AdministrationDowling CollegeOakdale, New YorkBusiness Administration
Bachelor of Science: Resource DevelopmentUniversity of Rhode IslandKingston, Rhode IslandResource Development
ADS, AS400, BI, business intelligence software, CICS, COBOL, clients, DTS, Databases, database, documentation, Excel VBA, finance, Focus, IBM, DB2, insurance, inventory, JCL, Mainframe, Microsoft Access, Microsoft Excel, Excel, PowerPoint, Microsoft Visio, 2000, Windows (95,, Word, Microstrategy, Operating Systems, Optimization, organizational, OS/390, pivot table, problem resolution, coding, Python, reporting, selling, Sales, SAS, SQL, SQL Server, Tableau, tax, Teradata, type, Unix, upgrades, Visual Basic, Visual Basic for Applications, VBA