Power Bi Quality Control
Resume:
USHAKIRAN YELLAJOSYULA BI Analyst/Developer
PROFESSIONAL SUMMARY
** ***** ** ********** ** experience with strong background on Business Analysis, Reports Development, Data Analysis and Quality control.
Thorough understanding of Software Development Life Cycle (SDLC); involved in all phases from planning to the implementation stage. Experienced in Agile methodology.
Experience in defining scope of projects based on gathered business requirements including documentation of constraints, assumptions, business impacts, project risks & scope exclusions.
Expertise with documenting Business Requirements Document (BRD), Use Case Specifications and Functional Specifications and Unified Modeling Language (UML) diagrams
Worked on Data visualization products Power BI and Tableau (Certified Desktop Associate)
Strong experience in data modeling, Entity Relationship diagram, Data Flow diagram, normalization, Physical and logical data modeling
Facilitated and participated in Joint Application Development (JAD) sessions for communicating and managing expectations with the business users and end users.
Extensive experience in coordinating with ETL, Finance and infrastructure teams
Good understanding of Data modeling concepts.
Major responsibilities include getting requirements from the user and developing Crystal Reports and Maintaining proper documentation of the reports for future reference.
Excellent understanding of relational database concepts and reporting tools.
Experience in Oracle 10g/9i/8i, SQL Server, MS Access, SQL, PL/SQL, SQL Plus, Toad, and MS SQL Server, Query Analyzer.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Hands on experience in Requirement analysis, Documentation and good understanding of SDLC.
Strong interpersonal skills, with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
Capable of working as an individual as well as a part of team.
Proficient in UAT (User Acceptance Testing)
Worked with Agile project management tools like JIRA and Trello Board.
EDUCATION: B.E. in Mechanical Engineering, Osmania University, India 2004
PROFESSIONAL EXPERIENCE:
Cincinnati Children's Hospital (Remote) May 2023 – Dec 2023
Business Intelligence Analyst
Maintain Business Objects reports and Tableau Dashboards and provide support to existing reports/VIz while working towards migration to Power BI.
Understanding and building a roadmap to translate Business Objects Universe to Power Bi Data models.
Validating Power Bi reports against existing Tableau Dashboards to confirm the accuracy of data and also check if same insights can be derived with newly migrated Power BI environment.
Engage with stakeholders and Business on how the Reports/Visuals can further be improved upon in the new environment.
Environment: MS Office, Tableau 10, SQL Server, Power BI, SAP Business Objects 4.3
IGT, Rhode Island (Remote) Oct 2021 – Apr 2023
Business Objects /Tableau Business Analyst
Engagement with customer and Business owners for collecting and documenting business requirements.
Document and support Business Objects Web Intelligence reports.
Support and validate and perform complete data quality testing post migration of visualizations from Tableau to Power BI.
Create and aid Business with Functional requirement documents and acquire Business acceptance and then create Technical Documents.
Manage process from initial design to final implementation.
Collect requirements for Tableau Visualizations and Dashboards supporting Revenue data.
Create proof of concept and mock up visualizations in Tableau.
Created detailed plan on Report distribution based on events, roles and user profiles.
Define validation rules and bind those rules to against the specific columns.
Created design specifications documents at report level and obtain customer acceptance.
Working with ETL team on Data collection, preparation and transformation rules mechanisms to extract data from multiple disparate systems.
Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users.
Create Visualizations connecting to AWS product Amazon Redshift.
Create UAT documents and test plans, SQL queries for Data testing.
Created end user training documents and provide user support.
Environment: Tableau 10, Power BI, SAP Business Objects 4.2
LGC Group (Life sciences/Biotech ),Manchester, NH Sep 2018 – March 2021
Business Analyst/SAP Business Objects Developer/Analyst
Conducted workshops with Business for collecting and documenting business requirements.
Create and aid Business with Functional requirement documents and acquire Business acceptance and then create Technical Documents.
Manage process from initial design to final implementation.
Universe Design for Sales and Finance reports. Support and enhance existing Universes.
Create IDT Universe based on Salesforce Opportunity and Leads data.
Create Web Intelligence reports from Salesforce data.
Created detailed plan on Report distribution based on events, roles and user profiles.
Working with ETL team on Data collection, preparation and transformation rules mechanisms to extract data from multiple disparate systems.
Define validation rules and bind those rules to against the specific columns.
Created design specifications documents at report level and obtain customer acceptance.
Working with ETL team on Data collection, preparation and transformation rules mechanisms to extract data from multiple disparate systems.
Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users.
Create UAT documents and test plans, SQL queries for Data testing.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Developed Tableau workbooks to perform year Sales commission reports based on Region, Territory and provide clear visualizations to tell a Story.
Created end user training documents and provide user support.
Administer and supervise the BO environment by monitoring/granting permissions and rights to users, creating and publishing reports and implement Folder and object level restrictions.
Provide support, service, enhancements to existing reports and Universes.
Environment: Oracle, SQL developer, SAP BI 4.2, MS Office, Web Intelligence, Tableau 10.
Tufts HealthPlan, Watertown MA. Feb 2017 – May 2018
BI Reports Analyst
Created Business Requirements Document (BRD), Use Case Specifications and Functional Specifications and Unified Modeling Language (UML) diagrams.
Created data model, Entity Relationship diagram, Data Flow diagram, Physical and logical data modeling.
Facilitated and Conducted Joint Application Design (JAD), interviews, workshops and requirement elicitation sessions with end-users, clients and stakeholders.
Collaborated with quality assurance, production support, and end users to provide business direction on system analysis, design, development, testing and deployment.
Tested the application using functional and regression testing.
Worked on Universe Design and Web Intelligence reports for Automation Project for public plans.
Responsible for Requirements gathering, Scope Analysis, designing and reviewing BRD
Facilitated and participated in Joint Application Development (JAD) sessions for communicating and managing expectations with the business users and end users.
Created Business Requirement Documents and Use cases and conducted walkthrough with the business owners and took sign-off.
Identified and documented the Business Rules that would affect the application
Updated the requirement documents as per the Process Change Requests
Worked on reports and dashboard development for public plans using Power BI.
Work extensively on SQL server Stored Procedures being used by Crystal reports to generate State and Medical Insurance reports.
Environment: SAP BI 4.2, SQL server Management Studio, SQL Server 2014, Crystal reports 2014,Oracle, Power BI, CVC(version control).
Maternity Leave Sept 2016- Feb 2017
MBTA, Boston MA April 2016 – Aug 2016
BI Developer /Analyst
Review and correct existing code for the Crystal Reports- generated reports and interfaces from use Hastus for vehicle and crew scheduling, use commercial or custom software to generate the reports and interfaces for their downstream processes and systems,
Review the Hastus data sources used, such as which tables are used, and what data is generated within the report. Research tradeoffs between accessing Hastus data directly from the reports versus exporting data to an intermediate file or data source prior to running the reports.
Environment: Crystal Reports 2008, HASTUS.
Business Intelligence Analyst Feb 2015 – April 2016
Interacted with the SMEs (Subject Matter Experts) and stakeholders to get a better understanding of client business processes and gathered and analyzed business requirements.
Gathered requirements from end users of all the regional offices and business units and prepared BRDs.
Followed Agile methodology
Analyzed requirements and workflow diagrams. Developed use cases and activity diagrams to model processes
Tested the application thoroughly. Manual Tests involved Functional testing and Integration Testing.
Participated in Project Management duties. Prepared weekly status reports for senior management on the progress of the project, delivery schedules and commitments from different sub-groups such as QA, Development
Redesign and enhance Universes according to new DB tables.
Design, Develop Crystal reports and Web Intelligence Analysis reports and Dashboards for UptoDate Licence Management system and several other utility reports coming from License management datamarts/datasources.
Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
Environment: Microsoft Visio, SAP Business Objects BI 4.1, Oracle 12c, live office, Xcelcius 2011, Crystal Reports 2008.
Partners Healthcare, Wellesley MA. Aug 2014 – Nov 2014
Business Objects Developer
Analyze and collect requirements based on existing Cognos reports.
Design, Develop Universes related to different Packages.
Developed over 50 Web Intelligence reports involving some complex Medicaid reports from Claims system.
Help set up User and report security. Check data quality and accuracy before deploying.
Environment: SAP Business Objects BI 4.1, SQL Server 2008, SQL Server Management Studio,Cognos 9.
Additional employment information provided on request
Wipro Technologies, SAP BO Consultant. 2007-2014
IGATE Global Solutions, SAP BO Consultant 2005-2007
Contact this candidate