Saibabu Maddineni
Summary
Microsoft Certified Professional with over 15 years in SQL Server development and support. Proficient in designing and deploying complex reports, optimizing database performance, and leveraging SSIS for effective ETL processes. Committed to enhancing data integrity and user satisfaction through innovative database solutions.
Overview
21
21
years of professional experience
1
1
Certification
Work History
SQL Server/SSIS/SSRS Developer
MRLP
, GA
09.2024 - Current
- Designed, developed, and deployed reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
- Prepared comprehensive data mapping and report definitions for 33 reports, ensuring accuracy and consistency in reporting.
- Developed multiple parameterized stored procedures for reports, enhancing data retrieval efficiency.
- Created parameterized reports, Drill down and Drill through reports using SSRS.
- Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
- Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into a data warehouse.
- Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
- Prepared the complete data mapping for all the migrated jobs using SSIS.
- Created databases and schema objects including tables and indexes, applied constraints, connected applications to database, and authored functions, stored procedures, and triggers, streamlining data management.
- Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
- Environment: Windows 2007 enterprise, SQL Server 2008/2005, SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB
.Net/BizTalk/SSIS Developer
MRLP
Cumming, Georgia
03.2010 - 08.2011
- Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
- Developed complex ETL packages using SSIS to extract data from staging tables to partitioned tables, enabling incremental load.
- Developed, deployed, and monitored SSIS Packages.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
- Performed T-SQL tuning and optimized queries for reports in SQL Server 2008/2005, improving execution times.
- Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
- Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
- Generated reports using SSRS with Analysis Services Cube as data source, enhancing data accessibility for stakeholders.
- Zondervan is a publishing company involved mainly in bible publishing. It is a part of one of the most famous publishing companies, Harper Collins. Their mission is to be the leader in Christian communications meeting the needs of people with resources that glorify the GOD and promote biblical principles.
- Environment: MS SQL Server 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access 2007, Office 2007, Windows Server 2003.
SQL Server (SSIS/SSRS) Developer
Confidential
Tampa, Florida
03.2009 - 02.2010
- Created Data Model or the Marketing Information System Team using Erwin.
- Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
- Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
- Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
- Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS).
- Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
- Created components, tools, techniques, methods and procedures used in an On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
- Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
- Health Integrated is the leading innovation partner for health plans, providing evidence-based solutions to accelerate achievement of health management goals for clinical outcomes, quality measures and cost containment.
- ENVIRONMENT: Windows XP, Windows 2003, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS, ERWIN.
SQL Server 2005 Developer
Confidential
Omaha, NE
06.2008 - 02.2009
- Create new tables, views, indexes and user defined functions.
- Designed database structure to optimize daily job execution and improve stored procedure performance.
- Created SSRS reports for Franchise Health Reports.
- Developed reports by extracting data from cubes using MDX queries for analytical insights.
- Designed reports, Graphs and deployed reports to web applications using SSRS.
- Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
- Designed MDX queries to retrieve data from SSAS cubes.
- Created SSIS packages for File Transfer from one location to the other using FTP task.
- Designed Cube partitioning and incremental synchronization for SSAS cubes.
- Conducted performance tuning of TSQL queries and stored procedures to enhance query efficiency.
- Optimized query performance by creating indexes.
- Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL Queries and Stored Procedures.
- Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures.
- Developed complex stored procedures to create various reports.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
- Designed Star Schema and Snow flaked schemas in the process of data modeling.
- West Corporation is connecting with their customers, speaking out clearly, confidently, persuasively in a market place that spans the globe and yet is as personal as a conversation between two people.
- ENVIRONMENT: Windows 2003 Advanced Server, MS SQL Server 2005, MS Outlook, TSQL, Erwin, SSIS, SSRS, SSAS, VB.
SQL Server Developer/DBA
Confidential
, India
01.2007 - 02.2008
- Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
- Installed SQL Server, designed databases, and created schema objects such as tables, views, and indexes.
- Migrated database code from SQL Server 2000 to 2005 in SDLC environment using bridging scripts, column mapping tool, and source control explorer in Visual Source Safe (VSS), ensuring successful unit testing of triggers and views for data validation.
- Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
- Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
- Developed and maintained ETL processes to support enterprise data warehouse system and corresponding marts, enhancing data accessibility and reporting capabilities.
- Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
- Generated reports using linked reports, sub reports, and filters in SQL Server Reporting Services to provide actionable insights for decision-making.
- Environment: MS SQL Server 2000, T-SQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.
SQL Server Developer/DBA
Confidential
, India
09.2005 - 12.2006
- Conducted systems study, analysis, and design for systems and databases to enhance functionality and performance.
- Designed and created SQL Databases, tables, indexes, and views based on user requirements.
- Collaborated with application developers to deliver SQL scripts using T-SQL that met project specifications.
- Created User Defined Functions, Stored Procedures, and Triggers.
- Created views for user interface implementation and triggers to ensure consistent data entry across the database.
- Experience in creating small Packages.
- The Department of Consumer Affairs serves as one of the largest government-run public welfare departments in India and the country's largest investor.
- Environment: HTML, VBScript, SQL Server 2000, SQL Query Analyzer, DTS, Windows NT, MS Access, MS Excel, Erwin.
Education
Master of Science - Computer Science
Kakatiya University
India06-2002
Skills
- SQL Server Development
- T-SQL Scripting
- SSIS Package Development
- SSRS Reporting
- ETL Tools
- Data Migration
- Database Performance
- SQL Query Optimization
- Data Modeling
- Data Analysis
- Reporting Tools
- BI Tools
Certification
Microsoft Certified Technology Specialist - Microsoft SQL Server 2008 Business Intelligence (SSIS, SSRS, SSAS) Development and Maintenance.
Timeline
SQL Server/SSIS/SSRS Developer
MRLP
09.2024 - Current
.Net/BizTalk/SSIS Developer
MRLP
03.2010 - 08.2011
SQL Server (SSIS/SSRS) Developer
Confidential
03.2009 - 02.2010
SQL Server 2005 Developer
Confidential
06.2008 - 02.2009
SQL Server Developer/DBA
Confidential
01.2007 - 02.2008
SQL Server Developer/DBA
Confidential
09.2005 - 12.2006
Master of Science - Computer Science
Kakatiya University