Saloni Sharma

Contact No: 609-***-****

Email ID: adz1r3@r.postjobfree.com

PROFESSIONAL SUMMARY:

Having 5+ years of experience as an SQL Developer Development & Support of Oracle Database in Production, staging and Development environments.

Very good experience in Oracle tools like SQL Plus, SQL Loader, SQL Developer using TOAD in secure databases.

Extensive experience in using Oracle seeded packages like DBMS_OUTPUT, DBMS_SCHEDULER, UTL_FILE, DBMS_SQL and DBMS_STATS.

Expertise in handling errors using Exceptions with RAISE application clause.

Expert in creating Public Synonyms, DB Links.

Generating SQL and PL/SQL scripts to install create and drop Trading Exchange Connection database objects including: Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.

Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.

Managing security by creating and granting Roles and Privileges to users.

Experience in developing external Tables, Views, Joins, Cluster indexes and Cursors.

Proficient in advance features of Oracle for PL/SQL programming like Using Cursor Variables, Ref Cursors, Nested Tables and Dynamic SQL.

Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.

Experience in creation of table Partitioning by range, list, hash, composite methods and Indexes for managing large tables.

Installed and configured on premises gateway in Power BI services.

Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators.

Developed website using Ruby on Rails on Mac OS, backed by MySQL and Capistrano to automate and ease the deployment process on Phusion Passenger server.

Proficient in Query/application tuning using optimizer Hints, Explain plan, SQL Trace, TKPROF.

Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables.

Wrote calculated columns, Measures query's using DAX in Power BI to show good data analysis techniques.

Written the ruby classes and wrote the test cases for the same.

Developed new Reports which are used to extract data from different systems and criteria.

Automated the process through the UNIX Shell Scripting and auto sys job scheduling.

Strong analytical, technical, and problem-solving skills with expertise in understanding business needs and defining requirements across organization-wide systems.

TECHNICAL SKILLS:

SQL Server Tools

SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Export & Import wizard, DTS, SQL Server Profiler, SQL server configuration manager

SQL Developer Tools

SQL Developer, SQL plus, Toad, Power BI

Reporting Tools

MS SQL Server Reporting Services (SSRS), Business Object Crystal Reports, Excel PowerPivot

Data Modelling

Erwin, MS Visio, MS Access

Languages

T-SQL, C, C++, C#, Visual Basic, HTML5, Shell Script, CSS3, AJAX, I Frames, UML

Web Servers

Apache Server, Windows IIS Server

Other Software/tools

Visual Studio, WinSCP, Putty

Databases

SQL Server, Oracle, DB2, MySQL, Mongo DB, Power Bi

Operating system

Windows Family, UNIX, Mac

PROFESSIONAL EXPERIENCE:

Client: Ally Bank, Detroit, MI Nov 2021 - PRESENT

Role: SQL/Power BI Developer

Responsibilities

Good understanding of Data Marts, Data warehousing, Operational Data Store ODS, OLAP, Star Schema Modelling, Snow-Flake Modelling, Fact and Dimensions Tables using MS Analysis Services.

Subsequently evaluated ProClarity and business objects as a front end for the ANALYSIS SERVICES implementation.

Designed Dataflows, Workflows and jobs to load data from source to target in BO Data Integrator.

Involved in reviewing the Investments application and interacting with business users to understand the user requirements.

Implementation of Ajax feature for improved performance.

Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server and SQL code.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Gathered user requirements and analyzed and designed software solution and database.

Involved in migration of Sql Server.

Designed and implemented data models and reports in Power BI to help clients analyze data to identify market trends, competition and customer behavior.

Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server.

Provided SWOT analysis on financial data using Power BI charts.

Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Involved in Analyzing, designing, building, testing of OLAP cubes with SSAS and in adding calculations using MDX.

Developed custom calculated measures using DAX in Power BI to compare the company’s industry wide.

Designed, developed, tested, deployed, supported, maintained and documented Key Point Indicators KPIs, Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server and SQL Server Analytical Services.

Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.

Responsible for implementation of creating complex SSIS packages using proper control and data flow elements with error handling.

Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.

Create multiple kind of Power BI Reports and Dashboards.

Expert in design and development of SQL Server Integration Services SSIS packages and using various control flow task and data flow transformation.

Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service SSRS.

Designed and implemented various reports using Crystal Reports and responsible for the migration to SSRS.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.

Stored Procedures, User Defined Functions, Views, T-SQL scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.

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

Environment: SQL Developer, SQL Server, SQL Plus, TOAD, ERWIN, HTML5, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Oracle, Erwin, MS Visio, UNIX, Windows.

Client: UMB Financial Corporation, Kansas City, MO Jun 2020 – Oct 2021

Role: SQL/Power BI Developer

Responsibilities

Define standards to avoid hard coding and creating the required packages to achieve that.

Creating the required tables and packages to be used in error exception handling.

Using explain plan, AUTOTRACE, TKPROF and RUNSTATS package to test different database physical design scenarios and to make sure there is no mistakes in the execution plans are chosen by the optimizer.

Cube design & KPIs using SQL Server Analysis Services (SSAS).

Automate processes using Control M and custom SQL metadata driven solution for jobs and error logging.

Using SQL developer for Automation Testing, debugging, creating data models and checking execution plans.

Developed website using Ruby on Rails on Mac OS, backed by MySQL and Capistrano to automate and ease the deployment process on Phusion Passenger server.

Using crontab and shell scripts to use SQL Loader to automate loading data into database tables.

Design and develop an automated reporting platform for Treasury and Capital Management department.

Improved Performance by creating Clustered and Non- clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Expert on creating multiple kind of Power BI Reports and Dashboards.

Worked to setup a process to create and share various reports on weekly and ad-hoc requests.

Coordination with other team mates on day-to-day basis and any project related concerns.

SEnd to end business intelligence solution development for Confidential.

Financial reporting and automation of income statement, balance sheet and trial balance reports for Confidential.

Reporting, delivery of automated reports & Power BI reports customization.

Writing SQL queries, Cursors using embedded SQL, PL/SQL.

Maintained Batch logging, Error logging tables and handled errors using Event handlers.

Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.

Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.

Experienced on creating multiple kind of Report in Power BI and present it using Story Points.

Created various kinds of reports using Power BI and Tableau based on the client’s needs.

Set-up Enterprise Gateway and SSAS Connector on Azure VM for Power BI Report Deployments.

Extensive use of T-SQL including Stored Procedures, views, triggers and column store indexes.

Created PL/SQL stored procedures, functions and packages.

Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.

Reviewed and fine-tuned stored procedures and triggers before production migration.

Environment: SQL Developer, SQL Server, SQL Plus, TOAD, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), ERWIN, HTML5, UNIX, Oracle, Windows.

Client: Silicon Valley Bank, San Francisco, CA Apr 2018 – May 2020

Role: SQL Developer

Responsibilities:

Analysis, mapping, flowcharting and documentation of existing Data Warehouse, legacy systems and Month End processing in preparation for systems conversion

SSRS Reports QC and Performance tuning.

Mapping of entire data architecture from SQL Servers thru databases to applications.

Developed the UNIX shell scripts jobs responsible for loading the data to the data warehouse tables.

Extensive testing on the Performance of the Stored Procedures.

Created Triggers to enforce data and referential integrity.

Developed the application using Ruby on Rails frame work, ActiveRecord, HAML, YAML, RHTML.

Developed ER diagrams and mapped the data into objects to modify the database and created alerts for error reporting.

Scheduling Daily, Weekly and Monthly MS POWER BI SSIS package execution process using SQL Server Agent jobs.

Fine-tuned a couple of old packages to improve performance and added better error handling capabilities to the existing packages. Did performance tuning for 5 existing packages.

Created required documentation for the changes done to the various packages and shell scripts.

Did unit testing and integration testing to ensure quality of final production code.

I was responsible for designing the front end of application using VB based on the requirement of the various teams.

Built a Tabular Model cube from scratch data and by MDX queries fetched data to MS POWER BI SSRS and Power BI reports.

Analysis and development of data migration from legacy systems and Great Plains into Microsoft Dynamics CRM for the migration of TB of legacy data.

Design and development of synchronization processes between remaining legacy databases and Microsoft Dynamics CRM.

Create reports in Power BI preview portal utilizing the MS POWER BI SSAS Tabular via Analysis connector.

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Migration of SSRS legacy reports to SSRS server along with implementing SDLC and source control.

Designed the back-end database tables using MS ACCESS and wrote set of SQL queries to load data from the Oracle database to MS ACCESS.

Created MS POWER BI SSIS packages to load data into Data Warehouse using Various MS POWER BI SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.

Implemented SDLC and source control across all main production databases.

Developed a self-maintaining Data Dictionary app which maintains column notes across schema changes.

As an oracle PL/SQL developer, I was involved in migrating the existing Oracle packages and Stored Procedures to the Amazon Redshift database.

Created MS POWER BI SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheet.

Wrote the complete application logic in VBA. Completed the Unit testing and then the deployment of the application.

Developed complex T-SQL code for the application conversions.

Developed reports using MS POWER BI SSRS and published as PDF, Excel, and CSV formats.

Created Stored Procedures, Triggers, Views and Functions for the Application.

Wrote the Letter Extract Functions and Stored Procedures in SQL.

Performed data transfer and database transfer for server relocation using DTS.

Worked with DBA to set-up the security roles for developers and end-users.

Merged data into a single server environment to have better control, consistency and security of data using SQL Integration Services SSIS.

Environment: SQL PLUS, SQL Developer, SQL Server, PL/SQL, ERWIN, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Oracle, UNIX, Windows.

Contact this candidate