Candidates About

                     

                  Uday Punnani                 

DWH-BI Business Systems Analyst      

PROFESSIONAL SUMMARY:

·         Certified ITIL V3 consultant with more than 10 years of IT experience working for Telecom, B2B/ B2C Portal, Digital Marketing/Campaign Management, HealthCare, Retail and Customer Care domains.

·         Extensively worked on all phases of Data Warehousing project like Data Cleansing, Data modeling for data staging & Data Mart, ETL, Indexing, Quality Assurance, Data updating plan, and Data presentation to business users.

·         Proven track record in data analysis and mapping data mining, Change control combined with analytical problem solving and decision making capabilities.

·         Running Reports/ Data Mart and Migrating Projects from cognos version to version

·         Done data validations for SAP Business Object reports, Cognos Reports

·         Gathering Requirements and design of technical specification documents. Document the business requirements for the Cognos BI reports. Derive Cognos report requirements from already existing report templates

·         Experienced in operational and ad-hoc reporting using SAP Business Objects Tool Suite.

·         Designed conceptual and logical data models of Data Warehouse and tables.

·         Worked on different versions of Cognos and had good understanding of OLAP, ROLAP and MOLAP.

·         Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams (ERD).

·         Gathered requirements and tested reports, dashboards for BI initiatives using OBIEE.

·         Involved in scope definition, design/development and deployment of Enterprise wide BI solutions.

·         Experienced in Quality Management and Defect Management using HPQC.

·         Trained and hands on experience in using Cognos10.2 and Informatica

·         Experience in developing using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 databases

·         Solid understanding of DWH, Business Intelligence (BI) related implementations for Decision Support systems, which includes EDW Architecture, understanding of Star and Snowflake schemas, scheduling of reports and Dashboards in the user requested formats using different BI reporting tools like Cognos, SSRS and Micro strategy.

·          Good at Documenting and analyzing Business processes, Process improvements, Automation processes, risk areas.

·         Developing technical and business requirements for an RFP as part of the solution, review and help evaluate the responses and work with IT departments of an enterprise implement these new processes, including selecting new products and/or services

·         Proficient in working on gathering requirements and creating Business Requirements Document (BRD) and Functional Requirements Document (FRD), facilitating Joint Application Development (JAD) sessions, Rapid Application Development (RAD) sessions, Disaster Recovery Plan (DRP).

·         Well versed in working different project delivery models like Waterfall, Agile, Spiral and SCRUM

·         Developing Use Cases, Test Approach, User Acceptance Testing (UAT) and Requirements Traceability Matrix (RTM). 

·         Creating Business Process Modeling, Use Cases, Activity Diagrams, Entity Relationship Diagrams, Sequence Diagrams, Collaboration Diagrams, Class Diagrams, based on UML methodology using tools like Rational Rose and MS Visio.

·         Excellent verbal and written communication, presentation and interpersonal skills

·         Modeling, Use Cases, Activity Diagrams, Entity Relationship Diagrams, Sequence Diagrams, Collaboration Diagrams, Class Diagrams, based on UML methodology using tools like Rational Rose and MS Visio.

 

Technical Skills:

BI/OLAP Tools	SAP Business Objects,Cognos 10 BI (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio), Business Objects, SSRS, Micro Strategy, Tableau 9, Qlikview 8
ETL Tools	IBM Data Stage V8.7,MS DTS, Informatica, SQL Server Integration Services (SSIS)
Databases	Mongo DB, Oracle 9.0/8i/4.x, SQL SERVER 2005
Life ray Open source portal	Security based portal building
Case Tools	MS Visio and ER-Win
PPM Tools	JIRA, SAP CRM, HP quality Center, Bugzilla, JIRA, SharePoint 2010, SharePoint 2013, Microsoft Project, Excel
Programming Languages	SQL, PL/SQL, Visual Basic 6.0
Operating Systems	Windows XP/7/10, LINUX
Functional Use	AWS, Microservices, JBOSS, WebSphere, SAPFICO, Citrix, TOAD, DB2, SQL Developer

 

 

Professional Experience

Veritiv Corporation, Cincinnati, OH                                                                                                                 Aug2016-Till Date

ETL/Reporting Business Analyst

Description: Veritiv is (formerly known as International Paper Company) is fortune 500 company providing

Solutions in Print, Packaging and facility solutions. Veritiv is formed by merging two companies i.e Xpedx and Unisource. Veritiv

Initiated a project called as VOS(Veritiv Operating System) which is about merging and mapping both the business entities into one

Single entity and thus a need was there to merge both the enterprise data into single Data warehouse for the reporting purposes.

The already existing reports had to be revisited and ensure that they are revamped, migrated according to the business needs.

Responsibilities:

·         Analysis/Requirement Definition for ETL and Data Gaps identified for SALES,INVENTORY and

 PURCHASES across the enterprise.

·         Business Process improvement for the current and all future ETL and Reporting requirements

·         Work with SA and Business for Analysis and Solution Building

·         Liaise between IT,Business,SA and offshore development team to ensure a

proper solution is built by identifying and mapping all the necessary data mapping required for reporting.

·         Define Source and Destination Data mapping of various layers of Enterprise DWH Architecture.

·         Prepare ETL specification document which is base for ETL development teams

·         Review the mapping requirements with the developers

·         Work with reporting team and identify data gaps in what is needed Vs what is available on the reports

·         Ensure to have the identified data gaps analyzed and identify the source of data and prepare the mapping from source to enterprise Data warehouse

·         Participate in data modeling needs for data being mapped through STAGE,INTEGRATION and EDM layers

·         Work with Business users to understand the reporting requirements and translate that into ETL requirements as needed

 

 

 

 

 

 

 

 

 

Convergys Corporation, Cincinnati, OH                                                                                                               Jul’2012-Aug 2016

DWH/BI Business Analyst

Description: Convergys Dynamic Decision solution is BI product, which maximizes the lifetime value of all customers by automating the process of increasing customer value, integrating all the major operational areas that affect the customer relationship, centralizing business policies and marketing initiatives, and Personalizing the customer service experience for each customer. It enables you to quantify a customer’s historical, present, and future value to the organization.

Responsibilities:

·      Collaborated with analysts, management, and IT personnel to develop metrics, reports, and dashboards in support of decision-making process. This function includes design, development, testing, and new and maintenance of existing solutions.

·       Worked to define Data Modeling Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.

·      Provided data analysis in support of user requirements or problems as they relate to BI environment.

·      Provided customer and BI Team support in developing BI models by defining information requirements, identifying and modeling data sources.

·      Responsible for writing complex reports using Report Studio, creating Cognos Framework Models, Cubes and Dashboards in support of business requests.  

·      Used Informatica to Develop Data Mappings between source systems and target system using Mapping Designer in test environment

·      Set up Test repository and maintain for testing in Informatica Test Environment. Own the test environment

·      Document mapping definition and transformation flow for the data ware house data loads

·      Conduct user interviews, gather requirements, and analyze requirements for new and updated application functionality.

·      Create and send end user communications in advance of new/updated functionality and technical outages

·      Provided clear and concise documentation regarding requirements management plans, functional requirements, supplemental requirements, test plans and test cases.

·      Acted as User Acceptance Testing coordinator, monitored business testing, and interfaced with the development team regarding defect status and fixes daily.

·      Direct liaison between systems support and business stakeholders during outages and other system issues.

·      Troubleshoot production errors – interface with end users and technical support.

·      Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.

·      Assisted with Test Cases and development strategies with Quality Assurance Group (QA) to implement them and Conduct sprint and regression testing, Reviewed and identified process improvements.

·      Interacted with Business Users to conduct thorough Requirements Analysis.

·      Coordinated activities with project manager and various other teams using MS Project.

 

 

#2 Convergys Corporation, Cincinnati, OH                                                                                       Oct’2006-Jul’2012

Technical Business Analyst

Description: Customer Care Operations’ Business Intelligence (EIS 1.0-3.7) requirements for the EIS release mission is to redefine information flow to the Customer Care audience by introducing industry-edge dash boarding and score carding, featuring a high degree of personalization, graphical presentation of data and emphasis on key performance indicators.

Responsibilities:

·      Gathered business requirements and use cases from customers and translate those requirements into top-down technical solutions and design documentation across all aspects of the business intelligence solution.

·      Developed Universes by defining joins, cardinality between tables, creating prompts, applying contexts and alias to resolve loops/traps and checked the integrity of the Universe in Business Objects Universe Designer.

·      Created complex Linked Universes to reduce development and maintenance time.

·      Defined security filters to implement Row level and Column level security

·      Created derived tables at the Universe level to reduce the complexity of the Universes.

·      Created Business Views and implemented the dynamic cascading prompts.

·      Generated Business Objects reports involving complex queries, sub queries, Unions, Intersections and Minus.

·      Working with CVM teams of the customer to define the segmentations of the subscribers to offer them right campaigns at right time.

·      Cross Sell, upsell based customer identification along with campaigns and offers pertaining to customers to churn.

·      Defining post campaign report requirement for evaluation and feedback the results to the Data Analytics for further refining of campaigns.

·      Liaison with technical and network component teams comprising of SMSC gateway, Provisioning gateway for defining load requirement.

·      Working with digital marketing teams pertaining to VOICE, DATA and SMS for gathering requirements and then ensuring the requirements were based on the actuals by validating the requirements along with these teams.

·      Gather and Analyze requirements, for new and updated application functionality.

·      Create and send end user communications in advance of new/updated functionality and technical outages

·      Support and liaise with business users in User Acceptance test phase and Create and analyze end user surveys.

·            Participated in converting other system reports to BI tools – including researching data availability and format, designing reports, programming, and publishing the reports.

#1 Hill Physicians Medical Group, Sacramento, CA                                                                              Nov’2004-Oct’2006

Senior Quality Engineer

Description: Primed Management Inc., Hill Physicians Medical Group is an independent physician association with over 380,000 members in Northern California, the organization’s problem was to present the existing data into information, which can be available to managers and physicians, who can analyze the data and take better decisions.

Responsibilities

·      Interact with the Clients and On-site coordinator on a regular basis for resolving issues pertaining to the data delivered and special client requests.

·      Initial analysis and understanding of Specification documentation and report layouts.

·      Synchronizing and offloading catalogs daily from remote server, testing them and adding the joins wherever necessary. Create Calculations and prompts at Folder levels.

·      Checking customizing picklist’s reports and IMS file, Query file, group, filter, prompts, summaries and functions. Templates for reports as per the Client requirements.

·      Designed the Report formats and developed reports using Impromptu and Power Play tools. (Used the Catalog and Transformer to generate reports and cubes).

·      Testing multiple Impromptu reports like List reports cross-tab reports and sub reports.

·      Developing Specification Documents for Reports as per client requirements.