Business Analyst Senior

Uday Vyawahare

**** ********* *****, ******, ** *4568

**************@*****.*** 510-***-**** Mobile

https://www.linkedin.com/in/udayvyawahare/

Summary of Qualifications

Business and Technology leader with abilities to manage and market a service or product through its lifecycle – planning, analysis, design, project management and implementation phases in both mainframe and client server and cloud technologies with strong development and technical project management skills.

Technical Expertise

Databases

Oracle, Sql Server, MySql, DB2

DB Tools

SSMS, SQL*PLUS, SQL*LOADER, TOAD

Programming

SQL, PL/SQL, Unix Shell Scripting, HTML, Cold Fusion, COBOL, JCL

ETL, Data Modeling Tools

SSRS, SSIS, Datastage, Erwin, Db Schema (open source)

OS

Windows, iOS, MVS, Unix, Linux

Tools

Oracle Grid Control, Golden Gate, MS Office, Visio, Team Site Content Manager, RequisitePro, Jira, Rally, Jenkins, Confluence, ActiveCollab

NoSql, Big Data and Cloud

Python, Mongodb, Cassandra, Hadoop, Spark, Azure, AWS

Reporting/Dashboard Tools

SSRS, iDashboards, Tableau, Power BI, Jira Eazy BI (Atlassian)

PM Tool

PMP - Agile AT&T Internal Certification 2012

Certificates

CSPO 2019

Professional Experience

Senior Business Data Analyst – PG&E June 2021 - Present

Partnered with internal and external stakeholder, design, adoption, training, testing and supported cloud collaboration technologies to release high quality product. Instrumental in process improvements to align production tasks as Jira stories and created Desk Level Procedures. Improved and managed team communications effectively using MS Teams and integrated Jira Server to help team manage operational tasks. Produced Quarterly Business Reports for executive leadership. Used Excel, Power Bi, Jira Eazy BI tools to create dashboards and created Power point presentations helped to show progress to align with Business goals.

Senior Technical Business Analyst (Consultant) – Kaiser Permanente August 2020 – June 2021

In support of National Pricing System responsible to drive functional business requirements by partnering internal and external stakeholder, design, adoption, training, testing and supported cloud collaboration technologies to release high quality product. Instrumental in process improvements to align production tasks as Jira stories and created Desk Level Procedures. Improved and managed team communications effectively using MS Teams and integrated Jira Server to help team manage operational tasks. Produced Quarterly Business Reports for executive leadership. Used Excel, Power Bi, Jira Eazy BI tools to create dashboards and created Power point presentations helped to show progress to align with Business goals.

Senior Business Analyst (Consultant) – Delta Dental Insurance Jan 2020 – August 2020

Collaborated with multiple stakeholders like Desktop Engineering, Architecture, Security, HR for enterprise release of Microsoft 365 Office Cloud Products in creating business requirements, Gap Analysis and mitigating and removing Risks, document user stories and conducting UAT. Created Analytics Power BI usage reports, conducted user training sessions, process improvements and mentored junior business analyst.

Business Intelligence Specialist – 1stUnited Credit Union Jan 2019 – Aug 2019

Developer and Architect for Banks dataware house using SQL Server 2012, SSMS, SSRS, SSIS, iDashboard, MS Visual Studio. Worked extensively with multiple internal departments like Finance, Marketing, Branch Operations, Compliance and Risk for their reporting and analysis. Worked with external vendors like Darling Consulting Group, Boston, United States to create enhanced member data pipe line on to their analytical engines to drive up-sale of member deposits into creating more

certificates deposit offerings and retain customers with high balance.

Technology Solutions Manager – Wellwrap, Inc Jan 2018 – Dec 2018

Created Dashboard products required by the Customer Care. Product Data modeling and analysis for the campaign metrics to determine the effectiveness of campaign strategy. Process documentation using confluence. Wore multiple hats even doing Business development and raising capital, reaching out to VC’s, WebPT sales, seeking out marketing opportunities, presenting the product with CEO to possible VC to attract funding, Hosting Tech Meetups.

Senior Business Analyst – Kaiser Nov 2017 – Nov 2018

●PeopleTools - Component Interface, Process Scheduler, PS Query and Data Mover.

●Worked as Sr. Business Analyst on PS (ver 9.2) for Benefit Admin support team at Kaiser Permanente. Provided application support for the Employee Benefits. Created solutions by reviewing and analyzing existing systems and processes. Defined functional business requirements and translated them solution design and CIs for updates to the system. Conducted gap analysis to document discrepancies between business requirements and system capabilities. Developed project tasks plans and ensured time line adherence. Resolved tickets, validated interfaces, and coordinated and conducted System Test and UAT. Benefit plan cleanup for cloud transformation project. Served as the liaison between the Benefit administrators and the KPIT organization.

Data Consultant - Veristorm Jan 2016 – Oct 2017

Data conversions from mainframe technologies like DB2/VSAM/COBOL into big data platforms like Hadoop and MongoDB. VSAM and DB2 file are extracted into Linux targets without staging and all data conversions are dynamically performed. Created Tableau reports.

AT&T, Inc., San Ramon, CA Nov 2008 - Dec 2015

Senior Operations DBA

Lead for designing and supporting Business Process Management and middleware common services Oracle databases and it’s functionalities for enabling Mobility, B2B services for clients like Best Buy, Apple and Walmart. Consultation to engineering teams regarding all DB design usage. Managing development, quality, performance and production environments, 24x7 support and monitoring with onsite and offshore model.

Responsibilities:

●Manage and mentor team of 5 onsite and offshore DBAs.

●Manage 50 plus database instances across multiple business critical applications.

●Dashboard DB Design - It keeps API transactional summary, 50TB data, of API usage for statistics and audit analysis.

●Oracle Dashboard DB (DWH) Migration to Cassandra.

●DB Migration Unix to Linux and upgrade to Oracle 11g.

●Automation of Tibco Database Kit deployments using open source Jenkins and shell scripting.

●PLSQL-DDL-DML Development for maintenance and enhancements projects in both Agile and Waterfall methodology. Shell Scripts and CRON setup of database refresh.

●Data cleansing and mining for creating db schema to enable audit reporting for API usage data.

●Data modeling, Logical and Physical database design. Capacity Planning.

●Performance Tuning of Instances and SQL optimization for fast processing inserts in OLTP.

●Database Refresh in Performance and Dev-QC-Test-UAT environments and Load testing during iPhone launches.

●DB Backup, Restore, Replication Strategies in high availability solutions using Golden Gate Oracle.

AT&T, Inc., San Ramon, CA Mar 2005 - Nov 2008

Senior Database Architect

Enterprise Database Modeling & Design for AT&T Online - Sales & Ordering website featuring products such as Uverse, Telco, Wireless, Broadband, Local and Long distance for consumer and business markets including retail partners like Apple, Yahoo, Best Buys, Microsoft, Comp USA and Walmart. Provided technical consultation and product model knowledge to product marketing managers, developers, user experience and metrics teams. Manage dev/test/stage/prod database environments. Presentations of database Model to leadership and internal business customers.

●Enterprise Data Modeling based on requirements gathered from multiple stake holders for new and existing products its features, content and pricing.

●Master Data Management of all products and its pricing.

●Converting Unix batch process to converge on a single new server using free GPG encryption software eliminating yearly licensing cost and improving availability by 50% for Greenlist batch job.

●Designed Rapid Deployment – Increased RD delivery every year. RDs allow for quicker delivery of crucial marketing promotions, campaigns and competitive introduction of new products, price changes and content management.

●Dev Lead on major release. Managing projects and its estimation and prioritization. Allocation of work to onshore and offshore contractors and tracking progress till implementation.

AT&T, Inc., San Ramon, CA Jan 2001 – Feb 2005

Lead Analyst

Lead in Exchange Master File Development and Bill Test team for enterprise billing system. Designed, developed and tested numerous IT wide mainframe technology projects.

●Lead in Bill Test team enabling End-To-End Testing for Mid West launch of Enterprise Bill Format enabled successful and timely implementation in short time so as to help comply with federal regulations and achieve company mission goals in M&A activities.

●SBC Moves ADESP (Automatic Directory Extraction and Scheduling Process) to the Web: Lead in Requirements, Design, Development, Testing and Implementation of Listing Services upgrade from second generation software (Cobol, C-List, JCL) to a web-based system. ADESP directory extraction automation using current technologies, Cold Fusion and Oracle, dramatically decreased system failures enabled reporting delivery via email and reduced enterprise expenses. In all company is saving $1.3 million every year on book extraction and repository for enterprise customer listing information. The process supports all listing products phone books, 411/DA, Street Address Directory and Directory publishing. The new process enabled online ordering and scheduling for numerous CLEC clients and helped company complying with regulatory board to get into long distance market.

Lead Quality Analyst/Consultant (1999 – 2000), VISA, CA

●Mainframe technology projects.

Lead Developer/Consultant (1997 - 1999), Pacific Bell, CA

●Mainframe technology projects.

EDUCATION

Master of Business Administration, General Business and Commerce, University of Phoenix, San Jose

Bachelor of Engineering in Computer Science, India

Contact this candidate