SUMMARY:

Senior software development professional who possesses strong data analysis, data visualization, written communication, and oral presentation skills. A trusted team leader with significant experience serving on enterprise information technology steering committees. Successful track record implementing high - quality, timely, scalable, and cost-effective software solutions through strong partnering with clients, stakeholders, users, direct reports, peers, and executive leadership.

TECHNICAL SKILLS:

Programming Languages: Expert: Visual Basic for Applications (VBA), MS Access, and MS Excel, Python and R

Relational Database Management Systems: Expert: MS Access SQL

Extract, Transform, and Load (ETL) Tools: MS Access SQL, VBA

Data Visualization Tools: MS Excel, Tableau and MS Power BI

Data Modeling Tools: MS Visio Professional 2016, MS Visual Studio 2017, and Lucidchart

Project, Program, Portfolio Management, and Agile Tools: VSTS, Jira 6.4 and Confluence, Clarity PPM

EXPERIENCE:

Confidential

SQL Data Analyst, Power BI Developer

Responsibilities:

• Designed and implemented a prototype SQL Server DB, SSIS, and Power BI solution to report descriptive statistics of telemetry usage data for client’s SaaS cloud platform.
• Prototype’s source systems included an on-prem SQL Server database housing Salesforce CRM data and an Azure SQL Server database storing client’s SaaS cloud platform telemetry usage data.
• Prior to design and implementation, conducted requirements analysis, data analysis, and data modeling.
• Documented a visual-rich design specification and operations guide.

Confidential

Sr. Technical Project Manager, Business Intelligence

Responsibilities:

• Served as primary contact for external clients representing a wide variety of industries.
• Managed multiple concurrent projects for multiple clients.
• Created VSTS user stories using INVEST model and led user story estimation efforts.
• Led daily standup meetings.
• Created and published detail project schedules and project status reports including budget burndown.

Confidential

Sr. Technical Project Manager

Responsibilities:

• Served as lead Confidential -SQL data analyst responsible for controlled-comparative experiment analysis to assist client with assessing the efficacy of various forms of marketing campaigns.
• Designed, developed, and implemented a descriptive statistics Power BI dashboard (employing Confidential -SQL queries and views and multiple DAX formulas) for use by primary client to monitor the marketing automation ETL solution.

Confidential

Sr. Technical Project Manager

Responsibilities:

• Teamed with client Product Owner to build Product Backlog.
• Managed Scrum Backlog during multiple two-week sprints.
• Created Jira user stories using INVEST model and led user story estimation efforts.
• Built an automated Jira-Excel-VBA status report tool with embedded Burn-Down and Cumulative Flow charts.
• Served as data analyst responsible for analyzing legacy application SQL Server DB logs to identify key process bottlenecks.

Confidential

Manager, Program and Project Management

Responsibilities:

• Served on VP’s Steering Committee responsible for technical solutions delivery for all back office systems.
• Coached and mentored team members supporting Confidential ’s evolving SDLC including Waterfall and Agile, using Jira.
• Led team to continually meet Confidential ’s UnCarrier program responsible for revolutionizing the 30-year-old wireless services model through, among other key initiatives, eliminating two-year contracts and their associated Smartphone subsidies.
• Partnered with IT Leadership to translate customer program roadmaps into short-term and mid-term projects solutions roadmaps.
• Served as a Clarity PPM subject matter expert in resource utilization, capacity planning, and project and program estimating.
• Led effort to design, build, and implement Confidential ’s first-ever standalone Clarity PPM analytics and reporting solution utilizing WSDL interfaces, SSIS, SQL Server DB, and Tableau. Result: Executive leadership gained ability to view daily current and historical project budget and schedule health statuses for 300+ projects spanning a period of greater than two years.
• Designed and built team’s Access/Outlook/VBA/SharePoint/SQL Server project status reporting tool.
• Designed and built team’s Access/Excel/VBA/SharePoint/SQL Server resource utilization and capacity planning tool.

Confidential

Manager, Resource and Release Capacity Planning

Responsibilities:

• Served on IT Governance team to define, document, and implement standard enterprise processes involving SDLC, release planning, resource utilization, and resource capacity planning.
• Led effort, involving all enterprise back office Resource Managers during annual and quarterly software release planning efforts, to analyze resource utilization and capacity reports in order to mitigate potential capacity constraints.
• Designed and built a MS Access/VBA/SQL tool to extract, transform, load, and process hundreds of Excel project estimates from all back-office teams. Analysts used the tool to publish resource capacity reports for use by IT Steering Committee for software release and resource capacity planning. Result: increased conformance, across all back-office teams, with project estimating process. A significant reduction in project estimates data errors. Reduction in time to accurately generate and publish resource capacity planning reports.

Confidential

Manager, Software Development, Business Intelligence

Development environment: MS SQL Server and Oracle databases, Teradata, Informatica, SSIS, and SSAS.

Responsibilities:

• Led team responsible for production of, to publicly-held parent company Deutsche Telekom, monthly and quarterly subscriber activity reports used for government-mandated quarterly financials.
• Developed and published technical BI project plans and schedules for use by enterprise project managers.
• Served on BI customer-facing leadership team to define and prioritize near-term and long-term customer roadmap solutions.
• Led effort to train enterprise project managers on use of BI team’s standard SDLC. Effort resulted in greater accuracy in deriving enterprise-level project plans and schedules and improvements in enterprise software release planning.
• Led Dev team effort, using ITIL framework, to provide Ops team with enhanced knowledge transfer for new BI solutions. Effort resulted in improvements in Ops team’s production defects troubleshooting and a reduction in escalations of said defects to Dev team.

Confidential

Manager, Software Development

Development environment: Openet Telecom’s FusionWorks product, C/C++, Java, Perl, JSP, JavaScript, HTML, Oracle and MySQL DBs, Unix Sun and HP-UX Operating Systems, HP and Sun hardware, and Tomcat, Apache, and Netscape Enterprise Web servers.

Responsibilities:

• Developed and published detailed technical project plans and schedules for use by enterprise project managers.
• Teamed with customers to continually improve our customer-supplier relationship.
• Analyzed new projects and assisted Architecture team with formulating high-level solution designs and cost estimates.
• Led development team’s effort to improve billing timeliness. Within the first 30 days of new assignment, daily processing times were reduced from an average of 70 hours to 9 hours.
• Led development team’s effort to improve timeliness of solving subscriber and revenue-impacting production issues. Within the first 30 days of new assignment, 75% of open trouble tickets were satisfactorily resolved and closed.