Sql Server Business Intelligence

Name: Rama Rao Gujjeti

Contact: 248-***-****

Email: ad5x91@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 10 Years of IT Experience in Software Analysis, Design and Development in Client/Server systems, Data warehousing and Business Intelligence applications.

Experience in requirement analysis, designing, coding, testing and evolution phases in a software development life cycle.

Experience in creating Indexes, Views, Triggers, Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.

Experience in writing Complex SQL Queries involving multiple joins.

Knowledge of Relational Database Management System (RDBMS), OLAP&OLTP, Data Warehouse Concepts and experience with MS SQL Server in writing T-SQL, working on SSIS, SSRS, SSAS, Data Analysis, Data Cleansing and Data Migration.

Excellent in High Level Design of ETL DTS Packages &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.

Created SSIS packages to transfer data between OLTP and OLAP Databases.

Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.

Expertise in generating reports using SQL Server Reporting Services (SSRS) and scheduling and deploying reports on report manager.

Good knowledge in developing and designing reports through SSRS and Excel.

Designed and developed matrix and tabular reports with drilldown, drill through, parameterized reports, sub-reports using SQL Server Reporting Services (SSRS).

Enhancing the Reports visually by adding the visual elements like charts, graphs in SSRS reports.

Good Knowledge of Normalization/De-Normalization and Data Modelling.

Proficient in Database Query performance optimization, debugging and performance tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger. TECHNICAL SKILL

Databases : MS SQL Server (2008, 2008R2, 2017)

DWH/BI Tools

: SSIS (2005, 2008, 2014), SSRS (2005, 2008, 2012), Crystal Reports, Business Intelligence Development Studio (BIDS), Visual Studio Development skills : T-SQL, PL/SQL, SSIS/SSRS/SSAS Languages T-SQL, OLAP, C#, VB Scripting, HTML

Reporting Tools : SQL Server Reporting Services, MS Excel, Tools/Methodologies : MS Visio, MS Project, SQL Profiler, MS Office PROFESSIONAL EXPERIENCE:

Fairway Independent Mortgage Corporation (Carrollton, TX) Oct18- Till Role: SSIS/ ETL Developer.

Responsibilities:

Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.

Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.

Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.

Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse.

Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries

Developed Query for generating drill down and drill through reports in SSRS.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.

Experienced in Azure Data Factory and preparing SI/CD scripts, Devops for the deployment.

Microsoft Azure and setting up communication with the help of endpoints.

Helped to develop a backup and recovery strategy for databases on a virtualization platform utilizing Microsoft Azure.

Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from Azure SQL database to Azure Data Lake Raw Zone.

Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.

Environment: MS SQL Server 2017, SQL Server Reporting Services (SSRS)2017, SQL Server Integration Services (SSIS),Visual Studio 2017,Azure SQL Database, Azure Data factory, Azure Data Lake, SQL Server Management Studio (SSMS).

Cotiviti Health Care (Blue Bell, PA) May17-Sep18

Role: SSIS/SSRS/ETL Developer

Responsibilities:

Developed MS Access VBA code and SQL for the claiming compliance application.

Created Technical design specification documents based on the functional design documents and the physical data model.

Supported data extraction from legacy systems into flat files for loading into Puddle claims database.

Developed Stored Procedures in SQL for extracting and performing data transformations on the legacy data and load into the claims database.

Optimized Stored Procedures and long running queries using indexing strategies and query- optimization techniques.

Monitored and modified Performance using execution plans and Index tuning.

Responsible for Migrate Data from multiple sources like flat file and Excel to Single SQL Server table.

Used Stored Procedures, DTS packages, BCP for updating Servers.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Automated messaging services on server failures, for task completion and success.

Leveraged dynamic SQL for improving the performance, and efficiency.

Managed the migration of SQL Server 2012 databases to SQL Server 2014.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Developed highly efficient, complex batch T-SQL procedures and functions for serving ad hoc reports.

Created triggers on the tables enforcing data validation for better quality.

Used different type of transformations for data conversion, sorting and cleansing the data from different sources.

Used FTP and SFTP servers to transfer files to vendors.

Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.

Query Optimization and Performance tuning.

Performed backup/ restore, database objects such as tables, procedures, triggers, constraints, Indexes and views.

Environment: MS SQL Server 2014, VBScript, HTML, Version One, JIRA, Excel Application T-Mobile (Atlanta, GA) Mar15-Mar17

Role: MS SQL Server Developer/ Analyst (SSIS/SSRS) Responsibilities:

Installation and configuration of SQL Server 2014.

As a BI Developer analyzed the requirements and systematically designed the data mart for the online Services. Identified the dimensions, Fact tables and designed the data mart using star schema.

Worked with end users, business analysts and application developers to identify business needs and transforming business rules to database specifications.

Developed ETL Processes using SQL Server 2014 Integration Services to migrate data from Oracle data source into a SQL Server 2014 database.

Created SSIS Packages by using different kind of transformations (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicast).

Deployed SSIS packages across development, test and production environments using project deployment model.

Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.

Generate KPI for customer satisfaction survey results and disease management.

Created various reports like financial, audit and monitoring reports using Parameterized, Drill down and Drill through reports, Sub Reports, and charts using SSRS.

Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.

Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.

Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.

Deployed and scheduled Reports using SQL Server 2012 Reporting Services to generate all daily, weekly, monthly and quarterly Reports including current status.

Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012. Environment: MS SQL Server 2012\2008R2, SQL Server Reporting Services(SSRS)2012, Tableau SQL Server Integration Services(SSIS),Visual Studio 2010,T-SQL,PL/SQL. Client: Reliance Ltd. India Jun13 - Oct13

Role: SQL Server Developer

Responsibilities:

Installation and configuration of SQL Server 2014.

Patches and service packs to keep the database at current patch level.

Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions.

Monitor failed and long running MS SQL Server jobs.

Contact this candidate