SUMMARY

• Over 8 years of IT experience as a SQL/SQL BI Developer, experience in Data Modeling, Database Design, Programming, Development, Implementation of Client - Server Applications & Database systems and can perform well both independently and as a team player.
• Expertise in Extracting, Transformation and Loading ( ETL ) using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration Services ( SSIS ). Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Strong knowledge in MS SQL Server , MSBI SSAS / SSIS / SSRS , Power BI and Tableau. Worked in end to end BI environment of ETL, Analytics and Reporting.
• Development and support of Microsoft SQL SERVER 2014/2012/2008 R2/2008/2005 Data warehouse, test and production Environment.
• Excellent experience of managing BI environment, which includes Business objects, Data Model, Data sources, ETL tools, target data warehouse, Data marts, Data analysis and Reporting tools.
• Experience in a fast-paced Agile Development Environment including Extreme Programming.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources, legacy systems and load into various Business Entities.
• Expertise in developing, monitoring and transforming data using SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Service (SSAS).
• Expert knowledge in developing multidimensional databases using SSAS.
• Experience in OLAP cubes using SSAS for data mining.
• Excellent technical and analytical skills with clear understanding of data architecture, metadata, design goals of ER modeling for OLTP and dimension modeling for OLAP .
• Experience in Data warehouse such as dimensional modeling , Star/Snowflake schemas , Data marts , fact and dimension tables identification.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services project
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Hand on experience in writing MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services (SSAS).
• Experience in Power BI Reports from Power BI Desktop to Power BI Service.
• Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experienced in rational database management system including normalization, joins and cursors.
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Very good hands on experience in Confidential -SQL programming and good knowledge on RDBMS concepts.
• Excellent working knowledge in developing data access using XML Applications, XML Schema, XSLT/XPATH & Web Services .
• Extensively worked in SQL server Reporting services (SSRS) to create reports that draw content from a variety of data sources.
• An In-depth grasp of Business Intelligence tools like Power BI and Tableau .
• Strong troubleshooting, decision making, organization skills and goal oriented, with a commitment towards excellence presentations and a good team player.

TECHNICAL SKILLS

Language/ Frameworks: Confidential -SQL, C#.NET, C, VB SCRIPT

Databases: MS SQL SERVER INTEGRATION SERVICES (SSIS), MS SQL SERVER REPORTING SERVICES (SSRS), SQL SERVER ANALYSIS SERVICES (SSAS), SQL Profiler, SQL Query Analyzer, MS SQL Service index wizard, Transact-SQL

Database tools: SQL Server Management studio, SQL data tools, BIDS, MS SQL server 2012/2008/2005/2000 , MS Access, ERWIN, Power BI,Tableau

Platforms: Windows, Linux

Methodologies: Agile Methodology, Waterfall, Extreme Programming

PROFESSIONAL EXPERIENCE

Confidential, Washington, PA

Sr. SQL/ MSBI Developer

Responsibilities:

• Involved in database development using stored procedures, triggers, views and cursors.
• Development, Deploy and support in ETL projects for large-scale Data Warehouse using SSIS (Integration between (SQL, oracle, Confidential -SQL, XML.) SSAS and SSRS.
• Followed the Agile Methodology in the SDLC.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying Confidential -SQLstored procedures/triggers for validating the integrity of the data
• Created indexedviews, and appropriate indexes to reduce the running time for complex queries
• To keep track of data manipulations using Audit functionalities.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversion.
• Created several packages in SSIS.
• Custom components for SSIS packages were written in VB.net.
• Scheduled the packages to keep extracting the data from OLTP Confidential specific time intervals
• Used various transformation tasks to create ETL packages for data conversion.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Used SQL Server Agent for scheduling jobs and alerts
• Performed Query optimization & Performance Tuning
• Optimized queries using SQL Profiler and Database engine tuning advisor
• Generated custom and parameterized reports using SSRS
• Created reports that call sub reports in SSRS
• Configuration and Deployment of all the Reports(RDL, RDS) across various SDLC environments
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Responsible for creating datasets using Confidential -SQL and Stored Procedures and also involved in Data visualization.
• Created multiple dashboards with filters and parameters for analyses utilizing power view.
• Created gauge, funnel, slicer, stacked area chart, line chart utilizing Power BI
• UtilizedPower BI- PowerPivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Created reports in Power BI desktop preview desktop portal utilizing the SSAS Tabular via Analysis connector. .
• Designed various reports and dashboards utilizing SSRS, Power View and Power BI.
• Utilized SSRS and SharePoint BI primer to create multitude of data intensive visual reports for clients and executive management.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services, SQL Server Reporting Services, BIDS, Confidential -SQL, Oracle, MS Excel, Windows 2008 Server, Power BI.

Confidential - Broomfield, CO

MSBI/ SSIS/ SSRS/ SSAS Developer

Responsibilities:

• Rewriting and optimizing Queries
• Migrating Database from IBM Acis 400 to SQL Server 2012
• Preparing Documentation and specification
• Collaborating with other team members and stakeholders.
• Created 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 Insert, merge and union all.
• Created SSIS packages to populate data from various data sources.
• Performance tuning, and optimization of procedures and queries.
• Involved in Requirements gathering, Analysis and design of all the client requirements.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for Power BI Report Deployments.
• 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 Database.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spread sheets, Text file, MS Access and CSV files to data base.
• Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.

Environment: SQL Server Management studio, SQL data tools, BIDS, MS SQL server 2012/2008/2005/2000 , MS Access, ERWIN, Power BI, oracle, XML.

Confidential, OH

MS SQL Server/ MSBI

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Loaded the data from different sources to SQL Server database using SQL Server Integration services (SSIS) 2012.
• Used the concepts of priority constraints, look up tables to validate data while dealing with SSIS.
• Created data marts respect to insurance domain and populated data as pr reports needs.
• Scheduled the SSIS packages to process the cubes in order to update the data from OLTP to OLAP.
• Refined the existing cubes by adding the new attributes to the dimensions and defining the relationship between the new attributes and the measure groups.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.
• Wrote many complex MDX queries to gather the data from the OLAP cubes while generating the reports in SSRS.
• Involving data visualizing using Tableau,created and published Tableau Dashboards into TableauServer.
• Created incremental refreshes for data sources onTableauserver.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Scheduled tasks to run every day to update changes in the base tables.
• Ran and tested required queries and reports before publishing.
• Published the reports and scheduled the reports in different formats (Email, Public Folder).
• Designed and implemented stored Procedures and triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using Confidential -SQL.
• Created/Modified SQL Joins, Sub - queries and Confidential -SQL code to implement Business rules.
• Performed database administration backup recovery, maintenance plans, database creation, tables & indexes.
• Involved in documenting the project steps and presenting to the team members
• Worked and resolved high critical incidents and resolved issues based on severity.

Environment: MS SQL Server 2008/2012, Windows Win7/Win10, SSIS 2008/R2/2012, SSRS 2008/2012, SSAS 2008/2012, Tableau.

Confidential, Branchville, NJ

Senior SQL Developer

Responsibilities:

• Generate Dash Board Reports for Internal Users using SQL Server 2008 R2 Reporting Services and Dundas Reporting
• Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers
• App Testing in Development, Production, DR
• UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2007
• Deploy various reports on SQL Server 2008 Reporting Server
• Tuning the Databases, Auditing, Dynamic Management Views
• Database Capacity Planning, Maintenance Plans, Backup, Restore
• Data Modeling, Conceptual/Logical/Physical Modeling
• Create and maintain database for Incident, Problem Tracking, Metrics
• Working with SQL, and T-SQL
• Design Reports as of Internal User needs
• Access SharePoint Server using Web Services to deploy reports on Reporting Server
• Working with Stored Procedures, functions, triggers, Views
• Involved in creating tables, stored procedures, indexes
• Creating and Maintain users
• Creating / Running jobs with SSIS packages
• Design, Creating and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
• Configuring the Database Mail, Mail Operators using SQL Server 2005
• Creating Jobs, Job Notifications
• General Day to Day Database Administration
• Importing Data from various sources like DB2, Oracle, Excel, XML
• Ensuring Data Consistency, Analyzing the Data
• Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries
• Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Environment: SQL Server 2008 R2, SharePoint 2010, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services(SSRS), Integration Services(SSIS).