SUMMARY

• Over 7+ years of extensive experience in database development and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MS SQL Server technology
• Experience in MS SQL Server 2012/2008R2/2008/2005 with OLTP/OLAP and Business Intelligence delivery using SQL Server Integration Services and SQL Server Reporting Services.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• Worked on Normalization and De - Normalization techniques for both OLTP and OLAP systems.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Strong experience with ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Good Experience in creating Master Child Packages in SSIS and in generating on-demand and scheduled reports for business analysis using SSRS.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2008 R2.
• Experience in Migration of SSRS reports from SQL 2005 to SQL 2008.
• Adept in designing Stylish Report layout and having Proficiency with drill down reports in SSRS 2008R 2/2008/2005.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2008 R2.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Experience in writing sub reports and parameterized Queries for generating reports in SSRS 2008.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

DATA WAREHOUSING TOOLS: SSIS, SSRS, SSAS, Report Builder, Oracle BI Publisher

DATABASES: MS SQL Server, PostgreSQL, Oracle, MS-ACCESS

PROGRAMMING LANGUAGES: T-SQL, PL/pgSQL, MDX,PL/SQL, VB.Net, Java

SOFTWARES: Visual Studio, pgAdmin III, TFS, VSS, Office Suite

WEB TECHNOLOGIES: C#, HTML, Java Script

OPERATING SYSTEMS: Windows 2K/XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

SQL Server BI Developer

Confidential, Dallas Texas

Responsibilities:

• Written stored procedures to populate final database tables from staging tables and clean inaccurate data.
• Written complex queries using Merge and Analytical functions of Sql Server 2008 R2
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Providing solutions to improve the existing processes and production support for various batch processes and also created the schedule for newly incorporated batch programs and processes.
• Designed and developed efficient SSIS packages for processing fact and dimension tables
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Used Script task in SSIS to write custom code using Vb.net
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Created SQL Jobs to schedule SSIS Packages
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Worked with the Program Architect and Technical Architect in design sessions to develop high-level solutions architecture for SQL Server Reporting Services solution.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008R2.
• Designed different kinds of reports like cascading parameterized reports and worked on Drill Down and Drill-through Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Performed performance tuning using Execution Plan, Analyzing Indexes.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: MS SQL Server 2008 R2/2012, Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, T-SQL.

SQL BI Developer

Confidential, Mettawa IL

Responsibilities:

• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2008/2008R2.
• Written DDL / DML Triggers as per the requirements.
• Experienced in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Responsible for backups/restores, designing SSIS packages and maintenance and performed Data transfer (using SSIS) from Development to Testing and then onto Production Servers.
• Responsible in Performance Tuning for queries and indexes using SQL Profiler.
• Involved in data migration and used SSIS to import and export data into tables using SQL Server 2005, creating tables, views and Store Procedures using SQL server.
• Involved in cube creation, and Browsing cube data using SSAS.
• Fine tuned Queries for the performance of reports developed in SSRS and generated specifications for analysis reports by using SQL Server Reporting Services 2008/2008R2.
• Created report models for ad-hoc reports using SSRS 2008/2008R2
• Developed reports from OLAP cubes using ProClarity and SSRS 2008/2008R2.
• Wrote Stored Procedures for Reporting purpose. Also developed various reports using SQL Server Reporting Services.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS)
• Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
• Used data profiling task in SSIS 2008 to identify poor data and repair it.
• Transformation etc. using SSIS.
• Involved in implementation and scheduling of the backup and maintenance strategy on the development server.

Environment: SQL Server 2008/2008R2, Microsoft SharePoint Server (MOSS), T-SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler

SQL Server Developer

Confidential

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created database logical and physical design to fit new business requirement and implemented new design into SQL Server 2008.
• Made changes to the existing data flows and redesigned the system.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created and scheduled jobs to run on a daily and weekly basis including the maintenance of the jobs.
• Involved in taking backups and restoring of crucial databases involved in the business.
• Writing queries which involve various joins in order to perform a thorough analysis on the missing sales on a daily and cumulative basis.
• Multidimensional Expressions (MDX) is to make accessing data from multiple dimensions.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Used link servers in cases where data is to be pulled form a different database like oracle.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Fixing bugs in scorecards which pertain to the pivot tables and formulas.
• Worked on advanced dimension Design and Cube design.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Filtered bad data by using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used Report Generator (Report Writer) which is a program to extract information from one or more files and is presented in a specific format
• Data generated through is presented in the form of pie charts, bar charts.
• Wrote stored procedures and functions to be called from front-end developers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created and managed users, roles and groups to handle database security.
• Tuned database by creating proper indexes.
• Created data dictionary for all columns and documented all the processes involved in maintaining the database for future reference.

Environment: SQL Server 2005 Management studio, T-SQL, Excel, Windows 2000/XP, SSIS, SSAS.

SQL Server/SSRS Developer

Confidential

Responsibilities:

• Involved in designing high level dashboards according to business requirement using SSRS.
• Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters etc. Experienced in developing stored procedure driven reports, building custom application on reports and formula writing/editing in reports.
• Created report models for ad-hoc reports using SSRS 2005
• Developed reports from OLAP cubes using ProClarity and SSRS 2005.
• Designed and developed Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reports using various features like Charts, graphs, filters etc.
• Defined report layouts for formatting the report design as per the need.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Formatted the reports using Global variables, Expressions and Functions using SSRS 2005.
• Generated periodic reports based on the statistical analysis of the data using SSRS 2005.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Participated in maintaining and modifying tables and constraints for Claims Database using SQL Server.
• Developed stored procedures and functions to implement necessary business logic for interface and reports.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data and Unnecessary Data like removing empty rows.
• Created the automated process for the activities such as database backup processes and SSIS packages run sequentially using SQL Server Agent job.
• Managed up gradation of DTS packages to SSIS packages.
• Responsible for developing, monitoring and deploying SSIS packages.
• Configured server for sending automatic mails on the failure and success of the scheduled job.
• Generated the reports using SQL Server Reporting Services.

Environment: MS SQL Server 2000/2005, Microsoft Visual Studio 2005, SQL Server Reporting Services (SSRS 2000/2005), Report Manager, Report Viewer, SQL Service Integration Services (SSIS), Data Transformation Services (DTS), Oracle 10g, Toad, MS Excel

SQL Server/BI Developer

Confidential

Responsibilities:

• Written T- SQL, Pl/SQL queries for data retrieval.
• Data migration from Text to SQL Server using BCP command line utility and Bulk insert.
• Reduced the T-SQL overhead and responsible for developing processes, automation of maintenance jobs, tuning SQL Server and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Fine tuned SQL queries using hints for maximum efficiency and performance
• Tested packages and fixed bugs using SQL 2005 Business Intelligence development studio
• Developed ETL Packages using SQL Server 2005 integration services to populate data from different sources like from flat files/SQL/Oracle Server to the staging database and then into the data warehouse. The packages created included a variety of transformations like slowly changing dimensions, look up, aggregate, derived column, conditional split, fuzzy lookup, multicast and data conversion.
• Developed reports using SSRS 2005 and crystal reports and used table control, matrix control for cross tab reports.
• Created drill down reports using SQL Server 2005 Reporting Services and deployed the generated reports on to the server.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Created reports by linking data from data warehouse cubes using SQL Server 2005 reporting services.
• Wrote complex SQL queries to populate data from different tables and which can be used for reports.
• Worked on querying data and creating on-demand reports using report builder in SSRS reports and sending the reports via email.

Environment: SQL Server 2000/2005, T-SQL, MS Access 2000, Windows NT platform, SQL Server 2005 Reporting Services, SQL server Integration Services Data Transformation Services (DTS), Oracle 9i, Toad, MS Excel, Crystal Reports.