Production Support Project Management
Resume:
Rama Pendikatla
Email: **********@*****.*** Mobile: +1-609-***-****
SUMMARY
•Proficient in the end-to-end process of gathering Business Requirements, Analysis, Design, Development, and Implementation.
•Expertise in Designing, implementing complex SQL queries and databases, with a focus on development.
•Skilled in Developing PL/SQL procedures, views, triggers, and schedulers to meet the specific needs of projects.
•Developed and enhanced triggers, packages, functions, views, and stored procedures to enable seamless integration with APIs and enhance user interface functionality.
•Improved query performance by employing optimization techniques such as Indexes and leveraging advanced features like CTEs (Common Table Expressions) and Global Temporary Tables.
•Developed Unix/SQL scripts to generate file feeds for projects, adhering to strict timelines.
•Assisted in data migration to new systems through comprehensive database validation, including reconciliation efforts.
•Well-versed in Agile methodologies, contributing to estimation and delivery processes within Agile lifecycle projects.
•Experienced in utilizing Jira tool for project management and tracking.
•Exhibits strong analytical, logical, communication, and problem-solving skills.
•Demonstrates a proactive approach to learning new technologies through self-study initiatives.
•Responsible for fulfilling L1/L2 and L3 Production Support.
IT SKILLS
Programming: SQL, PL/SQL, XML, JSON, Java
Databases: Oracle, PostgreSQL, Microsoft SQL Server, Microsoft Access
Database Tools: DBeaver, SQL Developer, PgAdmin
Data & Visualization: IBM Infosphere DataStage, SSIS
Reporting: QlikView, Tableau
Web Technologies: API Testing, Web Services, Postman
Project Methodologies: Agile, Waterfall
Domains: Banking, Telecom, Finance
AWARDS, ACHIEVEMENTS & TRAININGS
Awards:
Rise Gracias - Infosys Limited
Insta Award – Infosys Limited
PROFESSIONAL EXPERIENCE
Client: Verizon, TX Duration: Dec 2022 – Till Date
Role: Technology Lead (Infosys)
Project: Connect Modernization
Responsibilities:
Lead team for the migration of Subscriber Data from Oracle to PostgreSQL
Responsible for development of Oracle queries into PostgreSQL queries as per requirements and mapping sheets.
Developed Unix shell scripts and database queries based on mapping sheets and specifications.
Optimized several queries and fine-tuning of long running queries utilizing CTEs (Common Table Expressions) and Global Temporary Tables
Responsible for development of File feeds using Unix Scripts.
Well versed with writing SQL queries, JOINS, Hierarchical queries.
Created Views, procedures and triggers to support API functionality.
Created Database Constraints as part of Database Migration to PostgreSQL using SQL queries.
Responsible for Development, Maintenance and Production Support for File Feeds.
Responsible for Monitoring Feeds, Dashboards, Unix Shell Scripts on CRON.
Generated one-time reports using SQL to fulfill specific project requirements.
Document RCA for Incidents and maintained Tracker for all production issues.
Client: Verizon, Tampa, FL. Duration: Jan 2021 – Dec 2022
Role: Technology Lead (Infosys)
Project: Fiber Reporting
Responsibilities:
Involved in gathering requirements from end users, involved in modifying various technical and functional specifications.
Responsible for development of tables, views, stored procedures, triggers, and schedulers.
Handled and Effectively Communicated Multiple teams as part of Story Development.
Worked on several development user stories and tech spikes.
Improved performance for Various Stored Procedures, Views and API’s using SQL optimizer and Global temp / CTE tables.
Developed and Maintained various Java services/API’s using Controller, Service and Dao Classes.
Created new schedulers and worked with DBA to resolve various production issues and optimized several procedures.
Responsible for developing one-time reports using complex SQL and excels.
Coordinated and validated various production deployments and patching from Application team.
Responsible for Development, Maintenance and Production Support for Reporting application.
Lead team and proposed ideas to improve application usability.
Resolved Incidents and worked on Production support for Fiber Reporting application and other applications.
Experience in Incident Management, Incident Resolution and on call Production Support.
Client: Fremont Bank, San Francisco, CA. Duration: Oct 2019 – Dec 2020
Role: Software Engineer
Responsibilities:
Involved in gathering requirements from end users, involved in modifying various technical and functional specifications.
Responsible for making reports using Tableau desktop, Teradata according to the user’s requirements.
Responsible for maintaining reports in Tableau server, entity relational data modeling, giving appropriate access to users monitoring performances.
Developed restricted user access to Tableau reports according to the users’ requirements at worksheet level.
Developed different visualizations using bars, lines, scatter plots, bubbles and histograms based on the requirements.
Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server.
Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
Involved in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling of Tableau application.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
Developed different strategies for improving the performance of Tableau reports.
Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
Worked on loading excel files into the SQL server database using the SQL server integration services.
Worked on grouping to rollup products to their specific lines of business for reporting.
Responsible for validating the database, writing queries and getting appropriate data for reports.
Worked on making metadata tables to load the excel files into the SQL server database using Stored Procedures.
Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
Client: Budco Financial, Detroit, MI. Duration: Aug 2018 – Sep 2019
Role: Software Engineer
Responsibilities:
Interacted with stakeholders to understand the business objectives and gather functional requirements.
Created interactive dashboards using Actions, Quick filters, Hierarchy (drill down) and Parameters.
Helped identify trends, correlation and patterns in complex data using data mining in tableau.
Connected multiple data sources using data blending, unions and joins in tableau.
Proficient with restructuring data using data interpreter, pivot, custom split, changing data type and names of columns.
Published secured workbooks by creating user filters so that only appropriate teams can view reports.
Excellent understanding of Data modeling (Dimensional and Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.
Worked on Tableau administration tasks such setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
Administered user, user groups, and scheduled instances for reports in Tableau.
Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
Worked on Tableau Desktop, by creating Complex reports & Dashboards.
Created Tableau scorecards, dashboards, Heat maps using show me functionality.
Created procedures to ensure the quality, usability and accuracy of reports.
Created Packages to group logically related column types and to transfer data.
Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
Validated tableau reports by writing SQL queries and comparing them to results from DB.
Worked on Agile methodologies.
Scheduling the monthly/weekly/daily reports to run automatically.
Client: The Home Depot, Atlanta, GA. Duration: Apr 2017 – Jul 2018
Role: Software Engineer
Responsibilities:
Collaborated with business partners, developers and cross functional teams in gathering business and user requirements.
Creation of workbooks and dashboards those are accessible on different environments like any OS or any browser and a tablet.
Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
Administered user, user groups, and scheduled instances for reports in Tableau Server.
Effective story board development conveying the story in transparent manner to the users.
Responsible for generating dashboards in Tableau Server using different data sources including Excel, Oracle and Microsoft SQL Server.
Involved in publishing various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
Involved in conducting training to users on interacting, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports and Dashboards.
Used excel sheet, flat files, CSV files to generate Tableau Ad hoc reports.
Created Complex workbooks and Dashboards by connecting to multiple data sources (Teradata) using data blending.
Published Tableau dashboards on to server, administered user groups and provided production support for tableau users.
Ability to work quickly and under tight delivery deadlines with focus on details.
Company: Technocrat Technologies, India. Duration: Aug 2015 – Mar 2017
Role: Software Engineer
Responsibilities:
Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
Administered Tableau servers and involved in POC project for mortgage business unit.
In charge of all the support for the tools.
In charge of the team that built the shared Tableau Platform over the virtual environment.
Working with User for requirements and part of the team developing the software.
Created Backup scripts to take periodic backups for the content on Tableau server.
Defined group level security standards for Tableau.
Designed the strategy for Automated Software Delivery through Silent install for Tableau.
Worked on Tableau, Dashboard and report development team under performance management.
Worked closely with Health care business team and lead the HAIR Reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.
Took some sessions for the employees coaching them in Tableau development.
Worked on the backend SSAS cube development which was the source data for the tableau.
Responsible for writing complete requirement documents by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
Training sessions for the employees on the tools.
Contact this candidate