PROFESSIONAL SUMMARY:

• 6+ Years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 in Development, Test and Production Environments on various business domains like Health, Insurance and manufacturing.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2008.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in creating Dashboards using QlikView.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import ExportWizard, and Bulk Insert.
• Experience in database programming in writing T - SQL Stored Procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Proficient in OLTP, OLAP and Data warehousing Design concepts.
• Experienced in creating 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.
• Viewing Greenplum table DDL.
• Append-optimized tables, including compressed append-optimized tables.
• Developing reports on SSRS on SQL Server (2012/2008 R2/2008/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in SQL Server 2012 Self Service BI tools like BISM Tabular models and SQL Server Data tools.
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Worked Extensively on ETL process using SSIS package.
• Experience in Performance Tuning and Query Optimization.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Strong technical experience in Web technologies like C# and ASP.NET.
• Experience in JAVA Web services and Scripting languages (HTML, Java Scripts and JQuery).
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Experience in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

TECHNICAL SKILLS:

RDBM/Databases: MSSQL Server 2000/2005/2008/2012/2014/2016/2017, MS Access 97/2000/2003/2007, MYSQL. Oracle 12c/11g/10g/9i

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, XML, HTML, DHTML, Shell Scripting, Visual Basic 6.0

Data Modeling Tool: Erwin, MS Office Visio

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting.

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012), SQL Server Reporting Services (SSRS 2005/2008/2012) SQL Server Analytical Services (SSAS 2005/2008/2012), Agile Methodology, Power BI Visual Studio, BIDS.

Tools/Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0, Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS)

ETL Tools: Informatica Power Centre, SSIS, Data Stage 7.5, Ab Initio, Talend.

Version Control: Visual Source Safe, Clear Case.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

Operating System: Windows Server, Linux, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

SQL Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and T-SQL.
• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD's), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and UnPivot as per the client requirement.
• Architected and developed Qlikview business intelligence dashboards, reports and ETL scripts extracting data from Oracle, Logs, MySQL, MS SQL and XMLs. Lead generation, editorial.
• Worked in Object Oriented Analysis and Design in C#.
• Created Configuration Files for Packages and SSIS logging on XML Files.
• Developed different kind of reports such a Dashboards, Sub Reports, Charts, Matrix reports, Linked Reports Using SSRS.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2008R2.
• Scheduled SSRS 2012 Data alerts on mission critical reports to send alerts based on business rules.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Involved in creating new logical and physical design of the database to fit new business requirements and implemented new design into SQL Server 2012.
• Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2.
• Setup and monitored jobs for loading and processing SSAS Cubes.
• Involved in process building and maintaining different platforms including SQL Azure 2012 servers.
• Involved in building the Synchronization process between multiple servers across different platforms like Oracle, SQL Server 2008, SQL Azure, SQL Server 2012 etc.
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Created ETL technical specification documents describing ETL design and load strategies to populate operational data store and DataMart's.
• Involved in Automation of ETL processes and jobs using PowerShell to reduce manual intervention.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Participated in code-review sessions on existing SSRS report's performance and Dataset query tuning.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Created script tasks and components with C# and VB.NET in SSIS as part of ETLload.
• Developed power view reports using Tabular Models in SQL Server Data Tools.
• Participated in upgrading SQL 2014 Server. Migrated all the scripts and objects from SQL 2008 to SQL 2014
• Created standard and data driven SSRS subscriptions for weekly, monthly and daily reports.
• Involved in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Environment: SQL Server, SharePoint, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, BIDS, Tabular, Excel, Power BI, TFS, Power pivot, MDX, DTS, C#, VB.NET, Erwin,XML, SVN, Windows Server.

Confidential, Newark, NJ

SQL Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).
• Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSASCubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created the required Metrics and KPI's using DAX formulas.
• Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

Environment: MS SQL Server, Visual Studio, SSIS, SSAS, SSRS, Agile Scrum, Web Services, T-SQL, SQL Analyzer and Enterprise Manager and SQL Agent, XML, VMware, MS Excel, Team Foundation Server (TFS).

Confidential - Temple Terrace, FL

SQL Developer

Responsibilities:

• Contributed from design to implementation and maintenance phase of the application in AGILE environment/methodology.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes.
• Created packages with override functions that could be utilized by other systems that interface with this application.
• Analyzed data using complex SQL queries, across various databases.
• Created materialized views that refreshes data from other databases, via DB Links.
• Assisted quality assurance team with any functional and regression testing efforts.
• Provided assistance and support to programming team members as required.
• Performed data analysis primarily Identifying data sets, source data, source meta data, data definitions and data formats.
• Designed physical and logical data model and data flow diagrams.
• Worked on various tables to create Indexes to improve query performance. Involved in writing several queries and procedures.
• Worked with several tools to access and perform several operations on database. Experience in generating reports.
• Used joins, indexes effectively in where clauses for query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Co-ordinated with multiple application development teams, since the application interfaces with multiple systems.
• Created huge volumes of test data to test heavy data loads across multiple systems / databases.
• Performed extensive GAPanalysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Environment: Oracle 10g, 11g, TOAD, PL/SQL, UNIX, Shell Scripting, Tableau server versions (7.0 and 8.2), UNIX Linux, Windows, java, Control-M.

Confidential - San Jose, CA

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.
• Design and implementation of Security Model, Policies, and Procedures.
• 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.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• 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 Informatica version based environment and used deployment groups to migrate the objects.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into the target database.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created Adhoc reports and data exploration using Power View.
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS
• Performed DBCC checks and fixing data corruption in Application databases.
• 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

Data Analyst

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T- SQL in Development and Production environment for SQL Server 2000.
• Actively participated in gathering of Requirement and System Specification.
• 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.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression ( CTE )
• Created Stored Procedures to transform the data and worked extensively in T- SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2008/2005, T-SQL, Microsoft Framework 2.0, Erwin, MS Visio.