Subba Rao

510-***-****

acy2az@r.postjobfree.com

www.linkedin.com/in/subbarao1984

Objective:

To obtain a position as a BI/SSRS/SSIS Lead Developer, Microsoft SQL Server Developer

Professional Summary:

9+ years’ experience in Requirement Gathering, Analysis, Design, Software Development, Testing, and Business Intelligence (SSIS, SSRS, SSAS).

Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2005/2008/2008R2/2012/2014, MS Access databases and strong knowledge of SDLC principles.

Expertise in creating Sub-Queries and Joins for complex queries involving multiple tables, error handling and Exception Handlers used in Stored Procedures, Views and User Defined Functions.

Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Involved in Query Optimization and Performance Tuning using SQL Profiler, Index Tuning Wizard and stored procedure Debugger.

Proficient in SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Aggregate, Derived Column, Event Handlers, and Error Handlers etc. and extensively used SSIS to load Data Warehouses.

Strong experiences to design, deploy, and maintain various SSRS reports in SQL Server.

Excellent experience in designing and developing stylish and complex reports like reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and ad-hoc reports using Global variables, Expressions and Functions for Business Users using SQL Server Reporting Services (SSRS).

Expert in Creating and Deploying SSRS Reports on the portal for user accessibility

Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Experience in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server Analysis Services Business Intelligence (SSAS, SSRS).

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.

Experience in developing testing and debugging C# routines and overseeing execution.

Development support experience including database object creation and maintenance, performance analysis, and troubleshooting.

Worked on package migration from SQL Server 2008 R2 to SQL Server 2012.

Excellent interpersonal skills with problem solving and analytical skills.

Strong communication skills (oral and written) along with good organizational skills.

Experience working with code repositories such as GitHub, SVN and Team Foundation Server (TFS)

Experience in working with both Agile and Waterfall methodologies

Education Qualifications:

Bachelor of Technology in Computer Science & Information Technology, JNTUH. 2002 - 2006

Technologies:

MS SQL Server 2012,2008/2005, MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Tableau, MS SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), SQL Server Management studio, T-SQL, MySQL, Tableau, Power BI, Team Foundation Server(TFS), MS office 2003/2007, Windows 2000/2003 Server/Professional, XML.

Projects Summary:

Weltman Weinberg & Reis (WWR) (Cleveland, OH) Apr 2016-Till date

DWH Engineer

Responsibilities:

Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.

Looked at the reports and fixed bugs in stored procedures.

Extensively worked on views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.

Monitored scheduled jobs and alerts.

Responsible for gathering/refining requirements from the customer for developing reports.

Responsible for transferring the data using SSIS packages.

Developed, monitored and deployed SSIS packages.

Improved Report Performance and performed unit testing.

Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Created a cube using multiple dimensions and modified the Relationship between a Measure group and a dimension using SSAS.

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.

Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.

Developed and maintained multiple Power BI dashboards/reports and content packs.

Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.

Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.

Published Power BI Desktop reports created in Report view to the Power BI service.

Motifworks Technology Solutions LLP (Bangalore India) Apr 2012-Dec 2015

Lead - Business Intelligence (MSBI)

Project#1: Client: Weltman Weinberg & Reis (WWR)

Responsibilities:

Managed a team of 13 members and responsible for on time deliverables.

Worked on C# application where the database rows been processed as row by row to an xml to generate the output files in the required format.

Designed SSIS Packages, and/ or enhanced the existing SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task etc. to extract data from disparate sources (SQL Server, Oracle, Teradata, Access and Excel) to generate underlying data for the reports.

Developed T-SQL query, stored procedures and functions to retrieve data for reporting.

Validated the daily, weekly, monthly grain transformed data by comparing it with the source system.

Worked with internal customers to gather and analyse business requirements to identify and solve problems.

Implemented Calculated Members and Actions such as URL Actions, Report Actions and Drill Through Actions in SSAS 2008.

Responsible for building the report solution like drill-down, drill-through, and linked reports using SSRS, testing for quality and finally review with the customer to ensure the solution meets requirements.

Supported the efficient delivery of standard and ad-hoc reports with an emphasis on automating where possible.

Generated weekly, monthly and quarterly reports for the management using different techniques like data filtering, adding interactivity, deploying reports to report server in SSRS.

Project #2: Client: Carl Zeiss

Responsibilities:

Designed, developed, modified and enhanced the database structures and database objects in a MySQL database.

Developed Data Flow Diagrams, Entity Relationship Diagrams and Data Structure Diagrams.

Worked on backup and restore process as and when required.

Ensured 24x7 database availability, reliability and security while in a production environment.

Recognized and fine-tuned the database for its specific behaviours.

Collaborated with developers, architects, and business stakeholders to create high-performance, cost-effective solutions.

TATA Consultancy Services (TCS) Bangalore India Apr 2011 - Mar 2012

Client: Super Partners (Sr. System Analyst)

Responsibilities:

Worked on SSIS Packages and SSRS Reporting development

Writing Technical specifications for business rules and designing code for the spRIGHT application in SQL Server 2008 R2 database.

Resolving the issues by communicating with the clients through workshops.

Coordinating with the Business Analysts on changes in the existing functionality and on future requirements.

Worked on SSIS Package for data importing and cleansing. Extracted cleaned and validated.

Analysing the requirements and finding out the solution for different funds without changing the existing functionality.

Developed Tabular Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS). Running SQL profiler traces to check any issues with the application

Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights

Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau

Created Interactive reporting dashboards by combining multiple views.

Sun Technologies, Inc. Bangalore, India Jun 2010 - Jan 2011

BI Developer

Responsibilities:

Interface with business to gather Business Intelligence requirements

Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Text file, Excel Spreadsheets, CSV files and MS Access to data warehouse.

Created reports using SSRS from OLTP and OLAP data sources and deployed on report server

Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports as per business requirement.

Execute Business Intelligence solutions including ETL, OLAP, and Reporting requirements

Tested the data with complex queries, joins and sub queries.

Production support

Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application

IDEXCEL, Hyderabad, India May 2008 - May 2010

BI Developer

Responsibilities:

Created SSIS Packages to integrate data coming from Text files and Excel files.

Extensively worked on all activities related to the development, implementation and support of ETL (Extract, Transform and Load) processes for large-scale data warehouses using SQL Server SSIS

Scheduled SQL Job using SQL Agent to automate all the SSIS packages.

Monitored daily jobs and resolved the issues that caused by production data by modifying the SSIS packages.

Created an SSIS Package for data importing and cleansing. Extracted cleaned and validated.

Worked on Data Flow Transformations like Aggregate, Audit, Conditional Split, Data Conversion, Derived Column, Look up, Slowly Changing Dimension and Script Component etc.

Worked on Data Flow Task, Execute Package Task, Execute Process Task, Execute SQL Task, File System Task, and Script Task and Send Mail Task etc.

Monitored scheduled jobs and alerts. Improved report performance and performed unit testing.

Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.

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

Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.

Understood the various complex reporting requirements of company and created web reports using Reporting Services

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Modified report content and exported reports in multiple formats based on user input.

Modified existing reports as per the requirements of the end users.

MAKRO Technologies, Hyderabad, India Feb 2007- Apr 2008

Software Engineer

Responsibilities:

Created SSIS packages and transferred them to the appropriate destinations.

Proficient in implementing all transformations available on the SSIS toolbox.

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages

Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated

Responsible for creating reports based on the requirements using SSRS 2005.

Identified the database tables for defining queries for the reports.

Developed reports using SSRS 2005. Used table control, matrix control for cross tab reports.

Defined the report layout and identified Datasets for the report generation.

Built drill down reports and parameterized reports using SSRS.

Created different type of reports including Cross-tab, Conditional, Drill-down and Sub reports. Created numbers of complex formula in sub report.

Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Developed and implemented Stored Procedures, Triggers, and Functions.

Designed, developed, modified and enhanced the database structures and database objects.

Developed and implemented procedures to ensure the quality, usability and accuracy of reports.

Created Packages to group logically related column types and to transfer data.

Contact this candidate