Bharath Ummaneni

Email: adhjfv@r.postjobfree.com

Phone: 604-***-****

Burnaby, BC

Summary

** ***** ** ********** ** Information Technology in various domains (Tele communications, Insurance, Transportation & logistics, Finance, Healthcare)

Proactively built and managed relationships at all levels within client Organization (Finance -strategic, at-risk units, Business operational units) and to achieve overall satisfaction.

Extensive experience in Process Optimizations, Gap Analysis, ETL Process, & Bi Reporting

Experienced in developing Application Automation requirements for various Business groups (Sales, Operations, Procurement, Implementation, Admin Support) in the value chain

Experienced working in Large Enterprise Programs, deliverable includes, Impact assessments, Cost-benefit Tracking & Measurement, E2E Process development, Resource & Capacity planning, etc.

Experienced in business intelligence (BI), data warehouse (DWH), data analytics migration from legacy to vendor applications, data conversion, business operational reporting consulting projects.

Experienced in drafting Data models, Dimensional modelling (Normalization, de-normalizing tables), OLTP/OLAP, RDBMS, Identifying Business Objects, elements, & Attributes

Experience with relational and dimensional data modeling, star schema, and snowflakes schema and fact constellations

Worked in data integration project stream in providing data from various sources, such as, application data, reporting data, data from customer facing tools for further analysis

Excellent writing skills in documenting RFP's, Business Scope, Business Requirement & Functional Specification documentation, Product Training and Procedural documentation, Customer facing documentation, etc.

Experienced working with various technical stakeholders (Business System Analyst, Data Architect, Data Artist, Data Scientist, Subject Matter experts (SMEs), and Technical resources)

Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specification (FSD), Non-functional Requirements, Use Cases & UAT Test case scenarios

Experienced working with Multiple Business units in developing Business Cross Functional Process models, As Is-To Be, People Vs system, Swim lane diagrams.

TECHNICAL SKILLS SUMMARY

Methodologies

Agile, Waterfall, Customer Custom build models

Project/Requirement Management Tools

Jira, Caliber, and other 3rd party /In-house tools, Microsoft Project

Business Applications

Order processing, Service Provisioning/Fulfillment, Support/Service Assurance, Salesforce, Sibel, Oracle BRM, Service Now, Dynamics 365

Telecom expertise

Network Infrastructure, MPLS WAN/Wifi networks, Network & security devices, physical and logical device inventory management, PBXs, PSTN connectivity’s, deployment topologies & failover methods, GENBAND/CISCO switches, Network self-serv cloud platforms,

Project Implementation expertise

ERP Implementations, COTS implementations, Systems/Data Integration requirements, Application enhancements, IFRS, Finance & Operations Reports, Data warehouse/ETL, ISO certifications, web application development

Development Tools

Visual Studio 2003, 2005, 2008, 2010, 2013, 2015, 2017, Toad, SQL

Analytics Tools

Tableau, Power Bi, OBIEE, MS SSRS,

ETL tools

Informatica, MS SSIS, Data modelling – ERWIN

RPA tools

MS Power automate, UI Path, Blue prism

Platforms

Windows

Developer Technologies

Experience working with developers with following technologies (ASP.NET, WPF, ASP.NET MVC3 to 5, .NET Framework 2.0 to 4.6, .Net Core, ADO.NE, Programming languages – C#, PL/SQL, VB, Java, web technologies – JavaScript, Jquery, Jquery UI, Bootstrap CSS, HTML5, Ajax

Design Patterns

SOA, OO Design, Database Design (RDBMS)

Databases

Oracle 9i, 10g & 11g, SQL Server 2017, Cassandra

BA Tools

Excel, MS Visio, Word, MS Access, SQL

2.0 Professional Experience

Presently working on Microsoft Power Apps, Dynamics 365 certifications, Informatica certification

2.1 Freelance Technical proposal writer

Project/Products: ETL/Data warehouse, Robotic process Automation (RPA), Web Application Development & and service level-Maintenance projects

Responsibilities:

Developed Project proposals, SOW, RFP/RFQ/RFIs for multiple vendors

Developed Dynamics 365 Integration requirements, client business & functional specifications for Qualteck solutions

Prepared detailed Q&A Fact sheet for Dynamics 365 licensing requirements for internal & external users

Developed project proposal to automate manual processes using Microsoft Flow/Power Automate UI Flows for both modern and legacy applications.

Developed RFP for Data warehouse ETL & Analytics projects with hi-level architecture roadmaps

Developed RFPs for application modernization projects using vendor provided technology stack

Prepared functional specifications for ETL/Data warehouse projects using Informatica, MS SSIS tool

Prepared project proposals with functional specifications for web application enhancements, new feature development, & service level maintenance work.

Drafted systems, applications, Infrastructure architectural diagrams per vendor requests

Developed Business requirements for customers in building Canvas and Model-Driven apps in MS Power Apps.

TELUS – Contractor

2.2 Contractor– BI Analyst November 2018 to May 2019

Project: Optimize Business Applications - Cloud Collaboration Hosted Service, Business Connect

(internet broadband service)

Products- Cloud Collaboration, Business Connect, SD-WAN Network, Network as a service, Mpaas, etc

Responsibilities:

Implemented centralized reporting through Process optimization approach to have an early visibility on Contracts and to procure maximum discounts from the vendors (Avaya/Cisco/Tech Data/Ingram)

Created several SSIS/mappings/sessions/workflows to load data.

Build ETL solutions to source data from Sales Force (SFDC), Oracle, Internal MS Access systems and Spreadsheets.

Developed Reports/Dashboards with key measures on Product revenue by territory and Market segments (Public/Private/Enterprise/Mid-market) on monthly basis using Power BI

Utilized Power Pivot functions, such as, Data view & Relationship view in creating new Tables, Columns, and utilized DAX syntax to perform calculations at column level, and created Measures in Dashboard visualizations

Participated in automating reporting functionality using Power BI and consolidated bi-weekly vendor client procurement reports

Performed Data Preparation steps in Query editor in cleaning, categorizing, structuring, and transforming the data to the Data Model

Defined Metrics (KPI’s) on Data Impacting Functional areas, grouped the data by Aggregation & Calculated fields, by Transaction & Data volumes for reporting & dashboarding purpose

Extracted data from various sources, created connections to major sources (SQL server analysis service database, Azure Analysis services, Azure sql, on-premise etc ) to export & develop reports/visualizations in Power Bi

Applied Data Transformations in Power BI, such as, creating Reference queries, creating conditional columns, Append queries, Group by, Pivot/Un-Pivot, Null checks, Try function, Split by delimiter, Extract characters, Replace Values, Fill down Transformation, etc

Created new schemas with multi-dimensions/facts in Power BI to produce complex reports/dashboards

Consolidated Data from various (Sales, Order quoting/processing, CSEs, Design Engineers, Provisioning/Fulfillment and generated reports to the respective business units

Environment: Microsoft SSIS,SSRS, Informatica PowerCenter 10,1/9.1,SQL Server Teradata DB, Oracle,IBM Mainframe, Zena, AppDynamics,Hadoop, MapReduce,HDFS,Hive,Impala

EV Custom Systems (Personal project)

2.3 BI Analyst/Product Owner

April 2018 to Current

Project: CCD (Custom Component Design) Application - Design Evaluation Tool

Responsibilities:

Developed Use Cases for 25+ Functionalities with Actors, Scenarios, end goal of each use case

Applied Business Object oriented model/Dimensional modeling, in defining Entity relationships, Business Class model, Conceptual data model

Created Business Objects and Classes using Visual Studio Code in preparation of logical/physical Data model

Developed EVC Process definition for Angel investors, Sales/Pre-qualification teams -BMZ, developers to provide an end to end vision/goal in implementing the EVC custom design service

Developed Wire Frames for EV Custom Application UI (UI is mainly used by design engineers for creating ‘Request for Quotations’ to Manufacturers/Assemblers and other design engineers in EV component sector), providing a clear vision for developers

Applied DevOps framework and currently in the development of Prototype for Pack Assemblers/Manufacturers

Manitoba Public Insurance – Contractor

2.4 Bi Reporting/ETL Analyst

Sep 2017 to November 2017

Project – Security Score Remediation – ISO 27002:2013

Responsibilities:

Developed Dashboards for IT communications director with Power BI - PowerPivot & Power Query tools for Network, Infrastructure, & database Metrics

Taking ownership of data related problems. Assisting with database design, data model decisions, expert advice on SQL optimization, Database performance issues.

ETL Solution Design, develop using Informatica 9x, SSIS VS14.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPI’s

Performed Data Mapping Tasks from Source to Target data structures and applied transformation rules for mis-represented data

Performed Predictive analytics and Created Reports/Data Visualizations with various mapping tools, techniques for current MPIs Network & Infrastructure Capacity & Performance, Availability, Trending & Utilization Metrics

Utilized Power Pivot functions, such as, Data view & Relationship view in creating new Tables, Columns, and utilized DAX syntax to perform calculations at column level, and created Measures for the visualizations

Worked with Communications director in preparation of Resource Metrics with Trending & Utilization scenarios

Developed a framework to provide those metrics reports with a centralized reporting perspective

Generated Ad-hoc reports in Excel Power Pivot and Sheared them using Power BI to the decision makers for strategic planning

SaskTel - Contractor

Project 2.5 ETL Analyst

Jan 2016 to May 2017

Project: ETL Enterprise Program

Responsibilities:

Worked as a Business Analyst in defining business processes for Max Everywhere, Max Media First, VOD (Video on Demand) Store products for the existing legacy applications

Modified SSIS ETL packages, SSAS cubes and SSRS reports, Business Objects Deski and Webi Reports to handle the Change requests or fix the issues or performance issues. Created SAP Business Object Universes and generated Webi reports, dashboards from it.

Provided support to develop the Enterprise data warehouse architecture and plan the ETL process.

Followed Ralph Kimball approach Confirmed dimensions, Bottom up Data warehouse Methodology in which individual data marts provides views into organizational data.

Defined Business Objects during the design phase of conceptual and logical data models

Applied analytical skills in support of Data conversion to the new environment

Worked with architects, Tech leads and Vendors in preparing detailed level requirements, which includes, systems impact, Process impacts, and traced them to Ericsson's Technical requirements

Created CR's for SaskTel business functional areas to accommodate Ericsson's Technical requirements

Develop ETL mappings/sessions/workflows (Power Centre), (Power Exchange) to load multiple applications in Semantic Layers in Oracle11g, Sql server 2008 database, SAP BW.

Project: Inventory Management system (Optius & ODiN) Implementation. Enterprise Program

Created Power BI visualization of Dashboards & Scorecards (KPI) for Business operations/ Finance teams

Generated custom reports using Microsoft Power BI and for Hyperion Reports

Implemented Power BI gateway to collaborate and share from different sources to matching analysis criteria, and for further modelling through power pivot and power view

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPI’s

Developed Power BI reports and Dashboards from Multiple data sources using Data blending

Utilized Power query in Power BI to pivot and un-pivot the data model for data profiling and data cleansing

Collaborated with data architects for data model management & version control team ensure data warehouse and data mart designs efficiently support BI end users

Worked in Batch & Report stream in gathering Reporting requirements for multiple SaskTel organizations.

Collected Data, storage & distribution information of Business reports and validated those requirements with the new environment

Worked in Data conversion stream in preparing DATA RACI mapping document from Source to Target tables

Worked with business in creating Business Requirements, Change Requests for Inventory Management system

Worked with business stakeholders, Architect, Tech lead in gathering detail technical requirements for Batch programs, Modules, Reports and developed desired state for those Programs and modules

Technologies Used: Oracle 11g, Informatica 8x, 9x, PowerExchange, SAP Business Objects 4.0, SSIS, SSRS, SSAS, Pl/sql, Sql, Oracle 8, T-SQL, SAP BW, Shell scripting, C, Pro*C.

SHAW communications – Contractor

Project 2.6 Data/ETL Analyst

Dec 2014 to April 2015

Project: Callidus Cloud (Compensation/Commissions - COTS implementation)

Responsibilities:

Optimized the performance of the mappings by various bottlenecks in source/target and mappings

Performed Unit test mappings/sessions/workflows and assisted in SIT/UAT

Created Functional and Technical specifications with source to target mappings

Developed processes (Employee life cycle management, Commissions life cycle Management, Dispute Management)

Worked with NetCarcker team for Order Entry/Order Management, CallidusCloud team

Applied technical skills using Power BI and SQL in data collection & analysis, and to procure data from various sources to report and provide solutions to client requests

Developed Business Object oriented model in developing entity relationships as a foundation for Conceptual & logical data models

Utilized DAX syntax in creating relationship between the tables, categorizing the data, creating measures and calculated columns in preparation to a data model

Utilized Query Editor in cleaning the data, and to Load the data into a data model to prepare reports & Dashboards

Used SharePoint for creating and managing documents for Projects as a central document repository tool. Created folders, titles for new initiatives and saved document in the respective folders

Created Achieves and saved all the previous material in the respective folder

TELUS - Contractor

Project 2.7 – Data/Business Analyst

July 2013 to June 2014

Project: IP/SIP Trunking, Voice & Data Services

Responsibilities:

Provided Defect-free delivery of applications and promoted from Development to Quality Assurance and Quality Assurance to Production environments.

Managed ETL Support team - resolved incidents/ requests for multiple Informatica applications and developed new components of the ETL process using Informatica PowerCenter 9.1.0

Provided 24x7 on-call Production support for critical business applications.

Managed unplanned and planned outages to Data repository with a focus on minimising business impact.

Perfomed routine daily, weekly and monthly sustainment activities like generating statistical reports for business users.

Worked on Enhancements to Very Complex Applications and modified the code to accomodate new business requirements.

Designed, developed Real time ETLs to process data in near real time.

Prepared Requirement Traceability Report, to ensure each BR has an associated FR solution. Classified requirements as Process, System, Network, Technical, Procedures & documentation and facilitated sessions with individual groups to task and to draft the FR solution for all the BRs

Worked with Product Management team in preparing, Product Training and procedural documentation, Service agreements, Customer Communication and Welcome letters

Worked with Product Managers, Sr. solution Architects in preparing project scope document incorporating platform changes, additional features the new platform is offering, Network architectural components, Market Forecast

Prepared hi-level test case preparation documents, provided information from the wireframes/screen shots, use cases in preparation for UAT testing and written Test case scenarios

Worked with Oracle BRM (Billing revenue management system), NetCarcker vendor teams in capturing technical requirements

H&R Block – Contractor

Role: Application Support/BI Report Analyst

April 2011 to April 2012

Project 2.8 Business Process and Support Analyst

Project: CIS (Client interaction system), DTMax (Tax software) and TRD (Tax ReturnDistribution)

Responsibilities:

Worked with the Technical team (DBA's, Developers) in solving data related issues, bugs and verified solution meets the requirement specification/design documents

Worked with Sr. Solution Architect in defining conceptual, Logical and Physical data models

Analyzed requirement documents, systems, related use cases and documented the Business objects, entities and their descriptions for the data model design

Documented Business elements & attributes and coordinated with data modeling team in designing the Dimensional modeling for Star/snowflake schemas, familiar with Normalization and de-normalization concepts

Used Ervin tool to draft Dimensional data model and Entity relationship diagrams

Clear Channel communications

Project 2.9 SMB Manager

Jan 2010 to Feb 2011

Responsibilities:

Responsible for Sales and Managing Business Accounts.

Served as a process analyst between distribution center, purchasing, inventory management and logistic departments to draft current work flows of product through the supply chain

Drafted semi-quarterly, quarterly, half-yearly, inventory processes for logistics/distributions centers

Interacted with Business owners to identify their Telecom needs and generated Business Leads.

Worked with business owners, interacted with business operational departments (sourcing specialists, client, admin, field representatives, online advertising agents, Ad specialists) and developed Ad Matrix (forecasting modules) for the future generation of Business reports which are helpful in taking business decisions.

CITCS - Client Partner

Project 2.10

Jan 2007 to Nov 2009

Project: Reservation System Project( P140S Owner Requirements)

& Data warehouse/Migration Project

Responsibilities:

Responsible for developing Functional & Non-Functional requirement for Reservation system, main functionalities include, Order Car, Make Reservation, Pay Invoice, etc

Developed detailed Owner requirement ( P140S), for application users, such as, Customer Service Rep, Yard service Rep, Transportation Service Rep, Network Management center, etc)

Developed Product Catalog requirements, for service offering/packages

Developed Regulatory, Business strategy and Tactical requirements

Produced solution requirements with solution use cases, Functional & Non-functional requirements

Developed web-interface and system work flows with Upstream/Downstream interfacing systems

Interacted with clients, SME's, project managers in gathering business requirements.

Analyzed Business documents and provided Business KT (knowledge Transfer) to the technical Team.

Analyzed systems, related use cases and documented Business objects, entity descriptions for the data model design.

Documented Business elements & attributes and coordinated with data modeling team in designing the dimensional modeling.

Worked with UI team in preparing workflow documents, wireframes and presented POC's (proof of concept) to the clients.

Designed and developed end-to-end ETL process for the production systems.

Analyzed the business requirements for ETL process and created data flow diagrams in VISIO.

Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data brought into the warehouse from various sources.

Performed Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.

Involved in requirement gathering, analysis and designing technical specifications for the data migration according to the business requirement.

Analyzed engineering change control documents to Identify unstructured data and mapping simultaneously changes made in the production environment

Involved in design, development and maintenance using procedures for getting data from impacted systems to Data Warehousing system, and data was standardized to store various Business units in tables.

Project 2.11

Rentlane Co

Business Analyst/Project Management

Role: Business Analyst/Project Management

Project: Online classified, CMS and Marketing Portal.

Responsibilities:

Interacted with business users to gather functional requirements and document them

Prepare Functional design documents, high level process flows, use cases and class diagrams to obtain sign offs

Acted as a key facilitator between the business and the technical team

Communicated the requirements to the technical team (Data architects, data modelers, testing team) to transfer business knowledge

Worked as solutions analyst to determine and to recommend Technologies that best suits the client’s budget and needs

Worked with Java, .net, Oracle/Sql and Adobe Product developers to help them understand the business requirements and to build backend databases, User interfaces, and custom Webapp features & functionalities

Worked with project management team to schedule, manage scope and analyze change requests

Interacted with Business users and Company SME's in documenting new and change requirements and referred those requirements in RTM to the detail design document

Developed Entity relationships utilizing business object oriented modelling as a foundation conceptual level for developing new schemas/data model

Address, diagnose and resolve issues that arise on a day to day basis for the team including documentation of the causes, analysis and final resolution to the issues/errors

Project 2.12

Role: Business Analyst/ Project Management

Project: The project was to build a complete customer portal and a dynamic database driven website that allows customers to order for telephone services over the web for Mount Horeb Telephone Company.

Responsibilities:

Investigate, understand and document customer requirements, participate in the software development cycle to ensure designs satisfy requirements.

Conduct weekly meetings with clients to facilitate discussion between the different users to resolve issues.

Identifying opportunities for workflow/ process improvements.

Managed expectations of both business and IT stakeholders regarding functionality, project scope and deliverables.

Worked with Sr. Solution Architect in defining conceptual, Logical and Physical data models

Project 2.13

Project: To build a PNL system (Profit and Loss system) - a data entry and reporting system used by NetPixel administrative and executive staff.

Responsibilities:

Conduct requirements gathering sessions with business stakeholders

Clarify and validate requirements throughout project life cycle

Monitor, facilitate and participate in the testing and deployment of applications

Assist I/T Leads with providing leadership and support for change management and training,

Projects 2.14

Project: Web based ERP (Purti)

Responsibilities:

Conduct requirements gathering sessions with the product development team in gathering requirements for customizing the ERP application for Health Care ( Hospital Management System)

Clarify and validate requirements throughout project life cycle

Monitor, facilitate and participate in the testing and deployment of applications

Assist I/T Leads with providing leadership and support for change management and training,

Project 2.15

Atelier-Soft – Company Partner

Feb 2003 to July 2007

Project: Multiple Projects.

Responsibilities:

Played Client Partner role for clients in USA, CANADA and development firms in India

Worked as a SPOC for North American Clients. Rolled an Avg of 14 application per year

Played PM/BA role in and managed applications from inception to deployment

Covered vast portfolio of projects in Telecom, Finance, and other Industries

Education

Bachelors of Engineering (SCSVMV university, 4 years degree, completed year 2001)

Business Administration (NASIT, 1 year degree, completed year 2003), PG Diploma.

Certifications/Licences

2016 SQL Server Integration Services (SSIS)

Trained in Agile (SCRUM) at H&R Block

Contact this candidate