ETL Informatica Developer

Krishna Reddy Gayyam

BI Engineeer

******************@*****.*** 928-***-****

An accomplished individual with a strong analytical mindset and a focus on processes, possessing over 8+ years of valuable experience in developing SQL Server solutions. Proficient in driving data research and analysis, composing intricate SQL queries and stored procedures, and renowned for expertise in SQL Server Integration Services, Reporting Services, SQL Server Analysis Services, Tableau, Power Bi, and Amazon Redshift. Proficient in end-to-end design and implementation of ETL processes to enhance database and query performance. Known for a meticulous, detail-oriented, and comprehensive approach to multiple commitments while adhering to tight schedules. Demonstrates excellent interpersonal skills and the ability to build productive relationships with cross-functional teams and stakeholders at all levels, effectively prioritizing multiple projects in fast-paced environments and delivering outcomes within scope, time, and budget constraints.

SUMMARY:

Over 4+ years of professional experience utilizing My SQL Server Business Intelligence (BI) technologies such as Microsoft SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Tableau.

Proficient in developing and deploying various ETL packages, scheduling jobs, and utilizing Row Transformations, Block Transformations and Unblock Transformations for Performance Tuning in SSIS packages.

Skilled in translating Business System Design documents into technical design documents and installation, upgrading, and configuring Microsoft SQL Server and databases.

Expertise in T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User-defined data types, Cursors, and Indexes using T-SQL, writing complex T-SQL queries using Inner, Left, Right, Outer, and Cross Joins.

Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications.

Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.

Experience in deploying SSIS Packages from development server to production server and ETL(SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources such as Oracle, Excel, CSV, XML, MS Word, and Text Format Data.

Proficient in using SSIS Import and Export Wizard, SSIS designer, and other package execution utilities, as well as SSIS Configuration, Logging, Procedural Error Handling, and Data Error Handling.

Implemented robust security controls and access management policies for reporting environment, achieving compliance with industry standards and regulations.

Hands-on Experience in SSIS transformations including script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension.

Experience in developing SSRS reports, resolving complex issues associated with using Report Manager, Report Builder, and Business Intelligence Development Studio Framework.

Created many complex databases objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes that have least updates to improve the query performance.

Proficient in Relational Database Management Systems (RDBMS), including tables, Stored Procedures, Views, Functions, Indexes, and Triggers, as well as troubleshooting queries and performance tuning on databases.

TECHINCAL SKILLS:

RDMS

SQL Server 2008 R2/2012/2014/2015/2016/2019, MS Access

Languages

SQL, T–SQL, Python, R

Operating Systems

Windows XP/2003/2008

OLAP/Reporting Tools

SSAS, SSRS, SSAS

ETL Tools

Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS), Power BI, Visual Studio2010, 2014

Other Tools

Microsoft Visual Source Safe (VSS), TFS, Microsoft Office

Data Modeling Tools

Microsoft Visio 2000/2003

SQL Server Tools

SQL server Management Studio, SQL server Query Analyzer,

SQL server mail service, BCP and SQL server profiler.

Data Modeling

Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI

SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server 2008/2012 Analysis Services and SQL Reporting services, ProClarity, PPS-2007

Certifications

Snowflake, SnowPro Core Certified-C01

Microsoft Certified: Power BI Data Analyst Associate (IN PROGRESS)

Honour Health, Phoenix, Arizona Sep 2023- Present

SQL Developer

Responsibilities:

Leveraged life insurance knowledge to effectively assess client needs, provide comprehensive insurance solutions, and deliver exceptional customer service, ensuring long-term financial security for policyholders.

Developed Tables, Views, and Stored Procedures for Medicaid insurance data using SQL Server Management Studio.

Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.

Extensive use of Stored procedures, writing new stored procedures and modifying existing ones and tune them such that they perform well.

Conducted thorough testing of new or modified programs, meticulously validating their functionality against design specifications, effectively identifying and resolving discrepancies to deliver high-quality solutions.

Create Stored Procedures, Triggers, Views, joins and Functions for the Application.

Created data refresh strategies for Azure SQL Server and other sources, reducing data latency by 60% and improving data accuracy.

As a SQL developer, proficiently generated diverse and realistic test data sets, enabling rigorous testing of database systems and SQL queries to validate their accuracy, efficiency, and performance.

Proficient in Microsoft SQL Server Analysis Services (SSAS), showcasing expertise in designing and developing multidimensional and tabular data models for efficient data analysis and reporting.

Skilled in utilizing Dynamic SQL features such as parameterized queries, dynamic table and column names, and dynamic query generation based on runtime conditions

Demonstrated expertise in leveraging Integration Services Catalog, including Environments, to streamline deployment processes and ensure smooth execution of ETL workflows, enhancing overall efficiency and maintainability of data integration solutions

Utilized in-depth knowledge of Oracle E-Business Suite (EBS) to successfully troubleshoot and resolve complex technical issues, ensuring uninterrupted system performance and minimizing downtime

Experience in Querying a Tabular Model in Excel, Power View and used various DAX Functions. Loading

Data inside Tabular, Monitoring Security, Automating Deployment to Production Server.

Leveraged SSRS to effectively visualize and present complex data sets, enabling data-driven decision-making.

Created calculated columns and measures using DAX queries in Power BI based on report requirements.

Expertise in creating advanced calculated columns and measures with DAX using Power BI.

Expertise in designing and developing robust data transformation solutions using an array of SSIS components, such as Data Flow Task, Data Flow transform tasks, Data Flow containers, Foreach Loop containers.

Proficient in creating visually impactful dashboards, designing intuitive and interactive reports that present key insights and trends through charts, graphs, visual elements and data visualizations using SSRS.

Created DAX and VB scripts for Excel reporting and calculated members. Good experience on Kibana Reporting.

Designed Extraction Transformation and Loading (ETL) process using SSIS to extract Medicare data from flat

Developed automation routines using scripting languages to export data to Excel and other mediums, improving efficiency by 50%.

expertise in developing and designing reports using SSRS, leveraging its powerful features such as report parameters, data sources, expressions, and formatting options

Created SSIS Packages utilizing Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Aggregate, Execute SQL Task, and Execute Package Task for generating underlying data for reports and exporting cleaned data from Excel Spreadsheets, CSV files to Data Warehouse.

Proficient in using Visual Studio 2015 and 2017 for developing and debugging applications, including web applications, desktop applications, and services.

Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored

Environment: T-SQL, MS SQL Server 2016/2014/2019, MS SQL Server Reporting Services, Kibana Riporting, MS SQL Server

Integration Services, Stored procedures, IFrames, Microsoft Power BI, DAX Functions.

BSI Financial Services, India Feb 2021 - Aug 2022

SSIS/SQL Developer

Responsibilities:

Extensive experience in data Extraction, Transformation and Loading (ETL) of data using SQL Server 2015 Integration Services, for moving data from source to target system.

Utilized Execute SQL Task and Control Tasks to import Source/Target tables from respective databases in SQL Server 2015 Integration Services.

Skilled in creating and optimizing OLAP cubes and data mining models using SSAS, enabling in-depth exploration of complex datasets and facilitating data-driven decision-making processes.

Successfully identified and resolved performance bottlenecks by optimizing SQL queries, resulting in significant reduction in query execution time and improved overall system performance.

Designed and documented the entire Architecture of Power BI POC

Proficiently managed EBS implementations, customizations, and support, contributing to seamless business processes, data management, and financial operations

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Implemented data export automation process, reducing human errors and saving 2 hrs/week of manual effort.

Created SSRS reports and SSIS packages for exporting and importing data from SQL Server to Access, Text, and Excel files. Configured SQL mail agent for sending automated mails.

Skilled in creating and managing appropriate indexes to optimize query execution and minimize disk I/O.

Skilled in leveraging Power Flows to automate data extraction, transformation, and loading for report generation.

Skilled in analyzing and converting complex legacy report logic into interactive Power BI reports.

Implemented automated data refresh mechanisms for SQL Server and other data sources, resulting in a 50% reduction in manual effort and improved data availability.

Worked with Data modelers building database using Facts, dimensions, star schema, snowflake schema

Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database in the most efficient manner and created stored Procedures for the business logic using T-SQL.

Developed database triggers and stored procedures using T-SQL cursors and tables.

Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing.

Utilized Power BI Gateway to keep the dashboards and reports up to date.

Successfully optimized Dynamic SQL queries to handle large datasets and high transaction volumes, resulting in significant improvements in application response times and user experience.

Developed paginated reports for different sources of genome taxonomy that provide accessible information for accurate decision making.

Experienced in implementing security measures and role-based access control within SSAS, ensuring data confidentiality and adherence to data governance policies.

Experienced in utilizing the built-in tools and features of Visual Studio 2015 and 2017, such as IntelliSense, code analysis, unit testing, and source control integration the development process and ensure code quality.

Developed complex DAX Queries in Power BI to generate computed columns.

Contributed to Requirement Analysis, Design phase, and Development phase of Agile SDLC.

Developed T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, and Stored Procedures and Queries to develop Decision Engine.

Scheduled the ETL Package (Daily) using SQL Server 2016 Management Studio.

Created and deployed various SSIS packages, troubleshooted errors, and set up alerts using Send Mail tasks. Also, deployed reports generated from SSRS and Tableau on production server.

Environment: MS SQL Server 2019, SQL Server 2015, SSIS, SSRS, SSAS, Tableau Desktop (Desktop, Server), Microsoft Visual Studio,IFrames, Kibana Reporting, Stored procedures, Tableau, DAX Functions, SQL Server Management Studio, MS Excel, T-SQL, ERWIN, Microsoft Visual Basic.Top of Form.

OptimHire, India June 2019 - Jan 2021

Role: SQL Server/ MSBI Developer

Responsibilities:

Proficient in data Extraction, Transformation and Loading (ETL) Medicare data using SQL Server 2012 Integration Services.

Involved in complete Software Development Life Cycle (SDLC) process, analyzing business requirements and functional workflows.

Proficient in working with diverse data sources and transforming legacy reports into modern and visually appealing Power BI reports.

Proficient in designing and implementing ETL workflows using Informatica PowerCenter to extract, transform, and load data from various sources into a centralized data warehouse.

Proficient in designing and developing interactive Power BI pagination reports and dashboards.

Created complex Stored Procedures, Views, and Functions for loading data from Staging to Data Warehouse.

Imported Source/Target tables from respective databases using Execute SQL Task and Control Tasks in SQL Server 2012 Integration Services.

Proficient in utilizing Power Flows to automate report generation and distribution tasks.

Extensively utilized Derived Column, Data Conversion, Conditional Split, and Aggregate.

Scheduled daily ETL packages using SQL Server 2012 Management Studio.

Developed SQL Server Integration Service (SSIS) packages for transferring data between enterprise databases and third-party data sources.

Skilled in embedding external content such as reports, dashboards, and visualizations within reports using iframes for a unified view.

Extensive Testing on the Performance of the Stored Procedures.

Partitioned measure groups to enhance cube performance.

Designed reports in SSRS using data from the Data Warehouse database.

Developed SSIS packages for Data Importing, Cleansing and Parsing.

Followed Report Specification document and designed reports that meet client requirements.

Environment: MS SQL Server 2012, SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Visual Studio 2013/2015, SQL Server Profiler, Dashboard, Dax Functions, IFrames Stored procedures, SQL Server Management Studio.

Contact this candidate