Sushma Polavarapu
Glendale,AZ
Summary
Insightful Data Analytics-Technical Manager with 10+ year record of leadership experience in areas such as infrastructure development and management, application support and security optimization. Focused on satisfying customer needs through robust, innovative and forward-thinking solutions. Demonstrated success as operational leader, articulate communicator and practiced influencer. Collaborates across functions to outline and achieve project targets. Skilled in building solid business solutions based on methodologies and engineering principles. Complex problem-solver skilled in developing proposals, integrating technologies and managing projects. Dedicated to creating and delivering initiatives to guide organizational navigation of modern technology. Proven history of successfully translating technical requirements into business solutions. Strong proficiency in SQL and Visualization Tools with passion for utilizing excellent communication to foster company rapport.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Analytics- Technical Manager
Capgemini America Inc
10.2022 - Current
- Progressing skills in Business Analysis, Business Knowledge, Architecture Knowledge, Technical Solution Design and Vendor Management
- Participate in business requirements meetings and data mapping sessions to understand business needs
- Create various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources
- Identify and document project constraints, assumptions, business impacts, risks, and scope exclusions
- Develop database objects, including tables, views, Stored Procedures, and materialized views using MS SQL
- Build library of models and reusable knowledge-based assets to produce consistent and streamlined business intelligence results
- Identify and document detailed business rules and use cases based on requirements analysis
- Anticipate and identify the data gaps, customer pain points, concerns and by using available data from various sources then interprets, analyzes, and presents findings
- Identify single source of truth to understand what information assets are available to help make business decisions for Patrick Industries
- Coming up with a prototype from the requirements gathered and perform data analysis to discover additional requirements
- Interpret and evaluate the business benefit attained because of getting the information or outcome
- Understanding the customer’s existing organization data governance by working closely with the data stewards, SME’s, IT and functional teams to get more on business meaning of the data and their relationship to ensure robust model with high data quality and data integrity
- Validating and updating nearly 200 Spotfire, Greenplum and Redshift objects based on the detailed comparison.
- Developed and implemented data analysis strategies to improve the accuracy of analytics results.
- Maintained and monitored data quality standards across multiple databases.
- Conducted exploratory data analysis, identified trends and created visualizations for insights.
Data Visualization Lead
Capgemini America Inc
05.2022 - 10.2022
- Understanding and evaluating the customer data in terms of Volume, Velocity and Variety to create value to business
- Perform various data mining and data cleansing techniques on the raw data available in MS SQL, Cubes, Access & Power BI analytical tool by coordinating with the Business, Platform & Architecture teams
- Develops complex physical and logical models using POWER BI & SQL Modeler explaining relationship between each entity as per the proposed design derived from available data to help business maintain the enterprise level DW system, which will serve as single source of truth
- Deliver value to the client with Strategy driven Data Model and conceptual-level data dictionary to communicate data requirements with design Proof of concepts
- Creating end-to-end data flow diagrams and data maps to resolve potential data issues to address historical data migration or data integration for each subject area in the organization
- Creating data lineage for the sources in the scope of the engagement and build appropriate relationship to ensure data integrity is maintained
- Identify and implement the key business objectives like HR, Commercial, Supply Chain, Finance and Quality across the business units
- Prepare Blueprint, Data models, data mapping, functional and technical specifications, and GAP analysis documents as per business requirement and taking sign-off from the client.
Data Analyst Lead
Capgemini America Inc
01.2020 - 05.2022
- Led the Baker Hughes Executive Reporting for Digital Solutions business with 32 KPI’s integrated into a single report which helps leadership to understand and drive business in the right direction
- Contribute to Project & Organization based on functional/technological expertise and take delivery ownership and guide individual and groups to desired Outcome; initiate and maintain client relationships; anticipate and identify client issues and concerns
- Established clear and competitive goals, growth roadmaps and strategic business plans
- Deliver value to the client with Strategy driven Data Model and conceptual-level data dictionary to communicate data requirements with design Proof of concepts
- Facilitation on inter-team communication across many agile projects within organizations
- Prepare Blueprint, Data models, data mapping, functional and technical specifications, and GAP analysis documents as per business requirement and taking sign-off from the client
- The solution integrates real-time visibility, advanced analytics, forecast-actual integration possibilities, predictive baseline for performance check and broadcasting mechanism for HR, Commercial, Supply Chain, Finance and Quality using Talend, Greenplum & Tableau tools
- Vast experience in project management techniques and cross functional experience in structured design development and implementation of new computing architectures and as a Programmer, Developer in most advanced technologies like Big Data Management, Tableau, Talend, Greenplum, ThoughtSpot, Power BI with 8+ years’ experience
- Identify and implement the key business objectives like HR, Commercial, Supply Chain, Finance and Quality across the business units
- Develop database objects & reports, including tables, views, materialized views using SQL, ThoughtSpot, Tableau & Power BI Dashboards
- Recommend data standardization and usage for protection of data integrity
- Build library of models and reusable knowledge-based assets to produce consistent and streamlined business intelligence results
- Trained more than 800 users on Tableau, ThoughtSpot and Power BI reports developed
- Flexible with DevOps module on handling both monitoring & enhancements of HR, Commercial, Supply Chain, Finance and Quality Module
- Participate in all SCRUM ceremonies such as Daily Scrum, Retrospective, Planning, reviews, tasks assignments and tracking using RALLY
- Creating end-to-end data flow diagrams and data maps to resolve potential data issues to address historical data migration or data integration for each subject area in the organization
- Building a robust framework of data visualization which will be a single source for performing analytics for all in the organization which includes Executive Dashboards, Project Manager Dashboards, On Field Engineer Dashboards
- Provide critical knowledge transfer on our customized Data warehousing and Advanced Analytic Reporting solutions
- Adhering to SLA for resolving all the tickets/issues raised by following the process of in-depth RCA, Bug fixing, Enhancing Logics and UAT
- Implement solution that delivers real-time and historical visibility of KPIs
- Mentor team members based on my deep knowledge of registered tools and methodologies in Oil & Gas industry
- Presenting weekly and monthly status report to project leaders and key stakeholders
- Transition and provide hyper care support for the new enhancement.
Data Analyst
Capgemini America Inc
11.2018 - 01.2020
- BHGE currently has multiple applications on legacy BI technologies
- The DevOps Model provides a high-quality design solution of advanced new BI technologies like Cloud servers, Greenplum, Talend & Tableau etc
- It will enable to support with Operations, Monitoring and upgrade existing infrastructure to modern infrastructure that helps applications to be robust, secured, and high availability to all regions on AWS Cloud to support management decision-making
- Collecting comprehensive inventory/Metadata of BHGE enterprise data assets across databases, files, web services, reports, screens, and big data systems
- Prepare and update High-Level Topology Design, Functional Design, Convert them into Low-Level Technical Designs, Batch Processing automation and guide developer on development, testing, and implementation activities
- Designing cloud-based architectures with lower upfront cost, improved scalability, and performance the Model that gathers data from a wide range of sources within a BHGE and uses the data to support management decision-making
- Coordination with the offshore team during development and providing technical and functional assistance.
Data Analyst/Technical Lead
Capgemini America Inc
04.2017 - 11.2018
- These are the Tableau dashboards which are developed for GE leaders & Executives to get an overview of the current Overdue Backlog and On Time Delivery metrics spread across different geographical locations and sub businesses
- This Dashboard gauges performance and progress toward business goals
- Effectively evaluate a client’s need and business processes
- Translate, communicate, and document the requirements to the Agreement Express solution
- Communicate solution and requirements to customer and internal team in a brief and clearly expressed manner
- Collaborate with the clients through decision making process and gain consensus to reach sign-off
- Execute and effectively document test to sign off on solution quality
- Provided Tableau Demo Sessions to Business End users.
Tableau Consultant/ Onsite Lead
Capgemini America Inc
01.2017 - 04.2017
- Developing & migrating Tableau reports for businesses of GE Oil and Gas on the Sales order data for the SAP and Oracle strategic ERP’s, based on the client's requirements
- Working as a Team lead & Tableau Developer in the project
- Direct interaction with the client and Users in getting requirements and developing reports with proper analysis
- Developing logics, queries and Jobs as per the requirement
- Tableau Report development - Created Dashboard using List Reports, Cross tab Reports, Bubbles, heat, Pareto & Bar and Line charts
- Preparing the Report Documents and Test case documents
- Validating the reports
- Analysis, Design, coding and unit testing for new request and enhancement activities
- Working on debugging SQL queries and created SQL queries to extract data from database using joins and some analytical functions to display the reports on TABLEAU.
Technical Lead
Capgemini Technology solutions India Limited
10.2014 - 12.2016
- Developing Tableau reports for Measurement and Control business of GE Oil and Gas with Sourcing Data Warehouse as the source and enhance some of the Sourcing reports too, based on the client's requirements
- Working as a Single resource in the project
- Direct interaction with the client and getting requirements and developing reports with proper analysis
- Tableau Report development - Created Dashboard using List Reports, Cross tab Reports, Bar and Line charts
- Preparing the Report Documents and Test case documents
- Validating the reports
- Analysis, Design, coding and unit testing for new request and enhancement activities
- Worked on debugging SQL queries and created SQL queries to extract data from database using joins and some analytical functions to display the reports on TABLEAU.
Senior Software Engineer
Capgemini Technology solutions India Limited
12.2013 - 10.2014
- Sourcing DW and implemented Oracle Pascal system Integration
- Current Scope is to integrate - 35 Source system Applications into Global Sourcing Data warehouse, Tableau environment to be used for Sourcing metrics
- Perform Design to develop ETL Mappings for 45 Sources instances Integrations, Tableau Dashboards and Reports for the below modules: Purchase Orders, Receipts, Invoices, Vendors, Items, Business units/locations, payment terms, buyers, employees
- Tableau Report development - Created Dashboard using List Reports, Cross tab Reports, Bar and Line charts
- Preparing the Report Documents and Test case documents
- Validating the reports
- Analysis, Design, coding and unit testing for new request and enhancement activities
- Worked on debugging PL/SQL queries and created PL/SQL queries to extract data from database using joins and to display the reports on TABLEAU.
Education
Bachelor of Science - Electronics And Communications
SDM College of Engineering And Technology
Dharwad, Karnataka, IndiaSkills
- Client & Stakeholder Relations
- Project Leadership, Planning & Coordination
- Requirements Analysis
- Agile framework
- Product Development
- User Support, Organization and Time Management
- Training and mentoring
- Scrum,Sprint and Retrospection Planning
- Data - Warehousing, Coding, Quality Management , Validation, Migration, Deployment
- Databases - Amazon Redshift, Greenplum, Oracle SQL Developer, MS SQL Server, MS Cubes, IBM DB2
Certification
- Certified “Tableau Desktop Specialist”
- Certified in “Analyzing & Visualizing Data with Microsoft Power BI”
- Certified as “Tableau Certified Associate Consultant”
- Certified as “PL 300- Microsoft Power BI Data Analyst”
Timeline
Data Analytics- Technical Manager
Capgemini America Inc
10.2022 - Current
Data Visualization Lead
Capgemini America Inc
05.2022 - 10.2022
Data Analyst Lead
Capgemini America Inc
01.2020 - 05.2022
Data Analyst
Capgemini America Inc
11.2018 - 01.2020
Data Analyst/Technical Lead
Capgemini America Inc
04.2017 - 11.2018
Tableau Consultant/ Onsite Lead
Capgemini America Inc
01.2017 - 04.2017
Technical Lead
Capgemini Technology solutions India Limited
10.2014 - 12.2016
Senior Software Engineer
Capgemini Technology solutions India Limited
12.2013 - 10.2014
Bachelor of Science - Electronics And Communications
SDM College of Engineering And Technology
Similar Profiles
Amit GandotraAmit Gandotra
Portfolio Manager at Capgemini America IncPortfolio Manager at Capgemini America Inc
BHABANI SHANKAR TRIPATHYBHABANI SHANKAR TRIPATHY
Managing Applications Consultant at Capgemini America IncManaging Applications Consultant at Capgemini America Inc
Ranjeet Ranjeet null
SAP Solution Architect at Capgemini America IncSAP Solution Architect at Capgemini America Inc