Home

Ravi Potu` - BI Data Analyst | AWS, Azure, GCP

[email protected]

Location: Ellicott City, Maryland, USA

Relocation: Yes

Visa: Greencard Holder

Consultant Name: Ravi Potu Contact Number: 636-312-8820 Email: [email protected] Work Authorization: Green Card City and State : Ellicott city, MD Summary 13 years of experience in the data warehouse applications using MicroStrategy, Tableau, Qlik, Cognos, SAP Business Objects, AWS Redshift, Snowflake, Oracle, Sql Server, Netezza, Teradata, DB2 on Windows/Linux platforms. 9 years experience working with Social Security Administration (SSA) and Health care (CMS) IT Projects. Expertise in using MicroStrategy 11/10/9/8.x product suites including MicroStrategy Desktop, Web, Architect, OLAP Services, Object Manager, Command Manager and Integrity Manager, System Monitor, User Manager and Enterprise Manager. Expertise in migrating Business Objects, Cognos Reports to Microstrategy. Expertise in Migrating Microstrategy Reports to Qlik Sense, Tableau and Power BI. Expertise in development of reports and Visual insights in Google Looker and AWS Quick sight and development of business insights in Thought Spot 6.3. Experience in ETL tools Informatica and Oracle Warehouse Builder. Expertise in training Users and prepare BI tools User Manual guide for End users to develop Attributes, Metrics, Filters, Prompts, Datasets and Dossier. Experience working in agile projects and Certified safe Agile Professional. Two years of working experience with off shore development team. Expertise in MicroStrategy platform upgrades. Have worked on project planning and implementation of MicroStrategy platform upgrades starting with V8 to v2020. Expertise in working with AWS components AWS S3, EC2, Athena, VPC, Cloud Front, Cloud Watch, Glacier, Elastic Cache and Load Balancer. Expertise in Cloud based Database & Storage implementation on Snowflake, Redshift, Postgresql data warehouse. Expertise creating staging database and schema for S3 buckets before data load into snowflake database. Expertise in define roles and privileges in snowflake dabase. Expertise applying transformations to modify data before load into snowflake database. Experience in developing test cases and test plans for system testing, unit testing and UAT extensively. Experience in code optimization and performance tuning of database queries. Specialized in developing stored procedures, functions, packages, and database triggers using Oracle SQL and PL/SQL. Experience in Prod support of microstrategy existing reports and modification of reports as per users request and migration of reports from Dev to QA & QA to Prod after users sign off. Strong presentation, analytical, multi tasking, decision making, problem solving and excellent inter-personal skills Strong communication skills (written, reading comprehension, listening, verbal, training and presentation. CERTIFICATIONS Microsoft Certified: Power BI Data Analyst Associate from Microsoft on Apr 2023. Certified Professional in Microstrategy (MCD, MCE and MCEP). Certified Professional in 508 Testing. Certified AWS Architect Associate. Certified Agile SAFe4 and Scrum Master. Technical Proficiency BI/OLAP Tools Microstrategy 11.1/10.4/9.4.1/9.3.1/9.2.1/9.0.2/8.1.2/8.1.1/8.0.2 (Microstrategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Object Manager, Integrity Manager, Command Manager, Business Objects XIR2, R3/6.5(Universe, Xcelsius, Web Intelligence),Cognos 8.4.1, Framework Manager, Query Studio, Report Studio, Tableau 10.5 (Desktop, Public, Reader) and Qlik View 12 (Desktop and Server), SSIS 2010, SSRS 2010, SSAS 2010, Google Looker, Quick sight, Thought Spot 6.3 and Power BI. AWS Tools EC2, S3, ELB, Auto scaling Groups, Glacier, EBS, Elastic , Beanstalk, Cloud front, RDS, Redshift, VPC, Route 53, Cloud Watch, Cloud Trail, IAM, Dynamo db, Elasticache and Lambda ETL Tools Informatica 8.6.1/8.1/7.x/ 6.x, Oracle warehouse Builder 10.2. Data Modeling Tools Erwin 4.0/3.5.2, MS-Visio Databases Oracle 19c/18c/11g/10g/9i/8i, MS SQL Server 2000/2005, Netezza 5.0, DB2 7.0, Teradata 12, Bigdata Hive, Impala Cloud Databases Snowflake,Redshift,PostgreSQL Database Utilities Toad, SQL developer, SQL*Loader, Oracle Developer 2000 (Forms 6i & Reports) 508 Tools Jaws 2020, Jaws 12, 14, MAGic, Dragon. Languages C, C++, Python, JAVA, Visual Basic, Unix, SQL, PL/SQL, XML Configuration Tools Clarcase, VSS, GIT Operating Systems Windows 10/2000/XP/NT, HP-UX, Unix, IBM AIX 4.3/4.2, and Sun Solaris Education: Masters from West Virginia University in Computer Science. BE from JNT University in Computer Science. Client: Peraton (CMS), MD Mar 21 to Till date BI/Data Analytics cloud Consultant Project: MEPBS Responsibilities: Gather Business requirements and Transform business requirements into sustainable BI solutions through the construction of MicroStrategy reports and dossiers. Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema), Business and Data Analysis. Building the MicroStrategy Attributes, Facts, Metrics, reports and Dossiers for MEPBS project. Architect and designed logical and physical model based on the requirements. Identify and analyze performance issues by reviewing the Data Model and propose solutions to improve the performance. Perform Data Analysis and visually represent the data through MicroStrategy Dossiers. Prepare High level design, technical design documents and MicroStrategy object mapping sheet. Expertise in create microstrategy user guide to train CMS end users to develop Objects Attributes, Metrics, Filters, Prompts, Datasets and Dossier. Created MicroStrategy Hyperintelligence Cards to display information. Created and Modify MicroStrategy Dossiers, Libraries ,Users and User Groups from Workstation. Created Dossier in MicroStrategy desktop and shared to other users. Work with the admins to promote the MicroStrategy object packages from Dev to UAT & PROD. Responsible for conversion of Reports from Microstrategy to power BI. Responsible for design, develop, publish and scheduling the Power BI Reports & Dashboards as per the requirement. Responsible for define joins between table in Power BI Model View and Transform data in Data View. Responsible for development of Mapping document for conversion of reports from Microstratgy to Power BI. Responsible for Migration of Microstrategy Reports from DB2 & Sql server Database to Snowflake and AWS Redshift Database. Responsible for creating staging database and schema for S3 buckets before data load into snowflake database. Involved in define roles and privileges in snowflake database. Responsible for testing reports, dash boards for 508 compliances by using Jaws 14.0, Magic 11.0 and Dragon 11.0. Involved in unit testing the SQL and ETL Logic and perform data validations. Responsible for writing unit test cases for Validation of Reports. Environment: Power BI, Microstrategy 2021,Quick Sight, Architect, Desktop, Workstation, Python, Oracle 18c/19c, MS SQL Server 2014, AWS, Redshift, Snowflake, Big data, Hive, Impala, Big Query, Jaws 2020, Magic, Dragon Client: Truist Bank (NTT Data), NC Aug 19 to Feb 21 BI/Data Analytics Cloud Consultant Projct: Commercial Lending Project Responsibilities: Meet with different business units, understanding their data needs, help them do the data discovery themselves using MicroStrategy and Microstrategy or build reporting solutions for them. Responsible for Development of Mapping document for conversion of reports from Cognos and Business Objects to Microstrategy. Responsible for Design and Development of Schema Objects Attributes, Facts, Hierarchies and Transformations. Responsible in developing of public objects Filters, Prompts, Metrics, Drill Maps, Consolidations, Custom Groups, Templates and Reports. Involved in discussion with data modelers to understand data modeling of schema. Build the Logical and Physical data model for snowflake as per the changes required Validation of Microstrategy report with Oracle Database and Snowflake database. Created MicroStrategy Hyperintelligence Cards to display information. Created Attributes and Measures and Reports by using Artificial intelligence of Thought Spot. Involved in modify Sql of report to update output of Thought Spot Report. Responsible for Conversion Cognos and Business Objects Reports to Microstrategy Reports. Responsible for conversion of Reports from Business Objects to power BI. Developed Reports, Data sets, Dashboards and KPI using Power BI in alignment to business requirements. Design, develop, publish and scheduling the Power BI Reports Dashboards as per the requirement. Responsible for Migration of database from DB2 to AWS S3, Redshift and Snowflake data warehouse. Responsible for creating staging database and schema for S3 buckets before data load into snowflake database. Involved in define roles and privileges in snowflake database. Responsible for Development of ICUBES, aggregate tables to improve performance of Dashboards. Responsible for development of Dossiers to analyze data for Users. Responsible for setting of VLDB properties to optimize the query generates in Microstrategy. Responsible for Run Integrity Manager to take base line before Migration and Compare Report Results after Migration Process. Responsible for validate Reports after migrate to AWS environment using integrity manager. Responsible for writing unit test cases for Validation of Reports. Responsible for Prod support of microstrategy existing reports and modification of reports as per users request and migration of reports from Dev to QA & QA to Prod after users sign off. Environment: Microstrategy 10X/2020, Desktop, Workstation, Power BI, Google Looker, Thought spot 6.3, AI, Cognos Framework Manager, Business Objects Universe, Web, Oracle 18c/19c, DB2, Snowflake, Compass. Client: Trowe Price, MD Aug 18 to Jul 19 BI/Data Analytics Cloud Consultant Project: RPS Responsibilities: Worked as a MicroStrategy Architect and Developer. Meet with different business units, understanding their data needs, help them do the data discovery themselves using MicroStrategy and Microstrategy or build reporting solutions for them. Involved in discussion with data modelers to understand data modeling of schema. Responsible for Development of Client Kit Dashboard and other complex Documents in Microstrategy. Responsible for Development of User Statistics Dashboard, Inbox Messages Dashboard, Reports Shared dashboard and User Subscription Dashboard by Using by Enterprise Manager Metadata. Responsible for Development of ICUBES to improve performance of Dashboards. Responsible for development of Visual Insight Dashboards to analyze data for Users. Responsible for setting of VLDB properties to optimize the query generated Microstrategy. Responsible in development of reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse. Worked with cloud architect to set up the environment. Build the Logical and Physical data model for snowflake as per the changes required Validation of Microstrategy report with Oracle Database and Snowflake database. Working with extension objects and Master items for building the visualizations. Designing and developing reports and dashboards using Tableau Public and Desktop Responsible for Creation of Extract, Data source, attribute and Metrics filters in Tableau to display more refine data. Responsible for scheduling workbooks from Tableau server. Converted existing BO reports to tableau dashboards Involved in migration of data from Oracle to Snowflake Data warehouse. Responsible for Performance and Unit Testing of Developed Dashboards. Involved in working with DBAs to improve performance reports by checking explain plan of query and create Indexes on database columns to improve performance of Reports. Environment: Microstrategy 10.4, Architect, Web Intellegence, Oracle 11g, Snowflake, SAP Business Objects, Tableau Desktop 2018 and Tableau Public 2018 Client: ManTech (CMS), MD Jun 15 to Jul 18 BI/Data Analytics Consultant Project: BI/ETL Responsibilities: Worked as a MicroStrategy Architect, Developer and Administrator Worked with client to gather requirements and prepared technical specifications documents. Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports. Involved in discussion with data modelers to understand data modeling of existing schema. Responsible for development of Dynamic Dashboards by Using Multiple Panels and Selectors. Responsible for development of Visual Insight Dashboards to analyze data for Users. Responsible for setting of VLDB properties to optimize the query generated Microstrategy. Responsible in development of reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse. Responsible for Send Requests to Microstrategy Admin Group to Usage Report from Enterprise Manager. Responsible for Send Requests to Microstratgey Admin Group to Migrate Objects from Development to QA and QA to Prodution. Responsible for testing reports, dash boards for 508 compliances by using Jaws 14.0, Magic 11.0 and Dragon 11.0 Responsible for writing Logical Views in Desktop to Develop Reports. Responsible for working with Users to trouble shoot Reports and Guide users to Apply Job Codes in order to get appropriate User access privileges in the Project. Responsible for attending IDR Bi weekly meeting and Modify Reports and Update Data structures if any Changes happen in IDR Database. Responsible for Creation of Worksheet, Dash board by using Tableau Desktop and Public. Responsible for Creation of Extract, Data source, attribute and Metrics filters in Tableau to display more refine data. Responsible for scheduling workbooks from Tableau server. Responsible for saving Tableau work books and Data Source in TWB, TWBX, TDS and TDSX formats Responsible for Replication Reports from Pear Projects to IDR Building Block Project which are points to Different VDM s. Responsible for Run Integrity Manager to take base line before Upgrade and Compare Report Results after Upgradation Process. Environment: Microstrategy 10.4/10.2/9.4.1, Architect, Web Intellegence, Informatica 9X, Tera data, DB2 8.x/9.1, SQL Server 2016, SQL, PL/SQL, Windows NT and UNIX, Jaws 14, Magic, Dragon, Tableau Desktop 2018, Tableau Public 2018, Bigdata, Hive, Impala Client: Leidos (SSA), MD Feb 12 to May 15 BI Consultant Project: DCPS MI Reporting System Responsibilities: Worked as a MicroStrategy Architect, Developer and Administrator. Co-ordinated meetings with clients and business users to discuss and understand requirements. Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis. Involved in discussion with data modelers to understand data modeling of schema. Work with SSA to gather requirements and prepared technical specifications documents. Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports. Involved in prepare Summary and Detail Mock Up Reports to present end users before start actual development Involved in setting of VLDB properties to optimize the query generated Microstrategy. Responsible for development of Dynamic Dashboards by Using Multiple Panels and Selectors. Responsible for Developemnt of Anlytical dashboards to analysing data for End users. Involved in development of reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse. Responsible for installation of Microstrategy 9.2.1/9.3.1 on new boxes and hot fixes on already existing boxes. Expertise in using User Manager Window to create Users and assign them appropriate UserGroup privileges. Expertise in activation of license key through License Manager Duplication of projects In VM Environment for Developers by using Object Manager Window. Involved creating and executing scripts by using Command manager to list Reports and attributes, Metrics in the Project as well as its Properties. Use Enterprise manager to list to see statics of Reports like Table and Column was accessed by reports and top 10 reports accessed by users and longest execution Reports. Involved in implementing data level at DDS, Region and State level security by using Security Filters. Involved in creation of detail reports by drilling on metrics. Involved in Upgradaton of projects from 9.0.2 to 9.2.1 and 9.3.1 to 9.4.1 in Development, Validation, Integration and Production servers. Responsible for testing reports, dash boards for 508 compliances by using Jaws 13.0, Magic 11.0 and Dragon 11.0 Involved in using Scan Md to Repair the Meta data. Improve Performance of reports By Using Fine Tuning of Sql Quiries of Logical Views BY analyse Execution Plan of Queries. Environment: Microstrategy 9.4.1, Architect, Desktop Reports, Web Intelligence Reports, Report Services, Administration, Dashboards, Scan MD, Enterprise Manager, Object Manager, Informatica 8.1, Toad, Oracle 10GR2,Jaws 12, MAGic and Dragon ,Unix State of New Jersey Office of Information Technology (NJOIT),NewJersey Jul 11 Feb 12 BI Consultant Project: Dot Crash Reporting System Responsibilities: Worked with client to gather requirements and prepared technical specifications documents. Involved in design of proto type of reports based on requirements. Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis. Actively involved in walkthroughs and meetings with business team to discuss related issues and review of the objects and reports. Involved in creating schema objects and application objects necessary for the deliverable. Maintain the performance tuning of large reports by changing VLDB settings. Involved in defining logical views to get data through queries from self joined tables. Architected the projects and created all the necessary schema, application and configuration objects. Created transformational metrics (Bicylists Involved, Bicyclists Killed, Pedestrians Involved, Pedestrians Injured, Pedestrians Killed and Vehicles Involved) to compare monthly, quarterly and annual accidents. Created ad-hoc reports by drilling up, down, within and across hierarchies. Used Apply Simple and Apply Comparison functions to create complex filters and transformations. Involved in migration of Business Objects reports into Microstrategy Reports. Involved in developing reports by using Free Form SQL Queries in Microstrategy Desktop. Create a test plan, perform unit test and send the test plan along with the files generated for QA. Training the users how to use Microstrategy for their business analysis. Environment: Microstrategy 9.4.1, Desktop Reports, Web Intelligence Reports, OLAP Services, Architect, Narrowcast Server, Dashboards, Business Objects Xir2, Crystal Reports, Datastage 7.5.2, Toad, VBA, Oracle 10g, Windows 2000. Freddimac, Herndon, Virginia Jul 10 Jun 11 BI/MicroStrategy Consultant Project: Single Family Transaction Accounting (SFTA) Responsibilities: Worked as a MicroStrategy Architect and Developer. Involved in the meetings with business users to discuss and finalize the requirements and design of the reports. Involved in dimensional data modeling (Snow-Flake Schema) Data Architecture, Business and Data Analysis Involved in creation of canned reports and adhoc reports from the schema objects and public objects. Involved in setting of VLDB properties at report, metric and database instance levels to manage join, metric calculations and query optimizations. Involved in creation of logical views to defined Sql query against Data Warehouse. Involved in developing reports by using Freeform SQL in Microstrategy Desktop. Involved in creation of aggregate tables, datamart reports to improve performance of reports. Involved in moving the objects between two projects and two different environments by using Object Manager and merging the projects by using Project Merge Wizard. Involved in creation of services using subscription sets, schedules, device, local and information objects. Involved in upgradation of schema objects (facts, attributes, hierarchies, and transformations), application objects (filters, prompts, metrics, consolidation, and custom groups), and user groups from 8.1.1 to 9. Involved in development of reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse. Involved in creation of Users/User Groups and assigning privileges them through Command Manager Creating dashboard reports to view personalized reports based on user requirements. Involved in using SDK to customize web home pages. Involved in migration of reports from cognos 8 to Microstrategy. Involved in development of schema objects and Application Objects in Microstrategy Corresponding Objects Exists in Cognos Reports. Involved in partitioning the tables, indexes, and management of the schema objects. Involved in optimization of code and tuning queries for performance. Involved in tuning the application queries using Explain Plan. Involved In testing of reports and queries by test cases and test plans. Environment: Microstrategy 9/8.1.1, Desktop Reports, Web Intelligence Reports, OLAP Services, Architect, Narrowcast Server, Administration, Dashboards, Cognos 8, Clear Case 7.1, Toad, Rapid Sql, VBA, DB2, Windows 2005. Merck & CO., Inc. -Pharma (Cognizant), New Jersey Jan 09 Jun 10 BI Developer Project: Corner Stone Responsibilites: Worked with client to gather requirements and prepared technical specifications documents. Involved in design of proto type of reports based on requirements. Communicate offshore working team to explain client requirements and develop reports. Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, business and data analysis Actively involved in walkthroughs and meetings with business team to discuss related issues and review of the objects and reports. Responsible as a team lead for keeping team members on track toward completing the terms of goals. Involved in installation and configuration of Microstrategy 8.1.1. Creating schema objects (facts, attributes, hierarchies and transformations) and application objects (filters, prompts, metrics, reports) needed to create the Microstrategy objects necessary for the deliverable. Architected the projects and created all the necessary schema, application and configuration objects. Creating advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties. Creating dashboard reports to view personalized reports based on user requirements. Involved in the creation document from multiple datasets like Map Application Diagram, Grid and Graph. Involved in developing reports by using Freeform SQL Queries in Microstrategy Desktop. Involved in using Netezza data warehouse system for terabytes of dynamic, detailed data to dramatically simplify. Involved in optimization of code and tuning queries for performance. Involved in tuning the application queries using Explain Plan. Provided post production support to end-users. Environment: Microstrategy 8.0.2/8.1.1, Desktop Reports, Web Intelligence Reports, Architect, Narrowcast Server, Dash Boards, Administration, Informatica 7x, Unix, Toad, VBA, SDK, Excel, Oracle 10g, Netezza, Windows 2000 Keywords: cprogramm cplusplus quality analyst artificial intelligence user experience business intelligence sthree database active directory information technology hewlett packard microsoft procedural language Colorado Maryland Michigan North Carolina