SUMMARY

• 7+ years of professional experience in SQL Server database development, extensively worked in in Production, Test, Development and Replication & Cluster Server Environments & development databases as a Developer/ DBA.
• Extensive experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
• Hands on experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Involved on administration tasks such as disaster recovery with Backup and Restore Strategies, Data Loading, Batch Jobs, Data Unloading, Upgrades, Creating Databases, Files, File groups, Transaction logs, Clustering, Replication, Data Mirroring, Linked Servers, SQL Profiler, Log Shipping and Re-Indexing
• Efficient in creating joins and sub-queries for complex queries involving multiple tables
• Well versed in Normalization/De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler
• Expert in Microsoft SQL Server 2012 and 2008 backend programming, Extensive experience in creating database objects on MS SQL Server 2012 and 2008.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Expert in working with the Tableau, Business Intelligence Development Studio (BIDS), which includes SSIS, SSAS and SSRS.
• Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Possesses extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server 2005.
• Experience in data warehouse development with Integration Services, Analysis Services, Reporting Services and Report Development using POWER BI tools.
• Experience in using Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Extensive experience inSQL 2005/2008/2012 Partitioningof Tables and Indexes, for Performance, scalability and manageability of Very large databases (VLDB).
• Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support.

TECHNICAL SKILLS

RDBMS/Databases: MSSQL Server 2005/2008/2012 , Oracle 10g/9i, MS Access 97/2000/2003/2007 , MYSQL

ETL Tools: SQL Server Integration Services (SSIS), DTS, BCP, Informatica Power Center 9.5x

Reporting Tools: SQL Server Reporting services (SSRS), Tableau, Crystal Reports 9.0/8.0, Power BI, Visual Studio

OLAP Tools: SQL Server Analysis Services (SSAS) 2008

Performance Tuning Tools: SQL Profiler, DTA (Data Tuning Advisor)

Operating systems: Windows 9X/2000/XP/NT, MS-Dos, Unix, and Solaris

Back-end Language: T- SQL, PL-SQL, XML.

Front-end Language: C#

Web Applications: ASP.NET 2.0, SOAP, HTTP, Internet Information Services (IIS 6.0), FTP, TCP/IP, LAN, MS-Outlook Express

Scripts: T SQL, VB, JavaScript, PHP

PROFESSIONAL EXPERIENCE

Confidential, Redlands, CA

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed automated scripts in T-SQL and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL scripts.
• Creating Data Points for use by Decision engine using T-SQL, Stored Procedures and Functions.
• Creating Triggers on various Data base tables to maintain business rules.
• Responsible for Query optimization and Performance tuning.
• Involved in Debugging Issues as a part of Production Support.
• Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Developed Report Models for building customized Ad hoc reports. Played a Content Manager role on report server.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre-calculated measures.
• Well-versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing Reports from Multi-Dimensional OLAP Cubes.
• Designed aggregations and pre-calculations in SSAS.
• Involved in designing Partitions in Cubes to improve performance using SSAS.
• Creating and maintaining automated jobs for database backup on a weekly basis based on the percentage used and made sure the backup is current.
• Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.
• Monitoring and scheduling daily, weekly and monthly SQL Server jobs and debug any issues related with failed jobs or data discrepancy.
• Replicating the data bases from Production to the warehouse on a live basis.
• Cleaning up the QA environments after every release and rebasing the environments with current data.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.

Environment: SQL Server 2008/2012, SSIS, T-SQL, Excel, Microsoft SQL Reporting Services (SSRS), Power BI, SSAS, Oracle 10g, SQL Server Analysis Services (SSAS), T-SQL, Windows 8, XML, MS Excel.

Confidential, Long Beach, CA

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
• 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).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Responsible for buildingPowerBIDashboards using Tabular and Multi-Dimensional Models. Design and model data sets withPowerBIdesktop based on measure and dimension requested by customer and dashboard needs.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: Microsoft SQL Server 2012/2008, MS Access, BIDS, SSDT, HTML, Visual Studio 2008/2010, TSQL, .Net, Power BI, Shell Scripting, SQL Profiler, Team Foundation Server (TFS).

Confidential, Bloomington, IL

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in writing scripts for the client’s requirements for reporting purposes.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Developed several stored procedures to handle large amount of data manipulation.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
• Responsible for deploying/scheduling SSIS packages as per schedule.
• Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Published migrated data using SSIS (SQL Server Integration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. Created ETL packages using SSIS to extract data from different data sources reformats the data and load the reformatted data into destination tables.
• Used Scripts task for Data Flow and Error Handling in SSIS
• Used reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2008.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2008.
• Involved in analyzing the user requirements and transform them into TableauDashboards and Reports.
• Extensively used Tableaufeatures like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.
• Interacted with the Business Admin and gather the requirements and analyzed them
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: MS SQL Server 2008, SSIS, SSRS, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, Tableau 7.x, Windows XP.

Confidential, Brooklyn, NY

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created functions and developed procedures to implement application functionality at the database side for performance improvement.
• Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created ETL package for data conversion using various transformations tasks.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
• Created dash board to show the business performance.
• Created partitions and designed aggregations in Cubes.
• Created perspectives in SSAS and configured security levels for the Cubes.
• Designed KPI’s in SSAS and imported them to Excel.
• Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
• Created Ad hoc reports using SSRS.
• Created reports that call Sub reports in SSRS.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableauplatform.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in TableauDesktop.
• Created datasets for reports using T-SQL and stored procedures
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Responsible for Query optimization and Performance tuning

Environment: SQL Server 2005/2008 Enterprise Edition, .NET Framework, XML, T-SQL, SSIS, SSRS, SSAS, ASP, MS Excel, MS Access. Visual Studio 2005/2008, Tableau Desktop 8.2/8.0/7.0, Tableau Server, Team Foundation Server (TFS), SQL Profiler, SQL Server Management Studio (SSMS).

Confidential

MS SQL/SSIS Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000/2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Backupandrestoredatabases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theSSISPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000/2005, Management Studio, SQL Profiler, MS SQL Server DTS/SSIS, T-SQL, MS-Office, MS-Excel, VSS.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Experience in support and management of databases, systems, applications and Application Development.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Experience in planning and implementing the Replication of MS SQL Server 2000 Databases and databases Backup recovery strategy.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server and database to another database.

Environment: SQL Server 2000/2005, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS/SSIS, Windows Performance Monitor.