Sql Server Data

RAJITHA CHEELAM Ph. No: 469-***-****

SQL SERVER BI Developer E-mail: *******.*******@*****.***

PROFESSIONALSUMMARY

* ***** ** ********** ** Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2008/2005/2000.

Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

Experienced in creating and using Stored Procedures, Views, User Defined Functions.

Involved in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.

Experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.

Good knowledge in developing and designing reports through SQL Reporting Services (SSRS) and Excel.

Experience in various reports like tabular reports, matrix reports, and parameterized reports using SQL Reporting Services (SSRS).

Experience in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, and Bar Charts, Page Trails and Density Chart.

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

Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using Server Integration Services (SSIS).

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Experience in creating Sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.

Having experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using Server Integration Services (SSIS).

Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.

Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.

Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

Can work in a fast-paced environment, Good team player and can work independently.

EDUCATION

Master of Computer Applications from Osmania University, Hyderabad, India

Bachelor of Computer Science from Osmania University, Hyderabad, India

TECHNICAL SKILLS

Microsoft Languages

.Net Framework 3/3.5, C#.NET.

Data Warehouse Tools

SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS), SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler.

Databases

MS Access, MS SQL Server 2000/2005/2008/2012, Oracle 8i/9i/10g, MYSQL. Tools/Utility, Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler.

Non-Relational DB

MongoDB 2.6/3.2

Reporting Tools

Excel, SQL Server Reporting Services 2012,2008,2005, Crystal Reports 8.0

BI Tools

Tableau(Desktop/Server/Dashboards)8.3/9.0/10.1, Business Intelligence

Web Servers

Internet Information Server (IIS) 5/6/7/8

Languages

C, C++, Java

Web Technologies

Java Script, HTML, CSS

Configuration Tools

Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS)

Operating Systems

Windows 2003/2008/2012/2013 Servers

Other Tools

MS Office, Visio, MS Excel, MS-Project 2000.

PROFESSIONAL EXPERIENCE

Inventive Health, Dallas, Texas Mar’16 to Till Date

Designation: SQL Server BI Developer(SQL/SISS/SSRS/Tableau)

Project: Clinical Educators Performance

Responsibilities:

-Involved in Requirement Gathering, Analysis, Implementation, Development and production

-support of the application.

-Created dynamic queries to perform ETL operations by looping through multiple database servers and tables.

-Imported and Extracted data from various sources such as flat file, access, SQL Server and loaded those data into SQL Server to build various reports.

-Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 9.0

-Troubleshoot SSIS packages and migration procedures and Document complex SSIS packages and migration procedures.

-SQL Server database modelling, design and development with complex SQL scripts, Stored procedure, Views, Defined Functions, Triggers.

-Designed and developed mappings to load the data from flat file to SQL Server tables for

reporting purposes.

-Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ Dashboards 10.0.

-Involved in creating’s reports, creating Stored procedures and improving query performance.

-Developed stored procedures and views for data import and manipulation.

-Expert in Extracting and Transforming data using DTS in SQL Server, SSIS in SQL

-Server 2005, SQL Server Import Export, Bulk Insert.

-Restricted data for particular users using Row level security and User filters

-Used Both Mongo DB and T-SQL database as the source for the SSRS reports.

-Implemented ASP.NET AJAX Web Services to generate customer number.

-Configured User row level security for data in the Dashboard.

-Working on analyzing the existing BI infrastructure and coordinating with various teams to install and configure single node Tableau Server 9.0/10.0 environment.

-Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

-Generated periodic reports, charts based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

-Developed the application with a minimal support by following Experian Architectural standards in view.

-Developed Services using Windows Communication Foundation (WCF) for integration with other systems.

-Created complex Stored Procedures, functions, views, and others Joins for application using T- SQL

-Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.

-Used SQL Profiler to trace Performance of Queries and to index the Tables.

-Created a database impact tool to determine the full extent of change impact on database

objects and Create Custom T SQL scripts and SSIS packages for data integration, data

maintenance & bug fixes.

-Developed several complex ETL Mappings, Mapp lets and Reusable transformations for data loads that follow the user requirements and business rules. Usage of Dynamic Execute Immediate statements to fetch data as needed for Dynamic SQL.

-Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds and Created a field/column mapping and tracing tool to verity database object changes.

-Scrum master for data migration projects and Test driven development.

-Developed software test plans, test design specifications, and test scripts for various test scenarios and Performed Unit Testing for the project.

Environment: SQL Server 2014/12, SQL Server Integration Services (SSIS), Tableau Server, Tableau

Desktop, ASP.NET, C#, T- SQL, MongoDB, SQL Server Reporting Services(SSRS), SQL Server Business

Intelligence Development

Studio, XML, Report Manager, Windows.

Pegasus IT, Dallas, Texas, Sep’14–Nov’15

Designation: SQL Server BI Developer(SSIS/SSRS)

Project: Trade Exception Manager

Responsibilities:

-Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

-Designed and developed SQL Server Integration Services (SSIS)Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.

-Involved in complete SQL Server Integration Services (SSIS)life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

-Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

-Involved in ETL architecture enhancements to increase the performance using query optimizer.

-Implemented Event Handlers and Error Handling in SSIS packages.

-Created SSIS packages for Data Conversion using data conversion transformation.

-Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.

-Advanced extensible reporting skills using SQL Server 2008Reporting Services (SSRS).

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

-Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

-Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.

-Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.

-Worked closely with business power users to create reports/dashboards using Tableau Desktop.

-Coordinated with front-end for implementing logic in stored procedures and functions.

-Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.

-Involved in upgrading from SQL Server 2005 to SQL Server 2008.

-Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), Tableau, TSQL, C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Pegasus IT, Dallas, Texas Mar’13 – Sept’14

Designation: SQL Server BI Developer (SSIS/SSRS)

Project: Think Finance

Responsibilities:

-Design/Build Extract Transform Load procedures in SQL Server Integration Services.

-Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.

-Troubleshooting ODBC and OLEDB connection issues in SSIS packages.

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

-Designed the packages to extract data from SQL DB, flat files and loaded into Oracle database.

-Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.

-Developed user defined financial reports to provide on demand financial data analysis using SSRS.

-Performed data conversions from flat files into a normalized database structure.

-Developed numerous ad-hoc reports using SSRS for day to day financial reporting.

-Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.

-Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.

-Data migration (import & export – BCP) from Text to SQL Server.

-Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

-Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: SQL Server 2008 Enterprise Edition, SQL Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008, .NET Framework, C#, ASP.NET, CSS, T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008, MongoDB 2.6/3.2.

Mahindra Satyam, Hyderabad, India Sept’12– Jan’13

Designation: SQL Server BI Developer (SSIS/SSRS)

Project: Western Union

Responsibilities:

-Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

-Wrote efficient stored procedures for the optimal performance of the system.

-Monitored performance and optimized SQL queries for maximum efficiency.

-Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.

-Created indexed views and appropriate indexes to reduce the running time for complex queries.

-To keep track of data manipulations using Audit functionalities.

-Generated custom and parameterized reports using SQL Reporting Services (SSRS).

-Created reports that call sub reports in SQL Reporting Services (SSRS).

-Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.

-Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

-Responsible for creating datasets using T-SQL and stored procedures.

-Created several packages in SQL Server Integration Services (SSIS).

-Scheduled the packages to keep extracting the data from OLTP at specific time intervals.

-Used various transformation tasks to create ETL packages for data conversion.

-Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

-Responsible for rebuilding the indexes and tables as part of performance tuning.

-Used SQL Server Agent for scheduling jobs and alerts.

-Performed Query optimization & Performance Tuning.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SQL Server Integration Services (SSIS) 2008, SQL Reporting Services (SSRS) 2008, C#, T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access.

Mahindra Satyam, Hyderabad, India Jan’11–Sept’12

Designation: SQL Server BI Developer (SSIS/SSRS)

Project: MoveNetworkSystem

Responsibilities:

-Involved in documenting the code for understandability.

-Participated in creating reports that deliver data based on stored procedures.

-Experience in creating snapshots of static reports and configure subscription.

-Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.

-Involved in developing triggers to audit schema changes at the database level.

-Created sub-reports to present more detailed information about the summary.

-Designed and implemented stored procedures and triggers for automating tasks.

-Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.

-Data from various sources like flat files, to SQL Server database Using SSIS Package.

-Used Lookups Transformation to get the data from reference data sets Scheduling the SSIS packages and Jobs.

-Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.

-Making a Report as per user requirement using MS Reporting Services 2005/2008.

-Created SSIS Packages to migrate slowly changing dimensions.

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

-Worked on improving the performance of the system.

-Created permanent tables, temporary tables and table variables.

-Used Query Analyzer to optimize SQL queries.

Environment: SQL Server 2005/2008, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), C#, VBScript, ASP.NET, T-SQL, MS Excel 2003, MS SQL Query Analyzer, SQL Profiler.

Contact this candidate