SUMMARY

Senior Consulting position that utilizes my background in Business Intelligence, Data Analytics, Development, Automation, and Tableau

EXPERIENCE:

Technical Lead / Advanced Data Analytics

Confidential

Responsibilities:

• Assigned at Confidential on the Big Data team as a technical lead to implement data solutions and develop insights using Tableau
• Completed proof of concept, and production - ready solutions for Identity Access Management, Information Technology, and Information Security teams
• Developed executive level dashboards to highlight business expansion, service adoption, technical platforms and utilization, and business value
• Set up an Enterprise server-based solution to deliver automated dashboards using Cloudera Hadoop, Impala, SQL, and Tableau.
• Re-engineered existing dashboards/processes to meet best practice and provide solutions for specific use-cases
• Implemented performance solutions to produce responsive dashboards
• Recommended and implemented best-practices for dashboards and reporting
• Developed documentation and diagrams for process flows, user guides, implementation and security access, production installs, set-up and configuration, dashboard usage, data analytics and calculations

Sr. BI Consultant / Tableau SME

Confidential

Responsibilities:

• Tableau/BI Consultant and Architect across multiple teams (Virtual Channels Fraud, Virtual Channels Authentication, Fraud Prevention Services, Center of Excellence)
• Senior developer for Tableau Server/Desktop versions 9 and 10+
• Provided training and SME consultation for internal developers and users
• Primary ETL/Automation Developer for Confidential Virtual Channels Fraud Group responsible for transition existing reporting environment to Tableau
• Completed re-engineering projects that involved converting from a manual, Excel-based reporting system to fully automated processes using SAS, Teradata, Oracle, SQL, Unix, JavaScript, and Tableau;
• Database design and build, SQL and stored procedures, SAS programming, ETL, BI Reporting, job scheduling, full QA, data integration and backfill, requirements sessions, data aggregations/analytics, developing/publishing Tableau dashboards, security, training, and Tableau Administration
• Developed a variance/quality assurance dashboard to monitor the successful execution of all daily/weekly/monthly jobs, data loads, and variance to ensure smooth ongoing execution of jobs and consistent data integrity of ETL and reporting
• Developed SAS programs and optimized existing code to improve performance, ensure data accuracy, and provide Business Intelligence automation
• Assisted staff with advanced SQL, Tableau, and overall transition to automated BI
• Set up end to end architecture for fully automated ETL and BI processes
• Established best practices, naming convention, design patterns, prototypes, performance tuning, implemented consistency in design and efficient processes; developed and deployed full automation and scheduled processes
• Developed/Published new dashboards; Provided demos and user training
• Developed process flow diagrams and program documentation

Main Technologies used: Teradata, Oracle, SAS, Tableau 9 & 10, JavaScript, SQL, CRON, Ultra Edit, CRON, Windows Server and Unix environments

Business Intelligence Manager

Confidential

Responsibilities:

• Lead the Design and development of next generation data warehouse and reporting infrastructure
• Technical Project manager and Lead for Data Warehouse Systems Redesign project, SQL 2014 upgrade, ETL upgrades and enhancements, data integration efforts, and Business Intelligence efforts
• Developed plan and strategy for information architecture to integrate various systems at Confidential Foundation; Lead the overall strategy for data integration, business intelligence, and data analytics
• Developed web-based tools to facilitate tracking of students’ growth goals, college application submission process, college matching, attrition, counselor tools
• Managed and supported Tableau 9 Server Administration for the foundation (including upgrades, security, performance, configuration, publishing, backups, problem/resolution, user support, best practices); received gold star customer designation from Tableau for going above and beyond
• Developed/enhanced Tableau dashboards; created extracts, developed reports for survey, student test achievement, college counselor tools, set up interfaces to external vendor systems, scheduled data flows,
• Developed reporting and analytical tools using Tableau 9, SSRS, SSAS, SQL, SQL Server
• Primary liaison to Product Managers on Confidential Through College Research & Evaluation Teams
• Managed Data Warehouse Architect, Business Intelligence Reporting Engineer, and contractors
• Lead the technical development of platforms that enable Confidential to collect, store, and report data in order to facilitate data driven decision making
• Developed applications that allow schools to set academic goals and track academic growth
• Drove the data warehouse/database architecture design and development efforts for new systems and enhancements;
• Managed the development of upgrades, fixes, and enhancements to the existing data systems, infrastructure, and applications
• Provided technical oversight during the design and development of new applications and updates to existing applications to ensure successful project execution
• Provided technical leadership and guidance as teams explore opportunities to improve systems and processes.

.NET Web Developer

Confidential

Responsibilities:

• Developed corporate web applications using C#, Visual Studio, TFS, JQuery, JSON, JavaScript, SQL, AJAX;
• Enhanced and supported company intranet; developed web services, stored procedures, and tables; wrote queries and processes to pull data from various tables and data sources related to products, purchasing, stores, items, sales, marketing, and customer transactions; developed new classes, methods, services in C#.NET to facilitate new projects for marketing, operations, and finance
• Set up and configured Barracuda Web Application Firewall for load balancing, failover, security, URL translation, access prevention, login access, and handling of static files
• Completed a project to move all static files accessed from intranet web servers to central file server, modify related web pages, reconfigure web servers and integrate Barracuda firewall
• Completed an audit project to document company intranet web pages, usage, & content
• Completed a high-profile marketing project to send daily project alerts to customers; Duties included requirements meetings, designing/building a web based customer interface, pulling and analyzing the data, implementing daily extract and process, writing stored procedures, creating/consuming web services, Quality Assurance, installation, documentation
• Developed a web-based tool to monitor/troubleshoot handheld devices remotely. Features included: find devices for given store, display IPs, allow warm/cold boot, configure device remotely, ping device, and display status and details of devices
• Lead developer on an Agile team building business processes with IBM Business Process Management (BPM) tool; projects included store ordering application and customer wow alerts project

Sr. Data Integration Engineer

Confidential

Responsibilities:

• Responsible for all data integration for over 200 schools which involved creating processes to extract daily data from various schools information systems including Aeries, PowerSchool, Infinite Campus, and ESchoolPlus, and custom built systems
• Developed complex SQL scripts and queries to extract, cleanse, and combine data from a variety of sources and platforms including Oracle and SQL Server; Produced automated QA and data engineering processes to prepare school data to be used by a web-based tools
• Worked with clients to refine requirements and build custom data solutions used for tracking student attendance, behavior, grades, performance, test scores, and other metrics;
• Implemented new methods for daily ETL that greatly improved performance, scalability, consistency, and accuracy of data extraction.
• Incorporated new data flows and worked with engineering to improve existing products and enhance functionality
• Developed documentation, user instructions, methods, process flows, and data mappings • Worked with schools to assist them in implementing new processes, updates, and resolve data anomalies;
• Provided senior level support for data integration and extraction issues; assisted customer service and marketing manager to expedite and resolve daily technical issues and service new requirements.

Sr. Data Analytics Consultant

Confidential

Responsibilities:

• Analyzed, managed, and implemented high volume data acquisition projects in a large business marketing data warehouse using Teradata, SQL Server, and related tools; (supported BMG data warehouse group)
• Wrote detailed technical specifications for large ETL projects including instructions for databases, tables, stored procedures, data typing and naming, indexing, documentation
• Implemented key data projects including Intra-day ATM transactions, Voice of Customer merger survey, ATM hold decisions, customer negative address file, Good Decisions hold items/deposits, Enhanced Fraud Detection; provided technical analysis and instructions to department DBA, loaders, analysts, and staff
• Developed a full life-cycle web-based system to create and process technical specs for data acquisitions and metadata using Teradata, Visual Studio, C#.Net, and SQL Server;

V.P. - Sr. Applications Development Manager

Confidential

Responsibilities:

• Responsible for managing a team of applications developers and contractors
• Developed a continuous monitoring workflow system for the Independent Risk Monitoring group that facilitated monitoring plans, analysis and risks, identified risk trends, tracked key indicators, and tracking of audit issues.
• Developed an end-to-end web-based Credit Examination system to track all commercial borrowers for the bank, their loan obligations, related observations and risk; the system provided a valuable tracking/workflow tool for Credit Examiners and Analysts, providing calculations for ongoing ratios and rules. It also helped upper Credit Management to manage risk across lines of business, view productivity reports, comply with Basel II and SOX regulations, respond to key observations, and provide final exams to the Confidential
• Successfully re-engineered and rebuilt a major Risk Assessment Database for the audit department to address immediate security, design, and reporting issues; Developed and implemented new code in 3-4-week time frame to meet stringent deadlines;
• Developed and implemented many new systems for Compliance, Audit, and Credit teams including Regulatory Issuance, Compliance Issues Tracking, Time Reporting, Entities, Hierarchy Risk Tracking, Quarterly Group Head Reporting, CEO Forum Issues Reporting;
• Converted technical environment for audit department from Lotus Notes/Domino to Oracle, .NET web-based platform including DBA work, server set-up, design and programming; Maintained department SLA, successfully converted with no loss of data; Developed disaster recovery procedures, documentation, plans, and test scenarios;

Sr. Programming Consultant

Confidential

Responsibilities:

• Created a web-based General Ledger system for the Accounting department, converting a manual process to automated workflow resulting in substantial reduction of tasks and improved accuracy; included daily import, account balancing, and discrepancy reporting
• Re-engineered an Audit Management Information System, correcting various program deficiencies, data loss, and performance issues. Developed interface and consolidated code to be more concise, providing a clear, intuitive process.
• Provided senior level technical support for Lotus Notes/Domino, Java, and SQL issues