Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Butler/TillData Engineer
Apr. 2024Rochester, New York, United StatesThe Data Engineer is a hybrid role, combining the core competencies of data engineering with business intelligence techniques to support our client’s reporting needs with high agility. The role works closely with Information Analysts to plan and support the creation of reports, analysis, extracts, and data marts that feed directly into Power BI. This position concentrates on SQL, Python, and data processing within cloud environments (Snowflake, Azure, AWS), but also works to understand both Power BI and the marketing platforms that the source data derives from for Quality Assurance purposes. This role works to automate ad hoc processes, document ETL steps, and manage database schemas as well as works with senior colleagues to receive training, code reviews, and receive feedback to improve their deliverables. KEY OUTCOMES & RESPONSIBILITIES Key Outcome: IMPROVED ORGANIZATION & PRODUCTIVITY Effective data management fuels organization, productivity, and automation. Enabling internal consumers access to trusted data for running queries, developing strategic insights, and delivering standardized outputs. Adding value to our external customers and improving the bottom line. Key Responsibilities: Seeks direction from their Director and works with both internal and external stakeholders to capture requirements and document Butler/Till’s data frameworks. Writes scripts for the creation, support, and automation of standardized, scalable, and client specific data marts. Collaborates with other departments to create solutions to improve agency efficiency. Works closely with B/T’s Analysts, Media, and Account teams to understand our clients’ data needs and the standardization of campaign/ad naming conventions across clients. Maintains documentation on existing data policies, data dictionaries, metadata and ETL processes and assists with proof of concept (POC) designs for strategic initiatives.
QuinsiteData Engineer
Mar. 2022 - Nov. 2023Indianapolis, Indiana, United StatesEngaged in requirements dialogue to ensure requests are clarified first hand. Developed tactical plan by ensuring solutions steps and critical success factors are documented. Coordinated solution verifications with end users, this greatly help minimize rework and promoted satisfactions rateand reliance Contributed to development and improvement of ETL standard to automate clients' billing, report and scheduling data onboarding using Python, SSIS, stored procedure and dynamic SQL. Helped transitioned our SSIS ETLs to Python ETL Leveraged root cause analysis techniques bring solutions to end flat file to database repetitive issues. Undertook and solved complex ETL processes from clients with complex use cases
OptumData Analyst 2
May. 2018 - Mar. 2022Indianapolis, Indiana AreaUnitedHealth Group - Optum (formerly Equian) is a leading end-to-end payment integrity organization managing over $500 billion in claims data annually through an innovative platform designed to assist clients by avoiding, identifying, pricing, analyzing clinical codes, and ultimately recovering inaccurate transactions in the complex environments of healthcare, workers compensation, and property & casualty markets. Optum acts on data to pay the right party, the right amount, at the right time delivering over $3.5 billion annually in actionable savings throughout the payment spectrum. The Business Intelligence Engineer will support internal and external reporting needs of the company. He/she will be skilled at facilitating strong partnerships with internal and external constituents, have strong storytelling skills and depth of experience in advanced reporting and analytic techniques. Principal Duties and Responsibilities: * Work with Business Owners and Data Stewards to extract data from various sources and warehouse accurately, interpret data, analyze results and provide ongoing support to customers
*Create reporting deliverables that illustrate insights and recommendations based on program performance and learnings
*Ability to prioritize a high volume of requests to address those most urgent to the business
*Ability to assist with the standardization and scale of report offerings across a given line of business within Optum *Internalize and overhaul existing reporting packages, while still meeting needs from the original system
*Detect the presence of and diagnose the cause of data integrity issues, working with Business Owners and Data Stewards to resolve in the reporting layer or upstream
*Field business intelligence requests and dig deep to truly understand the internal and external reporting needs
*Migrate existing manual reports into dashboard and visualization tool for self-service
EquianBusiness Intelligence Developer III
May. 2018 - Jul. 2019Indianapolis, Indiana, United StatesEquian (now Optum) is a leading end-to-end payment integrity organization managing over $500 billion in claims data annually through an innovative platform designed to assist clients by avoiding, identifying, pricing, analyzing clinical codes, and ultimately recovering inaccurate transactions in the complex environments of healthcare, workers compensation, and property & casualty markets. Optum acts on data to pay the right party, the right amount, at the right time delivering over $3.5 billion annually in actionable savings throughout the payment spectrum. The Business Intelligence Engineer will support internal and external reporting needs of the company. He/she will be skilled at facilitating strong partnerships with internal and external constituents, have strong storytelling skills and depth of experience in advanced reporting and analytic techniques. Principal Duties and Responsibilities: * Work with Business Owners and Data Stewards to extract data from various sources and warehouse accurately, interpret data, analyze results and provide ongoing support to customers
*Create reporting deliverables that illustrate insights and recommendations based on program performance and learnings
*Ability to prioritize a high volume of requests to address those most urgent to the business
*Ability to assist with the standardization and scale of report offerings across a given line of business within Optum *Internalize and overhaul existing reporting packages, while still meeting needs from the original system
*Detect the presence of and diagnose the cause of data integrity issues, working with Business Owners and Data Stewards to resolve in the reporting layer or upstream
*Field business intelligence requests and dig deep to truly understand the internal and external reporting needs
*Migrate existing manual reports into dashboard and visualization tool for self-service
Eli Lilly and CompanyIT Service Delivery Lead
Apr. 2016 - Jan. 2018Indianapolis, Indiana AreaEnterprise Information & Platforms manages a complex environment of information technologies and services across the enterprise. The scope includes information at rest and information in motion for every business function and geographic location, spanning the entire data lifecycle from capture to retirement. Laws, regulations, and heightened security from Protect Lilly require these services to be executed with a high level of quality and control. The primary focus of the EIP Managed Service Delivery Manager will be the delivery of services related to software installation, monitoring, lifecycle management, and support of business area projects for the Business Analytics and Enterprise Data service area within EIP. This role will be the main interface to the Supplier to maintain consistent service delivery by meeting agreed upon service levels. This role must possess technical understanding of the various EIP technologies to ensure services are being delivered in a reliable and trustworthy manner. This role will review the approach and procedures of the Supplier, ensure alignment with Lilly Quality Standards and Practices, monitor service levels, provide an escalation point for critical issues, and suggest/review service improvements. This role will be part of the EIP Service Management Office, driving ITIL adoption to improve service delivery and optimize service costs. While this role will be focused on the Business Analytics and Enterprise Data, there is an expectation that it will work closely with the Service Delivery Leads representing the other services within EIP and act as a backup to ensure coverage across the team.
Eli Lilly and CompanyMedicine Development IT - Technology Integrator
Dec. 2013 - Apr. 2016Indianapolis, Indiana AreaThe Project Portfolio Systems Analyst combines 4 roles within the IT Career Framework: Software Engineer, Business Analyst, Technical Integrator, and Architect for Lilly Portfolio systems for Resource modeling and forecasting and project management office which include Orion and Planisware This position serves as a lead analyst to the LRL Development COE Business Operations areas on matters of technical leadership and operational support. It is the responsibility of this position to make decisions that impact project and service activities for several assets in the LRL Business Operations areas. The analyst leads the value assessment of all Business Operations systems in production support by the LRL IT – Solution Services – COE, working within the business operations leadership to create value plans and drive consolidation towards a more consistent information platform. Key outcome from this role is to reduce the cost to manage these solutions over time, while consistently growing the value, accessibility, and availability of information to LRL. This position develops relationships internally and externally related to business operations solutions. Based on knowledge gained from these relationships, the position then gains support to provide influence to the internal direction of Lilly.
SogetiBusiness Intelligence Consultant
Jun. 2013 - Aug. 2013Greater Detroit AreaLinking Business Intelligence and detailed analytics to your overall business strategy, performance
management and KPIs to best optimize your results.
• Leveraging the latest technologies, including our “Business Analytics as a Service” private Cloud offering, to reduce costs and improve efficiencies.
• Seamlessly migrating and supporting your Data Warehouse appliances.
GE HealthcareAmericas Services Mobile Application Testing Lead
Aug. 2012 - Feb. 2013Greater Milwaukee AreaPart of the $55 million project of service re-imagination (Service 2.0) in GE Healthcare Americas Services, As Mobile Testing Lead, collaborated, networked, and shared mobile testing best practices, managed vendor relationships GE and Verivo, ensured test scripts meet FDA healthcare system testing documentation standards and mobile application is tested and functions as intended.
• Leverage collaboration tools to bring visibility of testing strategies to internal team and stakeholders. Documented traceability of 100+ requirements between Verivo and GEHC Americas Mobile CRM project documentation. • Created, managed, executed project plan for mobile testing to maintaining consistency in testing. Introduced 4 processes strategy plans for testing lifecycles including: leverage requirements migration, test planning and execution types, data setup in Siebel 8.1 and defect management for agile testing for mobility in validated environments • Trained on/offshore testing team to guarantee a coordinated and cohesive approach to formal testing in validated environments. Led offshore team in developing 65+ scripts using GE Healthcare standards • Managed test scenarios, execution and traceability from user requirements to defects using Quality Center. Eliminated manual documentation complexity, reduced testing efforts and waste by ~75% through using Agile Methodologies with Quality Center for defects visibility and closure across teams. • Proactively raised defects through preemptive dry runs testing to reduce defects density. initiated risk based testing
• Drove virtual testing execution using Perfecto Mobile technologies to reduce objective evidence collection time for mobile application by nearly 95%. • Acquired vast experience with writing qualitative test scripts meeting requirements for validated environment. Created over 100 data samples in Americas Siebel 8.1 for testing execution and verification against the Verivo platform mobile application.
GE HealthcareOBIEE and SharePoint BI Lead
Jan. 2012 - Aug. 2012Greater Milwaukee AreaAs BI Lead, implemented global BI, strengthen IT and Process Excellence global presence and influence, improved global engagement reviews, supported knowledge management and collaboration strategy
• Successfully managed and simplified critical global financial metrics and KPIs. Planned, designed and implemented various dashboards using OBIEE to promote financial data visibility and increase reporting speed capabilities 5X faster to regional management. Reduced the global manual report time to corporate leaders by 80% (from 20 down to 4 days), optimized cost visibility and drill down, improved decision making support. and various intangible benefits
• Designed and tested SharePoint 2010 security permissions. Administered rapid intelligence reporting to consultants projects using Project Server 2010 to increase overall business commercial utilization standards above 80% and regulate resource planning and density.
• Developed and customized BI reports for several Project Server 2010 deployments in Europe and Middle East. Increased project accountability by nearly 98% which increased productivity and other intangible benefits. Provided support analysis for SharePoint/Jive integration for Knowledge Management deployment.
• Designed, implemented and tested dynamic forms using InfoPath to capture performance metrics and assess leader's performance in projects engagement reviews to strengthen client executive relationships and track expectation fulfillment.
• Streamline 50+ users' demands through creating workflow process to leverage Jive collaboration, foster team synergy and increase work productivity. Provided research reports, requirements and designs to support Jive/SharePoint integration for knowledge management.
KaplanBusiness Analyst
Feb. 2011 - Dec. 2011Miami/Fort Lauderdale Area• Identified 100+ legacy systems (worth ~$5-15 million) eligible for retirement during Kaplan’s IT landscaping using Iteraplan for Enterprise IT Planning while working closely with CTO and CEA (Chief Enterprise Architect) • Governed annual board executive meet up to manage Kaplan’s long term vision (K2020) using Confluence CMS to sustain content updates, user control, content security and privacy. • Designed and owned Kaplan Web Engineering Business Requirements template standard to support Kaplan in effectively constructing future internal web applications
• Managed and closed 50+ issues in 3 sprints using JIRA for Kaplan Reference Learning Platform project to support Kaplan’s next generation of open source virtual classrooms using Moodle
• Deployed virtual installation of Red Hat Linux Enterprise 5 configured with Apache Tomcat 6 and MySQL 5.5 to host Kaplan Enterprise Architecture landscape prototype using Essential Manager Architecture and Protégé Ontology 3.4 as open source software
IntelInformation Technology Intern
Jul. 2010 - Oct. 2010Phoenix, Arizona Area• Enhanced VF Starts MES Lot Attribute web application (ASP, VBScripts, and JavaScript) through remote debugging to assist in efficiency as well as effectiveness in reports. • Reviewed and tested programming technicalities referring to VF Starts in Visual Basic 6. VF (Virtual Factory) Starts is a windows-based application to facilitate wafer starts scheduling and logical lot creation in high-volume manufacturing.
• Simplified parts and suppler management in die manufacturing through steering code analysis, debugging and reverse engineering. Eliminated hidden costs through correcting Vendor Mix percentage assignments to desired requests in scheduling, lot numbering, lot creation, silicon management, and lot tag printing on Virtual Factory Starts using Visio to fix process, and Visual Basic 6 along with Visual Studio to fix code functions.
• Reduced cost of support for access related incidents and tickets generation through organizing and maintaining traceability of entitlement mappings to help Production services team.
• Executed User Interface (UI) testing in Work Flow Data Staging to improve functionality, navigation fluidity and data input validation.
United NationsUMOJA Project ERP Intern
Jan. 2010 - Jul. 2010New York, New York• Identified 200+ legacy systems before SAP deployment through collaborating in developing UN Apps using Google Web Toolkit, Eclipse, Spring framework, Java Persistence API with Hibernate, Postgres SQL, and subversion techniques.
• Improved legacy systems reporting efficiency through initiating dashboard interface development using Google Visualization APIs
• Documented executive meetings on taxonomies and data governances of data warehouse designs for effective master data planning and logistics in departmental resources • Enhanced knowledge sharing through organizing business process documents using Alfresco
Intch is a Professional Networking App for the Future of WorkSee more people like Stephane on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
451129 people
18
Technologist, Project/Program Manager
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
69589 people
24
Data Scientist Intern @ Newell Brands
15
Data Analyst
24
Looking to transition into Tech./. Former sales Representative and have very good Communication skilss @ @NikeStore