Keerthi Reddy

SQL BI Developer

Email: adldhu@r.postjobfree.com Mobile: 512-***-****

Location : Austin(Texas)

PROFESSIONAL SUMMARY:

4+ years of IT Experience in design of IT experience Most of the experience in designing & coding of database, and applications of MS SQL Server/Oracle. Work experience in the Area of SQL Development, integration Development using Microsoft tools like SSIS, SSRS,SSAS & POWER BI

Strong T-SQL experience in creating different database objects Tables, Stored Procedures, DDL/DML Triggers, Functions and User defined data types. Skilled in writing and reviewing-SQL code and maintaining coding standards.

Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.

Experience with Relational and Dimensional data modeling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate Keys, drill down and drill across approach.

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server2014/2012/2008.

Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding,

Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

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

Worked Extensively on ETL process using SSIS package.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

Expert in design and development of SQL Server Integration Services (SSIS) packages and Using various control flow task and data flow transformation.

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.

Expert in creating various type of reports such as Complex drill down & drill through reports,

Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.

Extensive experience working with SAP Cubes and DSO`s and ETL Process.

Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

Created views as per design needs for security reasons.

Created SSIS packages to import/export sales data to/from the excel sheets, flat files, XML files or other databases as per the user requirements.

Created data using SQL Server Integration Services (SSIS) and coordinated with ETL developer's team to ensure data extracted, transformed and loaded according to the specified requirements.

Education:

UNIVERSITY: Osmania University

MBA (Finance) (2009 - 2011)

UNIVERSITY: Jawaharlal Nehru Technological University, Hyderabad

BTECH (Computer Science) (2004 - 2008)

Technical Skills:

RDBMS: MS SQL Server 2016/2014/2012/2008/2008R2, MS Access, Sybase Server

Programming Languages : C, C++, T-SQL, Packages SQL Server Management studio, Enterprise Manager, Profiler Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET,

BI Tools : SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),Data Transformation Services(DTS), SQL Server Analysis Services (SSAS), MS Visio, Power BI Application Packages Microsoft Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, ProClarity.

Operating Systems: Windows 10/8.1/8/7/XP, Windows Server 10/8.1/8/7/XP

Professional Experience:

Client: DSS.Inc, Florida, July 2020- Present

Role: MS BI Developer

Responsibilities:

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.

Created views to restrict access to data in a table for security.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Published reports and dashboards using Power BI.

Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.

Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.

Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.

Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.

Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data

Warehouse.

Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and TSQL procedures in SQL SERVER 2014.

Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments

Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow

Defines and captures metadata and rules associated with ETL processes

Review and analyze database performance, cubes and reports generated using SQLSERVER 2008 R2 Reporting Services.

Environment: SQL Server 2012/2014/2016, SSIS, Power BI Desktop, Power BI Web, Git Hub, python 3.7, azure portal, XML, HTML

Client: Southern New Hampshire University Dec 2018 – June 2019

Role SQL Server BI Developer

Responsibilities:

Assisted in Business Analysts to gather technical requirements.

Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.

Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.

Published reports on Power BI services, shared dashboards utilizing within the office 365.

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

Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).

Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.

Work with Service Management teams to establish and monitor service level agreements, communication protocols with data suppliers and data quality assurance policies.

Provide data quality advisory services to clients and to internal stakeholders. Recommend maintenance enhancements to data acquisition processes to improve accuracy of data warehouse data.

Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.

Provide technology options and recommendations to solve for business challenges, Strong knowledge of database and system performance monitoring. Ability to share and communicate ideas both written and verbally to staff at various levels within the organization in a clear and concise manner that is relevant to each level.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Have good business analytical and technical knowledge in Healthcare Membership, Benefits and Provider Modules in FACETS.

Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning.

Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.

Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task Failed Event Types.

Installation of SQL Server 2008R2,2012 and 2014 with specific requirements, performed hardening and post provisioning to ensure standard and security

Configuring HA and DR solution including Replication, mirroring, and log shipping

Always On Availability groups and Failover Clustering installation and Configuration SQL 2012 and SQL 2014

Extensive experience in database backup and restoring in testing production environment

Experience creating and rebuilding indexes

Experience creating scheduled jobs and maintenance plan

Updated statistics with full scan on a weekly basis to make sure that the query optimizer uses the most recent statistics

Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands to find the slow running queries to get the performance metrics and performance tuning

Used SQL Server Profiler(Tracing), Perfmon and windows task manager to monitor query performance and SQL Server resource utilization

Environment: MS SQL Server 2014,Visual Studio 2013, SQL Server Integration Services (SSIS), Data Warehouse, Power BI, Informatica Power Center 9.5.1, Oracle 11g, SQL, Unix, Windows 10, MS Office, MS Visio, C#, Erwin 9.2 Data Modeling, Share Point, Team Foundation Server (TFS), ERP, CRM software, Widows server 2012, Linux server.

Client: Care Source Dayton, OH

Role: MSBI Developer: - Aug 16- Nov 18

Responsibilities:

Reviewed many T-SQL issues using management studio for better performance.

Working on various SSRS reports which are already existed.

Modifying the old reports and adding subscriptions

Automated the old manual reports and getting the updated data from app tracker from the site location.

Written Unit test cases for chef recipe testing using test kitchen, food critic etc.

Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.

Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and

SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc. Created reports using Cognos.

Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling

Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy the various report items like charts, maps, images, graphs, tables etc. to the R2 report server along with the reports.

Expert in designing reports using SQL server reporting services (SSRS) & Excel power pivot table base on OLAP Cubes.

Wrote T-SQL queries using inner join, outer join, and self joins, merge join. Also implemented functionality for removing duplicate records like using CTE and ranking function

Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.

Utilized T-SQL daily in creating customs view for data and business analysis.

Created subscriptions to provide a daily basis reports.

Developed the necessary project plan based on Agile Principles, timelines and schedules related to client's infrastructure and workflow needs for the scope of the project

Worked on SSRS in SharePoint Integrated Mode.

Good experience in configuring and supporting clustering, Mirroring and Replication high availability techniques

Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL 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.

Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.

Created SSIS Packages from various data sources.

Environment: - Microsoft SQL 2012 and 2008, Parallel Data Warehouse (APS), SSIS, SSRS, Tableau, TFS,

Business Intelligence Development Studio (BIDS), SSIS, SSRS, DTS, OLTP, XML.

Contact this candidate