PROFESSIONAL SUMMARY:

Data Analyst with over 18 years of ETL manipulation, statistical analysis and reporting. Hands on experience with T - SQL scripting and data modeling within Oracle, SQL Server, Sybase and MySQL environments. Detailed experience in data manipulation with SSIS, Microsoft Excel, Microsoft Access, Oracle, Sybase and TOAD ETL tools. In addition, experience with reporting analytic tools SAS, SAS Macros, Cognoos 10, Crystal Reports and Tableau. Exposure to PHP, Coldfusion, Sharepoint and Web Rich development tools. Master’s Degree in Applied Mathematics.

TECHNICAL SKILLS:

T-SQL (SQL Server, Oracle, Sybase, MySQL) Analysis Services, DTS, Microsoft Excel, TOAD, Crystal Reports, SharePoint, working knowledge of SAS, PHP, Sharepoint, Coldfusion.

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Analyst

Responsibilities:

• Ad hoc Cognos and SAS reporting centered around claims, authorization and case manager data.
• Provider scorecards reporting on performance metrics: hospital admissions, emergency visits, medical/pharmacy cost and pharmacy prescriptions.
• Project Lead on the centralized reporting for Executive Board Tableau dashboards to provide company-wide analytics on claims, encounters,, clinical and call center data.
• SAS scripting to provide EPSDT data report on member statuses to local county organization.
• SAS code redesign of OPS15 report, to identify and optimized data flow process via macros.
• Documentation of manual reporting processes, business logic and validation steps.

Confidential

Data Analyst

Responsibilities:

• Documenting and closing contracts for pharmacies that are no longer are 340B eligibl e front-end application validation.
• Continuing discussions with account managers regarding invoices, purchase orders and contract end dates for ineligible 340B pharmacies.

Confidential

Business Intelligence Analyst

Responsibilities:

• Analysis reporting support for 5 to 10 business programs within Tableau Server environment. Metrics ranging from standard headcount and trending invoice to cost savings and time-to-fill analysis
• Work with Business Intelligence team members to support the creation of reporting templates within FieldGlass environment
• Automating manual system process from Microsoft Excel to Microsoft Access.
• Document and validate data end-to-end process of data migration from Fieldglass environment to Tableau reporting.

Confidential

Reporting Systems Analyst

Responsibilities:

• Project support for PartnerEdge Next Generation as well as other PRM/Infrastructure projects.
• Review, track, prepare and execute blueprints and IT use cases.
• Preparation of and deployment assets as well as updates to existing assets.
• Preparation of cut over tasks for project go live.
• Support with global team alignment tasks, resource and project planning
• Manage content and development of PartnerEdge Next Generation intranet site
• Creating dashboard reports with Xcelsius 2008

Confidential, Wilmington, DE

Data Analyst

Responsibilities:

• Developed advanced adhoc queries (Inline views, Sub-queries) for reporting on company wide financial projects.
• Confidential financial Microsoft Excel reports via Pivot tables on Capital Investment and Expense summary projects (Actual Labor, Vendor and Hardware Cost vs. Estimated Labor, Vendor and Hardware Cost).
• Processing reporting through Microstrategy and Distribution Service.
• Utilizing PL/SQL to import or update data changes within Oracle warehouse.

Confidential, Philadelphia, PA

Data Analyst

Responsibilities:

• Through IMS and HIMSS data sources developed profiling tables of 7000+ hospitals and 50+ networks throughout the US for the sales, pricing and marketing team for strategic analysis.
• Transitioning of Access databases and data modeling into a SQL Server environment for data consistency and efficiency.

Confidential, Chicago, IL

Associate Analyst

Responsibilities:

• Compare and analyze yearly data performance of 2,000 classes, grade point averages, student satisfaction and failure rate utilizing Microsoft Excel Pivot tables
• T-SQL ad hoc reporting and data modeling within SQL 2008 data warehouse environment for Academic Deans, Advisors and Chairs, validated with SAS data steps and PROCS for second level accuracy
• Created SSIS packages to automate, clean and load data from data warehouse to reporting resources.
• Full documentation of SSIS procedures, T-SQL queries and reporting results for transparency of daily functions.

Confidential, New York, New York

Business/Data Analyst

Responsibilities:

• Liaised with 25+ senior level management to authenticate Business Leads, Data Custodians and users to 240+ Confidential infrastructure applications.
• Developed complex queries within Microsoft Access to analyzed life cycles, response time and Business Lead responses to optimize the variance in communications between segment leads and the Information Security department. In addition to Report objects to display statistics: means, standard deviation and percentages of the three phases.
• Developed Microsoft Access objects: Correlated Sub-Query and Derived tabled Queries and conditional report labeling to automate project status.
• Documented business rules and standards to ensure accuracy and consistency with Confidential Integrated Services.

Confidential, Stamford, Connecticut

Reporting and Data Analyst for Global Sales

Responsibilities:

• Leveraging historical data from Oracle warehouse and metrics reports for Sales Global Strategic Operations department. Assist with overall seller performance reporting goals for 300+ Global Sales Associates utilizing advance Pivoting tables.
• ETL from teradata warehouse with SQL scripting performed in TOAD, Microsoft Access and SQL+ Worksheet against Oracle data warehouse for ETL integration.
• Utilized Data Dictionary to better understand definition of schema objects: tables, view and stored procedure.
• Developed Microsoft Access systems and Microsoft Excel spreadsheet pivot tables with VLOOKUP technique from raw historical data which forecast Weekly Sales Cycles, Win Rate analysis, Net Production and Average Daily Rate for global divisional segments.

Confidential, New York, NY

Procurement Systems & Reporting Analyst

Responsibilities:

• Developed monthly metric Crystal reports dashboards to analyze and improve the performance and life cycle of 1000+ purchase orders, wire transactions, vendor-to-client relationships through the Procurement system.
• Designed reports in Crystal Reports and Excel Pivot tables for Confidential heads to analyze metrics, historical performance, and/or fraudulence of vouchers, purchase orders and wire transactions.
• Developed and executed testing on data extracts against Sybase 10 teradata warehouse to ensure accuracy of reporting.
• Developed Microsoft Access database for credit card tracking process of historical departmental use and reporting statistics.

Confidential, Philadelphia, PA

Database Analyst/Developer

Responsibilities:

• Consolidated Unix and SQL Server data warehouse through DTS services to generate Museum-wide daily schedule of events. Daily reports generated in Crystal Reports for daily museum use of staff and visitors.
• Developed Microsoft Access Load Agreement reports for over 5000 art objects within the Museum.
• Metric reports on room optimization of Museum resources (heating, lighting, janitorial services) by the head of Facilities utilizing SAS base procedures.
• Automated metrics reporting (through DTS, SQL Server 2000 and MS Access) for Director of Information Services on help desk support logging on 500+ end users, inventory and technician support performance.
• Analysis reporting on the rate of art objects within SQL Server 2005 data warehouse posted to Museum’s website.
• Collaborated with over 15 department heads and 50 end-user to create a test environment, question/answer/recommendation and implementation period of SharePoint portal to for Museum wide reporting and document sharing.
• Liaison with Editorial Graphics department to upgrade Virtual Ticket and Job Manager.
• Worked with Visitor Service to implement ticket scanning process to capture special exhibition metrics.
• Managed, development intranet via Sharepoint, Coldfusion with SQL Server 2000 back-end