Raghu

Certified SQL BI (SSIS/SSRS/SSAS) Developer

Email: ac0hc6@r.postjobfree.com Contact: 636-***-****

Summary:

Over 3 years of strong experience in the IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS-SQL Server [2014/2012/2008R2/2008] for both OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical and manufacturing.

Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance

Experience in Performance Tuning and Query Optimization.

Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.

Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation.

Expertise in creating visualizations and reports using Power BI.

Expertise on creating multiple kinds of Power BI Reports and Dashboards

Good knowledge of System Development Life Cycle (SDLC).

Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.

Created Reports with complex formulas and to query the database for business Intelligence.

Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.

Worked Extensively on ETL process using SSIS package.

Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations

Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.

Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.

Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.

Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.

Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

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

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Developing reports on SSAS & SSRS on SQL Server [2014/2012/2008R2/2008] Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.

Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server [2014/2012/2008R2/2008]

Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.

Education:

Masters in Computer Science from Frostburg State University, MD, 2016

Bachelor of Engineering Computer Science from JNTUH India, 2014

Technical Skills:

Databases

SQL Server 2014/2012/2008/2008R2/2005, Oracle 8i/9i/10g/11g, MYSQL

Database Tools

SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Power BI, Data Transformation Services (DTS), Power View, ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages

T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA

OLAP

SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau

Change Management Tool

Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems

Windows Server 2000/2003/2008/2012, MS DOS, Unix, Linux.

Professional Experience:

Imperial Marketing, South filed, MI., M Aug 2016 - Present

SQL BI (SSIS/SSRS/SSAS) Developer

Imperial Marketing is a comprehensive sales and marketing firm focused on all aspects of brand building encompassing extensive experience in the conception, planning and execution of customer based initiatives. We take a consultative approach that assists our clients identify revenue objectives and help them to put in place systems and processes enabling them to access our

expertise at scalable levels targeted to their specific requirements.

Responsibilities:

Involved in gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.

Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.

Involved in debugging Reports and deploying Reports.

Scheduled the Reports to run automatically.

Extract Transform Load (ETL) development using SQL Server 2008, SQL 2012 Integration Services (SSIS).

Experience in creating complex SSIS packages using proper control and data flow elements with error handling.

Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.

Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.

Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL Code.

Experience in handling Tabular Data Modeling in SSAS.

Created reports in Power BI Desktop and published to portal utilizing the SSAS Tabular via Analysis connector.

Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2.

Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2012.

Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.

Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.

Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS.

Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs

Used Multi-dimensional expressions (MDX) to present the date asked by the user, to simultaneously query on different dimensions.

Developed Analysis Services Project. Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.

Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.

Developed charts and various visualization using Power View.

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Created Informatica mappings with T-SQL procedures to build business rules to load data.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Used Performance Point Server to create interactive reports with an ability to drill down into details.

Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic

Experience in Performance Point Server powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.

Created SSIS packages to migrate data from Oracle DB to SQL Server 2008R2.

Involved in Data migration (Import & Export using BCP) from text to SQL Server2008.

Involved in Creating Stored Procedures for Reports generation.

Performed Documentation for all kinds of reports and DTS and SSIS packages.

Designed and implemented stored procedures and triggers for automating tasks.

Developed data interface layer using ASP.NET and C# for data access.

Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS and Crystal Reports with .NET applications.

Involved in the design, development and implementation of web user interfaces using C#. NET, ASP.NET

Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Filter and sorting data using Power View in Excel 2013.

Tested applications for performance, data integrity and validation issues.

Environment: SQL Server 2014/2012/2008R2, SSIS, SSAS, SSRS, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003 & UNIX, Informatica, .NET, C#, Agile Programming, ASP.NET, C#, Shell Scripting, Oracle, Crystal Reports.

Walking Tree Pvt. LTD. Hyderabad, India Oct 2013- Jul 2015

SQL BI Developer

Effective testing methodologies has become a critical factor for improving the odds of a new product’s commercial success. This necessitates a high order of cleverness in the analysis as well as process beyond mere risk management, cost control, improve and automate over time. Our end-to-end analysis services enable our customers to accelerate the delivery of their products and services on the cutting edge of innovation.

Responsibilities:

Involved in migration of SQL Server 2008 to 2012/2014.

SQL Server 2008 Reports Writer and performed complex SQL report writing and design.

Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.

Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports

Used Jasper Reports as a reporting tool.

Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.

Design the ETL for the data load.

Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Develop reports using MS Power BI, enhancing pivot tables and charts with power pivot.

Created reports using crystal reports.

Maintained and updated Jasper reports.

Create Master Package to run different other ETL in one Master package.

Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Trouble shoot any kind of data issues or validation issues

Created stored procedures using Common Table Expression (CTE) and various types of UDF functions

Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.

Bug fixes in SSIS, SSRS and stored procedures as necessary.

Used C# and VB Scripts in ETL Packages where ever necessary.

Developed web based ASP.NET internet applications

Worked in an agile scrum methodology.

Scheduling the jobs to run for ETL using SQL Server Agent.

Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.

Designed and developed the reports according to the requirements using Tableau and Power Map.

Created Informatica mappings with T-SQL procedures to build business rules to load data.

Played roles like production support of SSIS and SSRS jobs.

Perform T-SQL tuning and optimizing queries for and SSIS packages.

Created SSIS process design architecting the flow of data from various sources to target.

Created numerous simple to complex queries involving self joins, correlated sub queries, CTE's for diverse business requirements.

Worked on Incremental Loads using concepts like Checksum and Column to Column compare.

Scheduling SSRS jobs and production support.

Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS

Environment: SQL Server 2014/2012/2008R2/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, ASP.NET, T-SQL, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, Informatica, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Contact this candidate