SUMMARY

• Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005/2008R 2/2012/2014/2016 in Development, Test and Production Environments on various business domains.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008 R 2/2012 /2014/2016.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and POWER BI
• Developing reports in SSRS with SQL Server (2000/2005/2008/2010/2012/2014 ).
• Experience in using T - SQL in SQL Server 2000/2005 and 2008 platforms.
• 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
• Expertise in Power BI, Power BI Pro, Power BI Mobile. Expert in creating and developing Power BI Dashboards in to rich look.
• Building, publishing customized interactive reports and Dashboards, report scheduling using Tableau server.
• Hands on experience in Creating Star Schema and Snow Flake Schemas, Involved in writing MDX Scripts, generating Static Reports using MDX queries and MDX Base Report Definition. Sound Experience in SSAS, OLAP cube and Architecture.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Great ability to create and manage various database objects like tables, views, indexes and sequences.
• Experience in Data Modeling, Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Experience in Created complex SSIS packages using proper control and data flow elements with Error handling.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

SQL Server tools: Enterprise Manager, Power BI Desktop, Power Bi Service, SQL Profiler, Query Analyzer, Tableau Desktop, Tableau online, DTS, SSIS, SSRS, SSAS, Development studio, Analysis Manager, Visual Studio.

Database: MS SQL Server 2014/2012/2010 , 2008 R2, 2005, SQL CMD, Microsoft Office

Methodologies: SDLC, Agile, Waterfall

Language: C, C++, HTML, XML, TSQL, MYSQL, DHTML, VB.NET, ASP.NET, C#, JavaScript.

Operating System: Windows, IOS, UNIX.

RDBMS: Oracle, MY SQL, MS SQL Server

Tools: Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports 8.5,10, XI, R2, Microsoft office 2003/2007, Team Foundation Server (TFS), EXCEL, Geocoder, LINQ Pad, Toad.

ETL TOOLS: SQL server integration system (SSIS), Data transformation services (DTS), T - SQL stored procedures.

Transformations: Business Intelligence, Split And Join, Row, Row-Set, aggregate, conditional split, data conversion, lookup, merge, merge join, multicast, union all, bulk insert.

PROFESSIONAL EXPERIENCE

Confidential, Akron, OH

SQL SERVER DEVELOPER/IAM Analyst

Environment: SQL Server 2008/2014/2016/2017 , SSMS, SSIS, SSRS, T-SQL, Power BI Pro, Windows 7/10, MS Word, MS Excel, C#, SAP SYSTEMS, SQL Profiler, Source Tree, Visual Basic, AZURE, Visual Studio 2010/2015/2017 , Active Directory, Service Now.

Responsibilities:

• Actively collaborate with users, Team leads, and technical managers to fully understand the requirements of the system.
• Involved in Planning and coding the database tables in order to store the application’s data with Architect.
• Performing Replication, Backup compression for individual tables and indexes and reducing the disk usage.
• Used various ETL tools like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Extensively used T-SQL in constructing User Defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Worked on Active Directory to create Users and User Accesses globally.
• Created and updated the Existing complex SSIS packages using proper Control and Data flow elements.
• Executed effective processes for service desk handling relating to AD incidents and ServiceNow.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Worked on Performance query and Query optimizing for the existing tables and stored Procedures.
• Created and scheduled reports, jobs like Daily, Weekly and closely monitoring the Jobs.
• Troubleshooted the Application GAIMS using tables, Stored Procedure, SSIS Jobs.
• Crafted table indexes in order to help in improving the database’s performance and Encoded views, several stored procedures and the functions too.

Confidential, Parsippany, NJ

ETL Application Developer/Reporting Developer

Environment: Power BI , SQL Server 2014/2016, SSMS, SSIS, SSRS, SSAS, T-SQL,Power BI Pro, Windows 7, MS Word, MS Excel, C#, Visio, JIRA, SQL Profiler, Source Tree, Visual Basic, AZURE, Visual Studio 2015/2017Responsibilities:

• Gathered Business Requirements, interacted with the Program Manager, Project Manager and SMEs to get a better understanding of the Business Processes
• Installed and configured MS SQL Server 2014/2016 along with Visual Studio on a network domain system
• Created Reports to Retrieve data using Stored Procedures that accept parameters
• Coordinated with DBA and Release Management team in Deploying Stored procedure and Reports in Visual basic production server
• 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
• Weekly presentation to the business users about the reports and their changes as required
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server
• Preparing Deployment Notes for the Data feeds and reports to be deployed every week
• Created, Tested, Deployed the reports and fixed bugs in the stored procedures related to Daily, weekly, Bi weekly, Monthly Reports
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in power BI
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI and also deployed dashboards onto production server
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems

Confidential, Philadelphia, PA

Tableau developer /SQL Server BI Developer

Environment: Tableau Desktop 9/8, Tableau Server 9/8, MS SQL Server 2016/2014/2012 , MS SQL Server Integration Services, Power BI, TFS, MS SQL Server Reporting Services, AZURE, DAX, MS Visual Studio 2012, Erwin, Informatica.

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axe
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI and also deployed dashboards onto SharePoint
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems
• Validated the results in Tableau by running SQL queries in MS SQL developer
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Developed tableau functional design document
• Performed performance tuning of the dashboard in Tableau desktop and Power bi desktop
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Involved in the development of SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities

Confidential, Princeton, NJ

SQL Server BI Developer

Environment: MS SQL Server 2014, Visual Studio2012, SSIS, SSRS, Tableau server, Tableau desktop, Query Analyzer, Database Engine tuning wizard, Power BI, MS Access, DAX, TFS, MS Excel, ERWIN, Windows Server 2012, Oracle 11g, Toad, MS-Visio, ETL Informatica

Responsibilities:

• Worked on Agile/SCRUM methodology for iterative and incremental development.
• Actively involved in gathering and analyzing stakeholder’s requirements.
• Installed and Configured SQL Server 2014 successfully.
• Worked on latest version of all software's like Visual Studio 2012 ultimate, Management Studio 2014.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Designed many technical documents individually to help the team understand the requirement for Building packages using SSIS.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Responsible for Deploying, Scheduling, Alerting and Maintaining SSIS packages.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently using Power BI.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Used SQL Queries at the custom SQL level to pull the data in tableau desktop
• Used Execution Plan to optimize and enhance the performance of SQL Queries.
• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Created SSIS packages to import data from MS Access, Excel to SQL 2014.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Proficiently created Reports based on the requirements using SSRS and power BI.
• Defined parameters for parameterized Reports.
• Converted few reports from crystal reports to SSRS.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Held responsibility for database maintenance plans.
• Explored Erwin for Data Mapping and Modeling.
• Created alerts, notifications, and e-mails for system errors.
• Performed unit testing for every package created.
• Deployed and scheduled tidal Job a job for SSIS Package for different environment.