Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Rama Krishna Chekka

Senior Business Intelligence Architect / Senior Data Analyst
Gilbert,AZ

Summary

A Dynamic IT professional with 18+ years of IT experience as a Sr. BI Consultant (Qlik Sense/QlikView/Power BI/Tableau) / Sr. Data Analyst involved in analysis, design, development, testing and implementation of various critical business applications with good analytical skills. Onsite experience with Customer facing – 14+ years of Onsite experience worked in USA for large Pharma clients working on critical BI projects involving onsite-offshore teams, interacted with Vendor and business teams, conducted regular meetings with teams for project status and deliverables. Strong experience in Life Sciences and Pharma Domain with large Pharma clients (Genentech, GSK & IQVIA). Strong knowledge of data sources including IQVIA Sales, Veeva Alignments, Customer Interactions, Claims, Payers & Plans, Patients, Service Requests, Affiliations, etc., and expertise in data profiling. Good understanding of the Master Data Management (MDM) and Clinical Data Management (CDM). Around 9+ years of experience in Designing and Development of Business intelligence application with Qlik Sense, QlikView, Power BI, Tableau as BI tools. 10+ years of experience in a formal Data, Services and Solution Architecture role in a complex development organization. 5+ years of experiences in Big Data Solution Architecture role. Proficient in writing complex SQL/HQL queries, Functions, Views and Stored procedures and experience with relational databases, query optimization as well as working familiarity with a variety of databases. Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report designing and Performance Tuning using Qlik. Expertise in developing complex Qlik dashboards by integrating data flowing from different data sources like Oracle, AWS, Hadoop HIVE, SQL Server, Teradata, Salesforce, Text files and Excel documents. 7+ years of experiences in Big Data Solution Architecture role. 6+ years of extensive IT experience in the areas of Data Collection, Data Extraction, Data Cleaning, Data Aggregation, Data Mining, Data Verification, Data Analysis, Reporting, Data Warehousing, Production Maintenance Support, Documentation of Client/Server, n-tier and Legacy Applications. Experienced and proficient in various phases of Software Development Life Cycle (SDLC), Agile and Software Testing Life Cycle (STLC) such as Requirement & Analysis, Design, Implementation, Deployment, Post Deployment Support, Test Case design and execution, Bug reporting etc. Expertise in Performance Tuning (Data model, set Analysis, advanced aggregation) and involved in Migration of QlikView/Qlik Sense Applications. Implemented the 3-tier architecture (Extraction, Transformation, Data-Modeling and Application Development) as per recommendation in best practices guide. Good experience in Automation of applications to multiple environments. Strong problem solving and logical thinking skills - the ability to take complex ideas and break them into logical actionable steps. Defines and maintains best practice guidelines and standards for data, metadata, data modeling, and management. Work effectively as a team, supporting other members of the team in achieving business objectives. Provide leadership / consulting / direction to the team on all aspects of data architecture to ensure advanced learning occurs. Lead and manage data architecture activities within the team. Team oriented individual with a result driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management. Excellent communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure.

Overview

21
21
years of professional experience
3
3
Certifications
1
1
Language

Work History

Sr. BI Architect / Sr. Data Analyst

Genentech
01.2021 - Current
  • Requirements gathering, Design & Develop of Qlik Sense & Qlikview dashboards based on business need and Use cases
  • Involved in full project life cycle implementation of Qlikview / Qlik Sense dashboards
  • Developed complex dashboards and designing the data models in Qlikview/Qlik Sense to accommodate the application requirements
  • Extracted the data from various sources like MDM, CDM, Access Solutions and many others to get Patients, Claims, Sales, Interactions, Affiliations, Alignments, etc
  • Applied Line of Therapy(LOT’s) complex KPIs on Claims data for different Indications
  • Working with BSAs, Clients and Scrum Masters and ETL teams to build data models and to resolve data issues
  • Experience in complete project life cycle including documentation, analysis, development and testing under agile methodology
  • Extracted data from different sources and development Qlik dashboards using charts (Straight table, pivot table, Line, Combo charts, etc.,), List Boxes, Multi Box, Input Field, Table Box, etc
  • Extensively used set analysis to calculate/aggregate the fact data, Qlik functions and implemented section access for security
  • Developed automation process to create streams, data connections, and tasks, publishing and reloading of Qlik Sense applications using automated batch scripts
  • Worked on Dev, UAT and PROD environments and successfully migrated the dashboards
  • Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software
  • Extensively used Qlik Document Analyzer for tuning the existing documents
  • Performed architecture, redesign of QlikView / Qlik Sense BI platform running 40+ dashboards that improving availability, scalability and performance to accommodate high volume data
  • Assistance to Offshore/Operations team in dashboard training and KT activities
  • Handling change requests (or) bug fixes through JIRA process
  • Skillset: Qlik Sense, Qlikview, Tableau, SQL, AWS, Data Modeling, Hadoop (Big Data), Python, UNIX Scripting, Excel and Data Warehousing (Data analysis & problem solving)

Sr. BI Lead / Sr. Data Analyst

IQVIA (IMS Health & Quintiles)
06.2018 - 12.2020
  • Responsible for working with different stakeholders from Business, IT, external vendors to gather requirements and providing BI end-to-end solutions
  • Interaction with the client on regular basis in requirements gathering and designing the applications
  • Collecting the data from multiple heterogeneous data sources (Sales data – Retail & Non-Retail, Interactions (Calls), Affiliations, Alignments, Patient data (LAAD), etc.,)
  • Involved in full project life cycle implementation (requirement gathering to production) of Qlik Sense / QlikView dashboards
  • Worked with Qlik Sense Nov’18/June’19/April’20, Bigdata (Qubole), IE Plug-ins, Excel, flat files, Qlik Geo Analytics, QMC
  • Developed automation process to create streams, data connections, tasks, publishing and reloading of Qlik Sense applications using automated batch scripts
  • Installation experience of Qlikview / Qlik Sense in DEV, UAT and PROD servers
  • Experience in setting up Server, Publisher configurations and Security authorization at different levels
  • Model the data with using different modeling techniques
  • Developed executive dashboards in Qlik Sense delivered through the web, enabling to measure the performance the performance of the business with analytical capabilities
  • Developed report sheets like Geographic, HCO, HCP, Managed Care Overview, Managed Care Dynamics, Patient Care Dynamics, Patient Funnel & Dynamic Reports with the Patient Data
  • Extensively used Qlik Document Analyzer for tuning the existing documents
  • Managed 12 members of offshore team to deliver multiple projects at a time under Agile Methodology
  • Worked Closely with BA and Clients to understand the requirements
  • Worked Closely to the Database team to build good data model and to solve data issues
  • Experience in complete project life cycle including Documentation, Analysis, Development and Testing
  • Provided end user and production support after deploying the application into the production environment, also provided extensive support for the users on application usage and trained users in the functionality of the software
  • Performed architecture, redesign of QlikView / Qlik Sense BI platform running 40+ dashboards that improving availability, scalability and performance to accommodate high volume data
  • Assistance to Offshore/Operations team in dashboard and automation KT activities
  • Handling change requests (or) bug fixes through JIRA process
  • Skillset: Tableau, Qlik Sense, Power BI, SQL, Teradata, AWS, Data Modeling, Hadoop, Python, Java, UNIX Scripting and Data Warehousing (Data analysis & problem solving)

BI Lead /Onsite Lead /Senior Data Analyst

GENENTECH - GSonar
08.2015 - 05.2018
  • Review Business requirements, Functional specifications and User stories and prepare high level test scenarios
  • Actively involved with Onsite Genentech leads/BAs/developers to understand the business requirements and design specifications
  • Analyze data from multiple data sources (SHA – Claims, Sales, Interactions, Affiliations, Alignments, Roster, Master Data Management (MDM), etc.,)
  • And draw conclusions to provide insights to management and development Teams
  • Respond to data and product related inquiries in real-time to support business and technical teams
  • Write complex SQL queries and optimizing them to pull the required data in an effective way
  • Extracting data from legacy system, transforming and loading to Oracle DB
  • Validation of data in all the layers and Qlik reports
  • Preparation of Test estimation, Test strategy and Test plan
  • Preparation of Traceability matrix and review test cases as per the requirements
  • Validation of data loaded from multiple Sources into the Hadoop database using HQL scripts
  • Validation of KPIs and Base Metrics as per rules which are essential for business teams
  • Conducting regular meetings with Customer and team members for work progress and resolve open issues
  • Open/Track defects in HP ALM and arrange the defect triage meetings to coordinate with all the teams and plan the testing needs accordingly
  • Involved in UAT/Prod support and smoke testing activities
  • Involved in providing the Testing Sign off for every release of the project
  • Preparation of Weekly Status reports and sharing with the project groups
  • Skillset: Hadoop Hive, Oracle, Qlik Sense, SAS, Informatica, Python, SQL Server 2008 and UNIX scripting

BI Reporting & Data Analyst Lead

United Parcel Service (UPS) – P416 Reporting
04.2014 - 07.2015
  • Designing and maintaining data systems and databases; this includes fixing coding errors and other data-related problems
  • Gathering Business requirements from Clients, Providing Project Estimates & involved in Business Meetings
  • Actively involved with Business Analysts, Architects and End Users to understand the business requirements and design specifications and providing demos
  • Responsible for the implementation, analysis, design, development, administration and support of the Qlik dashboard
  • Mining data from primary and secondary sources, then reorganizing said data in a format that can be easily read by either human or machine
  • Using statistical tools to interpret data sets, paying attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts
  • Demonstrating the significance of their work in the context of local, national, and global trends that impact both their organization and industry
  • Preparing reports for executive leadership that effectively communicate trends, patterns, and predictions using relevant data
  • Collaborating with programmers, engineers, and organizational leaders to identify opportunities for process improvements, recommend system modifications, and develop policies for data governance
  • Creating appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary
  • Skillset: QlikView, Informatica, Microsoft SQL Server, Oracle 11g, Teradata, Excel, Flat files, MS Access

BI Reporting Lead & Data Analyst

GlaxoSmithKline
02.2006 - 03.2014
  • Work with executives and other business leaders to identify opportunities for improvement
  • Facilitate business rules discussions with cross-functional Analytics teams and other stakeholders
  • Interacted with Client and business team to gather requirements
  • Responsible in Coding and Documentation
  • Responsible for development of enhancements, change requests and support requests
  • Create reports for internal teams and/or external clients
  • Collaborate with team members to collect and analyze data
  • Use graphs, infographics and other methods to visualize data
  • Establish KPIs to measure the effectiveness of business decisions
  • Structure large data sets to find usable information
  • Work with a team of analysts and other associates to process information
  • Create presentations and reports based on recommendations and findings
  • Gathering user requirements and designing Database accordingly which involves creating Logical Data model and Physical Data modeling
  • Understanding Business requirements and translate into Application and operational needs using QlikView reporting tool
  • Interacted with customers to gather business requirements and developed functional and technical specification document
  • Used Oracle PL/SQL for implementing business rules and do performance-tuning procedures
  • Actively involved with Onsite Managers/BAs/developers to understand the business requirements and design specifications
  • Analyze, assess, and implement data and business processes, perform gap analysis, and identify data quality issues with those business processes
  • Organize disparate data sources into single data models
  • Design and developing of reporting applications
  • Stored procedures and triggers used to implement business rules
  • Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated
  • Performed daily database backup & restoration, monitored the performance of the Server
  • Skillset: SQL, Oracle, Qlikview, MicroStrategy, Crystal Reports, Excel & other tools (Data analysis & problem solving)

SQL Developer

Ernst & Young (EY)
09.2004 - 01.2006
  • Participate in requirements analysis
  • Collaborate with internal teams to produce software design and architecture
  • Write clean, scalable code using SQL programming languages
  • Test and deploy applications and systems
  • Revise, update, refactor and debug code
  • Improve application performance by optimizing the SQL queries
  • Develop documentation for the project
  • Serve as an expert on applications and provide technical support
  • Skillset: SQL, Oracle & UNIX Scripting

Education

Master of Science - Information Systems

Bachelor of Computer Applications - undefined

Skills

Qlik Sense

Certification

Certified Prince2 Foundation in Project Management.

Accomplishments

  • Awarded ‘Pat on the Back’ for excellence in data quality and project deliverables.
  • STAR Performer & top performer in annual appraisals.
  • Received appreciations from top management for successful implementation of critical projects and solving critical Production support issues within stipulated timelines.

Timeline

Sr. BI Architect / Sr. Data Analyst

Genentech
01.2021 - Current

Sr. BI Lead / Sr. Data Analyst

IQVIA (IMS Health & Quintiles)
06.2018 - 12.2020

BI Lead /Onsite Lead /Senior Data Analyst

GENENTECH - GSonar
08.2015 - 05.2018

BI Reporting & Data Analyst Lead

United Parcel Service (UPS) – P416 Reporting
04.2014 - 07.2015

BI Reporting Lead & Data Analyst

GlaxoSmithKline
02.2006 - 03.2014

SQL Developer

Ernst & Young (EY)
09.2004 - 01.2006

Bachelor of Computer Applications - undefined

Master of Science - Information Systems

Rama Krishna ChekkaSenior Business Intelligence Architect / Senior Data Analyst