Lakshmi P

Mail: ad10a3@r.postjobfree.com

Mobile: +1-469-***-****

LinkedIn: linkedin.com/in/lakshmi-pamarthi

Executive Summary

Having 6 years of experience in the IT industry, built a successful career as a SQL Developer, ETL/MSBI Developer, and PowerBI Developer. My expertise spans various domains, with a focus on Health care/Insurance and Finance. Recognized for a proven track record in the successful execution of MSBI projects, demonstrating proficiency in SQL/ETL development. Possesses a comprehensive understanding of database structures, principles & practices. Known for meticulous attention to detail, I excel in implementing diverse data modeling techniques. Actively contribute to migration projects, showcasing superb problem-solving and analytical skills

Extensive experience in designing, developing, and deploying Business Intelligence solutions using MS SQL Server, specializing in Business Intelligence with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) & PowerBI

Expertise in data extraction, transformation, and loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP.

Extensive experience in creating database objects such as Stored Procedures, Functions, Packages and triggers using SQL

Well-versed in utilizing Oracle-supplied packages, Dynamic SQL, Records, and PL/SQL Tables.

Handled heterogeneous data sources, including databases like Oracle, IBM DB2, Teradata, and XML files, using SSIS.

Extensive knowledge in SQL Server 2012/2016/2019 programming and Transact-SQL (T-SQL), having successfully developed Tables, Stored Procedures, Triggers, Cursors, User-defined functions, Views, Indexes, Joins, user profiles, and relational database models

Designed, developed, and tested the ETL (Extract, Transformation, and Load) strategy to populate data from various source systems feeds using SSIS

Skilled in developing parameterized, charts, graphs, linked dashboards, scorecards, and reports on SSAS Cube using MDX, as well as drill-down, drill-through, and cascading reports using SSRS and Power BI.

Furthermore, I have expertise in creating Power Pivots, Power Queries, Power Views, and SSRS reports using tabular models (DAX), Cubes (MDX), and SQL queries

Proficiently able to import data from various sources, such as SQL Server, SQL DB, SSAS, and Excel. Moreover, I have gained significant expertise in data modeling within Power BI

Designed and developed Data Warehouse (DWH) and ETL processes in an Agile working environment and developed Data Marts using Star schema and Snowflake schema methodologies

Having Knowledge in the creation of SSIS packages to extract data from OLTP systems and transform it into OLAP systems

Developed and managed various SSIS packages, automated Scheduled jobs were used to call these packages & stored procedures

Participated in the development of SSIS packages for various assessment tests and testing data. These packages were designed to store the data in a Data Warehouse, which was then utilized for generating reports

Data is then extracted, transformed, and loaded from source systems to Azure Data Storage services using a combination of Azure Data Factory, Azure SQL, and Azure Data Lake Analytics

Having expertise in ticket triaging by utilizing Jira, Service Now, and Azure Devops to address and resolve issues raised by numerous users

Developed excellence in managing the configuration, deployment, administration, management, and troubleshooting complex configuration of the application/backend servers.

Strong skills in identifying, troubleshooting, and resolving system performance issues, proficient in building automation into daily processes, server builds, patching, and configuration analysis.

Proficient in the Software Development Life Cycle (SDLC) process, including conducting a thorough analysis, gathering requirements, coding, and performing unit testing, as well as integration and system testing.

Skills And Abilities

Cloud Platforms

Azure Data Factory (ADF), Azure Data Bricks (ADB), PySpark, Azure SQL

Database

MS SQL Server, Oracle, MySQL

Operating Systems

UNIX, Linux 9, and Windows NT/2014

Programming Languages

Shell Scripting, SQL, PLSQL, Python 3.0

ETL Tools

SSIS, Informatica, ADF

Reporting Tools

SSRS, Reporting Scheduler, PowerBI

Bug Tracking Tools & Ticketing tool

Jira, ServiceNow, Azure Devops

Job scheduling tools

Tidal, CA-Workload, Control-M

Methodology

Agile (SCRUM), Waterfall

Work Tools

Visual Studio, SSMS

Certification

•Microsoft Certified MySQL Database Developer

•DP-203: Data Engineering on Microsoft Azure

Professional Experience

KCS IT Solutions (Client: Discover Financial Services) May 2023 to till date

Data Engineer

Project Description: As part of the CC360 Data Exchange Project, developed a generic inbound and outbound process that handles various external JSON and Delimited Flat files, invokes internal transformations using Integration Service, reads and writes to Database tables, reads, and writes to SQL Server tables, sends a simple text and more elaborate notification emails by using SQL server agents with relevant metrics information.

Responsibilities:

Work closely with the creation of ADF Pipelines processing data loading from various sources to destinations

Creation of ADF Pipelines processing data loading from various sources to destinations

Responsible for data processing by using PolyBase in Azure Synapse Analytics Data warehouse

Development of Custom Scripts and Stored Procedures for Data import and Manipulation

Responsible for analyzing the logic and optimizing the backend queries using PySpark

Extensively using Azure Analysis Services to create Semantic Models

Responsible for developing Pipelines in Azure Data Factory using multiple activities

Modeling & architecture of DW design, directing, and/or executing the DW process

Responsible for the creation of Database stored procedures, triggers, and tables

Responsible for loading the data into various database destinations using SSIS Packages

Created and optimized various SSIS packages and scheduled jobs for daily monitoring

Having experience in query optimization by using various techniques to increase the performance of code

Monitoring and reducing logic with appropriate requirements by using SSMS

Having experience in manual query optimization by using various techniques to increase the performance of code

Published Power BI Reports in the required originations and made Power BI Dashboards available to Web clients.

experience in creating advanced chart types, visualizations, and complex calculations to manipulate the data as per business needs through Power BI

Environment: MS SQL Server 2012/2017, SSIS, SSRS, PowerBI, Azure Cloud, Azure Data Factory (ADF v2), Azure Azure Data Lake, BLOB Storage, SVN Source Control, JIRA.

TCD Technologies Pvt Ltd (Client: CDW) Oct 2022 to April 2023

Senior ETL Consultant

Project Description: This project involves the process of triaging, analyzing, and developing the tickets/incidents based on the requirements of the user/client. Designing the SSIS Packages and loading that data into our database tables. Designing the SSRS reports based on businesspeople requirements and rendering those in the form of PDF, Excel & CSV, etc. Finding the solutions for Triage tickets which are raised by multiple users within a short period of time

Responsibilities:

Responsible for the development and optimization of backend SQL code and logic

Involved in the design and implementation of SSIS Packages, SSRS reports, and data-loading processes

Tasked with investigating and resolving discrepancies in Sales and tax amounts for specific states/periods

Collaborating closely with code deployments across different environments (QA & Prod)

Responsible for creating estimation and enhancement documents based on incident analysis

Experienced in utilizing appropriate tools to backtrack data and resolve triage tickets

Skilled in creating backfill packages to address differences in sales and tax amounts for respective states

Proficient in creating & modifying T-SQL Queries, Index, Views, Complex Stored Procedures, Triggers, and cursors

Optimized stored procedures to achieve faster execution, resulting in a performance increase of over 75%

Modified triggers and stored procedures to accommodate business changes

Designed Functional Requirements and Mapping Technical Specifications based on Functional Requirements

Created and optimized various SSIS packages and scheduled jobs for daily monitoring

Designed and Mapping Technical Specifications based on Functional Requirements

Created and optimized various SSIS packages and scheduled jobs for daily monitoring

Involved in system analysis & design for Enterprise data warehouse implementation

Modified stored procedures, SQL queries, triggers, and views to improve functionality and performance

Developed reports with various styles using Table, Sub Reports, and Matrix using SQL Server Data Tools (2012/2014)

Created reports with formatting options such as Grouping, Sorting, Drill-down, and Parameter prompts

Environment: MS SQL Server 2005/2008, SSIS, SSRS, PowerBI, SVN Source Control, JIRA

TCD Technologies Pvt Ltd (Client: HMSA) June 2020 to Sep 2022

ETL Developer

Project Description: As part of the AS400 Migration Project, involves extracting data from the disposition format tables in QNXT & BlueCard to create user interface applications. The interface is designed to be interactive, allowing the user to search for provider /member details. It also provides options for adding, editing, and viewing details of existing providers and members to the end-users. In parallel, developing and loading data through SSIS packages & generating SSRS reports to RTM’s/RTP line of businesses.

Responsibilities:

•Interacted with business resources on a daily basis to analyze business processes, track requirements, and deliverables

•Implemented various transformations, including for loop container, For Each loop container, execute package task, FTP task, Bull Insert task, and Script task in SSIS Control Flow. Additionally, utilized transformations such as Row sampling, Lookup, and aggregate grouping in SSIS Dataflow

•Designed, developed, and tested the ETL (Extract, Transformation, and Load) strategy to populate data from various source systems feeds using SSIS.

•Prepared source-to-target mapping data, including claims, insurance, and provider-related data.

•Took charge of designing and documenting the entire Architecture of Power BI POC.

•Demonstrated expertise in writing complex DAX functions in Power BI and Power Pivot.

•Created SSIS packages for file transfer from one location to another using FTP task, with master SSIS Package to execute all other packages

•Worked on Data Warehouse Modeling with SQL Server Analysis Services (SSAS).

•Automated SSIS Packages using SQL Server Agent Jobs.

•Generated parameterized reports, sub-reports, drill down, and drill through reports using SQL Server Reporting Services (SSRS), working alongside MDX queries.

•Utilized all types of transformations available in the PowerBI query editor.

•Created stored procedures and SQL queries to extract data into the Power Pivot model.

•Participated in project planning sessions with project managers, business analysts, and team members to analyze business requirements and outline the proposed solution.

•Utilized Power Query in Power BI to pivot and un-pivot the data model for cleaning and massaging.

•Used Power BI Gateway to ensure the dashboards and reports are up to date

•Configured Power BI Gateway and developed complex DAX queries to generate computed columns and Interacted with business resources on a daily basis

•Configuring node manager in multiple environments like Dev, QA, and Prod

Environment: ETL Testing, MySQL, User Acceptance Testing, Extract, Transform, Load (ETL), PL/SQL, Transact-SQL (T-SQL), Microsoft SQL Server, SQL Server Integration Services (SSIS), Microsoft Power BI

TCD Technologies Pvt Ltd (Client: HMSA) Sep 2018 to May 2020

SQL Developer

Project Description: This project encompasses query optimization, package performance tuning, and seamless migration from a lower version to a higher version, ensuring error-free execution. The packages are developed and designed in accordance with the requirements, following the Agile Methodology.

Responsibilities:

Performance tuning of WebLogic Server in various environments

Created Stored Procedures, Functions, and Triggers using T-SQL and PLSQL

Developed complex SQL scripts involving primary keys, foreign keys, constraints, joins, and unions

Implemented object creation such as Tables and Views and table Normalization, User Created Data Types, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes, and appropriate Triggers to ensure efficient data manipulation and data consistency

Documented step-by-step instructions for migrating database objects across different environments including Development, UAT, Staging, and Production

Proficient in creating and modifying reports, as well as utilizing Data Transformation Services (DTS)

Skilled in resolving issues identified during testing by troubleshooting the existing code

Actively participated in design and code reviews to uphold high development standards

Played a key role as a team member in support and development tasks and prepared User Acceptance Test Plans (UATPs) with expected results

Handled day-to-day responsibilities involving backend code logic implementation and testing

Responsible for writing T-SQL queries and testing code based on specific requirements

Designed ODI and SSIS packages based on business requirement documents

Migrated SSIS packages from lower versions to higher versions using Visual Studio

Analyzed issues and performed code deployments across different environments (QA & Prod)

Environment: PLSQL · T-SQL · ETL Testing · SQL Server Management Studio · Test Cases · MySQL · Azure SQL · User Acceptance Testing · Extract, Transform, Load (ETL) · Transact-SQL (T-SQL) · Microsoft SQL Server · SQL Server Integration Services (SSIS)

Education

Bachelor of Technology, Jawaharlal Nehru Technological University, India. - 2018

Contact this candidate