Sql Server Developer
Resume:
Kusuma K
Email: ******.****@*****.***
Mobile: 321-***-****
Professional Summary:
Over 7 years of professional work experience in System Analysis, Design, Development, and Implementation of MS SQL Server (Client/Server applications).
Well versed in all vital phases of Software Development Life Cycle (SDLC). Including preparing development strategies, analysis, design, development, program specifications, coding, code reviewing, test plans & testing, coordinating the implementation of the application software with the customer support groups.
Extensive experience in writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and Triggers.
Experience in creating databases and various SQL server objects like schemas, tables, indexes, indexed views as per the specifications and requirements to meet the business functionality.
Experience in creating complex Stored Procedures, effective User-Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
Good knowledge in system tables and system stored procedures using T-SQL.
Proficient in SQL Server 2005/2008/2012 and MS SQL Server products like SSIS and SSRS
Strong work experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading (DTS/SSIS) of data from multiple solutions into Data Warehouse.
Experience in working with SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
Expert in development, implementation, administration and support of SSIS packages for data load.
Expert at understanding the business and transforming requirements into SSIS packages.
Experience in deploying the SSIS packages and creating scheduled jobs in MS SQL Server to execute the packages.
Extensive Knowledge in tuning T-SQL queries and improving the performance of the database application.
Extensive experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix and chart report.
Experience in creating simple, parameterized, ad-hoc, linked and custom reports using SSRS 2005/2008/2012.
Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008/2012.
Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly and quarterly reports.
Experience in working with programming language C#.Net and VB.Net to maintain and continue development for existing application.
Technical Skills:
Databases: MS SQL Server 2005/2008/2012
ETL: SQL Server Integration Services SSIS/DTS
Reporting Tools: SQL Server Reporting Services (SSRS)
Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligent Studio (BIDS), SQL Profiler.
Development Tools: Visual Studio 2003/2005, VSS, VSTF
Languages: C# .Net, VB.Net
Services: Windows Services
Middleware: ADO.Net, ADO, ODBC, OLE DB.
Web Servers: IIS 6.0/7.0
Operating Systems: Windows NT 95/98/2000/2003/2008/2008 R2/XP, Windows 7
Education:
BS in Computer Science, India.
Certifications:
Microsoft Certified Technology Specialist – SQL Server 2008 Implementation and Maintenance (MCTS)
Microsoft Certified Professional Developer
Microsoft Certified Software Developer in SQL, ASP.NET and XML WEBSERVICES
Projects Summary:
Project: Results Companies, Orlando, FL.
Client: GE Appliances.
Role: Sr. SQL Database Developer (T-SQL, SSRS, SSIS), January 2015 - Till Date.
Description:
Results Companies is a Call Center IT Management and Reporting Company. Results generates 4000 reports daily around the globe for outbound and inbound clients such as US Robotics, GE Appliances. Generally reports in Microsoft Excel, Web reports using SSRS containing statistics and metrics.
Working as SR. SQL Database developer for GE appliances application which was deployed corporate-wide. The main objective of the project is to maintain and organize "GE Enterprise Centralized Database". It implements the incoming information from web applications, further more load the financial and sales data to the corporate database about. This database keeps track about the customer status and revenues made by products of GE Appliances which were sold to the customers and their warranty agreements . All centralized information is categorized into two different modules, Financial Information and Sales Information, which is also exported to the web reporting system to generate reports on Finance and Sales using SQL Server Reporting Services (SSRS).
Responsibilities:
Use SQL Server Management Studio for retrieving data using T-SQL Queries and Sub-queries.
Involved in writing T-SQL statements for creating Tables, Views, Constraints, User-Defined Functions and Triggers.
Created indexes to improve the performance of the queries.
Written complex T-SQL procedures using temp tables, cursors, sub queries and functions.
Improved automation of existing processes of SQL using stored procedures and SSIS packages.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
Used SQL Server Integration Services (SSIS) to perform bulk insert operations from SQL Server databases to flat files/CSV files and vice versa.
Implemented incremental loading as per the daily changes in source database and applied event handlers and check points and error logging on the failure of packages.
Developed and implemented ETL processes using SSIS for data conversion from multiple data sources of legacy system data to target database schema.
Extensively used SSIS transformations such as Data conversion, Conditional split, SQL task, Script task and Send Mail task etc.
Created SSIS packages for File Transfer from one location to other using FTP task.
Developed, implemented and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality and reliability checks.
Extensive knowledge in using system variables and creating User-Defined Variables for SSIS packages
Extensive knowledge in using Package Configuration Wizard to configure SSIS packages.
Designing, Managing and Publishing various Dash boards using SQL Server Reporting Services.
Created Tabular Reports, Matrix reports, ad-hoc reports based on the business requirements using SSRS.
Extensively worked on expressions to join the multiple datasets and create the reports as per the business requirements.
Developed Parameterize and custom reports and deployed them using SSRS.
Formatted the report layout as per the requirement of the end users using SSRS.
Generated SSRS Reports using Global variables, Expressions and functions for the reports.
Provided technical guidance and support to end-users by developing documentations required.
Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS 2008/2012), Business Intelligence Development Studio (BIDS).
Project: Walmart - Sales and Operations Planning, Bentonville, AR.
Role: SQL- Database and ETL Developer, February 2014 to December 2014
Description:
Walmart is mainly a Retail Marketing company with stores all over US. The application Sales and Operations Planning (S&OP) is a cross-functional supply chain & sales planning methodology.
Sales & Operations Planning (S&OP) is a business process that helps to keep demand and supply in balance. It is a web based tool developed using ASP.net, C# and SQL Server. It is a Forecasting tool being used by Walmart internal people like Marketing, Sales, Finance and the Account Executives. S&OP tool collects the 18 months forecast data from the different users at different levels like Product (Product Division, Product Family and Product), Geography (Region, Sub region and country) and Customer levels.
Responsibilities:
Creating and managing schema objects such as tables, views, indexes, stored procedures and triggers.
Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
Wrote and modified the store procedures to implement the complex business needs for generating product level and geography level forecasting.
Created SSIS packages to populate data from various data sources.
Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
Developed Tabular reports, parameterized reports using SQL Server Reporting Services (SSRS).
Configured SSIS packages using package configuration wizard to allow packages run on different environments.
Worked with Meta-Data Driven SSIS packages to pull the data from different sources and load to Data mart.
Developed complex SSRS reports using multiple data providers, Variables, Expressions, User defined objects.
Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
Built ad-hoc reports using SQL Server Reporting Services (SSRS).
Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa.
Conducted data import and export operations using DTS wizard.
Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS 2008/2012), Business Intelligence Development Studio (BIDS).
Project: OCPS - State Reporting System, Orlando, FL.
Role: Data Analyst/Database Developer, July 2013 to January 2014
Description:
Orange County Public Schools (OCPS) is the school district for Orange County, Florida. It is based out of the Educational Leadership Center, has earned a reputation as a premier school system.
Integral member of the State Reporting Team, providing technology support to meet the school district’s State Department of Education Reporting Requirements in order to maximize efficiencies and funding for schools; on Windows and SQL Server platforms.
Developer of the in house developed high profile web based State Reporting System (SRS) amendment and transmission system using .NET and SQL Server. This initiative replaced a portion of district legacy system (mainframes); provided streamlined state reporting and amendment process to district schools, including change management and training to 4000+ end users.
Responsibilities included Requirements gathering, eliciting business requirements; creating technical and functional Specifications; database development; data integration using SSIS and SQL; SRS report building and management, data quality development; quality assurance and LOB (Line of Business) applications support.
Responsibilities:
Created logical and physical database design, data structures and maintained it by using SQL Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
Used Joins and sub-queries for complex queries involving multiple tables from different databases.
Optimized the database by creating various clustered, non-clustered indexes and indexed views.
Involved in designing web forms using C# and ASP.NET.
Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SQL Server Integration Services (SSIS).
Developed SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
Used different transformations lookup, condition split, row count Transformation, Derived Column, Data Conversion, Union All in SSIS.
Experience in writing script tasks using C# in script component task.
Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
Created parameterized reports and linked reports using bookmark links and hyperlinks.
Written the custom code in Reports to avoid the case statement in the SQL stored procedure.
Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
Created jobs, alerts to run SSIS packages periodically.
Participated in the creation of Analysis Service (SSAS) objects such as Cube, Dimensions, MDX queries.
Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
Performing unit testing and integration testing.
Environment: MS SQL Server 2008 R2 (TSQL/SSRS/SSIS/SSAS Developer), Visual studio 2008 C#, ASP.NET, ER-Win, VSTF, VSS, Windows 7
Project: Implementation of ERP - Johnson Controls, Mumbai, India
Role: SQL Developer, January 2012 - June 2013
Description:
Implementation of Ramco e.App an ERP, It was the initiation of Johnson controls. All their manufacturing partners units have a very good data base system for their business operations. They would like to establish the same with Indian partner, a fresh Implementation of ERP. Based upon the business requirements the base product has been customized and the new reports were developed as a part of Implementation. In that I took part of sales module and Tax module. I played a major role for Sales and sales Tax module Implementations. This project involves collection of relevant details to build the master data and to test the same in the ERP to suit to the needs of the clients, Continuous contact with the users to make fool proof systems.
Responsibilities:
Assists the design, coding, testing, and implementation of databases, and applying knowledge of database design standards and database management systems (DBMS).
Monitor the progress of the project & prepare documents for management
Attend business meeting and gather the new business requirements.
Performs projects tasks to ensure that associated deliverables are completed in a timely manner.
Designed physical development databases on SQL 2008/2008 R2 using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in developing database for contract maintenance system.
Design & implementation of Views, stored procedures and triggers.
Write technical design documentation for alterations to current state systems and future project designs.
Responsible for writing complex stored procedures using sub-queries, joins, case statements, temp tables, cursors and functions.
Using SQL Profiler to find out the long running queries and stored procedure and fix the queries and stored procedure.
Designed DTS/ETL to extract external data source. Responsible for extracting the data based on business requirement.
Responsible for exporting data into various formats like CSV, XLS and etc.
Designing, Managing and Publishing various Dash boards using SQL Server Reporting Services (SSRS).
Responsible for analyzing the data if daily process failed or any data inconsistency.
Environment: SQL Server 2008/2008 R2, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), Windows 98/XP
Project: State Bank of India, Mumbai, India
Role: SQL Developer November 2009 to December 2010
The Origin of the State Bank of India goes back to the first decade of the nineteenth century with the establishment of the Bank of Calcutta in Calcutta on 2 June 1806. The bank is entering into many new businesses with strategic tie ups - Pension Funds, General Insurance, Custodial Services, Private Equity, Mobile Banking, Point of Sale Merchant Acquisition, Advisory Services, Structured Products etc - each one of these initiatives having a huge potential for growth.
The Project works with Create new reporting data models by working with internal clients, directors, analysts and developers to deliver high-performance, high-integrity business intelligence reporting.
Responsibilities:
Involved in project planning, scheduling for database module with project managers.
Created Tables, Stored Procedures, Views, Indexes, User-define Functions, Cursors, Joins and Triggers.
Created indexes to improve the performance of the queries.
Optimize long running store procedures and queries for effective data retreival.
Used SQL Server Integration Services (SSIS) to perform bulk insert operations from SQL Server databases to flat files/CSV files and vice versa.
Designed, developed and tested store procedures, views and join queries for SSRS reports.
Created Tabular Reports, Matrix reports, ad-hoc reports based on the business requirements using SSRS.
Extensively worked on expressions to join the multiple datasets and create the reports as per the business requirements.
Formatted the report layout as per the requirement of the end users using SSRS.
Performed Job scheduling to ensure the data loads on daily basis.
Monitoring the jobs by creating alerts for job failures using SQL Server Agent, Analyzed the reason for job failures and resolved the issues.
Environment: SQL Server 2005, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
Project: Kamineni Hospital's & Health Systems, Hyderabad, India
Role: Developer May 2008 to October 2009
Description:
Kamineni Group was started in Andhra Pradesh, India in 1995. Kamineni Hospitals is a model that combines the best of healthcare and other businesses that contribute to the national market with high reputation for excellence in total care. This company unites the physicians and scientists with the health professionals and facilities that make up the broad, integrated "Kamineni Hospital's & Health systems (KHS)".
KHS has various applications running on different servers. Worked with development team for designing the data model of various applications using Erwin. Extensively worked using Visual Studio (C#, ASP.Net, ADO.Net and SQL Server in developing the health system.
I was also involved in supporting the application in production environment. As a member of the production support team, supported all the systems under Production Environment.
Responsibilities:
Involved in project planning, scheduling for database module with project managers.
Responsible for Analysis of specifications, Design and development, Coding using C#, ASP.NET, Database management, Testing - Unit Testing and Integration Testing
Involved in designing web forms using C# and ASP.NET.
Used ADO.Net objects to access data from SQL Server database by using stored procedures and queries in T-SQL
Designed SQL Server Database, created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, and functions in SQL Server 2005.
Design and develop SSIS packages to transfer data and to extract data from external data sources.
Generate Reports using SSRS by extracting the data from different databases.
Responsible for exporting data into various formats like CSV, XLS as required by the users.
Design and implemented the SSIS packages using scheduled SQL jobs to load data.
Creating the SQL Agent Jobs and Monitoring the jobs by creating alerts for job failures using SQL Server Agent, Analyzed the reason for job failures and resolved the issues.
Deployment of Application on Test and Production Server.
Performed Unit, Functional and Integration testing.
Providing support to the applications in production system. Technical and Root cause analysis of the issues/bugs found and fixing them.
Responsible for preparing entire user manual and documentation and assisting the end users.
Environment: Visual Studio 2005, C#, ASP.Net, ADO.Net, SQL Server 2005, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), VSTF, VSS.
Contact this candidate