RISHI

ad4yqu@r.postjobfree.com

513-***-****

https://www.linkedin.com/in/rick-i-502676228/

SUMMARY:

Highly motivated SQL Server Developer with over 9+ years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and hands on Experience in Installing, Configuring, Managing, Data Modeling, Administration and troubleshooting SQL Server.

Highly experienced in designing SSIS packages to import and transform data between databases and external data sources using various transformations.

Experience in configuration and maintain Report Manager and Report Server for SSRS, Developed, Deployed and Scheduled the Reports in Report Manager

Experience in Ad - hoc reports, data driven subscription reports by using Report Builder.

Experience in SQL Server Analysis Services (OLAP).

Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

Expertise in creating reports from importing, Direct Query and Live data from several data sources.

Good at developing and implementing reporting and data solutions, including custom user interfaces. In-depth understanding of all stages of software development life cycle (SDLC).

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. Provide database coding to support business applications using Sybase T-SQL.

Expertise in installing, maintaining and troubleshooting the Personal and On-Premises Gateway

Import data from different data source to create Power BI reports and dashboards.

Involved in creating dynamic well-organized, accurate and Insightful Power BI reports/dashboards to support strategic decisions.

Worked on end-to-end project in Azure Environment by pulling the source data from SQL Server and storing the data in Azure SQL Server creating reports using Power BI Desktop.

Expertise in data transformations such as adding calculated columns, manage relationships,

Create different measures, remove rows, replace values, split column, Date & Time Column, etc.

Created different reports in Power BI Desktop and publish to Power BI online.

Strong knowledge in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.

Worked on Power BI desktop and power BI service to publish the reports.

Involved in writing Complex SQL queries, stored procedures and Triggers accessed SQL SERVER Management Studio (SSMS).

Worked with developing events and delegates in implementing multi-threaded application.

Experience in Creating Reports using SQL Server Reporting Services (SSRS).

Effective team player and excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines.

Good knowledge with tableau desktop and tableau server.

Create various reports and dashboards using tableau.

Excellent verbal and written communication skills, analytical and inter personnel skills.

TECHNICAL SKILLS:

RDBM/Databases: MSSQL Server 2000/ 2005/2008/2012/2014/2016, MS Access 97/2000/2003/2007, MYSQL.

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, C, JAVA, MDX, XML, HTML, DHTML, Shell Scripting, JavaScript, Visual Basic 6.0, ASP .NET.

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.

ETL-Tools: SQL Server Integration Services (SSIS), Informatica.

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012/2014/2016 ), SQL Server Reporting Services (SSRS 2005/2008/2012/2014/2016 ), Microsoft Power BI (Power Pivot, Power View, Power Query, Power Map), Tableau, SQL Server Analytical Services (SSAS 2005/2008/2012/2014/2016 ), Visual Studio.

Tools: 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), ERWIN 7.3/7.2.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010, VBA.

PROFESSIONAL EXPERIENCE:

Charels Schwab (Dallas, TX) April’ 2023 – present

SQL BI Developer - SSIS/SSRS/SSAS/Power BI

Responsibilities:

Involved in gathering cost optimization Business Requirement after interacting with the Manager and development team to build up a solution.

Experience in Project Requirement Gathering and creating Business requirement documents.

Built on-demand Unit Price comparison data request and scheduled the report, for business analysis, management decision using Power Bi

Built Reports in Power Bi from scratch.

Worked on deriving KPI’s for Profit and Loss data.

Played role in design of scalable, reusable, and low maintenance ETL templates.

Involved in designing technical specifications for building Data Warehouse.

Contributed in creating ETL designs and provided end users an easy access to data marts.

Documenting the process followed for restoration based up gradation of TFS server.

Configuring Microsoft SQL server with TFS server.

Identified the dimension, fact tables and designed the data warehouse using star schema.

Built complex queries deriving Allocated Freight using CTE, Temporary tables.

Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert and merge.

Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.

Experience and exposure to different phases of Software Development Life Cycle (SDLC), Agile and Scrum Methodologies

Created reports using SSRS such as Drill Down Reports, Parameterized Reports, Linked Reports and Sub Reports apart from generating Ad-hoc Reports.

Created and Configured Dimensions, Attributes and Hierarchies using SQL Server Analysis Services (SSAS).

Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.

Created Business Power Bi Reports using the Tabular SSAS models.

Working extensively with Power Bi Business Intelligence tool to develop various dashboards.

Designed and implemented Dashboards and Scorecards with business KPIs.

Converted reports into interactive dashboards in Power BI that were presented to Business Users, Program Managers, and End Users.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Involved in modeling activities which included building star schema as per the business requirements.

Created dimension hierarchies and assigned levels and custom aggregation rules for each level.

Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.

Created reports in Power BI preview portal utilizing the SSAS Tabular.

Built MDX queries for Analysis Services & Reporting Services.

Create reports in Power BI utilizing the SSAS Tabular via Analysis connector as Data Source.

Bank Of America (Charlotte, NC) Nov’ 2021 – Mar’ 2023

SQL Developer

Responsibilities:

Developed complex stored procedures, indexes, triggers, functions, and views for different applications using SQL.

Expressions (DAX) and using Power Pivot for analysis included functions in metadata and prepared and deployed dashboards and reports using SSRS and Power Bi.

Experience on working with SQL Joins, Common Table Expressions (CTE), Sub queries and Triggers.

Writing complex SQL queries for project evaluation data extraction from the source, based on the client requirements.

Experience in performance tuning of SQL queries and stored procedures by creating Indexes on the Columns, which enhances the performance of the code.

Experience in developing different types of reports such as parameterized, drill down and drill through Using SQL Server Reporting Services (SSRS).

Experience with report deployment, scheduling and uploading files to report server catalog from report manager.

Utilized all tableau tools including Tableau Desktop, Tableau Server, Tableau Public, Tableau Reader, and Tableau Online.

Experience in installing, configuring & maintaining Tableau Development environment.

Professional expert in Data Visualization development using tableau to creating complex, intuitive and dashboards.

Effectively used data blending feature in tableau.

Validated reports to ensure quality of data and interacted with business analysts to review reports and obtain continuous feedback.

Involved in implementing Azure Data Factory

Developed SSIS packages to import the data from CSV Files, Text files and Excel spreadsheets.

Hands on experience in using different transformations like Script task, Lookup, Derived

Column, Conditional split and Multicast transformation using SSIS.

Loaded data using Azure data factory.

Created SSIS packages to load data into Data Warehouse using Various SSIS tasks which includes execute SQL task, bulk insert task, data flow task, file system task.

Working on resolving bug fixes in queries, reports and packages which leads to report failure and Incorrect data.

Strong experience in transforming business requirements into functional requirements for reports design, development and deployment.

Provide technical support and insight to the improve user experience and solve production issues.

WSFS Financial (Wilmington, DE) Sep’ 2017 – Oct’ 2021

SQL Developer/Power BI developer/Tableau

Responsibilities:

Involved in understanding the client's business processes and gathering technical requirement.

Analysing the KPI's based on the end user requirements and needs to develop dashboards using POWER BI.

Worked on preparing technical design documents and setting up different environments.

Worked with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.

Involved in creating dynamic well-organized, accurate an insightful Power BI reports/dashboard to support strategic decisions.

Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.

Analysed the KPI insights provided by the client using Power Bi Desktop.

Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.

Implemented Tableau features such as Parameters, Table Calculations, Quick Table Calculations, Sets, Groups, User Filters, and Hierarchies.

Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry specific KPIs.

Collaborated with Business Analysts, SMEs and other BI developers across departments to identify existing report needs, new reporting requirements and translated them into deliverable solutions.

Extracting business data from different OLTP systems and loads into data warehouse using SQL server Integration Services (SSIS)

Worked on providing row level securities using power bi to restrict data access for various users.

Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.

Worked in establishing the migration of data source connection between the Credit and collections power BI reports from SQL DB to the Azure blob storage and extracting the data.

Involved in s to be renewed/ rotated and storage to be re-mounted into CDS-A without impacting Power BI reports.

Used TFS (Team Foundation Server) and Visual Studio Team services (VSTS) to share all the work, code, to sort out the exceptions raised during work.

Worked on Azure SQL database and Azure SQL data warehouse.

Accenture (Optum) Sep’ 2014 – Aug’ 2017

SQL/SSIS Developer

Responsibilities

Understanding the business requirement and functional specification of the client module with Business executives & Analysts.

Expert in preparing performance Dashboard, Job Failure stats, Data Volume check using SSRS, SSIS, and SQL.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler and Database Tuning Advisor.

Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2015 and developed ETL packages to extract and transform data from data sources.

Involved in Data Scrubbing and Data Cleansing.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.

Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.

Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data.

Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).

Design and write elastic queries to access data across database and migrate an existing SQL Server Database to use Azure Database.

Deploying application to Azure using visual studio

Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

WNS Solutions (India) Aug’ 2012 – July’ 2013

SQL Developer

Responsibilities:

Analysed the existing data and performed the migration steps to SQL Server 2008.

Developed complex stored procedures, triggers, cursors, tables, indexes, constraints, views and other SQL joins for applications.

Created clustered /non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.

Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Performance tuning of SQL Queries and Store procedures.

Used Triggers to generate customized error messages.

Create joins and sub-queries for complex queries involving multiple tables.

Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.

Taking Database full Backup, Transaction log backup & differential backup in daily routine.

Traced long running queries and deadlocks using SQL Profiler.

Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of Databases.

Experience in Azure SQL Databases and Azure SQL Data warehouses and SQL Serve

Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent

EDUCATION:

Bachelors in Business Administration – Osmania University (2012)

Master’s in marketing Analytics - Wright State University (2014)

Contact this candidate