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.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• 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.
• Experience in creating SSIS packages, DTS Migration and Metadata Management. Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Automated manual process with SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in designing report layouts and developing Custom Reports and different types of Tabular/Matrix/Adhoc/Sub/drill down/drill through Reports and Charts in multiple formats using SSRS 2008/2005.
• 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.
• Good exposure or knowledge working on C#, VB.NET framework.
• Extensive knowledge of addressing Performance Issues and query tuning, Index tuning, Data Profiling and other database related activities.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Experience in developing User reports and Management reports using MS SQL Server Reporting Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• 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, BIRT, Tableau 7/8.

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, Addison TX

MS SQL/BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• DDL Scripts for generating Tables, Views, Functions.
• Analyzed and designed software and database solutions.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2008.
• Extensively worked on Visual Web parts in Visual Studio 2010
• Created different Power Pivot reports as per the client requirement.
• Worked on a web-based dynamic product registration and tracking system linked through ODBC to corporate DBMS.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Resolved significant PPS connection string issues with import process.
• Used Tableau to visually analyze data and create concise and actionable dashboards.
• Created visually compelling and actionable interactive reports and dashboards.
• Created backup scripts to take periodic backups for the content on Tableau server.
• Provided DBA assistance in SharePoint 2007 to SharePoint 2010 conversion.
• Worked with Business Analysts, Developers and customers to resolve and escalate project issues.
• Gathered the business system requirements and act as a SME for the system and business and created status reports.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: MS SQL Server 2012/2008/2005, SSRS, SSIS, SSAS, Windows2003 Advanced Server, ASP.Net, TSQL, Visual Studio 2008, Oracle, Erwin.

Confidential, Baltimore, MD

SQL BI Developer

Responsibilities:

• Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
• Createdpartition tablefor very large database for good performance.
• Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS
• DeployedSSISpackages and Reports to Production Servers.
• Involved in creation of Data warehouse Cubes inSQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool inSSIS.
• Maintained system monitoring jobs and providedhigh availability support.
• Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
• ParticipatedDatabases Architectureanddata modelingdesign.
• Created External list using Visual Studio 2010 with full CRUD functionality using Business Connectivity Services
• Created Custom Web parts in Visual Studio 2010
• Performing DBA functions, installing, configuring and supporting database systems.
• Developed various operational, drill-through and drill-down reports using SSRS.
• Reported all events and requirements through established reporting mechanisms inSSRS.
• Reviewed and developeddata models and database designswith development teams
• Wrotestore proceduresfor some job automations.
• Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL ServerAnalysis Services (SSAS).
• Designed and developedMS SQL ServerReporting Services (SSRS)under SQL Server 2005.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity,C#,ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential, Lakewood, NJ

SSIS, SSRS and MS SQL Developer

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Effectively worked in Tableau version based environment and used deployment groups to migrate the objects.
• Develop the mappings using needed Transformations in Tableau according to technical specifications.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Designed and developed Data mart using SSAS.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

SQL Server Developer

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: Windows 2000 Server, SQL Server 2005, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.