summary

• 7 years of IT experience as a MS SQL Server 2005/2008/2012 Developer and Business Intelligence with main focus on T-SQL, SSIS and SSRS. Good experience as a database developer in IT, Healthcare, Banking and Manufacturing sectors
• Extensive programming experience as Database Report Developer in Microsoft SQL Server 2008/2012 using T-SQL and Business Intelligence Data Tools and various platforms.
• Good experience in Design, Development, Implementation and Testing of Database systems using MS SQL Server 2005/2008/2012 DDL, DML, DRL and DCL commands for various Data Warehouse and business applications.
• Worked with databases like SQL Server 2005/2008/2012, Oracle 10g/ 9i, Ms Access and Expert in MS Office 2010.
• Experience in writing Complex T-SQL Queries, Dynamic Queries, Sub-queries, Complex Joins.
• Extensive experience in Database design using SQL, T-SQL in Stored Procedures, Views, Functions, Constraints Primary Key, Foreign Key , Triggers, Indexes and Batch Scripts.
• Have used TFS 2010 to support agile development practices to produce quality software.
• Experience in Performance Tuning and Query Optimization.
• Have reviewed various stored procedures with options, Function and T-SQL code and Improved the performance of queries by suggesting the DBA for appropriate Index, Views and Join Hints.
• Good knowledge in Data Warehousing methodologies, dimension modelling and ETL Process.
• Good knowledge in RDBMS concepts, data models, Star/ Snow Flake Schema.
• Expert in Extraction, Transformation, and Loading ETL data from various data sources using SSIS. Created packages to extract data from Oracle, Flat file and load into MSSQL.
• In SSIS I have worked with Lookups, Slowly Changing Dimensions, Fuzzy Lookup, Web Services, and Container and created Fact and Dimension Tables to use in Analysis Services SSAS for Creating Cubes and used that in Reporting Service SSRS .
• Developed reports on SSRS on SQL Server 2000/2005/2008 . Sound Experience and understanding of SSAS, OLAP cubes and Architecture.
• Have worked with implementation of Tableau Analysis Services.
• Used SSRS and created Table Report, Adding calculated Values, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
• Created reports that have been defined by Business Objects and generated Crystal reports.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Have performed DBA roles in Sql server 2008/2012
• Build, Deployed and Published the Reports to Report Manager Website. Have worked with XML and Web Services.
• Programming knowledge in .NET and to connect the .NET front end with Microsoft SQL Server Management Studio and Retrieve data.
• Increased query performance, necessary for statistical reporting by more than 25 after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Strong in Analytical, Technical Skills coupled with Good Communication and Interpersonal Skills and Ability to work in team environment and also individually.
• Have good ability to gather the Requirements, Analyse, and Plan according to the deadlines, Develop Queries, Test and Maintain in future.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Report Developer

Briggs Healthcare focuses on healthcare providers for more than 60 years as a retail industry. It's is headquarters is located in West Des Moines, Iowa. And its main branches are located in three other states Waukegan, Il and jesup, Atlanta. It has warehouse in many states from where the medical products are supplied. It has many customers like Amazon, Walmart, Walgreens, Target, Qvc, BJ, Overstock and many more. My role is in information technology to handle database, reports, .net and three major servers.

Responsibilities:

• Worked with SQL Server 2008 R2 and created multiple Stored procedures, views, tables, Functions and other SQL joins
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development
• I handled three main production servers that run the daily job that updated many tables.
• Used ATTask for project task and new project request
• Created and modified various Stored Procedures used in the application using T-SQL.
• Worked with TFS source control tool for reports and .net applications
• Interacted directly with the end client to find the requirements and developed multiple SSRS Reports.
• Created Data warehouse with star schema with dimension and fact tables.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.
• Worked with Tabular reports, Matrix reports, Gauges Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services SSRS .
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Worked on Microsoft visual studio 2010 .net C applications. Cleared multiple errors in the applications that is used daily.
• Scheduled Job to run in Visual Cron and monitored if the reports are properly delivered on time.
• Worked on performance tuning Projects and used Database tuning advisor, SQL Server Profiler and did query optimization.
• Created clustered index and non-clustered index based on the query and the table used.
• Have taken training in Database Administration and acquired Good ability to troubleshoot problems that arises on Database, Reports and Provide Training on using Reports.
• Performed SQL Performance tuning on Queries, Reports and used Join Hints, Clustered Index and improved the performance of queries and reports.
• Performed Unit, System Testing and created several Test Cases to validate the data from reports.
• Environment: Microsoft SQL Server 2008 R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , T-SQL, ATTask, TFS 2010, Visual Cron, Microsoft Visual Studio 2010, .Net/C

Confidential

SQL Server Developer

Confidential an expensive, large and cumbersome mainframe child support system, thin-client system using Microsoft technologies SQL Server and ASP . The client is, a Non-Profit Organization which has branches all over the USA. As a part of the IT team I was responsible for Migration as well as Integration for few modules such as Maintaining the Database, Updating the recent records to the system and creating reports whenever required. I was involved very closely from end to end right from business requirements and interacting with the end users.

Responsibilities:

• Created complex Stored Procedures, functions, triggers, views, and other SQL Joins for application using T-SQL
• Worked with development teams in the design of physical database and in modification.
• Experience in writing T-SQL scripts, dynamic SQL, Constraints, relational database models, data dictionary and data integrity.
• Designed and developed interactive dashboards that enabled stakeholders to focus on performance drivers.
• Developed multiple processes of daily reports using SSIS and SSRS.
• Created views for specific columns to maintain privacy of the customer data.
• Migrated data from different sources text based files, Excel spreadsheets, and Access to SQL Server databases using SQL Server Integration Services SSIS .
• Performed the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Created numerous ad-hoc and canned Reports using SSRS.
• Designed and developed matrix and tabular report with drill down, drill through and drop down menu option.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL Reporting Services.
• Implemented various reports for the migration to SSRS.
• Knowledge in creating Basic table Report, Adding calculated Values, Using Document Maps, Tablix Report, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
• Involved in post deployment and maintenance of reports.
• Developed ETL framework to extract and load the data from multiple database from SQL Server 2008 to File Server.
• Good knowledge on auditing the data that is entered in the OLTP and updated in Data Warehouse and used in report.
• Environment: Microsoft SQL Server 2008/2012, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Report Manager, T-SQL, Oracle 10g,11g, SQL, MS-Excel.

Confidential

SQL Server BI Developer

deposits and withdrawals from various customers. The major modules in the system are Deposit Booking, Withdrawal Partial, Full Deposit closure Pre mature, Mature Tax deduction, Central Integrity, Customer Statements, Query Module, BOD and EOD.

Responsibilities:

• Responsible for all technical SQL Server database operation, ongoing development for various in house databases.
• Designed and developed various database objects like Tables, Stored Procedures, Rules, User Defined Data types and functions.
• Modified current database by adding tables and relationships to support online system.
• Defined constraints, rules, and defaults and involved in Database Normalization.
• Have done various data conversions from various data sources to SQL Server using SSIS.
• Developed SSIS packages for integrating data using OLE DB connection from many sources Excel, CSV, Oracle, Flat file, Text format data by using multiple tools like conditional split, Bulk insert, merge, Union All, Lookup, Forloop and For each loop container.
• Created several tables, views using SQL Server management studio, based upon the functional specifications and primary key foreign key constraints.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Experience in building star and snowflake schema depending on the business data requirements.
• Scheduled nightly jobs for some of the process to run for the data flow.
• After creating the packages deployed the packages into management studio.
• Ability to run the packages from various methods like XML, cmd prompts, Sql Server.
• Customized existing Reports and developed new Reports to suit client requirements. Also created the test scripts for the generated final Reports.
• Used various types of reports layout options like charts bars, lines, pie etc . , images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Formatted the reports using Global Variables and expressions.
• Experience in deploying the created Reports in various sources like Web Browser and XML.
• Experience in developing custom reports and many types of Tabular Reports, Matrix Reports, and Drill down Reports, Parameterized, Conditional and Sub Reports using SQL Server Reporting Services SSRS in Business Intelligence.
• Environment: Microsoft SQL Server 2008, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , T-SQL, Oracle 10g,11g, SQL, MS-Excel.

Confidential

SSIS/SSRS Developer

Confidential uses the aggregated data to help customers to manage risk and identify more cost-efficient care options. Spectrum Health Group focuses on four main areas of operation, which include claims and payment integrity, disease management, clinical and quality outcomes and health care data intelligence. The project focuses on developing tools that enable rapid health care data aggregation and validation from medical facilities for clients that include health-insurance plans, hospitals, pharmaceutical companies and regulatory agencies.

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Took part in the preparation of Project plan, user acceptance testing. Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality.
• Rewrite the existing code for long running queries by replacing cursors with various joins, common table expression CTE and indexing.
• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases.
• Created SSIS packages using for each loop transformation to load multiple files from same source folder.
• Configured XML config files .dtsconfig files to change properties of packages dynamically.
• Created reports for policy holders by using Excel pivot table and SQL server Reporting service SSRS .
• Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, Sybase, EXCEL sheets, CSV format and used complex data conversions to load the data into destination databases.
• Implemented security for the reports, user tabs, report models and folders in the report manager at the application, database and the report manager level.
• Proficient in analyzing the end user requirements and converting them into efficient Technical design and technical code documents.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production
• Environment: Microsoft SQL Server 2008, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , T-SQL.

Confidential

SQL Server Developer

Confidential number one retailer on offering customers the biggest range of products around. The project was to keep track of the products that are getting viewed by the customers, how many of the customers are purchasing the product, what are the discounts that are given to the products. The report was generated based on the products type, count of the products based on the year, month and so on. The sales of the product was analysed and chart report are created to check the review of the product and to satisfy the customers and the revenue of the company.

Responsibilities:

• Involved in design and development of technical specifications of the project and developed the prototypes.
• Developed T-SQL queries for table creation, wrote stored procedures, views, triggers, and tested tables in company's BI star schema structure.
• Analyzed and designed UML model using Rational Rose to reflect existing business models.
• Designed star schemas using dimensional modelling and created fact tables and dimensional tables.
• Created SSIS packages to load insurance data received from different insurance agents and other locations into consolidated data warehouse using Derived columns, Lookups, Fuzzy Lookups, Conditional split, Execute SQL Task, Data Flow Task, and Execute Package Task.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed, produced documentation of data transformations for all extractions.
• Developed the TSQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Created report Model using T-SQL queries on SSAS Cubes as well as changing default configuration on existing Cubes.
• Involved in setting up hierarchies and defined scope of analysis for providing drill down/ drill through options in the reporting environment.
• Involved in migrating data from SQL Server 2005 to SQL Server 2008 environment.
• Implemented security for the reports, user tabs, report models and folders in the report manager at the application, database and the report manager level.
• Developed Reports using Microsoft Reporting Services SSRS , Report Manager.
• Developed custom selection of reports using SQL Server Reporting Services SSRS .
• Used SSRS to create reports, customized Reports, on-demand reports.
• Development of code following the various coding standards, as provided by TESCO.
• Integration of code with the existing code and maintaining various version of the code using Clearcase version controlling tool
• Environment: Microsoft SQL Server 2008, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , T-SQL.

Confidential

SQL SSIS/SSRS Developer

Responsibilities:

• Performed the physical database analysis and feasibility requirements.
• Created basic form in .NET and connect it to the SQL Server Management Studio.
• Full SDLC development of an address cleansing, name cleansing and enterprise individual/customer identification system utilizing Quality Stage for cleansing and standardization.
• Proficient in SQL Server and T-SQL DDL and DML in constructing Tables, Normalization techniques on database Tables.
• Database planning resulting from database requirements. Designed capacity, security, performance, backup and recovery planning.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Migrated organization orders, adjustments, objectives and data in various formats like text based files excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints.
• Expert in writing Stored Procedures, Functions, ad hoc queries, UDF ,Common Table Expressions CTEs and Triggers to facilitate efficient data manipulation and data consistency using SQL Server Management Studio.
• Created SSIS packages to process cubes and schedule the processing as per requirements.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Developed Reports Using SSRS on statistical data during migration of data.
• Used UML for Design and Documentation.
• Have taken training in Database Administration and acquired Good ability to troubleshoot problems that arises on Database, Reports and Provide Training on using Reports.
• Performed SQL Performance tuning on Queries, Reports and used Join Hints, Clustered Index and improved the performance of queries and reports.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Performed Unit, System Testing and created several Test Cases to validate the data from reports.
• Environment:
• Microsoft SQL Server 2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , T-SQL.