Kamaleshwer Peddamalka

Experience

• 

  HSBC

  Sept 2013 - Aug 2015

  SQL MSBI Developer

  • Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.• Worked closely with Business Analysts to produce all required documentation. • Worked with Product Development Team to architect Database Design and strategy. • Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dishoarding requirements • Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.• Created different visualization in Power BI according to the requirements. • Reviewed and fine-tuned stored procedures and triggers before production migration.• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis• Published Power BI reports from Power BI desktop to Power BI service Show less

• 

  Sephora IT

  Oct 2015 - Dec 2017

  SQL Developer/Power BI Developer

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements. • Developed Power BI reports and dashboards from multiple data sources using data blending.• Created Power BI Visualizations and Dashboards as per the requirements.• Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse and OLAP Cube using the entire Microsoft BI Stack with emphasis on, but not limited to SSIS, SSAS, and SSRS. • Configured and maintained Report Manager and Report Server for SSRS.• Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Linked Servers.• Used Try catch and @@error for exceptional handling.• Restricted access to users by creating security roles to access reports in Power BI.• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.• Extracted data from various sources like SQL Server, Oracle, CSV, Excel and Text file from Client FTP servers.• Modifying SSIS packages for business logic enhancements. Writing/modifying VB scripts for sales file moments and data loads. • Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation. • Published Power BI reports from Power BI desktop to Power BI service.• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports. • Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return back in to the cube. Show less

• 

  CareMore Health

  Jan 2018 - Oct 2018

  Sr.SQL Developer/ Power Bi Developer

  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan. • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support. • Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc. • Designed and developed SSIS Packages to import and export data from MS Excel,SQL Server and Flat files. • Worked on Tabular Model and imported it into Power BI.• Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages. • Prepare and Distribute Financial Reports using SSRS to internal and provide recommendations for client’s strategic decision making• Resolve production issues related to the SSRS reports and create ad-hoc financial reports for the clients.• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.• Defined data sets with joins and sub-queries for complex queries involving multiple tables in Power BI.• Used Configuration Files in SSIS to ease the process of moving the packages across servers. • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and PowerMap to visualize reports.• Developed packages in SSIS with error handling. • Created DAX calculated columns in power pivot worksheets to extract, import and join data that coming from different sources.• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations Show less

• 

  Panasonic Avionics Corporation

  Nov 2018 - Mar 2019

  Sr.Power BI Developer

  • Having experience in gathering requirements from Director’s and created the functional documentation using Confluence.• I also have experience in maintaining the reports in power bi services and sharing with another team member in the organization.• Creating row-level security for the visuals and also had experience in scheduling to refresh the data. • I do have the experience in Power bi admin, like creating content packs, how many users are accessing the dashboard, how many users are using power bi Pro license.• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.• Designed and developed Power BI dashboards, Reports and published it on Power BI sites.• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically. • Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation. • Published Power BI reports from Power BI desktop to Power BI service• Used MDX to interact with the back end OLAP Services• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages. • Migration experience with DTS.• Experience in creating reports through PROCLARITY and used PROCLARITY for accessing and analyzing cubes and dimensions.• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging Show less

• 

  Johnson Control

  Apr 2019 - Jan 2020

  Sr. Power Bi/Azure Developer

  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.• Having experience in altrex designer application to pull the data from workday.• I’m directly working with the sales department to communicate their requirements and to collect the requirements.• I also worked on SharePoint to create SharePoint sites. The SharePoint sites are mainly used by our stake holder to update the data for different regions.• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc. • Worked on pulling the data from Jira using Rest Api or third party driver’s. I created visuals for my director’s to measure the performance of the team. • Used power Query editor to pull the data from different sources and created power pivot visuals. • Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations. • Used PowerQuery to acquire data and PowerBI desktop for designing rich visuals• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages. • Good Knowledge on Python and R#. Show less

• 

  Chevron

  Jan 2020 - Jun 2020

  Sr. SQL/ Power Bi/Azure Developer

  • Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.• Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically. • Implemented Performance Tuning and Query Optimization.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging• Expertise in Power BI, Power BI Pro, Power BI Mobile.• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages. • I have experience in various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle.• Created custom visuals using Python and R# which is integrated into Power BI. Show less

• 

  Walmart

  Jun 2020 - Aug 2021

  Sr. Power Bi / Azure Developer

  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan. • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables. • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support. • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to the data warehouse. • Used MDX to interact with the back end OLAP Services• Created Dashboards to present critical company data in a single report.• Created list reports & cross tab reports using Cognos 10.1• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.• I created data pipelines in power bi services to publish the reports in staging like DEV, PROD, Test environments.• I also had a pretty good experience in power bi admin tenant settings, capacity settings, usage metrics, • Experience in using Tableau functionalities for creating different requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts• Developed relations in canvas using latest version Tableau 2020.3 version.• I have experience on working Alteryx tool which is used to do ETL transformations and schedule refresh in Alteryx gallery as well.• I also worked to automate my dataflows from alteryx to Azure data bricks using sparck and push data into Azure Sql Server. Show less

• 

  Fidelity Investments

  Sept 2021 - Mar 2023

  Sr. Power BI Engineer

  • I have experience in designing and implementing snowflake data warehouse and data bases.• I have experience with data integration, data loading and data querying within snowflake.• I’m familiar with snowflake feature and functionality.• I have ability to manage and optimize snowflake performance and scalability.• I worked on snowflake’s snowpipe for Realtime data ingestion.• Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into a Snowflake DW• I also had pretty good experience in power bi admin tenant settings, capacity settings, usage metrics.• I had experience in creating paginated reports in power bi service and I had experience in creating Row-level Security in power bi Desktop • I created data pipelines in power bi services to publish the reports in staging like DEV, PROD, Test environments.• I also main the access permissions in each environment in power bi services for each environment• I have experience in Performance Analyzer to deep dive in slow performance of Power bi reports. We use Dax studio to modify the Dax calculation to improve report performance. • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.• Expertise in Power BI, Power BI Pro, Power BI Mobile. • implemented row-level security on data and have a complete understanding of application security layer models in Power BI.• I have experience in scheduling the task in windows scheduler.• I have worked on creating pipeline to publish the reports into power bi service using Jenkins Show less

• 

  American Airlines

  Apr 2023 - now

  Sr. Power BI Engineer

  • I have migrated the reports from Tableau to Power BI• I have developed Power Automate flows to pick the file from Outlook and store the file into Network shared folder.• I have implemented ETL process in Alteryx to extract data from multiple sources from CVS, EXCEL and schedule workflows in Cloud environment. • Manage end to end complex data migration, conversion and data modeling (using Alteryx) and create visualization using Power BI desktop application to develop high quality dashboard.• Extracting the data from different data sources like Archer, crowdstrike, Proofpoint, One trust API’s into Alteryx ETL tool. • Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business. • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and PowerMap to visualize reports.• Created DAX calculated columns in power pivot worksheets to extract, import and join data that coming from different sources.• Use advanced Business Objects techniques to present data including contexts, drill downs, hierarchies, advances functions, predefined conditions, and prompts.• Created data pipelines in power bi services to publish the reports in staging like DEV, PROD, Test environments.• Worked on Administration functions including deploying code solutions PowerShell scripts..• Implemeted the Row level security to restric the users to access the reports and Data• Worked with different technology teams to gather the requirements and then created a functional document, • Worked on trouble shooting the power bi reports using porfermance Analyzer with in power BI desktop• Worked on Dax Studio to pull the model into it and work on different functions to run the query in Millli sec• Creating the data flows in power bi service and calling Archer API into dataflow.• Created ECRG Dashboard which is visible to Managers, VP, CFO. Show less