Rohini Masarapu
Cary,NC
Summary
9 Years of experience in Business Intelligence lifecycle and SDLC projects from requirements gathering, documentation, analysis, designing, modelling, development, testing, production deployment and support. Designed and created SQL tables, and views. Extensively worked on PLSQL Procedures, functions and packages. Worked extensively on Qlik Replicate Proficient in report development using data visualization tools like QlikView, QlikSense, Power BI utilizing different sources like Apptio, ServiceNow, and SAP HANA Views. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Data.
Overview
10
10
years of professional experience
Work History
Sr. BI Developer/Data Analyst
Credit Suisse
04.2021 - Current
- Extensive experience on leading a project for both development and testing activities for Dashboards
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Good team player and capable to work under pressure to deliver dashboards to the business
- Followed Agile methodology in delivering projects to business which includes planning, sprint end review and retrospective sessions for each sprint
Sr. BI Developer/Data Analyst
T.Rowe Price
09.2020 - 04.2021
- Worked for security team to provide data insights by creating reports and dashboards like Internal Content Classification dashboard and Symantec DLP reporting on top of security related data for the business
- Closely worked with business to get requirements and modify existing dashboards as per business needs
- Reviewed design prototypes with business at every stage of development to modify them based on feedback
- Worked on creating reports for identifying anomalies for the events that captures data loss prevention records
Sr. BI Developer
Sanofi
03.2020 - 08.2020
- Worked on various projects by guiding offshore team and coordinating between team members and business to deliver applications to business
- Played a critical resource to fix production issues and bugs in existing qlik applications
- Was supporting team to convert qlikview dashboards to qliksense applications to make dashboards friendly for self-service functionality to users
- Trained users to understand the dashboard functionality and applying filters in the qlik dashboards
Qlik Developer
CSL Behring
06.2019 - 03.2020
- Expertise in developing complex and business critical reports by utilizing data from multiple sources and delivering the reports to users and training them to use the reports
- Worked on Qlik reports for financial reporting and group finance team by incorporating forecast category comparisons to actual and budget data in reports using Alternate states
- Expertise in coordinating with different technical teams and business teams to align and understand the flow and functioning of the data
- Guided Offshore Qlik team in production support for existing applications
QlikSense Developer
T.Rowe Price
05.2017 - 05.2019
- Worked on dashboard sand visualizations such as TCO BI Dashboard, GT BCM Portfolio, Decom Requests, Time Tracker and other data needs which gives insights of cost operations using QlikSense load editor and front-end sheets
- Designed and developed Unified Data Layer (UDL) app in QlikSense which extracts data from all the sources, concatenates as a single denormalized data table and stores as a single source of data for all apps in QVD
- Developed capabilities in UDL like snapshotting data, source control mechanism, data file recovery mechanism, logging mechanism and data backup mechanism
QlikView/QlikSense Developer
Natera
09.2016 - 04.2017
- Working on various projects such as performance analysis, forecast, key performance metrics, marketing ROI and other data needs which gives insights of commercial operations using QlikView
- Designed and developed various reports and KPI dashboards including both backend and frontend development in QlikView/QlikSense and MySQL
- Involved in various stages of software development life cycle design, development and also testing
- Worked on Scheduling and publishing QlikView apps using QlikView publisher and NPrinting
Qlik Developer
Vertex Analytics
03.2014 - 03.2016
- Created reports based on the different counties under numerous categories for benefit programs and other development programs
- Eliminated Synthetic keys, ambiguous relationships and closed loops in data model development in Qlik
- Worked with bulk volumes of data and extracted them from various sources like excel, Oracle, SQL Server through ODBC and OLEDB connections
- Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (SQL-Server, Oracle, Flat files, Excel, CSV, QVD etc.)
SQL Developer (Intern)
Amara Raja
06.2013 - 12.2013
- Worked extensively on database joins, procedures and involved in improving performance of queries by debugging the joins and datatypes of columns in database tables
- Build and maintain SQL and PLSQL Scripts, indexes, complex queries for data analysis and extraction
- Created complex SQL Scripts in development process
- Tested SQL Scripts and worked on tuning and performance monitoring
Education
Master of Science - Management Information Systems
University of Houston Clear-Lake
Houston, TX08.2015
Skills
- TECHNICAL SKILLS:
- Query Languages :SQL, PLSQL
- Database Query Language : Oracle, My SQL, SQL Server, PostgreSQL, IntelliJ
- Data Modelling : Normalization Techniques, Star and Snow flake schemas
- Networking : CCNA Certification
- Operating Systems : Windows, Unix, Linux
- Front end Development : HTML, CSS, Java Script (Qlik Extensions)
- Programming : Python
- Development Tools :
- SQL Developer, Toad, Pgadmin
- Data Sources : Apptio, ServiceNow, JIRA, Share point, Salesforce, Excel, csv files , SAP HANA Views, Impala, Snowflake Cloud
- Reporting Tools : QlikView, QlikSense, Power BI
- ETL : ODI, Qlik Replicate
- Project Implementation : Agile Methodology
Timeline
Sr. BI Developer/Data Analyst
Credit Suisse
04.2021 - Current
Sr. BI Developer/Data Analyst
T.Rowe Price
09.2020 - 04.2021
Sr. BI Developer
Sanofi
03.2020 - 08.2020
Qlik Developer
CSL Behring
06.2019 - 03.2020
QlikSense Developer
T.Rowe Price
05.2017 - 05.2019
QlikView/QlikSense Developer
Natera
09.2016 - 04.2017
Qlik Developer
Vertex Analytics
03.2014 - 03.2016
SQL Developer (Intern)
Amara Raja
06.2013 - 12.2013
Master of Science - Management Information Systems
University of Houston Clear-Lake
Similar Profiles
Helder RibeiroHelder Ribeiro
Senior Production Support Analyst at Credit SuisseSenior Production Support Analyst at Credit Suisse
Imran ShaikhImran Shaikh
Securities Operations !! Account Closure Service at Credit SuisseSecurities Operations !! Account Closure Service at Credit Suisse
Mohan LakshmananMohan Lakshmanan
Control and Integration (C&I) APAC Support Lead at Credit SuisseControl and Integration (C&I) APAC Support Lead at Credit Suisse
LAUREN MCANANYLAUREN MCANANY
Supervisory Analyst, VP at Credit SuisseSupervisory Analyst, VP at Credit Suisse
Sarah Hope FitchSarah Hope Fitch
CCR Teacher (Literacy Focus) at Fred J. Carnage Middle SchoolCCR Teacher (Literacy Focus) at Fred J. Carnage Middle School