Business Intelligence and Data Science Professional

Business Intelligence and Data Science Professional

Professional Summary

MicroStrategy 7.2 – 2020 (11.x) (15+ years) Business Objects XI R3 OBIEE 11g Oracle 7 – Current Version AWS Redshift Cloudera Hadoop Spark SQL SQL, SQL Plus, PL/SQL SQL Server Python Intel Servers LINUX iPhone, iPad, Android

Data Modeling ETL Database Views Database Stored Procedures Dashboards MicroStrategy Mobile Bootcamp Graduate SOX Retail Manufacturing Distribution Pharmaceutical Financial Insurance

MicroStrategy Certified Engineering Principal (MCEP) Oracle 9i Certified Associate

Employee Awards… “Count On Me” Award 2013 Constellation Award 2014

Professional Experience

Employment:

Cognizant, Teaneck, New Jersey Sept 2019 – Present

Manager of Projects / Architect (Fulltime)

Work within the Artificial Intelligence and Analytics Service Line. Leverage expertise in a technology area to design system architecture, guide and review technical delivery by internal teams, resolve architecture issues and deliver / own architecture of application solutions spanning across multiple technologies for projects of the following nature - high revenue projects / complex projects / large strategic maintenance project to deliver technically sound projects across one / multiple customers WITHIN the guidelines of the customer and Cognizant standards and norms.

Cognizant Projects:

Avangrid, Orange, Connecticut

Project… MicroStrategy Reporting and Quality Assurance Lead on an Estimate Time of Power Restoration Big Data project.

Leads offshore resources and ensures the team is using industry-accepted best practices.

Oversees all aspects of reporting and quality assurance, including establishing metrics, and developing new tools and processes to ensure reporting and quality goals are met.

Acts as a key point of contact for all reporting and QA of releases, providing reporting and QA services, both internally and externally.

Develops reporting and executes test cases, scripts, plans, and procedures in a MicroStrategy and Big Data Hadoop Hive, HDFS, Spark SQL, and Scala environment.

UBS, Weehawken, New Jersey

Project… Big Data Architect, remediated ETL performance problems in their Cloudera Hadoop Data Lake. Identified long-running queries, diagnosed, performed SQL coding changes, and generated performance improvement statistics.

Barclays, Whippany, New Jersey

Project…MicroStrategy Architect, converted the CRO Enterprise Reporting, Mandate & Scale Level Dashboard to use MicroStrategy Dossiers and access a Cloudera Hadoop.

Consultant Contractor Jan 2016 – Aug 2019

Contract Projects:

Sompo International, Purchase, New York

Senior MicroStrategy Architect and Reporting Lead Consultant

Project…Combined data from three Surety Bond Insurance Systems and create a SQL Server Data Mart. Used best practices for data modeling and ETL. Created MicroStrategy architecture, standard reports, dashboards, and setup self-service in an enterprise environment.

Situs Inc., Houston, Texas

Senior MicroStrategy Architect Consultant

Project…Created MicroStrategy reports and dashboards in an enterprise environment. Leverage my background in SQL, database, and data warehouse concepts.

Audible, Newark, New Jersey

Senior MicroStrategy Architect and Amazon DataNet/Metrics Report Developer Consultant

Project…Worked with data engineers to create a schema and applicable objects to build and support dynamic reports and data visualizations in MicroStrategy.

Citibank, Warren, New Jersey

Senior MicroStrategy Architect and Reporting Lead Consultant

Project…Facilitated the identification, definition, and documentation of client needs and which MicroStrategy functionality would best support the customer's long and short-term needs.

Coach, New York, New York

Senior Mobile Business Intelligence Consultant

Project…Enhanced and deployed 3 MicroStrategy Mobile business applications to respond to the desired need for better decision-making ability.

Employment:

Wyndham Hotel Group, Parsippany, New Jersey Sept 2012 – Nov 2015

Manager, Business Intelligence Development

Lead Business Intelligence MicroStrategy team understood the strategy and objectives of each business organization and make recommendations to a MicroStrategy, standard reporting, Mobile, service-based, centralized solution that correlates multiple KPI’s and exposes through a single point of access 25 to 50 projects.

Software By Design, Inc., Rye Brook, New York Jul 2010 – Sept 2012

Senior Consultant, Business Intelligence Architect

Responsible for leading the strategic design and maintenance of business intelligence applications. Obtained MicroStrategy 9 Certified Project Designer (CPD), Certified Report Developer (CRD), Certified Document Developer (CDD), MicroStrategy Certified Developer (MCD), MicroStrategy Certified Engines Specialist (CES), the MicroStrategy Certified Platform Administrator (CPA), and MicroStrategy Certified Engineering Principal (MCEP) certifications.

Contract Projects:

Olympus Surgical Technologies America, Southborough, Massachusetts

Project…MicroStrategy Mobile iPad executive dashboard based on Revenue, Gross Margin, Backorder, Booking and Shipping, and Cost Center subject areas.

Brandeis University, Waltham, Massachusetts Project…MicroStrategy Change Management Project…Recommend to the MicroStrategy Administrator an analysis of three change management techniques under consideration for streamlining their growing 9.2.1 environment due to limited staff.

Project… Compose two custom MicroStrategy Web training classes to be administered by Brandeis staff, Consumer or End User and Creator, or Power User Training.

Project…Compose a Custom MicroStrategy Object Manager Training based on the previous MicroStrategy Change Management Recommendation assignment.

Diageo North America, Norwalk, Connecticut

Project… Led a team of 3 junior to senior MicroStrategy resources from analysis through the implementation of a North American restructuring program. Completed this very aggressive, short timeline project before the deadline and under budget.

Project…Troubleshoot MicroStrategy hierarchy architecture flaws correcting many errant grid reports. Identified and corrected 3 attributes causing inefficient query generation and inaccurate results.

Project…Developed MicroStrategy sales and marketing dashboard, consisting of 30 pages.

Investment Technology Group, Inc. (ITG), New York, New York

Project… Data Modeled, architected a multi-fact POC, logical design, conformed dimension database design, database implementation, ETL design, through MicroStrategy implementation.

Project… Perform analysis and design for migrating the semi-manual Excel Indication of Interest (IOI) Messaging statistical reporting system to MicroStrategy.

Project… Perform analysis, design, and POC for migrating the semi-manual Excel Connections Reporting statistical system to MicroStrategy.

Starwood Hotels and Resorts, White Plains, New York

Project…Convert a 10-tab, 15 report Excel Sellers Performance Report Book spreadsheet to MicroStrategy. Cut prep time from 2 weeks to instantly available at month-end.

Project…Sales Performance Report Book Automation: Converted a 15 tab, 55 reports, 39 graphs Excel spreadsheet to MicroStrategy. The task consisted of creating some very complex Report Services Document structures to meet the client’s formatting needs.

Employment:

AIG Enterprise Risk Management, New York, New York Jul 2007 – Jul 2010

Senior Database Administrator, Operations and Systems Sept 2008 – Jul 2010

In addition to Change Management activities, I became responsible for all Development (DEV), Quality Assurance (QA), User Acceptance Testing (UAT), and Production (PROD) databases. Provide 24x7 support. Worked with developers to troubleshoot and tune their code. Responsible for Sarbanes Oxley (SOX) reporting and compliance.

Directed 2 onshore Sr. DBA and DBA consultants and 3 offshore DBA members.

Senior Database Administrator, Change Management May 2007 – Sept 2008

Deployed Oracle and SQL Server software into 4 Quality Assurance (QA), 2 User Acceptance Testing (UAT), and 1 Production (PROD) databases.

Oracle Software Deployment Automation: Automated and fine-tuned Oracle software deployments resulting in a 30% performance gain.

CommonHealth, Parsippany, New Jersey Aug 2005 – May 2007

Business Intelligence Analyst

Scoped, and implemented Business Intelligence and Data Warehousing activities. Developed and implemented security and integrity policies and procedures and resolved database performance and capacity issues.

Improved data load success rate from 60% to 95%, a 35% improvement, by implementing configuration changes and introducing daily maintenance.

Reduced data load time from 13 hrs. to 5 hrs., a 62% improvement, by upgrading hardware, O/S, SQL Server, Ascential DataStage, MicroStrategy, and additional configuration changes. Introduced Change Data Capture ETL techniques.

Obtained MicroStrategy 8 Certified Project Designer (CPD), Certified Report Developer (CRD), and Certified Platform Administrator (CPA) certifications.

Fisher Chemical, Fair Lawn, NJ Apr 2003 – July 2005

Promoted to Data Warehousing Administrator

Business Intelligence, Data Warehouse, and database initiatives. Designed, modeled, installed, and maintained corporate databases.

Developed and implemented security and integrity policies and procedures and resolved database performance and capacity issues.

Reported to Global Director

Senior Database Administrator

Infrastructure: Implemented Backup and Recovery, Fault Tolerance, Overall Strategy.

Sapphire LIMS Upgrade (IBM AIX, MS Access Data Conversion (IBM AIX, ACROS Organics Quote, and Order Application, Fisher Chemical Quote, and Order Application.

Organon USA, Roseland, NJ Apr 1999 – Mar 2003 - Project Manager Data Warehouse Development

Education

Montclair State University, Montclair, New Jersey

Bachelor of Science, Computer Science, and Mathematics (Dean’s List)

Contact this candidate