Professional summary

• 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 and Batch Scripts.
• Created database objects such as views, synonyms, Tables, Indexes, Sequences as well as custom packages tailored to business requirements.
• 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.
• Performed Tuning on the T-SQL code and checked the values if it is retrieved appropriately. Have Analysed the Execution Plan and Statistics to check if the values are retrieved fast.
• 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.
• Used SSRS and created 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.
• Created reports that have been defined by business architect and generated canned reports.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Build, Deployed and Published the Reports to Report Manager Website.

• 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 Developer

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.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Designed SSIS packages for synchronizing the data between two different servers.
• Experience with creating complex SSIS Package using proper control and data flow elements with error handling.
• 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

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.