SUMMARY

• Over 7 years of strong experience in the Database Design, development and deployment of large - scale enterprise applications.
• Extensive experience and in depth working knowledge in various SQL Server tools and IDE to work with Database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio and Query Analyzer.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, and strong understanding of BI application design and development principles.
• Excellent knowledge in RDBMS concepts and constructs along with Object creation such as Database, Tables, Normalization, User Defined Functions, SPROC, Views, Cursors and Triggers.
• Hands on Experience in writing complex stored procedures, Indexed Views and also creating and Updating tables for Data consistency and Data manipulation by executing DBCC commands.
• Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SQL Server Reporting Services (SSRS) 2005/2008.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expertise in Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Extensive experience in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Sophisticated experience in creating new data models, data flows and data dictionaries.
• Expertise in Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, Tableau Server and Reports, and MS Excel spreadsheets and Power Pivot.
• Created Scorecard/Dashboard pages in Performance point server (PPS).
• Defined group level security standards for Tableau.
• Used Tableau to visually analyze data and create concise and actionable dashboards.
• Comprehensive knowledge on essential data warehousing concepts such as dimensional modeling, star and snowflake schemas, Data marts, front end/Back end architecture, security and Report distribution.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Experience in managing offshore and onsite resources. Excellent multi-tasking and inter personnel skills with efficient planning in prioritizing of projects.
• Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2012, 2008, 2005, MS ACCESS 2007, 2003, 2000.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development, Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQLQuery Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP.

BI Tools: SSRS, SSAS, Crystal Reports

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook.

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages: MS SQL, PL/SQL, T-SQL, MDX, C/C++, Java, VB, VBA, HTML, XML.

Web Technologies: HTML, DHTML, XML.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, ROLAP, MOLAP and OLTP

O/S: Windows 2008/2003/2000/ NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

SQL SERVER/MSBI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Analyzed the specifications provided by the client and gathered the requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS
• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from data sources.
• Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load in order to create and maintain a centralized data warehouse.
• Designed and configured SSIS packages to migrate the important data from Oracle, legacy System using various transformations.
• Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures
• Validated and tested all packages on development server
• Coding, troubleshooting and performance tuning SQL and complicated SSIS packages.
• Generated customer reports using SQL Server Reporting Services 2012/2008R2from the OLTP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created report snapshots and cache for better performance.

Environment: MS SQL, SSRS, SSIS, Excel, Oracle DB

Confidential, New York, NY

SQL Developer

Responsibilities:

• Developed SSIS packages to load data from application database and general ledger into data marts.
• Designed SSIS packages to pull the data from Oracle to SQL Server.
• Responsible for creating SSIS packages, Scheduling packages in SQL Server database.
• Gathered requirements from several Interfacing teams and prepared the Requirements document.
• Implementations of MS SQL Server Management studio to create Complex Stored Procedures and Views using T-SQL.
• Responsible for deploying reports to Report Manager and Troubleshooting for any errors during the execution.
• Scheduled the reports to run on daily and weekly basis in Report Manager and emailing them to director and analyst to be reviewed in Excel Sheets.
• Created several reports for claims handling which had to be exported out to PDF formats.
• Created several Drill down & Drill Through reports using SSRS for the different divisions to see their weekly, monthly and quarterly claims handling data.
• The reports had to have the data broken down in several visualizations using line, bar and column charts.
• These were delivered as subscriptions via email to the groups.

Environment: MS SQL Server 2005, Query Analyzer, Enterprise Manager, Data Transformation Services (DTS).

Confidential, Broadway, NY

MS SQL/BI Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Repaired/recreated PPS reports damaged in the conversion process.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential

SQL Server DBA

Responsibilities:

• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in designing Flow charts, office layout for the business users and professionals using VISIO.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• 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.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Involved in developing report using SQL Server Report 2000.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Performed all aspects of database administration, including data modeling, backups andrecovery.

Environment: MS SQL Server 2000/7.0, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, SSRS 2000,IIS 4.0, Visio 2000, SQL Server Query Analyzer, SQL Profiler, ERWIN.

Confidential

SQL Server DBA

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL