Jay Stevens Email & Phone Number

Mckinney, Tx, Us

Plano, Texas, Us

People First + Driven to Transform Our people-first approach to technology offers best-in-class service and success rates. With the world of business and technology growing more complex and confusing every minute, CG Infinity keeps it simple for our clients. Your leaders work with our leaders throughout an engagement. The leaders of our small, blended teams work hand in hand with your team to ensure your objective success. We partner with companies in a vast array of industries, including the Energy & Utilities and Financial Services industries, to help them thrive in the modern marketplace by leveraging technology to drive their enterprise. From our perfect record in Salesforce implementations, our trusted experience integrating Salesforce with backend applications, to our creative custom software solutions, CG Infinity is your trusted ally for business technology transitions. With our skilled employees and veteran leadership team, CG Infinity doesn’t complicate life for our clients, we simplify. Who We Serve Mid-size businesses looking to grow Large companies looking to stay ahead of the competition Key Focuses Salesforce Implementations Energy + Utilities Financial Services

Dallas, Texas, Us

Operating across a dynamic network of five interconnected practice areas, our versatile teams blend classically trained professional services expertise with a wealth of entrepreneurial acumen to help you gain momentum in your transformation journey. Originally founded as Sana Sano Consulting in 2014, The Bridge Strategy and Technology Consulting, now led by an experienced team of Dallas consulting executives, is an 85-person firm serving clients in north Texas and beyond.

Seattle, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

Armonk, New York, Ny, Us

Hired on as Data Integration Architect for Watson Health.• ETL Architect for health care practice data integration into the Watson Health data lake/warehouse.• Data exploration within client EMR databases to determine and analyze data needed for feeds.• Develops SSIS packages for data ingestion into Watson Health data repos. • Sources code within github. • Writes technical documentation in Confluence. • PowerBI presentations of exploratory data analysis. • Works with client on the implementation team.

Carrollton, Texas, Us

2 month contract to help stabilize legacy data infrastructure and then help migrate the data infrastructure to Azure Datalake. • Wrote C# script to parse out file name elements to re-build those pieces as a hierarchy directory for the file.• Consolidated multiple data feeds into one single data feed.

Roubaix, Fr

• Transitioned to OVH US via OVH acquisition of the VMware vCloud Air business• Maintaining current VMware Operational BI stack/tooling• Updating current VMware Operational BI stack/toolingo Enhancing the SSIS projects with a modular and portable design.• Learning OVH Operational big data, BI and data science stack/tooling• Developing Pig scripts and Cron jobs to execute data unification• Creating financial and capacity data unification workflows within the OVH US datalake using dataiku and Python Pandas • Developing reusable datasets for the Business Intelligence team• Creating Executive Dashboards in RMarkdown• Began a documentation campaign for the Business Intelligence team

Palo Alto, Ca, Us

• Team lead for vCloud Air Ops Reporting • Project lead on integrating finance, revenue, provisioning and cloud (integrated vSphere/vCenter, vCD, vCIM and Service Now) data. Developed ETL process that includes analytical frameworks to integrate this data. Worked with various teams outside of operations such as RevOps and Finance. Designed end report - Customer Revenue Capacity Report.• Implementing GitHub as source control, SSIS ETL Documentation.• Architecting a star schema to warehouse cloud asset and customer data. * Developing an SSIS ETL solution to process the warehoused data elegantly.

Palo Alto, Ca, Us

• Recruited to implement BI solutions for vCloud Air's Operational Department.• Provides metrics for Gartner Magic Quadrants.• Writes API calls. • Writes XQUERY to shred XML.• Develops SSIS (ETL) packages to bring in ServiceNow (ticketing system) data • Implements unique Control and Data Flows for a Type 2 slowly changing dimension that captures snapshots of Incident tickets initiated by the datacenter monitoring systems.• Develops SSIS (ETL) packages to dynamically iterate through over 400 SQL Servers that oversee data center management• Data modeling of the reporting database.• Designs dashboard reports for executive, operational and engineering teams.• Focuses on KPIs to show the health of different operational systems. • Designs MHTML emailed reports for viewing on smart phones.• Optimizes existing queries. • Report requirement gathering and report requirement analysis. • Daily monitoring of SQL jobs. • Implementes documentation of SQL scripts.

Irving, Texas, Us

• Contracted specifically to help rebuild the reporting portal team.• Unit testing of ETL processes • Data Analysis between ERP (JDE) and SQL environments • Reverse engineers existing Stored Procedures• Denormalizes normalized tables/files• Attends change control meetings and promotes the changes to production• Writes new and updates existing Stored Procedures• Creates new and updates existing SSIS packages• Design new and updates existing SSRS reports

• Writes SQL queries. Designs reports in Tableau and then uploads the report to Tableau Server.• Unit testing of new database objects.

• Developing Data Warehouse for Call Center data • Star Schema • Maintaining Data Warehouse in SQL Server 2012• Creating SSIS packages • Produced cURL protocols for automatic download of data in conjunction with Windows Task Scheduler • Automating SSIS packages with SQL Server Agent• Building SSAS cube• Designed SSRS reports• Writing queries for adhoc reporting

Analyst• Implementing a Data Mart via SSIS.• Annual Sales Forecasting Model- Linear Trend Analysis using the Least Squares (Regression) method.• Reoccurring analysis and reporting on sales, orders processed, new customer first orders, approved new customers, referral sources, and returns.• Prepared yearly analysis of sales / orders. • Provided metrics and reports on customer referral source. • Constructed decision strategy by performing decision analysis (payoff table, assigned probability, identified best alternative through the expected value approach, decision tree model). Then prepared managerial report summarizing findings with recommended action.• Designed Voice of the Customer survey – data collection, analysis, and reporting for product development project. • Formulated new product pricing.• Developed data retrieval, data analysis and reporting using SQL Server and Excel. • Process documentation by diagramming sales and service workflows in Microsoft Visio for lean processing. Along with control charts and Ishikawa diagrams was able to reduce order-processing speed from an average of one hour to an average of ten minutes. Order processing errors also dropped dramatically from about 65% to about 25%. Sales, Service and Marketing Manager• Created training workbooks and role specific handbooks.• Hired, trained and lead more than 10 employees with over $1 million in annual revenue and roughly 3,000 registered customers (with 400 active customers and 80 customers accounting for 80% of sales). • Increased sales from $350k to $1.3 million through customer experience program. • Managed Social Media Strategy.• Wrote or edited all company copy.

Streamlined the ordering process.o Removed unnecessary steps with workflow diagrams. o Assisted owner with Quickbooks integration by developing the billing process.Developed processes to handle proactive care cases. o Reviewed common cases and standardized workflow and resolutions based on root cause analysis. Increased customer satisfaction.o Created an environment were individual personalities thrived. o Standardized the company email and phone call procedures.