SUMMARY:

• Over 7 years of IT experience as a MS SQL Server BI Developer 2014/2012/2008 R 2/2008/2005/2000 in various Industry verticals like State, Finance and Insurance.
• Extensive experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.
• Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.
• Extensive experience in Data-Warehousing projects as a Business Intelligence developer worked in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)and SQL Server Analysis Services (SSAS) SQL Server 2014/2012/2008 R 2/2008/2005.
• Experience on Performance monitoring using SQL Profiler. Scheduled and monitored all maintenance activities of SQL Server 2014/2012/2008 R 2/2008/2005/2000 including database consistency checks and index defragmentation.
• Experience in SQL Server ( 2014/2012/2008 R 2/2008/2005/2000 ) Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Extensively worked with Parameterized Reports, Report Snapshots, and Linked Reports and used Report Manager for deploying reports in SSRS (2008R2/2008/2005).
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Experience in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts.
• Experience in designing Power BI reports and Dashboards.
• Experience in Power BI, Power BI Pro, Power BI Mobile.
• Good experience in creating and developing Power BI Dashboards in to rich look.
• Used Visual Source Safe (VSS)for version control and configuration management.
• Strong knowledge working with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience in using Microsoft Azure Cloud Platform.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.
• Can do Attitude and ability to effectively communicate with all levels of the organization such as Management, technical and customers.
• Involved in creating Design documents of various APIs

TECHNICAL SKILLS:

RDBMS: SQL Azure, MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Access, Excel.

Database Tools: BIDS 2012/2008 R2/2008/2005, Management Studio, Visual Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, SSIS, SSAS, Upgrade Wizard, Replication.

Programming languages: SQL, T-SQL, PL/SQL, VB.NET, C#, Hive

Scripts: PHP, JavaScript, CSS, VBScript, HTML and XML.

Operating systems: Windows NT/2000/XP/2003/Vista/Windows 7/8.

Reporting Tools: SSRS, Performance Point Server, Report Builder, Focus, Power Pivot, Power BI.

Other: Microsoft Office, Visio, Dream viewer, Team Foundation Server (TFS) and Visual SourceSafe, Hadoop, COSMOS, HDFS.

PROFESSIONAL EXPERIENCE:

Confidential, TENNESSEE

Sr. SQL/BI Developer

Responsibilities:

• Developed and changed Branch Reports, Management Reports SSRS Reports according to the prerequisite.
• Designed and Developed reports in light of necessities utilizing SQL Server Reporting Services (SSRS) and conveyed them.
• Server Reporting Services (SSRS). Made Alerts for fruitful or unsuccessful culmination of Scheduled Jobs.
• Extensively chipped away at Cross Tabbed and Matrix reports utilizing SSRS.
• Built compelling questions for elite announcing and rendered them to HTML, XML, PDF and Excel organize utilizing SSRS 2012 and 2014.
• Developed Query for producing Drill Down and Drill Through Reports in SSRS 2012 and 2008.
• Designed and designed SSRS Reports utilizing Parameters and Expressions for the Reports.
• Refreshing the required Databases through SSIS bundles.
• Monitoring SSIS Jobs nearly and checking the Data in tables
• Modified the current SSIS bundles to meet the progressions determined by the clients.
• Scheduled Jobs for executing the put away SSIS bundles which were created to refresh the database on Daily premise.
• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Worked on all activities related to the development, implementation, administration, Installation of SQL Server, SSMS, SSIS, SSRS and support of ETL processes for large-scale Data project which included the claims & policy data of the client.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Implemented SSRS solutions, used dashboards and gauges to enhance for the business users.
• Deployed and Generated SSRS reports using the Reporting Services, Report Manager and Microsoft SharePoint 2010.
• Loaded data into data warehouse from multiple sources such as flat files, excel sheets and from different databases.
• Involved in extensive movement task to move reports from 2012 to 2014 in SSRS.
• Designed SSRS reports with sub reports, dynamic arranging, characterizing information source and subtotals for the report.
• Developed specially computed measures utilizing DAX in Power BI to fulfill business prerequisites
• Provided proceeded with support and improvement of bug fixes for the current and new Power BI Reports.
• Updated Applications influenced by advance Telerik UI for ASP.NET AJAX Security Vulnerability and tried all the application utilizing Telerik.Web.UI.dll and investigate the mistake and influenced the applications to run effectively.
• Modified the current ACT (Access confirmation Tool) SSIS bundle to variant 15.7 to affirm consistence with last login Date necessity.
• Deployed reports, made report timetables and memberships. Overseeing and anchoring reports utilizing SSRS.
• Working on new change asks for on SSRS reports. In charge of Scheduling Jobs, Alerting and Maintaining SSIS bundles through Active Batch Job Schedule
• Created a SSIS bundle for BULK Copy Program sending out the tables to level record to new NDM shared area.
• Worked with different changes like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and parcel all the more utilizing SSIS.

Environment: MS SQL Server 2014/2012/2008 , SSRS, SSIS, SSAS, PL-SQL, ETL, Server Data tools, SharePoint, VB.Net, .Net 4.0/3.5.

Confidential, TEXAS

BI/SSIS/SSRS Developer

Responsibilities:

• Gathering detailing prerequisites from clients and business experts and investigating necessities.
• Generated reports utilizing SSRS that could be utilized to send data to various Primary sellers, customers and supervisors.
• Designed and executed put away methodology and triggers for computerizing assignments.
• Involved in making SSRS Reports, which are, exceed expectations well-disposed to perform different activities like rotate.
• Created SSIS Packages for Import/Export information to/from SQL Server.
• Developed Operational reports to help complex client necessities utilizing SSRS.
• Worked on SSIS execution tuning utilizing counters, mistake dealing with, occasion taking care of, re-running of fizzled SSIS bundles utilizing checkpoints.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created SSIS DB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment. Used Batch Files to Import Data from other Data Base.
• Created Tableau scorecards, dashboards utilizing stack bars, structured presentations, scattered plots, land maps, Gantt graphs utilizing show me usefulness.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
• Creating data blending in case of merging two different datasets using Tableau
• Created Datasets in T-SQL, stored procedures for SSRS.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Creating Database objects - tables, perspectives, and capacities and creating methods for executing application usefulness at the database side for execution change. Performing question designs and ensuring every single inquiry is utilizing fitting valuable lists.
• Involved in taking care of live site creation issues. Giving a hot fix to the issue.
• Create distinctive SSRS Reports in view of the client's necessity. Different sorts like specially appointed reports,
• Involved in Dimensional Data displaying.
• Involved in Unit Testing, Validating Reports and Production Support to determine progressing Production Problems by checking on configuration changes made to creation frameworks Involved in Performance tuning the SQL Server Queries utilized as a part of SSRS Reports.
• Bug settles in SSRS and put away systems as vital.
• Played parts underway help for SSRS occupations.
• Optimized long running put away techniques and inquiries for powerful information recovery.
• Involved in Dimensional Data demonstrating.
• Use of SharePoint and TFS for rendition controlling, putting away and report the same by making Tasks in TFS.
• Developed Dashboards to investigate deals, inventory network.

Environment: MS SQL Server 2014/2012, SSRS, SSIS, SSAS, PL-SQL, ETL, Server Data tools, SharePoint 2012, VB.Net, .Net 3.5, SCOM.

Confidential, TENNESSEE

BI Developer

Responsibilities:

• Defined Check Constraints, functions, indexes, synonyms and views.
• Created and modified complex TSQL batches/stored procedures.
• Involved in Logical/Physical design of database and maintenance.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement. Performing query plans and making sure each query is using appropriate useful indexes.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Involved in defining referenced relationships with the measure groups and fact tables.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Created various parameterized reports, drill through reports using SSRS.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created SSIS Packages for Import/Export data to/from SQL Server.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Scheduled jobs and alerts using SQL server agent.
• Implemented a well-planned backup and restore strategy that protects databases against data loss.
• Responsible for monitoring and tuning SSRS Report Performance.
• Build the OLAP cubes with Dimension and Fact Tables using SQL Server Analysis service (SSAS).
• Fine-tuned SQL queries for maximum efficiency and performance.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, SSAS, Windows NT/2000/XP, Enterprise Manager, UNIX, SQL Query Analyzer, SQL Profiler, MS Access, MS Excel.

Confidential

Jr SQL/BI developer

Responsibilities:

• Installed and Configured SQL Server 2000.
• Transformed data from various data sources such as Excel and text files.
• Developed queries and macros for reporting purposes.
• Developed modules to export the data to excel for creating Charts and Graphs.
• Expert in all aspects of MS Access (tables, queries, forms, reports, modules, macros, security) including database design, developing, testing and documentation.
• Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.
• Strong reporting experience using Excel, Access.
• Optimized long running stored procedures and queries for effective data retrieval.
• Managed the security of the servers, as a part of Junior DBA administration duties.
• Experienced in evaluating and modifying tables, queries, and reports as per requirement.
• Extensive experience in analyzing data of relational database designs.
• Created tables, views, functions and stored procedures.
• Optimized queries by creating indexes.

Environment: SQL Server 7.0/2000, MS Access, MS EXCEL, T-SQL, Windows 2000 server.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows 2000, Toad.