PROFESSIONAL SUMMARY:

• 8+ 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 in SQL 2005/2008/2012 Partitioning of 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/2014/2016, 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

Backend Language: T- SQL, PL-SQL, XML.

Frontend 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/Power BI 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.
• Design, develop and provide unit test data loading and data transformation programs related to Data Warehouses and Data Marts .
• Involved in modifying the Existing Data ware house and add new Data Points for Data Analysis.
• Worked on ETL( Datastage ) jobs from Source to Target
• Build efficient SSIS/ETL packages for processing fact and dimension tables with complex transforms.
• Extract, Transform and Load(ETL) 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
• Used Power BI for creating multiple kinds of Reports and present it using Story Points.
• Created Dashboards Scorecards, views, pivot tables, charts, for further data analysis. Migrate existing data into the Power BI.
• Used DAX for creating Calculated columns and Calculated measures.
• Created many dashboards in Power BI using DAX expressions and deployed them using content pack.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS/ETL packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS/ETL 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 using POWER BI.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI .
• 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.
• Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.

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

Confidential, Long Beach, CA

MS SQL/SSIS/SSRS/SSAS/Power BI 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.
• Best practice and standards were maintained for both analytics and bid data.
• 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/ETL 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).
• Prepared strategic plans for data warehousing projects and related quality documentation.
• Assisted in designing and implementation of detailed data warehouse models and mappings.
• Provided technical expertise to technologies in fields of data warehouse and relevant analytics.
• Knowledge of Datastage (Administrator client, Designer client and Director client).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterized and 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 building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Representing data using the Cross Tabs, Scatter Plots, Geographic Maps, Pie Charts and Bar Charts, Heat Maps, Gauge, Tree Maps in Power BI .
• Published reports on Power BI services, shared dashboards utilizing within the Office 365.
• Implemented Subscription, schedule refresh, data alert utilizing Power BI Gateway.
• 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 2016/2014/2012/2008, MS Access, BIDS, SSDT, HTML, Visual Studio 2008/2010, TSQL, Power BI, 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.
• Extensively used Tableau features 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 Tableau platform.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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 like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL 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 with coding, design and performance tuning.
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the SSIS Package through ETL Process 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.