SUMMARY

• 5+ years of professional experience as a SQL Developer. 5+ years of experience in Agile with the entire project life cycle of Business, Design, Development, Testing, Implementation and Maintenance.Quick learner, highly adaptive and possess very good inter personal skills and work ethics. Self - Motivated SQL developer seeking an opportunity to bring knowledge of programming, design, and media to a position with an esteemed organization.
• Actively participated in gathering business requirements to implement functional and technical specifications.
• Migrated databases\instances from SQL Server 2008 to SQL Server 2017 version.
• Expertized in designing, modeling, developing &integrating with Microsoft SQL Server SSIS/SSRS.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS).
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).
• Experience in working with multiple cross functional teams under strict deadlines. Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Demonstrated experience in writing complex T- SQL queries as per requirements.
• Experienced in optimizing SQL code by understanding execution plans, using SQL Profiler, DMVs, Index tuning wizard and other tools.
• Incorporated complex business logic into functions and stored procedures for reusability. Experienced in creating database objects such as tables, views, indexes, triggers etc. as needed.
• Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.
• Knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Experienced in Extracting, Transforming and Loading data from various data sources like excel, flat file and Oracle to SQL Server databases using SSIS SQL Server Integration services.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Some exposer in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert utilities.
• Experience in working with partially / full blocking transformations and expertise in performance tuning of SSIS packages.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Experienced in developing WCF (Windows Communication Foundation) Services and Web Services using C#.NET.
• Proficient in SSIS package designing/development/deployment/documentation.
• Skilled in Designing, Development and Deployment of Reports in Business Intelligence Development Studio (BIDS).
• Strong experience in assigning permissions to the valid users for executing the reports & deploying reports to report servers.
• Experience in using source code analysis tools, automated build process and unit testing, debugging.
• Expert in creating Drill Down and Drill Through, Ad Hoc, Parameterized reports, Sub-reports, Snapshots, designing report layout using SQL SSRS.
• Experience in creating packages to transfer data between ORACLE and SQL Server.
• Extensively experienced in designing and developing Packages, Stored Procedures, Functions and Triggers using PL/SQL.
• Efficient in writing Complex SQL Queries, Hierarchical queries, use of analytical functions, Regular Expressions and features in oracle 11g.
• Hands on experience in ETL process using different ETL tools and using PLSQL to populate the tables in OLTP and OLAP Data warehousing environment.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL Loader.
• Translated the T- SQL procedure, function and views into Oracle's PL/SQL Packages, Procedure, Function and Views.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows, Linux

Databases: SQL Server 2016, 2014, 2012, 2008 R2, Oracle, MS Access, HBase

Database Tools: SSMS, SQL Server Data Tools, BIDS, SQL Enterprise Manager, Query Analyzer, SQL Profiler, SQL Server Dashboard

Tools: / Utilities: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio, TOAD, Putty, Import/Export, SQL*LOADER, SQL Developer, CVS, DTS Package, UML, Erwin, Cognos, WinSCP, MS Excel, MS Project, MS Visio, Tableau

Languages: SQL, T-SQL, PL/SQL, C, C#, HTML, UNIX shell script, Java Script, .Net

PROFESSIONAL EXPERIENCE

Oracle PL/SQL developer

Confidential, New Jersey

Responsibilities:

• Involved in gathering user requirements and reporting requirements for a better understanding of the business process
• Extensively worked with Oracle SQL and PL/SQL and converted business requirements into PL/SQL logic as per the requirement
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) and OS monitoring using SAR, VMSTAT, TOP, PRSTAT in Unix environments.
• Worked with Materialized Views and Functions
• Creates new Tables, Indexes and Views
• Created Reports in PDF, XML and Excel format as per the Requirement provided by the User
• Worked with Paper Parameter form, Paper Layout's on Oracle Reports
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN
• Designed and Developed data validation, load processes using PL/SQL scripts, Stored Procedures, Functions, and Triggers
• Experience in writing complex SQL Queries
• Writing Shell scripts to call stored procedures and packages to load data files using external tables
• Good experience in Running the Reports based on Monthly Schedules
• Worked with Scheduler for Scheduling and Running Oracle Reports/Jobs
• Created Indexes and used hints to improve performance
• Worked with Data Integration Projects
• Good knowledge on Service Now Concepts
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables
• Provided support to the User/Customer incase if they have any questions on running the Reports
• Experience in working with PL/SQL Packages and Stored Procedures, Triggers
• Involved in doing Unit Testing, Integration Testing and System Testing
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Used different types of Indexes like Function - Based Index, etc.. to improve the Package Performance
• Created Indexes on Tables to increase the performance of Packages
• Good at problem solving and communication skills, also ability to interact with individuals at all levels
• Wrote T- SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T- SQL for various needs of the transformations while loading the data
• Performance tuning of SQL statements using SQL server profiler
• Implemented joins and queries (T- SQL) for the business analyst to make reports
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database
• Conducted data import and export operations using the DTS wizard

Environment: - Oracle 11g, Oracle Reports 11g, SQL, Oracle PL/SQL, SQL Navigator, UNIX, MS SQL Server 200/2012/20148 , Informatica Power Center 9.1

SQL/SSIS/SSRS/Tableau Developer

Confidential, New York

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for the applications.
• Responsible for performing T - SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with SQL Server 2008/2012/2014 .
• Performance Tuning of stored procedures, triggers, Indexes and long running queries and SSIS packages.
• Implemented Transactional and Merge Replication in SQL server 2008R2.
• Created the maintenance plans for optimization and integrity check.
• Experienced in creating SQL JOBS and scheduling and set alerts.
• Active directory administration includes users and group creation in a multi domain environment.
• Created SSIS and DTS packages for data manipulation and perform business information.
• Experience in improving SQL Server performance using performance monitor, index tuning wizards, SQL Profiler, Data base Engine tuning Advisor (DTA) and execution plans.
• Created and managed schema objects such as tables, views, indexes, stored procedures and triggers and maintaining referential integrity.
• Created different types of user-defined functions using T-SQL.
• Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Generated several types of drill down and drill through reports using SSRS.
• Developed complex SSRS reports using multiple data providers, global variables, expressions, user-defined objects, aggregate-aware objects, charts, and synchronized queries.
• Designed and implemented parameterized and cascading-parameterized reports using SSRS.
• Deployed reports, created report schedules and subscriptions. Managed and secured reports using SSRS.
• Migrated SSRS Reports from SQL Server 2008 to SQL Server 2012.
• Created ad-hoc reports using SQL Server Reporting Services (SSRS).
• Worked on ETL, data profiling, data quality and clean ups for SSIS packages.
• Created SSIS packages to populate data from various data sources.
• Experience on Creating packages using SSIS for data extraction from flat files, Excel files and OLE DB to SQL Server.
• Extensively worked on Configuring SSIS packages using Package Configuration Wizard to allow packages to run in different environments.
• Worked with Metadata-Driven SSIS Packages to pull the data from different sources and loaded them to the DataMart.
• Worked with project teams for upgrading SQL Server 2008 to SQL Server 2012.
• Involved in fine tuning queries and stored procedures using SQL Profiler and Execution Plan in SQL Server.
• Heavily involved in query optimization and troubleshoot long running queries.
• Administered and troubleshoot FTP jobs.
• Administer and troubleshoot SQL SERVER AGENT jobs. Wrote complex stored procedures, triggers and functions.
• Worked on Developing, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Hands on experience in building queries to retrieve data into Tableau from SQL Server and Oracle server.
• Designed Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts.
• Generated interactive web sharing dashboards with simple drag and drop options.
• Worked extensively on trend lines, statistics, dual axis, groups and sets to develop detailed level of summary reports.

Environment: MS SQL Server 2008/2012/2014 , Team Foundation Server, Microsoft Visual Studio 2008/2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Tableau.

SQL Server/BI Developer

Confidential, PA

Responsibilities:

• Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer
• Generating Complex Transact SQL (T - SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using Stored Procedures, Triggers, User-defined Functions, Views, and Cursors
• Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems
• Writing T-SQL queries (DDL and DML) . Creating SQL Scripts for data loads and Upgrades for data migrations and data validations
• Involved in query tuning by creating Cluster and Non-Cluster Indexes on the tables, also used Index Tuning Wizard (ITW) for enhancing the query performance
• Written complex Stored Procedures using temporary tables
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Derived Column, Lookup, Merge Join, Conditional Split, Slowly Changing Dimension, and Data Conversion etc.) in SSIS packages
• Used event handlers for error handling includes (On Pre-Execute, On Post Execute and On Error)
• Implemented SSIS package configuration files in SQL Server, XML files, Environment Variables and Parent Package Variables
• Implemented Package logging in both standard ( SQL Server and file based) and custom logging using customer Stored Procedures and tables
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages
• Involved in troubleshooting Complex SSIS Packages and Production Support tasks
• Implemented Standard and Custom SSIS Package logging in SQL Server tables and text files
• Used SSIS Package Configurations stored in XML files and SQL Server Tables
• Involved in installation, reporting services configuration, maintenance, deployment and troubleshooting SSRS reports in (2005/2008)
• Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports, Drill Down, Drill Through, and Chart reports using complex data set queries, Stored Procedures, Views in SSRS 2005/2008
• Generated and formatted reports using Global Variables, Expressions, and Functions
• Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded parameters
• Developed complex Report Models which provides ability to the users to create their own reports using Report Builder and save it in the Report Manager. Also, created Linked reports to optimize redundancy of the reports on the report server
• Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC environments
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF, MS Word (from 2008), and Excel formats using SSRS 2005/2008
• Involved in creation of create and edit views in the CIS and Involved in the creation of the Composite views and publish each view to make it available to client applications that connect to the server through JDBC and/or ODBC
• Created reports using time intelligence calculations and functions
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
• Executed dashboard setups and data manipulation using DAX
• Wrote Calculated Columns, Measures query's in Power BI Desktop to show good data analysis techniques
• Weekly presentation to the business users about the reports and their changes as required

Environment: MS SQL Server 2012, SSRS, SSIS, T-SQL, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005, Crystal Reports, Power BI, DAX.

SQL and Report Developer

Confidential - Philadelphia, PA

Responsibilities:

• Spearheaded a project to implement company standards and establish procedures to ensure a unified data management approach.
• Experience in Backup, using different Recovery models depending on Application requirement.
• Experience in Performance Monitor/SQL Profiler to solve dead locks/long running queries.
• Designed SSIS packages and uploaded Epic data into the existing BI Operational data mart, also setup SQL agent jobs to kick off the packages nightly.
• Converted the database from a transactional database, EZCape, to a newly designed Data Warehouse, Data Lake, for all the SSRS reports
• Converted the embedded SQL queried into stored procedures for all reports
• Converted the existing Crystal reports to SSRS reports
• Converted some of the existing reports to Tableau reports for the data visualization
• Utilized Tableau and develop dashboards and visualizations that empower decision makers
• Worked with Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online
• Applied Tableau to customize and develop creatively stunning and dynamic visualizations
• Developed Power BI model used for financial reporting of Profit & Lost and Headcount.
• Designed and documented the entire Architecture of Power BI Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure Excel, flat files.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in Power Bi service.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Experience in T - SQL Scripts and stored procedures to implement the business needs and to support the frontend application.
• Experience in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Environment: - Windows 2000 Advanced Server, SQL Server 2014/2013/2012/2008 , Enterprise Manager, Informatica 9.6, Tableau, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS.