Siva Ponnapati

(ad3478@r.postjobfree.com)

Contact: +1-910-***-**** / +91-901-***-****

LinkedIn: www.linkedin.com/in/siva-ponnapati-4862a866

SUMMARY

Over 15+ years of Professional experience in IT Industry Delivered BI & Data Warehouse Solutions across Supply chain, Retail, HR, Banking, and Financial Services.

Responsible for allocating and managing resources within a project. This includes human resources, equipment, and budgeting. Collaborate with project business analysts, and stakeholders to understand project requirements. Analyze the scope of the IT project, including deliverables, timelines, and resource needs.

Identify and list all the potential costs associated with the project, such as hardware, software, personnel, training, and external services.

Ability to articulate ideas clearly. Approach to decision-making and effective decisions. Resolving conflicts within the team. Ability to delegate tasks effectively. Identifying and solving problems. Setting clear goals for the team. Monitoring progress and making adjustments as necessary. Building team and collaboration. Flexibility in adapting to changes. Handling unforeseen challenges. Prioritizing tasks and projects. Ensuring deadlines are met. Willingness to learn and adapt. Encouraging a culture of continuous improvement within the team. Handling crises and high-pressure situations. Maintaining composure and leading the team through challenges.

Major responsibilities include Acting as the key interface between the users and the project manager they gather information, document processes, evaluating business processes, anticipating requirements, Leading ongoing reviews of business processes and developing optimization strategies. Conducting meetings and presentations to share ideas and findings. Performing requirements analysis. Documenting and communicating the results of your efforts. Comprehensive understanding of cloud infrastructure management, security, and optimization.

Coordinating with users & understanding business requirements, functional/Business analysis, creating documents and translates business reporting requirements into technical design and solution. Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Experienced in full lifecycle of data warehouse delivery including analysis, design, dimensional modeling, development, testing, implementation, training and support

Involved in cloud infrastructure management, security, and optimization’s Developer background in designing, implementing, and maintaining cloud-based applications. Involved and maintained applications hosted on AWS EC2 instances, utilizing various AWS services. Monitoring and Logging (S3,CloudWatch, CloudTrail). Implemented and optimized database solutions on AWS RDS. Good Understanding including identity and access management (IAM) configuration. Participated in troubleshooting and resolving issues related to AWS infrastructure and application deployment. Good knowledge in Networking and VPC configuration.

skilled Snowflake developer experience in designing, implementing, and managing data warehousing solutions. Seeking to contribute my expertise in Snowflake architecture, SQL, and ETL processes to a dynamic team. Leda the design and implementation of Snowflake data warehousing solutions. Developed and optimized SQL queries for efficient data retrieval and analysis. Collaborated with cross-functional teams to define data requirements and specifications. Implemented and maintained ETL processes for seamless data integration.

Conducted performance tuning to enhance the overall efficiency of Snowflake databases. Provided technical support and training to internal teams on Snowflake best practices. Collaborated with data architects to design and implement scalable and efficient data models.

Developed and maintained documentation for data warehousing processes and procedures. Participated in code reviews to ensure code quality and adherence to best practices. Conducted regular performance monitoring and tuning activities to ensure efficient database operations.

Implemented and managed security measures, including user access controls and encryption. Established and executed backup and recovery strategies to safeguard critical data.

Participated in the implementation of Tableau Server, ensuring optimal performance and reliability. Developed and maintained documentation for Tableau processes, best practices, and guidelines. Conducted Tableau Server administration tasks, including user management and security settings. Proficient in design and development of various dashboards, reports utilizing visualization and other making use of actions, other according to the end user requirement in creating dashboards with relational and multi-dimensional databases gathering and manipulating data from various sources. Produced attractive visuals/dashboards with Tableau reports.

Administered and maintained Power BI environments, ensuring optimal performance and reliability. Configured and managed Power BI Gateways to facilitate secure data connectivity.

Implemented security measures and access controls for Power BI datasets and reports. Collaborated with business stakeholders to understand data requirements and ensure effective data distribution. Designed and developed data models to support business reporting and analysis. Created and optimized DAX expressions for complex calculations and measures.

Developed visually appealing and insightful reports and dashboards using Power BI. Conducted performance monitoring and tuning activities for Power BI reports and dashboards.

Implemented backup and recovery strategies to safeguard critical Power BI assets. Provided training and support to end-users on Power BI usage and best practices.

Technical hands-on expertise using Business Objects XI 4.x (Designer, CMC, Desktop Intelligence, Web Intelligence and Info View, Import Wizard, Report Conversion tool, Publishing Wizard, CCM

Strong Working knowledge of the CMC and general Admin activities in BO 4.x suite.BI Folder security, user/group security using CMC. Expertise in Planning, Designing, Developing, Distributing and Maintaining BO Universes. Expertise on migration of BI universes and Strong at Resolving Loops / Traps in Universe Development using Contexts and Aliases. Build reports using WEBI, DESKI tools. Monitor and support existing schedules using, use Query builder to analyze report schedules. Investigate and fix production issues related to BI universes and Crystal report. Experienced in Designed reports with complex sub reports, Drill down, Cross Tabs, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label, Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects, Custom Formulas and Custom Functions and building canned reports, multiple tabs, multiple queries on single screen, listed and cross tabs, dash boards, charts,Slice and Dice, Drill Down, Cross Tab, Multiple Table/Section and Master Detail Type reports from Single and Multiple Data Providers etc. in SAP Business Objects reporting tool .

Ability to work independently also a Team player. Ability to Switch New Technologies If required.

EDUCATION: Master’s in computers - Acharya Nagarjuna University INDIA

Technical- Skills:

Data ware housing & ETL : Snowflake, Informatica, Data Stage.

Visualization Tools : Tubule (Desktop, server, Tableau Prep, MDX), Power BI (Desktop, Power BI Service, Power BI

Gateway, DAX, Power Query, M).

BI Tools : SAP Business Objects 4.x(CMC, CCM, UDT, WEBI, DESKI), SAP Crystal Reports 2016/2013/2008,

Microsoft SQL Server Reporting Services (SSRS).

Cloud : AWS EC2, AWS S3, AWS Gule, AWS RDS, AWS Identity and Access Management

AWS (IAM), Networking and VPC configuration, AWS CloudWatch, AWS CloudTrail

Disaster Recovery and Backup Strategies.

Data Governance : Collibra, SAP Master Data Governance, Oracle Enterprise Metadata Management.

Project management : JIRA, Adobe Workfront, Microsoft Sprint Panning.

SDLC : Jira, GitHub.

File management Tools : WinSCP, Putty, Super PUTTY, Tabby, Kitty.

Documentation : Confluence, Click Up, Asana, Smartsheet.

Domaine & General : Supply chain, Retail, HR, Banking, Data Warehousing, Cloud, BI Reporting, Dashboard Design,

Project management, Version Control, Collaboration and Teamwork

EXPERIENCE:

BI Analyst/Data Engineer – Consultant – Nike, Portland-OR

March 2022 –July 2023

Nike, Inc. is an American multinational association that is involved in the design, development, manufacturing and worldwide marketing and sales of apparel, footwear, accessories, equipment and services. The company’s world headquarters are situated near Beaverton, Oregon, in the Portland metropolitan area (USA). It is a major producer of sports equipment and one of the world’s largest suppliers of athletic shoes and apparel.

Scope of the project

Efficient supply chain management involves optimizing these various components to ensure a smooth and cost-effective flow of goods and services. Also addressing challenges such as demand variability, supply chain disruptions, and the need for real-time information to make timely and informed decisions.

Major responsibilities include Acting as the key interface between the users and the project manager they gather information, document processes, evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.

Preparing STM Documentations for Integrated and Aggregated layers based on Curated model for APLA space for Storage & utilization and Shipment.

Understand the Requirements and Functionality of the application from specifications.

contribute my expertise in Snowflake architecture, SQL, and ETL processes to a team. Leda the design and implementation of Snowflake data warehousing.

Developed and optimized SQL queries for efficient data retrieval and analysis.

Collaborated with cross-functional teams to define data requirements and specifications. Implemented and maintained ETL processes for seamless data integration.

Provided technical support and training to internal teams on Snowflake best practices. Collaborated with data architects to design and implement scalable and efficient data models.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Converted existing BO reports to tableau dashboards

Created different KPI using calculated key figures and parameters

Developed Tableau data visualization using Cross tabs, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Utilized Tableau server to publish and share the reports with the business users.

Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.

Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

BI –Consultant – City of Portland, Portland-OR

Jul18 –Jan 2022

Office of Management & Finance the Business Solutions program supports the City goal to deliver efficient, effective, and accountable services as well as the OMF goal to maximize the cost-effective use of technology through the development and delivery of innovative services which allow customers to meet their business.

Scope of the Project:

Collaborate with stakeholders to gather and understand reporting requirements. Define the purpose, audience, and key metrics for the reports. Analyze and extract relevant data from various sources to support reporting needs. Work closely with other team members, such as database administrators, data analysts, and business stakeholders. Document report specifications, data sources, and any relevant information for future reference. Optimize report performance to ensure timely delivery of information. Fine-tune queries and data retrieval processes for efficiency. To deliver accurate, timely, and actionable insights through well-designed and effectively implemented reports. Update reports as business requirements evolve. Implement appropriate access controls for sensitive information.

Involved in Transformed business requirements into functional and nonfunctional requirements.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Developed Tableau data visualization Using Heat maps, Box and Scatter Plots, Geographic Map, Pie Charts and Bar Charts.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Utilized Tableau server to publish and share the reports with the business users.

Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.

Created lot of ad-hoc reports, Charts using Power BI Desktop version for Police Buero. Used Power BI Gateways to keep the dashboards and reports up to date. Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations. Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Proficient in design and development of various dashboards, reports utilizing Power BI visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement, Used DAX Functionality in Power BI for creating the computed tables for Analysis. Publish the dashboards & reports into PBI server to make available to group of Business to access. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Involved in trouble shooting of performance issues which were associated with Power BI reports.

Worked closely with the DBAs, BA team and Marketing team to identify resolve bugs and issues related to the reports. Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating, and publishing reports. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Involved in Develop the Universe and reports by using SAP Business Objects tools.

Exported the ad-hoc ready to make semantic layer available to the users In A7. Troubleshoot errors for reports, dashboards. Fixed them to work as per the business needs. Scheduling the Reports and used Events for Daily/Weekly /Monthly. Extensive testing and migrating the reports or objects from development to Production system.

Design and develop Crystal standard (SAP Crystal Reports 2016 and ad-hoc reports using SQL Server database with specific driver, Handle BI Folder security, user/group security using CMC, Migration of BI universes/Reports and reports using promotion management tool/Export wizard. Monitor and support existing schedules using, use Query builder to analyze report schedules, Investigate and fix production issues related to BI universes and Crystal report

Investigate and fix production issues related to Crystal reports

Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production. Involved into create the Tickets for promoting the reports in One environment to Other Environment. Responsible for deliverables on a project which may include A7 reports as per process defined.

BI- Developer -Capital Group (Infosys)Los Angeles-CA Sep 2016 –Jun 2018

world's oldest and largest investment management organizations, with over $2.6 trillion in assets under management. Founded in Los Angeles, California in 1931, it is privately held and has offices around the globe in the Americas, Asia, Australia and Europe. Capital Group Companies, Inc. The Capital System™ is designed to produce highly diverse portfolios that deliver consistent long-term results, a smoother ride and management continuity over a range of market conditions.

Scope of the Project:

Collaborate with stakeholders to gather and understand reporting requirements data analysts. Define the purpose, audience, and key metrics for the reports. Analyze and extract relevant data from various sources to support reporting needs by using SAP BO and Crystal

Coordinating with users & understanding business requirements, functional/Business analysis, creating documents and translates business reporting requirements into technical design and solution. Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Involved in articulate ideas clearly. Approach to decision-making and effective decisions. Resolving conflicts within the team. Ability to delegate tasks effectively. Identifying and solving problems. Setting clear goals for the team. Monitoring progress and making adjustments as necessary. Building team and collaboration.

Involved in writing stored procedures for MM App Reports using Crystal Reports 2013. Maintaining proper documentation of the reports for future reference. Design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Crystal Reports.

Provided Production support to CRD users and Wrote Custom SQL to support business requirements.

Developed Universes by defining joins, cardinality between tables, creating prompts, applying contexts and alias to resolve loops/traps and checked the integrity of the Universe in Business Objects Universe Designer.

Exported the ad-hoc ready to make semantic layer available to the users In A7. Troubleshoot errors for reports, dashboards. Fixed them to work as per the business needs. Scheduling the Reports and used Events for Daily/Weekly /Monthly. Extensive testing and migrating the reports or objects from development to Production system.

Created derived tables at the Universe level to reduce the complexity of the Universes.

Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

Design and develop Crystal standard SAP Crystal Reports (2008) and ad-hoc reports using SQL Server database with specific driver, Handle BI Folder security, user/group security using CMC,Migration of BI universes and reports using promotion management tool, Monitor and support existing schedules using, use Query builder to analyze report schedules

Investigate and fix production issues related to BI universes and Crystal reportExported the ad-hoc ready universes to making semantic layer available to the users.

Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs. Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports. Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production. Responsible for deliverables on a project which may include CRD reports as per process defined.

SAP Business Objects Developer - Goldman Sachse (Infosys), New York-NY Dec 2013 –Aug 2016

Goldman Sachs Group, Inc. is a leading global investment banking, securities and investment management firm that provides a wide range of financial services to a substantial and diversified client base that includes corporations, financial institutions, governments and individuals.

Scope Of the Project:

Collaborate with stakeholders to gather and understand reporting requirements data analysts. Define the purpose, audience, and key metrics for the reports. Analyze and extract relevant data from various sources to support reporting needs by using SAP BO and Crystal

Working closely with Business team to define BO requirements and documenting the requirements in order to design, develop and maintain BO Reports for HR Team.

Converting Business Requirements into Universe Design Document for reporting.

Designed and developed BO universe Web Intelligence Reports and Dash Boards with different functionalities based on user requirements.

Involved in creation of Web Intelligence Reports with different functionalities like cascading prompts, drill down, linking reports, charts and graphs, ranking and alerts.

Troubleshoot any report design and performance issues. Support end user questions related to reports and universe issues. Involved in Admin related activities to migrate Universe from Development to UAT and Production environments on demand basis and make sure that existing system doesn’t impact.

Provide weekly metrics details to make better decisions to the higher managers.

Contributing to the design, development and maintenance of ongoing metrics, reports analysis dashboards etc. to drive key business decisions. Involved in migrating reports from 3.1 to 4.1 version and make sure that report working properly.

SAP Business Objects Developer Capital One Auto (Infosys) Plano-TX

Dec 2012 –Dec 2013

Capital One Financial Corporation is an American bank holding company specializing in credit cards, auto loans, banking, and savings accounts, headquartered in McLean, Virginia with operations primarily in the United States. It is on the list of largest banks in the United States, is the third largest issuer of Visa and Mastercard credit cards and is one of the largest car finance companies in the United States

Scope of the Project:

Working closely with Business Analysts to define BO requirements and documenting the requirements in order to design, develop and maintain BO Reports.

Creation of Low-level/Technical/Detailed Design documents for Web Intelligence Reports

Make sure that all 4-part keys are in corporate in the SQL as well as in the report level.

Prepare the report requirements to Upstream for data availability in table level

Make sure that the developed report data is matching with the current production report or not. Involved in performance tuning of Crystal and Business Objects Reports.

Set up meeting with the customers to provide the necessary changes in the report for feature usage. Work closely with Data analysts for getting the Sign off for each report. Involved into create the daily tasks for offshore and onsite in Version 1 (Agile methodology).Involved in adhoc requests and involved in report enhancements.

Involved into create the Quotes for promoting the reports in One environment to Other Environment. Responsible for deliverables on a project which may include Crystal 2008 and Web Intelligence reports as per process defined. Supporting the UAT testing.

Offshore Experience - INDIA

Mar 2010 –Nov 2012 Business Objects Report Developer -Capital One Bank -Infosys (Hyderabad)

Jan 2009 – Mar 2010 ETL Developer (DataStage) - Finacle (Product) -Infosys (Hyderabad)

Sep 2008– Dec 2008 Business Objects Report Developer - United Airlines -Infosys (Hyderabad)

Apr 2008– Aug 2008 Business Objects Report Developer - M0TOROLA -Infosys (Hyderabad

Jan 2008– Mar 2008 Business Objects Report Developer - Warner Music Group -Infosys (Hyderabad)

Feb 2005–Dec 2007 ETL Developer (Informatica) - GE (General Electronics) -Patni (Bangalore)

Contact this candidate