Pujitha Penugonda
Manchester,MO
Summary
Over 8 Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL/Business Intelligence Developer with expertise in SQL Server Integration Services, Analytics, Reporting and Self Service BI
Overview
7
7
years of professional experience
Work History
Senior SQL Developer
Delta Airlines
04.2022 - Current
- Defining project scope, plans, and deliverables, including proposed implementation dates
- Researching, analyzing, recommending, and implementing modern technologies, standard processes, tools, and techniques
- Assisting in defining alternative solutions for business problems
- Participating in standard business and technical information technology solution implementations, upgrades, enhancements, and conversions
- Uses appropriate tools to analyze, identify, and resolve business and/or technical problems
- Working on systems based on core technologies, Development (Niche) refers to niche technologies such as ecommerce systems and Specialty Development in Delta terminology refers to Mobility and TPF
- Constructing, evaluating, and implementing portions of business and technical information technology solutions through application of appropriate software development life cycle methodology
- Applying specialized knowledge in a single discipline such as assembly/integration, cross- discipline functions, knowledge engineering, industry expertise, or legacy evolution
- Interacting with the customer to gain an understanding of the business environment and technical context
- Writing SQL queries in updating tickets, coupons, and agreements data and works on quarterly processing for various countries and generates various kinds of share gap, Vol share reports using Hyperion tool
- Analyzing and updating SSIS packages to meet the customer needs
- Creating Linux scripts to automate ARC related processes and schedules the scripts to run on different schedules like weekly, daily, monthly etc
- Using Control M jobs
- Involved in various EET regression processes to evaluate the exhibits creation automation process using LWC mode and updating the UFT scripts accordingly
- Maintaining and running the SQL Agents jobs to refresh the agreements and build performance for various accounts and countries and works in regenerating and reprocessing the payments when needed for specific accounts
- Updates the existing GSIS packages, procedures and tables based on customers’ requirements
- Creates various reports using Salesforce for different countries like NAM, MX and Canada
- Creating ETL packages (SSIS) helping in migrating data from different sources (Oracle, files, SQL) and updating the current servers/ tables in SSMS
- Populating datasets using SQL queries involving joins, sub queries in Teradata environment on the customer’s data
- Worked extensively with SSIS to import, export and transform the data from different data sources like XML, Text Tables, Oracle, SQL profilers
- Worked with various SSIS control flow tasks and data transformation tasks like data conversion, derived column, look-up, and fuzzy look-up, conditional split etc
- As part of ET Created checkpoints and configuration files in SSIS packages.
SQL BI Analyst
Molina Health Care
04.2020 - 03.2022
- Develop ad-hoc reports using MS SQL Server, SQL Reporting Services, SQL Server Integration Services and Power BI
- Solid understanding of relational database, modeling concepts and Power BI Dashboard Reporting
- Understands how to prioritize reports according to business need, regulatory requirements, urgency and / or other key business factors
- Coordinates data and analyses from MHI and / or Health Plans as needed
- Modifies reports in response to error identification and / or approved change requests; understand the balance between responsiveness to business requests for enhancements versus department needs to complete work efficiently and timely
- Analyzing, requirements gathering, documentations, coding like stored procedures and packages, Query optimizing, testing, bug fixing, designing reports using SSRS and SQL server 2005
- Writing SQL server stored procedures and create / maintain SQL Server Development Database objects in the data warehousing environment
- Conduct data mapping, design, develop, and implement extract / transform / load processes using custom ETL based on SSIS technology
- Help Optimization of queries and performance tuning to make the queries run fast from tables with millions of records using PL/SQL codes
- Creating adhoc reports and automate reports as and when needed using SSRS and Power BI Participated in team meetings and got involved in technical design/ planning of middle ware database to combine data from various sources
- Created various complex Map Chart, Cross tab Reports and Chart Reports
- Developed multiple tabular and combination charts
- Extracted, compiled and tracked data, and analyzed data to generate reports
- Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions
- Established Database Connection and Created Dashboard file (DXP) in Spotfire Server
- Responsible for developing business centric reports, dashboards, data requests, metrics, and other tools using the Microsoft Business Intelligence framework
- Represent the department in fostering and developing relationships with other business units requesting business intelligence services
- SSAS, SSIS and SSRS Develop data extraction, write SQL queries, stored procedures, and packages, and manage data integrity for the data used in the reporting projects
- Working on migrating SQL code to Data Lake Impala
- Creating dynamic SQL parameters in SSRS when using Data Lake as a source
- Working on importing data into data lake sandbox and Queried both Managed and External tables created by Hive using Impala
- I have work experience in various kinds of data sources such as Teradata and Oracle
- Successfully loaded files to HDFS from Teradata and loaded files from hdfs to hive and impala.
SQL Server BI Developer
HCSC
02.2019 - 03.2020
- Involved with business analysts in creating/reviewing business requirement documents Involved in creation/review of functional requirement specifications and supporting documents for business systems
- Created tables for loading Provider and claim data in SQL server 2016 Developed high performance views/ stored procedures for generating extracts for Provider and Claim data
- Developed new ETL architecture for loading data using SSIS instead of Data Stage Developed various SSIS packages for loading the Provider, Claims and Membership data into a data warehouse
- Created complex Packages in SSIS 2016 as part of automating the extract Process
- The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split and Data Conversion
- Reviewed & Tested packages, fixing bugs (if any) using SSDT 2016
- Generated different SSRS reports for different providers and provided subscriptions on daily, weekly, Bi-weekly, monthly, Quarterly and yearly basis Established connection between Spotfire and Tibco Data Virtualization to utilize AccelQ API’s
- Integrated stored procedures with Spotfire to create a unique selection of columns for report
- Used SQL Azure extensively for database needs in various applications Loading Data into different environments based upon the requests
- Analyzed the data models to document the tables & their relationships
- Worked on different data sources (xml source, excel, csv, flat file, web service) to pull, parse and load data into client servers
- Optimized SQL queries and procedures for efficiency and to reduce time duration of data load
- Created the store procedures and Data Modeling to back up the production data
- Create database objects such as tables, views, stored procedures, Triggers, User Defined Functions, linked server queries for extracts from db2 and MySQL
- Created the SSIS package to filter the physician data according to Vendors and Hospital Management requirement
- Also created the SSRS package to generate the Reports for Financial team.
MS SQL Server (SSIS/SSRS) Developer
FEDEX WHQ
07.2017 - 01.2019
- Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
- Created SQL Server Reports based on the requirements using SSRS 2012,2014 Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements
- Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database
- Experience in creating XML files by designing the SSIS packages and SQL server
- Developed reports and deployed them on server using SQL Server Reporting Services (SSRS)
- Troubleshooting performance issues and fine-tuning queries and stored procedures Worked on OLAP Data warehouse, Model, Design, and Implementation
- Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement
- Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture
- Created multiple reports with drop down menu option having complex groupings within the report
- Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
- Experience in creating complex SSIS packages using proper control and data flow elements
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports
- Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers Querying and manipulating multidimensional cube data through MDX Scripting in SSAS
- Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2/2008 (SSAS) Scheduling the SSIS packages and Jobs
- Worked very closely with Business Customers, End Users and resolved any business process related issues
- Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse
- Periodically developed a Report to be used by the Senior Management utilizing SSRS
- Developed SAS Macros for data cleaning, reporting and to support routine
- Develop and Debug T-SQL scripts in a complex relational database system (RDBMS)
- Worked on Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 by using MDX And generated the Reports using SSRS and Power BI tools for vendors
- Built the whole new Data Base with table’s, views, triggers, indexes and store procedures to avoid the use of Access Data Base
- And created the SSIS package to send the data to vendors
- Created the optimized SQL query’s to get the data from DWHS to avoid the use of Adhocs
- Worked on the optimization and performance tuning of SQL Server using Profiler
Education
Master's - Computer Science
Governors State University
Chicago, IL05.2017
Bachelors - Computer Science
JNTUH
Hyderabad06.2013
Skills
- Power BI /DAX/MDX
- PL-SQL/T-SQL
- SSIS/SSRS
- GitHub
- SQL Query Analyzer/SQL Profiler
- Toad/Hue
- Linux
Timeline
Senior SQL Developer
Delta Airlines
04.2022 - Current
SQL BI Analyst
Molina Health Care
04.2020 - 03.2022
SQL Server BI Developer
HCSC
02.2019 - 03.2020
MS SQL Server (SSIS/SSRS) Developer
FEDEX WHQ
07.2017 - 01.2019
Master's - Computer Science
Governors State University
Bachelors - Computer Science
JNTUH
Similar Profiles
ROHBIN JOLIZ IDECHONGROHBIN JOLIZ IDECHONG
Customer Service Supervisor at Delta Global Services, Delta AirlinesCustomer Service Supervisor at Delta Global Services, Delta Airlines
Khadijah DanielKhadijah Daniel
Special Assignment Flight Attendant (SAFA) at Endeavor Airlines (Wholly Owned By Delta Airlines)Special Assignment Flight Attendant (SAFA) at Endeavor Airlines (Wholly Owned By Delta Airlines)
Kimberly AllenKimberly Allen
Csa Agent at Delta AirlinesCsa Agent at Delta Airlines