Sql Server Developer

Stalin Babu Chennupati

Sr.SQL Server / BI Developer Email: **********.****@*****.*** Mobile : +1-510-***-****

Having 8 years of strong experience as a MS SQL Server Developer in various domains like Investment Banking and Healthcare with expertise in MS SQL Server 2012/2008r2/2005, SSIS, SSRS and SSAS. Proven ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

Professional Summary:

Having both offshore and onsite experience with managing offshore software development teams.

Highly proficient in using T-SQL, writing Stored Procedures, Triggers, Functions, Views and Cursors in SQL Server.

Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012, 2008r2, 2005.

Extensive experience creating complex packages for ETL purposes using various transformations in SSIS 2012, 2008, and 2005 as an ETL tool while transferring the data from various sources into the destination files.

Transformed data from various data sources to SQL Server using BCP, DTS and SSIS 2012/2008.

Creating the OLAP cubes using various dimensions and creating SQL Server Analysis Projects using SSAS 2008. Adept in defining referenced relationships and calculated members in SSAS, creating OLAP structures from OLTP databases.

Hands-on experience with Relational database modeling and Dimensional database modeling concepts, Fact tables, Dimensions and star/snowflake schemas implementation.

Extensive experience in Performance Tuning and Optimization of queries and stored procedures

Experienced in all phases of project life cycle, starting from business requirement gathering and analysis to testing and deployment.

Proficient in using SQL Profiler, Execution Plan, Index Tuning Wizard and Performance Monitor.

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

Excellent experience in designing, maintaining & tuning various RDBMS like T-SQL & SQL Server 2012/2008/2005, MS-Access databases.

Experience in Developing and Extending SSAS Cubes, Dimensions, creating calculated measures, partitions, aggregations and Processing and Deploying SSAS objects and developing reports using MDX and SQL.

Proficient in Migration of database, successfully migrated database from SQL Server 2005 to SQL 2008 and SQL 2008 to SQL 2012

Successfully migrated content from DB2 to SQL server 2008, Oracle 10.g to SQL Server 2008.

Involved in performance tuning of the queries in SQL server.

Database management including backups, restores, updating statistics and rebuilding indexes.

Good experience with Teradata utilities Fast Load, Multi Load, TPUMP, Fast Export and TPT Jobs.

Good knowledge of Object Oriented Programming and .NET Framework 2.0/3.5, ASP.Net, C#, ADO.NET, MVC.

Good knowledge in Web Technologies JavaScript, J-Query,Webservices, WCF, HTML, CSS and XML

Comprehensive knowledge of Software Development Life Cycle, having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and implementation.

Experience in Tableau Desktop & Server 9.x/8.x/7.x in analyzing and creating highly actionable and interactive reports and dashboards

Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

Having domain knowledge in Banking, investment management and Healthcare.

Technical Skills:

MS SQL Server 2012/ 2008r2/2008/2005, SQL Server Integration Services (SSIS), SQL Server DTS, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, XML, ASP.NET, C#, VB.Net, JavaScript, HTML,CSS, J-Query,MVC,WCF, Web services, Tableau reporting tool, Oracle, Teradata, Hadoop, Hive, Pig.

Work Experience:

Oaktree Capital Management, Los Angeles, CA

Benchmark Data Load and Reporting

Sep 2013 – Present

Sr MS SQL Server Developer (SSIS/SSRS/SSAS)

Description:

Loading data into SQL database and generating the reports on top of them. Oaktree gets benchmark data from their vendors Citigroup, BofA Merrill Lynch, CSFB and Barclays in different formats. So it’s a daily/weekly/monthly process that we load data into warehouse and then business users will run the required reports for the current month and historical periods.

Responsibilities:

Worked with Business users to understand the Business Logics as per the need

Generated various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS) for various projects

Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.

Creating SSIS packages using C# scripting, script components and script tasks.

Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for extracting, cleaning, transforming and loading data into data warehouse

Worked with DBAs in order to schedule SSIS packages as jobs either daily, weekly, monthly.

Writing complex PL/SQL queries and designed SSIS packages to load the data into warehouse

Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS

Developed Tableau visualizations and dashboards using Tableau Desktop.

Finding the root cause of a problem and then ensuring that it is resolved through the most appropriate solutions.

Environment: SQL Server, SSIS 2012, SSRS 2012, SSAS, PL/SQL, Asp.Net, C#, Tableau, Visual Studio.Net, TFS

Anthelio Healthcare Solutions, Dallas, TX

MS SQL Server/SSIS/SSRS Developer

May 2011 - August 2013

Healthland is an EHR provider focused exclusively on the rural hospital market. Healthland has a product by name Classic which used to maintain patient, provider, and financial information of hospitals. This application used DB2 as backend. In recent days, Healthland emerged with a new product Centriq which was developed using Microsoft .NET and used MS SQL Server 2008R2 as backend. The migration was carried in different phases such as financial information modules and clinical information modules.

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.

Successfully implemented indexes on tables for optimum performance.

Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Created ETL packages with different data sources (SQL Server, Flat files, Excel source files) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008.

Wrote MS SQL Server Store Procedures using existing Oracle logic.

Worked on creating and maintaining Oracle objects such as Tables, views, and PL/SQL queries.

Used SSMA for migrating data from Oracle to SQL Server.

Involved in testing to compare and verify the result set in Oracle database and SQL Server.

Environment: SQL Server, SSIS 2008, SSRS 2008, DB2, T-SQL, Oracle and SSMS, Asp.Net, C#, J-Query, TFS

Oaktree Capital Management, Los Angeles, CA

June 2009 – Apr 2011

MS SQL BI Developer

Client service template is an intranet application which generates reports of all clients. It outputs the data in designed format of a template. Report generation is in excel format by using Sync fusion. A report consists of information about each account holder or client. Client can schedule the excel reports to his email id monthly/weekly basis.

Responsibilities:

Dealt with requirements gathering, analysis, design, development, change management, deployment and user training.

Wrote complex T-SQL queries for various tasks such as functions, store procedure, triggers, cursors and various DML, DDL statements.

Involved in writing dynamic SQL queries to accommodate changing data type and column names.

Created, maintained, modified, and optimized SQL Server databases, database security and auditing

Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.

Scheduled Jobs and Alerts, and scheduling SSIS package using SQL Server Agent.

Connected Linked Servers to OLE DB data sources and providers.

Evaluated database performance and performed maintenance duties such as tuning, backup, and restoration.

Performed Data Analysis for automating various drugs related reports utilizing SQL Analysis Services.

Produced operational reports in SSRS 2008r2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.

Designed, programmed, deployed and tested the requested Reports.

Migrated DTS packages to SQL Server Integration Services (SSIS)

Environment: MS SQL Server 2008, SSIS, SSRS, PL/SQL, T-SQL, Windows 2008 Server, Asp.Net, C#, JavaScript, TFS

Airport Rooms, Chicago, IL

Dec 2008 – May 2009

MS SQL Server /SSIS / SSRS Developer

This is a web Portal through which user can book hotel and cars throughout the world. All the features like searching, booking and canceling the reservations are processed with XML web services. The portal also provides reports on reservation bookings and cancellations. The Admin module has the option of add/edit/delete users, their security permissions or access levels.

Responsibilities:

Participated with business analysts in order to gather requirements for design and implementation of database.

Worked on extracting, transforming and loading data using SSIS 2008 Import/Export Wizard.

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

Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS

Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

Created local variables and global variables package configurations and error handling.

Designed parameterized reports and ad-hoc reports using Report builder for the brokers and clients.

Responsible for designing, creating and deploying the reports into the production server.

Created complex store procedure to copy Database Objects from remote server to local machine and vice versa.

Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).

Created complex Stored Procedures, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: SQL Server 2005, SSRS, SSIS, MS Access, MS Excel, BCP, T-SQL, Query analyzer, Visual studio, SVN

COMPUTECH, DETROIT, MI

Jan 2008 – Nov 2008

MS .Net / Crystal Reports Developer

HHCMS (Home Health Care Management System) is meant to track the activities going on in care origin i.e. right from the referral source getting a patient to care origin till he discharged from the hospital and maintaining the information about the patients like patient info, patient caring info, hcp’s details, visits details. Care Origin gets the referrals/patients from different sources like hospital, relative, physician etc.

Responsibilities:

Involved in design, development and unit testing

Involved in creation of database tables, writing stored procedures and views

Involved in creation of User Controls and Master pages

Used visual source safe for version control

Generated few reports using Crystal Reports

Environment: MS .Net, ASP.Net, C#, AJAX, JavaScript, HTML, CSS, MS SQL Server 2005, Crystal Reports, VSS.

Education: B.Tech from JNTU, Hyderabad, India.

Contact this candidate