SUMMARY:

• Experienced IT and business analytics professional with a proven ability to deliver against core business needs with customer - focused strategies built upon effective “collaboration. Nimbly able to work across applications, languages and data types to deliver customer-driven solutions. Possessing a distinctive aptitude for leading cross-functional teams to achieve organizational goals and meet stringent deadlines.
• Project managementRelationship management People managementBusiness AnalysisCommunicationPresentationKnowledge SharingRequirement Gathering
• Microsoft Office Suite
• ExcelWordVisioPowerPointSharePoint
• T-SQL (7 years)
• SSRS (12 years)SSIS (5 years)SSAS (5 years)Power BI (3 years)Power Query
• Data Flux
• SASRPeopleSoft
• T-SQL (7 years)
• Power BI (3 years)
• Power Query
• GIMP
• Data Extracts (15 years)Data Architecture
• Data Lake
• Data Warehouse
• Star/Snowflake Development
• Cube
• Domain

PROFESSIONAL EXPERIENCE:

Confidential

Systems Engineer

Responsibilities:

• Partner with Business Analyst to understand reporting requests and independently deliver data in an intuitive and actionable format within the Microsoft Visual Studio suite, from SSRS tabular or matrix reports that drills down to a different granularity within the same report or link the report to a new solution such as Power Query.Augmented Microsoft SSRS templates, report parts, and style sheets using Visual Basic, XML/XAML and HTML that enabled faster turnaround of data requests, consistent messaging and definitions to front line workers and executive teams alike; as well as a branded portal that could be share with internal and external customers.Leveraged past work experience and to introduce new reporting concepts techniques and tools intended to increase the portfolio of reporting solutions out team could provide as well as give consumers alternative approaches to consume data and increased flexibility to self-serve their data with more confidence and better inform future requests.Created interactive data aggregation, manipulation and delivery using Microsoft SharePoint web parts and Power Query allowing requests to move through the development life cycle more quickly by speeding data discovery, requirement gathering, development, quality assurance, and ultimately, user acceptance using the same understanding and definitions of data at every phase.Outlined a security structure for report delivery that would increase flexibility and security by allowing customers to the same report but see only the data that was relevant and secure for them and introduce the concept of applying security at stable designations such as services provided or business process rather than more fluid attributes such as department or position and mapping that process to specific security categories such as personally identifiable information or sensitive corporate information.

Confidential

Senior Data Analyst

Responsibilities:

• Power BI was the spearhead to C.H. Robinson's self-service initiative. Analysts were charged with not only rewriting the underlying queries to the new Hadoop infrastructure; they were challenged to make the existing reports more performant but compelling and actionable as well. To that end, not only were new and custom visuals explored but pulling in sources from multiple locations, including API data, relational data, Excel and hand written figures to help contextualize data for the end use.
• Due to company priorities and IT’s adherence to its Waterfall approach, analysts were charged with writing procedures that more closely resembled application development rather than data collection. Builds would commonly contain temporary tables, with the familiar development routines of insert, update and delete the creation of functions, loops, etc.
• Evaluate potential resource constraints including; performance tuning, creation of cron jobs that initiated procedures, create auto generated “early warning” emails to alert when resources were spiking and needed monitoring and, potentially, killing long running queries or resource intensive procedures to stabilize the reporting server.
• Define, detail, and model, load balance pricing based on test data within the application's development environment. Ensure that application level data is correct as it is promoted up through production databases in the values it captures, as well as the structure required to deliver operational reporting and key performance indicators within the module to measure as well as relationships in place to connect to other sources structured in the data lake in OLTP (relational) as well as OLAP (analytical) structures.Identify performance opportunities as data moves from more traditional databases such as SQL Server to Hadoop. This wasn't exclusively a "literal translation" of each step from one source to the other, but a conceptual shift in approach as well to leverage Hadoop’s significant boost in processing ability as well as some of its limitations.Identify "quick wins", as well as larger projects that may not be worth the resource spend with new launches scheduled that would provide better results and make current development obsolete.Gain working knowledge of and utilize new tools for data aggregation, transformation and visualization, including R (and corresponding packages) Python as well as other modeling tools to support the company until a unified platform is in place.

Data Analyst

Responsibilities:

• Created custom procedures to automate the intake, segmentation and loading of multiple customer files.
• Architect and build specific modules to process customer’s unique needs and speed up real-time queries hitting the production database.
• Build custom queries using SQL Server’s metadata to support the launch and monitoring of newly launched procedures.Responsible for facilitating multiple launches concurrently. Each launch was its own project and included being in lock step with the IT Development team, Sales Representatives and direct customer interaction to gather and clarify requirements, and assuring each phase was adhering to a very aggressive launch date.
• Created custom procedures to automate the intake, segmentation and loading of multiple customer files.
• Build custom queries to support the launch and monitoring of new site.Create custom visualizations within the web interface that demonstrate to the clients the participation and usage of their specific clients. These include both line item reporting and graphical.

Confidential

Senior Business Data Analyst

Responsibilities:

• Partnered with the finance teams (business and systems) to gather requirements enabling the sun-setting of current general ledger reporting and built an interactive and intuitive Tableau solution.Created a product quality dashboard that allowed the production teams to work with vendors and quickly target specific areas of concern and trend solutions over time. This included remodeling the existing data architecture to support visualization and drill down capabilities.Redefined the business description of "scrap" material as it related to medical device production to be stored in the Data Warehouse as well as made guidelines on current capabilities of system generated data and recommendation to production and system design to improve future capabilities.Worked with third party data and internal sales and marketing team to develop algorithms that targeted areas of opportunity and underserved markets for directors of sale down to individual sales agents. Created a visual map, using Tableau, to quickly recognize areas of focus and return on investment.

Confidential

Wells Fargo - Business Data Analyst

Responsibilities:

• Leverage Teradata platform to help business partners articulate and document data needs. This role requires an independent work style, the ability to quickly analyze and understand new data sources and results. Worked with third party data and internal sales and marketing team to develop algorithms.Create Business Requirements Documents in quick paced environment while understanding business needs as well as the appropriate documentation content and style required for auditing.Take on additional assignments with the ability to independently contact and form a rapport with technical and business partners alike.Gain consensus on documents provided allowing dependent downstream partners to remain on schedule.

Confidential

Senior Data Analyst

Responsibilities:

• Facilitate predictive analytics models by leveraging flexible coding to accommodate multiple data in disparate style formats, source intake processes and field comprehensiveness. Strong business analytics and acumen were required to navigate complex data and data constraints.Standardize, note, and document code to ease transition of programming to multiple developers for each additional refresh. Process improvements have reduced refresh complexity by an estimated 25%. Collaborate with a larger team to ensure the overall project is delivered on time and staged in a consistent and intuitive format. Success required positive interaction with stakeholders/customers, gathering requirements through interviews and existing system documentation or procedures and defining business processes.Migrate and convert data from multiple sources into a consolidated configuration that delivers integrated data in a meaningful and actionable format while operating within client and third party deadlines.

Confidential

Senior Data Analyst

Responsibilities:

• Create reporting solutions that drive deeper insights into analytical and operational processes. Noteworthy s include ground-up build out of customer-facing report that mapped specific, dynamic account data in a digestible and aesthetic document.Manage project resourcing, timelines and communication from business analysis, project management to technical delivery. Success required operating autonomously but tracking to larger initiative expectations and timelines. Key s include drafting a data dictionary spanning multiple data sources and upgrades.Maximize agile operating environment by creating tables and views to support fast, consistent report development that eases complexity for junior developers.Pivotal to implementation of self-service initiative focused on tabular modelling and delivery via PowerPivot.
• Represented multiple data team’s perspectives on the School Policy Review and Implementation initiative where I spoke to opportunities for tracking and monitoring opportunities as well as implications new policies may have on data
• Provided business analytic support to drive optimized process and problem resolution for highly customized applications in an environment with rapidly evolving business needs.
• Managed special initiatives including launching and support of a management reporting hub for leadership to track business critical metrics leveraging disparate report delivery tools.Supported the larger analytics community by automating ad-hoc requests, building Entity Relationship Diagrams, and pro-actively demonstrating best-use cases to drive innovation.Designed and implemented a security model for sensitive data and report delivery.
• Worked with business sponsors to accurately assess problems and quickly generate business requirements and transform them into innovative, technical solutions.Crafted business plans and project initiatives and executed by effectively managing project teams through all phases of the development lifecycle.
• Leveraged data-driven, customer-focused approach to strategize and manage projects. Key initiatives included building an in-house University Library and representing critical stakeholder groups through PeopleSoft launch.
• Delivered against cross-functional team projects with leadership, insights and acumen. Key projects included system-capabilities based solutions for Tier 2 team reporting.
• Delivered against aggressive growth goals by qualifying prospects, investigating and uncovering career and learning objectives, and presenting customized solutions to meet the overall long-term goals of the prospective student.Leveraged company reports and systems to effectively forecast enrollment goals and report to the Management team