SQL Developer,Power BI Developer,Business Intelligence
Resume:
Hemanth Manepalli
SQL Developer
*************************@*****.***
Professional summary:
Over 4+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2019/2017/2016/2014/2012 using SSIS ETL.
Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
Hands on Experience in using tools like SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
Good Knowledge of Data Warehouse/Data mart concept and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
Expertise in writing SQL Queries, Dynamics, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors.
Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView, and Tableau) Packages (Developing, Deploying, Scheduling, Troubleshooting, and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.
Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.
Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, Power BI and Tableau.
Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS).
Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.
Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Thorough understanding of Kimball’s theory, KPIs and Perspective, Data mining structures
Experience in Migrating Data from an older version to newer version of MS SQL Server.
Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
Excellent knowledge & experienced in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined datatypes, effective functions, cursors and indexes using T-SQL.
Expertise in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, OLAP and Sub reports in Business Intelligence Development Studio.
Building and publishing POWER BI/Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
Experienced in creating interactive dashboards and scorecards utilizing Power BI.
Hands on experience in MS Power BI desktop and Power BI service.
Hands on Experience in Data Migration from MS SQL Server to Oracle ERP Systems.
Strong team player with great verbal, written communication and interpersonal skills.
Education
Masters in Information Technology -University of Texas at Dallas
Technical Skills:
Data Warehousing & BI
SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Azure SQL.
Reporting Tools
SSRS 2019/2017/2016/2014/2012, SSAS, Excel, Tableau, Power BI, SQL Query Analyzer.
Database
MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, Database Engine Tuning Advisor (DTA), Hadoop, Hive, pig
Programming
C, C++, TSQL, DAX, MDX.
IT Processes
Software Development Life Cycle (SDLC), Project Management
Productivity Applications
MS Word, MS Excel, MS Access, MS Project, Visio
Operating System
Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX
Integration Services
SQL Server Integration Services (SSIS), Data Transformation Services (DTS)
Developer Tools
Informatica Power Center, Informatica IDQ, SSIS, Cognos Analytics, SSMS
Work Experience:
Engage Healthcare, Silver Spring, MD Aug 2023 - Present
Role: SQL Developer
Responsibilities:
Responsible for the design and development of a Sales Data Warehouse project leveraging the Informatica Power Centre ETL tool, Teradata database, and Micro Strategy reporting tool.
Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Parsed high-level design specifications to simple ETL coding and mapping standards.
Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
Designed and customized data models for Data warehouse supporting data from multiple sources in real-time
Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
Imported various Sources of data and created Targets and Transformations using Informatica Power Centre Designer (Source Analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
Extracted the data from the flat files and other RDBMS databases into the staging area and populated into the Data warehouse.
Developed complex mappings using corresponding Sources, Targets, and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate and expression transformations in extracting data in compliance with the business logic.
Performed data cleansing and transformation using Informatica. Design mappings to populate data from source system files to the data warehouse.
Maintained stored definitions, transformation rules, and target definitions using Informatica Repository Manager.
Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.
Extensively used SQL loader to load data from flat files to the database tables in Oracle.
Knowledge on Teradata Utility scripts like Fast Load, and Multiload to load data from various source systems to Teradata.
Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports. Designed Drill through Ad-hoc Reports.
Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
Experience in creating complex SSIS packages using proper control and data flow elements.
Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2016.
Created ad-hoc reports, drill down, and drill through reports using SSRS.
Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive web-based reports.
Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for users.
Environment: MS SQL Server 2016/2014, SSRS, T-SQL, SSIS, C#, MS Access 2010, Power BI, DAX, SQL Server Management Studio (SSMS), SharePoint, ASG-Zena, IBM Cognos, SQL, Python.
Accel Frontline, Hyderabad, India Feb 2021 – Jul 2022
Role: Power BI Developer
Responsibilities:
Worked on SQL Server Integration Services (SSIS) to integrate and analyse data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2016).
Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers.
Configured and created SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
Responsible for generating different types of daily and weekly reports based on specifications and user’s requirement using SSRS.
Developed parameterized reports for generating Ad-Hoc reports as per client requirements.
According to business requirements developed Tabular reports, Matrix reports, Gauges & Chart reports, Parameters, Sub reports, Ad-hoc reports, Drill down reports, Drill Through using SSRS.
Deployed SSRS Reports into Report Manager and managed report subscriptions, delivery, generation and rendering.
Creating test cases for ETL mappings and test design documents for production support.
Wrote and modified various Stored Procedures used in the application using T-SQL.
Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
Responsible for creating partition function and schema for the table partitioning.
Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period.
Created SSIS 2016 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
Created various jobs using SQL Server Agent.
Used SQL Server Profiler to trace the slow running queries and the server activity.
Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.
Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
Environment: Microsoft SQL Server 2014, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Report Builder, SQL Server Analysis Services (SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2008, SQL Profiler.
Unisys, Hyderabad, India Aug 2019 - Feb 2021
Role: SQL Server Developer
Responsibilities:
Created complex SQL stored procedures using Microsoft SQL Server 2014 and 2012.
Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
Developed SSIS ETL packages using data warehouse architecture model by creating fact table’s
role playing and conformed dimensions.
Developed SQL queries to fetch complex data using Inner/Outer joins, sub queries, CTE, Tally tables accommodating complex filters and database links.
Strong Data Modelling experience using dimensional data modelling, star schema modelling, snow-flake modelling using tools like Erwin.
Experience in developing reports using SSRS 2014 and SSRS 2016.
Created SSIS-ETL packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
Created SSIS packages to other SQL Server instances in SSIS 2014.
Performed the task of data transfer from files in remote server to folders in another server using FTP.
Experience throughout developing OLAP cubes for data mining and created reports from the OLAP cubes
Generated reports from the cubes by connecting to Analysis server from SSRS.
Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2014 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
Developed various reports using SSRS, which included writing complex stored procedures for datasets.
Experience in creating snapshots of static reports and configure subscription.
Experience in creating complex SSIS-ETL packages using proper control and data flow elements
Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
Extracting the data from the different sources (CSV files, and MS SQL 2018) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
Environment: SQL Server, Business Intelligence Studio (SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, MS Excel.
Contact this candidate