Manager Data Analyst

Chandra Gangidi ********@*****.***

BI Analytics Consultant Data Analyst Power BI Mobile: 330-***-****

https://www.linkedin.com/in/chandra-gangidi-4797044

Charlotte NC

Professional Summary

Accomplished Data warehouse Architect with over fourteen years of experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and Production.

Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions.

Dynamic, result-oriented, team player with a sound understanding of BI Architecture.

Excellent working knowledge in the ability to interpret and analyze customer requirements to develop and design new Reports/Dashboards.

Strong ability to think laterally to provide solutions, exercising independent judgment and decision-making in the diagnosis and resolution of problems.

Aggressive in identifying and solving inefficient operational processes.

Keenly focused on customer requirements and service levels that directly contribute to measurable results.

Skills Summary

Installation & Configuration of BI tools

Gathering the Requirements with Business users.

Migration and Upgrading.

Expertise in handling Administration tasks.

Design and Develop creative reports.

Building Power Play Cubes, Framework packages.

Design and Develop Dashboards.

Scheduling Cubes and Reports.

Application Documentation / End User Testing.

Production Support.

Performance tuning and optimization techniques.

Databases DB2, Oracle and SQL Server.

Project Management

Code Reviews.

Customer Requirements / Customer Focused.

Problem Resolution.

Collaborative / Innovative Leader – “Outside the Box” Thinker.

Excellent Interpersonal / Communication Skills.

Team Player and solo performer.

Meticulous Attention to Detail.

Proactive attitude.

Research and Analysis.

Travel Flexibility.

Power BI,Informatica Power Center 9.1.0, Cognos Analytics 11.1.6,Microstrategy 10.2, Actuate, SSAS,SSRS,SSIS,SSMS,Microsoft Azure Sql Database, Visual Studio 2017, Spotlight, Fiddler 4, Denodo 8.0, Informix, Cisco DB, Razor SQL, Jira, Service Now, MotioPI, Control – M, Oracle 11g,10g, Unix, Linux, Tomcat, LDAP.

Professional Experience

Sunbelt Rentals, Inc – Fortmill SC April 2019 – present

SR BI Analytics Consultant/Admin/Data Analyst/Power BI Developer

Installed and Configured Cognos Analytics on Dev, Qa and Prod environments

Performed Cognos Analytics Upgrades

Implemented 3rd Party CA to allow for SSL between components in IBM Cognos Analytics 11

Created user groups and roles for different access levels.

Implemented passthrough authentication for Cognos to access Databases

Developed Data Modules, Dimensional and Relational Framework Manager Models

Created FM Packages for SSAS data source connections

Integrated Cognos Analytics environment with Okta for centralized single sign on solution.

Configured and implemented Okta SSO with Cognos

Developed Customized reports using JavaScript

Converted Cognos dashboards to Power BI Visuals

Customize cognos portal and added new dashboard icons by writing Json script

Imported data from SQL Server DB, Microsoft Azure SQL DB to Power BI to generate reports.

Desgin and developed various analytical dashboard such as Executive, Resource Analysis,Call Center Analysis, Operations etc.

Created user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts,Pie Charts, slicers, Drilldown and drill through features

Expertise in writing complex DAX functions in Power BI

Extensively used SUM, SUMX, CALCULATE, PARALLELPERIOD, SAMEPERIODLASTYEAR, ALLEXCEPT, FILTER, SWITCH, DIVIDE, SELECTEDVALUE Functions to create calculated columns and measures.

Implemented Time Intellegence in Power BI to measure patterns in business metrics over time utilizing external tools like Tabular Editor.

Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS), SSMS and SSDT

Developed Test Plan, Test Cases and Test Scenarios for testing based on BRD.

Environment: Power BI,Tabular Editor, Cognos Analytics 11.1.6,SSAS,SSRS,SSIS,SSMS,Microsoft Azure Sql Database, Visual Studio 2017, Spotlight, Fiddler 4,Denodo 8.0, Informix, Cisco DB, Razor SQL, Jira and Service Now

The Adecco Group – Charlotte NC June 2017 – April 2019

Sr BI Lead/Microstrategy Developer

Used Agile Software development methodology in report development and defect solution. Join daily scrum call to update the status of development and defects.

Served as the Reporting Development Lead responsible for Business Intelligence (BI) Reporting and Data Analytics for The Adecco General Staffing and Specialty Brands.

Provide senior technical guidance in the areas of Cognos report development and Dashboards.

Managing the report developers and supporting the development team with Framework model related changes.

Follow up with on-site coordinator for timely delivery of requirements.

Escalate issues to business/management in timely manner.

Offshore Review meetings and managing the workload between resources based on priorities.

Planning for handling the Production Incidents raised within the given timelines based on urgency to avoid business impact.

Working with business users and helping them in troubleshooting and resolving tickets/incidents opened in eService and Service Now.

Work with ETL and DBA team to understand dataflow, remove data discrepancies and modification/updating in data model.

Developed documentation related to Microstrategy and Cognos project implementation.

Performed day-to-day technical operations. This includes server maintenance, creating user groups and providing security, Installation and Configuration.

Involved in designing of Schema Objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.

Involved in development of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports on top of the Schema Objects.

Environment: Microstrategy 10.2, Cognos 10 Suite, Oracle 11g, SQL Developer, Actuate, eService, Service Now, Autosys.

State of Ohio (Department of Jobs and Family Services) – Columbus, OH August 2012 – June 2017

Sr Cognos Architect/Informatica Developer

Involved in gathering the Requirements with Business users and prepared Functional Requirement Specifications for report development.

Extensively worked on loading Dimensions and fact tables in a star schema.

Designed & Implemented SCD methodology including type 1 and type 2 changes to keep track of historical data.

Created mapping using various transformations like Source Qualifier, Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression and Update Strategy.

Participated in implementation and testing of various type 1 and type 2 dimensions.

Designed and built staging tables to restrict the data for Incremental loads.

Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.

Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.

Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.

Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.

Involved in Migration and Upgrading of Frame work models, power play cubes and Reports from series 7 to Cognos 8.4 and from Cognos 8 to Cognos 10.2.2.

Proficient in deploying Reports and Packages from one environment to other environments (export, import and Copy to Clipboard)

Expertise in handling Administration tasks like bursting and scheduling the reports.

Created Data Source Connections in Cognos Connection for new development.

Involved in creation and maintenance of BMC Control-M jobs that submit Cognos cube build scripts that perform automatic publishing of Power Play Cognos cubes providing version control.

Developed Transformer Models and publishing the Cubes to Cognos Connection to be used for multidimensional analysis.

Design and developed Relational and DMR Framework Manager Models with Physical layer, Logical Layer and Reporting Layer and published them to cognos portal for standard reporting and Adhoc Analysis.

Implemented the Security levels in Cognos framework Manager.

Developed IQD packages out of Frame work Manager Model and published them to portal and used as a source to create Power play Cubes.

Created filters and prompts within the Framework Model for improving performance of the Model.

Converted 100+ Oracle Discoverer reports (an integrated Oracle product) to Cognos 10.2.2(JFS OIS enterprise reporting system).

Developed the complex reports using Cognos Report studio like summary reports, detail reports, Drill through reports and Drill down reports.

Developed Child Care BI dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.

Provided optimal customer support in troubleshooting and resolving the service tickets for ODJFS BIC Customer Service within sufficient timeframes.

Deployed the packages and reports from Development to Production.

Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.

Resolved issues resulting from User Acceptance Testing (UAT).

Responsible for knowledge transfer, training and communication to end users and team members.

Environment: Informatica 9.1, Cognos Analytics 11, Cognos 10.2.2/10.1/8.4.1 Report Studio, Query Studio, Cognos Connection, Cognos Map Manager, Framework Manager, Power play Transformer, Cognos Scheduler, MotioPI, PL/SQL, IBM DB2, Oracle 11g/10g/9i/8i,TOAD, Unix, Flat Files, Shell Scripting, Quality Center & Control –M.

American Electric Power – Columbus, OH September 2011 – August 2012

Sr Informatica Developer

Collaborated with business analysts and technical team for requirement gathering and business analysis and prepared high-level design document to provide an overview of technical design specification system.

Analyzed the existing application physical data model and suggested changes to data Model based on the ETL and Referential Integrity gap requirements. Accommodated ETL Mappings according to Database Management change requests. Developed Data Quality architecture for ETL environment.

Worked with Shortcuts across Shared and Non Shared Folders, used Parameter files and Mapping Variables for Incremental Load.

Created User Defined functions, reusable transformations to be re-used during the development life cycle

Coordinated with Source System Owners to analyze sources for data feeds, mappings and Defaults for the Data and Created folders, groups, users and assigned permissions and privileges to groups and users using the Informatica Repository Manager.

Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.

Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.

Performed tuning of Informatica Mappings for optimum performance and SQL overrides in place of homogeneous sources. Designed and coded rejected row handling process.

Designed and implemented CDC backup process for Mainframes. Designed data loading sequence and populated data into ODS, staging and warehouse with business rules following Data warehouse methodologies. Implemented SCD Type 1 and Type 2 to update the dimensional schema.

Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.

Added enhancements such as mail functioning, success flag, pre and post session functions etc.

Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.

Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.

Responsible for best practices like naming conventions, Error Handling and Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.

Involved in Unit Testing, System Testing, User Acceptance Testing to check whether the data load into target are accurate which was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test cases based on the pre-defined test plans.

Created data lineage documents for data flow and ETL process based on Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Autosys, Oracle 11g, DB2 V 9.1, Flat Files, AQT, Ultra Edit, UNIX Scripting, AIX, Windows XP.

State of Ohio (Department of Jobs and Family Services) - Columbus OH January 2011 – September 2011

Sr Cognos Architect/Informatica Developer

Developed CFSR Performance Dashboard, dashboard provides maximum flexibility, as well as allows leaders to identify and monitor children for each permanency measure.

Worked on creating Data Warehouse for SACWIS in Ohio, using Infomatica.

Created adhoc reports, drill through and CFSR Metric Indicator reports based on user request.

Extensively used features likes Conditional blocks, Bookmarks, Conditional formatting, HTML, Prompts, and Drill throughs.

Used Java scripts in HTML item to set the most current dates in the Dashboard reporting.

Used Cognos Connection as Web Portal to manage reports, develop prompt pages and conditional variables.

Set up the security at the package level, query subject level and query item level.

Created Query Prompts, Cascading Prompts, Calculations, Conditions and Filters.

Extensively worked on loading Dimensions and fact tables in a star schema.

Involved in the design and implementation of Bridge tables in a data warehouse.

Responsible for developing and testing ETL mappings for Fact_Child_Disability fact table and surrounding dimensions. This fact table tracks disability claims and the dimensions provide data groupings for federally required reports. The fact table is treated as type 2 with current flag and effective date ranges due to updates and deletes in the source schema.

Responsible for building bridge tables to implement many-to-many relationship between fact table and a dimension.

Analyzed source data and developed Fact Allegation table with supporting dimensions. This table tracks abuse allegations for the Department and vitally important for correct reporting.

Lead testing of various fact and dimensions tracking child foster care placements.

Participated in implementation and testing of various Type 1 and Type 2 dimensions.

Used the Workflow manager to create workflows, worklets and tasks.

Delivered and sign-off of deliverables pertaining to the Operations Data warehouse.

Prepared design documents, ETL data mapping and migration documents.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Cognos 8.4.1 Suite, Oracle 11i/10g, Quality Center.

American Modern Insurance Group - Cincinnati OH August 2009 – January 2011

Sr Cognos Lead Admin/Architect

Installed and configured Cognos 8.4.1 Business Intelligence environment and performed knowledge transfer in support of this company’s evaluation of Cognos for its national rollout of new insurance products.

Consult and assist Sales and FID departments with the usage of Cognos Tools.

Monitoring daily cubes and Reports which are scheduled to run and Burst to users every morning before business day starts.

Externalized IQDS out of Cognos 8.4.1 Framework Packages to support Power play Cubes.

Created individual state reports for the FID department to give the ability to enhance their risk management capabilities by providing a visual depiction of FID’s experience and exposures on both countrywide and state maps.

Involved in setting up Groups/Roles to secure the models and packages (Data Level) using Access Manager.

Uploading Burst tables and run the reports and Burst them to Agents based on alpha sorts during Month End Processing.

Created High level design and analysis documents and set up a meeting with Business to get their approvals.

Environment: Cognos 8.4.1/8.3 Suite, Framework Manager, Power play Transformer, Oracle 11i/10g,TOAD, HTML, MS-Access, MS- Excel, Unix, AIX, Windows NT.

Washington Metro – WMATA - Washington DC May 2009 – July 2009

Sr Cognos Product Specialist

Involved in Migration and Upgrading of Reports from Cognos 8.3 to Cognos 8.4.

Designed and modified reports with Java SDK in Report Studio.

Created Power play Cubes using Power play Transformer generated Power play Reports.

Involved in setting up Groups/Roles to secure the models and packages using Access Manager.

Created High level design and analysis documents and set up a meeting with Business.

Environment: Cognos 8.4/8.3/8.2, PL/SQL, IBM DB2, SQL Server 2005, DTS, Oracle 11i/10g,TOAD.

Kaiser Permanente - Pleasanton, CA APRIL 2007 – April 2009

Cognos Architect/Developer

Develop the HR Dashboards for the Kaiser Management of the HR activities and

Write BTEQ scripts in Teradata as part of ETL task to load the target systems

Designed National Dashboard reports on the critical performance metrics in the path toward Best Quality, Best Service, Most Affordable and the Best Place to Work which make up the KP Value Compass.

Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.

Designed Multidimensional Model (IT Performance Measurement DMR) in Framework Manager used MDX functions for report generation.

Implemented security (Data Security, Object Security, Package Security) to the package based on user requirement.

Created Dashboard (National Dashboard, HR Dashboard and Hawaii Dashboard, NCAL Dashboard) reports for the IT department to check the performance of the IT employees.

Extensively used features likes Conditional blocks, Bookmarks, Conditional formatting, HTML, Prompts, and Drill throughs.

Used Java scripts in HTML item to create run and reset buttons.

Created summary tables to increase the performance of the Dashboard reports.

Worked independently for writing test cases, test scripts, executing them, and preparing the consolidated test results.

Environment: Cognos8.4 Suite, Oracle10g, Teradata Sql Assistant12.0, DB2, SqlServer2005, T-SQL, Analysis Services (SSAS), SQL Server Integration Services, Toad.

Pearson Assessments, Eagan, MN Feb 2007 – April 2007

Cognos Developer

Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8.2 using Migration Utilities.

Designed models using Framework Manager and deployed packages to the Report Net Servers

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.

Environment: : Cognos 8.2 Suite, Cognos Report net 1.1, Cognos Transformer, Power play Window/Web, Impromptu 7.3,Mig Utilities, Oracle 10g,SQL Server 2000, Unix Shell Scripting.

Education

University of New England, Sydney, Australia

Master of Science (M.S) Computer and Information Sciences, May 2006

JNTU, Hyderabad, India

Bachelor of Technology(B.Tech) Computer Science, May 2003

Certifications

Cognos 8 BI Author v2 Certification Program

Cognos Report Net Modeling Product Professional Cognos Certification Program

Cognos Report Net Authoring Product Professional Cognos Certification Program

Contact this candidate