PHANI CHALLA
Summary
To leverage 11+ years of expertise in software engineering and data-driven solutions to design scalable applications, lead cross-functional teams, and drive innovation that aligns technology with business growth.
Overview
12
12
years of professional experience
Work History
Tech Lead
Infinite Computer Solutions
09.2023 - Current
- The data mart feature to create silver and gold layer data marts in the Enterprise Data Platform (EDP) using Databricks. At a high level, an ADF pipeline called Master_PrepareDatamart Databricks is run using an Event Trigger that represents a set of SQL scripts to be run to populate one or more target tables. Masking will be performed while Data refresh from PROD to non-PROD Environment as well as while ingesting inbound data.
- Responsibilities:
- Perform data cleaning & transformations by using Pyspark and ADF.
- Processing the data by using the PySpark.
- Writing complex queries by using SQL, handling performance issues.
- Creating data pipe lines with SSIS & ADF.
- Creating reports & dashboards with power BI, Python.
- Perform complex python code for Data cleaning & transformations from very diverse unstructured data APIs and aggregate to datamart and database.
- Working on DAX queries to create report.
- Maintain the application with responsive with the screen adjustments.
- Monitoring the application logs by using Data log.
- Used the CI/CD tools like git, github, docker container.
- Environment: Azure SQL, ADF, Azure Dev-ops, Azure Data Bricks, Python, Pyspark, MS SQL 2018, SSIS, SSAS, Power BI, Erwin, DAX, MDX, Snowflake, Mongo DB, Git, PostgreSQL, C#.Net.
Deputy Manager
Deloitte
01.2022 - 10.2023
- Foreign portfolio investment or FPI is a form of investment wherein foreign investors make investments in capital markets. These investments could include stocks, derivatives, bonds, exchange traded funds (ETFs), mutual funds, units of business trust or any other securities. The investors can be trusts, partnerships, body of individuals, association of persons, companies, or even Government in International countries.
- Responsibilities:
- Perform Data cleaning & transformations by using python and ADF.
- Writing complex queries by using SQL, handling performance issues.
- Creating data pipe lines with SSIS & ADF.
- Creating reports & dashboards with power BI, Python.
- Perform complex python code for Data cleaning & transformations from very diverse unstructured data APIs and aggregate to datamart and database.
- Working on DAX queries to create report.
- Maintain the application with responsive with the screen adjustments.
- Monitoring the application logs by using Data log.
- Used the CI/CD tools like git, github, docker container.
- Involved in writing Store procedures, functions, CTE’s as per business logic in MSSQL DB.
- Actively participating in the business meetings to get brief idea about the DB requirements.
- Moving the data from Data base to reporting DB by using SSIS Packages.
- Responsible for creating and managing the SSIS packages.
- Improving the performance of DB by using Query performance techniques.
- Involved in Design of Extract, Transform and Load functionality from Database and loaded the data from database to flat files by applying different transformations in PACKAGES by using SSIS.
- Used SSIS (ETL) features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints, and protection levels.
- Involved in the creating & maintaining reports by using power bi reporting tool.
- Troubleshooting database issues related to performance, queries, store procedures.
- Environment: Azure SQL, ADF, Erwin, Azure Dev-ops, Azure Data Bricks, Python, Pyspark, Flask, MS SQL 2018, SSIS, SSAS, Power BI, DAX, MDX, Snowflake, Mongo DB, Git, PostgreSQL, C#.Net.
Sr. Software Developer
CGI
10.2018 - 12.2021
- RSS (Rebate Sharing System) is one of application that handles the Claims information, which raised by the insurance clients. RSS system calculates the sharing amount based on their contracts and generates the reports into clients.
- Responsibilities:
- Provide dashboard visualization, KPI’s to clients.
- Using the DAX queries while prepare the dashboards.
- Managing the dashboards, cubes & SSIS packages.
- Cleaning the data using python libraries.
- Create reports based on client requirements by using SSRS and power bi.
- Gathering requirements from clients for designing the crystal reports and dashboards.
- Maintaining the ETL jobs without any issues, designing the ETL jobs based on application requirement.
- Actively participating in the team meetings.
- Handling the application with minor support from teammates
- Provide reports to customers on monthly, weekly, daily basis.
- If any modifications happened in up streams, analysis the impact on lower ends.
- Create reports based on client requirements by using crystal reports and power bi.
- Provide dashboard visualization, KPI’s to clients. Providing the weekly, monthly & daily reports to clients through SAP Crystal report BOE.
- Gathering requirements from clients for designing the crystal reports and dashboards.
- Maintaining the ETL jobs without any issues, designing the ETL jobs based on application requirement.
- Loading the data from web API to database server through c#.net code in project
- Environment: Azure SQL, ADF, DAX, Tabular Cubes,Azure Dev-ops, Azure Data Bricks, Erwin, Python, SSIS, SQL Server, SSRS, REST API, Power-BI, Django, MDX, Snowflake, Mongo DB,C#.Net, Oracle.
Sr. Software Developer
HPE
02.2018 - 10.2018
- Responsibilities:
- Handling the data and creating data pipelines using the Azure Data Factory.
- Designed the verity of charts like column charts, column stacked charts, pie charts, donut charts, ribbon charts, table charts, card, slicer etc
- Analyzed data by creating simple SQL queries and identified fact and dimension tables.
- Designed mapping using various transformations such as source qualifier, expression, joiner, sorter, union, etc.
- Performed data analysis primarily Identifying data sets, source data, source meta data, data definitions and data formats.
- Designed Physical and Logical Data model and Data flow diagrams.
- Designed, constructed, and tested ETL processes. Created SSIS packages to extract data from the transnational and/or operational databases, transformed the data according to analytical / reporting business needs, and loaded the data into a data warehouse or data mart.
- Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
- Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
- Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using SQL Server Integration Services (SSIS)
- Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
- Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
- Environment: ADF, Flask, Erwin, Power BI, Python, Pyspark,MS SQL Server 2012/2014, SQL server Integration services (SSIS), SQL server Reporting services, SQL server Analysis Services (SSAS), Azure, Windows 2008 Server.
Software Developer
HCL
04.2016 - 02.2018
- Responsibilities:
- Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
- Involved in designing database using MS Visio.
- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
- Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
- Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
- Responsible for creating SQL datasets for power BI and Ad-hoc Reports.
- Expert on creating multiple kind of power BI Reports and Dashboards.
- Created, Maintained & scheduled various reports in power BI like Tabular Reports.
- Environment: Power BI, Azure SQL, Azure Blob, MS SQL Server 2008/2012, TSQL, PL/SQL, MS Visio, SSRS, SSAS, SSIS, T-SQL, Visual Studio 2008, Crystal Reports 6.1.0 API, ADF, Python, Pyspark.
Software Developer
In4suite
08.2015 - 04.2016
- Client: Real estate’s Clients (RMZ, Indiabulls, magic-brics, Shobha)
- In4Suite (pronounce info-suite) is our core product platform that combines a group of integrated modules that together provide a comprehensive and complete solution for the end users. While the entire package can be purchased and used in its entirety, our solution can also be bought and run in components or modules which can be added on as a plug-and-play architecture. ADC (Application Development Center) is a team which deals with client new requirements and enhancements. After all testing and development merge with production. Yearly it releases four versions to productions.
- Preparing Technical Documents (TDs) based on the Functional Documents (FDs) which is giving by designers for SQL, SSRS, SSAS, and MDX.
- Identifying the database tables for defining the queries for the reports.
- Creating Unit test documents for packages and reports.
- As per the requirements developing the reports using SQL Server 2012 Reporting services.
- Used various report items like tables, list, images and charts to develop the reports by using SSRS like table reports, drill through, drill down, sub reports, cascaded reports.
- Deployed the reports into Report Manager.
- Worked with various Delivery mechanisms of Reports including PDF/Excel etc.
- Solved the defects related to reports after Client verification.
- Creating and modifying the cubes and converting cubes from 2008r2 server to 2012.
- Good skills in Integration of various Data Sources like MS Excel, Flat Files, Different Database Sources and Other Sources into the Staging Area.
- Worked with various tasks such as Control Flow (Execute Sql task, Foreachloop container, Data Flow task, File System etc...) and transformations such as Sort, Lookup, conditional split, Multicast, Aggregate, derived column etc.
- Environment: MS SQL Server 2008/2012, TSQL, PL/SQL, SSRS, SSAS, SSIS, T-SQL, Visual Studio 2008, Crystal Reports 6.1.0 API.
Software Developer
Karvy
10.2013 - 07.2015
- Project: K-BOLT Application
- Client: Mutual Funds Clients (CANARA, LIC, AXA, Reliance)
- K-BOLT is a one application which is interfaced between the AMC and Mutual Fund investor that is done by the Karvy Branches online transactions. KBOLT is a full featured application for all ISC needs. You can use this to enter mutual fund applications, print account statements, get various reports or just query investor data. KBOLT has a subscription service for account statements, frequently used reports that enable ISC to setup an auto mail and get the frequently needed information to their desktops at the time they need it. KBOLT has host of transaction/MIS reports ranging from simple DTR to other complex reports like inflow/outflow report. KBOLT’s management console empowers head office executives and account to monitor the nationwide fund/transaction activity.
- Responsibilities:
- UI Designing
- Used 3-tier architecture for presentation layer, the Business and Data Access Layers and were designed and coded using C#.
- Developed Web Forms and web services using C# and ASP.NET.
- Perform different type of update, insert, join operations.
- Use the Query pro-filer & Query Optimizer to improve the performance of DB’s.
- Create and managing the jobs by Sql Server Agent.
- Manage the daily replication data by using ssis packages.
- Work on different types of transformation techniques in data flow task level & tasks in control flow level.
- Implemented the Logging, Error handling, and Package configuration techniques.
- Experience in generating different types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
- Environment: MS SQL Server 2008/2012, TSQL, PL/SQL, MS Visio, SSRS, SSIS, T-SQL, Visual Studio 2008, C#.Net, Asp.Net, CSS, HTML, Java Script, Jquery.
Education
Master's of Technology - Computers
Bachelor of Technology - Computers
Skills
- Good experience in working with Azure SQL, ADF & Azure Data Bricks
- Good hands on in writing complex logic with Python language
- Handling the data, cleaning, computation using the Pyspark
- Explore data in a variety of ways and across multiple visualizations using power BI
- Excellent back-end skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, User Defined Data-Types, Change Data Capture (CDC)
- Experience in writing complex Stored Procedures, Indexed Views and Triggers for data consistency and manipulation
- Working experience on data transformation (SSIS), Data Cleansing, Data Scrubbing and Data Migration
- Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization, Fact Tables and Tuning
- Good knowledge on snowflake cloud data warehouse
- Experience using performance optimization tools like Database Engine Tuning Advisor, SQL Profiler, and Index Tuning Wizard
- Experience with C# and VBNet scripting when using SSIS packages
- Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technologies of Analysis services
- Created stored procedures to build the Fact tables in the data mart for multi-Dimensional analysis
- Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Drill Down, Drill Through, Parameterized and Cascaded reports Working knowledge of Tableau
- Good experience in Creating, Populating, and maintaining Data marts Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts
Languages
English
Professional Working
Hindi
Limited Working
Telugu
Native or Bilingual
German
Limited Working
Timeline
Tech Lead
Infinite Computer Solutions
09.2023 - Current
Deputy Manager
Deloitte
01.2022 - 10.2023
Sr. Software Developer
CGI
10.2018 - 12.2021
Sr. Software Developer
HPE
02.2018 - 10.2018
Software Developer
HCL
04.2016 - 02.2018
Software Developer
In4suite
08.2015 - 04.2016
Software Developer
Karvy
10.2013 - 07.2015
Bachelor of Technology - Computers
Master's of Technology - Computers
Similar Profiles
Jessica FrazierJessica Frazier
Professional Test Engineer at Infinite Computer SolutionsProfessional Test Engineer at Infinite Computer Solutions
Ommi Ashok KumarOmmi Ashok Kumar
Senior Executive to Associate Executive(Technical) at Infinite Computer SolutionsSenior Executive to Associate Executive(Technical) at Infinite Computer Solutions
Karthik BonuKarthik Bonu
Senior Project Manager at Infinite Computer SolutionsSenior Project Manager at Infinite Computer Solutions
R. KarthickR. Karthick
Technical Lead at Verizon Connect Payroll of Infinite Computer Solutions (India) LimitedTechnical Lead at Verizon Connect Payroll of Infinite Computer Solutions (India) Limited
Pratyasa AdhikariPratyasa Adhikari
Tech Lead at CapegeminiTech Lead at Capegemini