Lakshmi P

Mail: ad37st@r.postjobfree.com

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

LinkedIn: linkedin.com/in/lakshmi-pamarthi

Location: Dallas, Texas, USA

Executive Summary

Having 7 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. Actively contribute to migration projects, showcasing superb problem-solving and analytical skills.

Extensive experience in designing, developing, and deploying Business Intelligence solutions using Microsoft 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

Extract data from various sources such as databases, flat files, APIs, etc., using AbInitio components like Database components, FTP components, etc

Optimized ETL processes for better performance by identifying and resolving performance bottlenecks using AbInitio performance-tuning techniques

Performed 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

Technical Skills and Abilities

Cloud Platforms

Azure Data Factory (ADF), Azure Data Bricks (ADB), 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, AbInitio, ADF

Reporting Tools

SSRS, Reporting Scheduler, PowerBI

Bug Tracking Tools & Ticketing tool

Jira, ServiceNow, Azure Devops

Job scheduling tools

Tidal, CA-Workload, Autosys

Methodology

Agile (SCRUM), Waterfall

Work Tools

Visual Studio, SSMS, RedHat

Certification

•Microsoft Certified - MySQL Database Developer

•Microsoft Certified - DP-203: Data Engineering on Microsoft Azure

Professional Experience

KCS IT Solutions (Client: BCBS, TX) May 2023 to till date

Data Engineer

Responsibilities:

Work closely with the 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

Design, develop, test, and deploy data pipelines using Azure Data Factory

Create and configure linked services, datasets, and pipelines in Azure Data Factory

Implement data integration solutions to move data between various sources and destinations, including on-premises and cloud-based systems

Develop data transformation activities using various technologies supported by ADF, such as Azure Data Lake Analytics, Databricks, HDInsight, SQL Server Integration Services (SSIS), etc

Implement data cleansing, enrichment, aggregation, and other transformation logic within the pipelines.

Responsible for developing Pipelines in Azure Data Factory using multiple activities

Modeling & architecture of DW design, directing, and 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 Data Lake, BLOB Storage, SVN Source Control, JIRA.

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

Senior ETL Developer

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

Defined and maintained information related to ETL processes & data models using AbInitio metadata management features

Worked and managed on OLAP Cubes and Star Schema Cubes using SSAS

Responsible for creating estimation and enhancement documents based on incident analysis

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

Performed data cleansing, manipulation, and transformation according to business rules using the AbInitio graphical development environment and components like Reformat, Rollup, Join, etc

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%

Implement error-handling mechanisms and logging strategies to capture and handle exceptions and errors encountered during ETL processes using AbInitio error-handling components and features

Designed Functional Requirements and Mapping Technical Specifications based on Functional Requirements

Performed and maintained Linux scripting to automate routine tasks related to ETL process execution, file management, and system maintenance

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 Tables, 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, Linux/Unix, AbInitio

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

ETL Developer

Responsibilities:

•Interacted with business resources daily 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.

Environment: MySQL, Extract, Transform, Load (ETL), PL/SQL, T-SQL, MS SQL Server, SSIS, Microsoft Power BI

TCD Technologies Pvt Ltd (Client: CDW, IL) Sep 2017 to May 2020

SQL Developer

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, MySQL, Azure SQL, Microsoft SQL Server, SQL Server Integration Services (SSIS), MySQL, SQL Server, SQL, NoSQL, PostgreSQL, Oracle, MongoDB

Education

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

Contact this candidate