Amrita Rani

Senior SQL Developer

EmailId: ad322f@r.postjobfree.com

MobileNo: +1-650-***-****

Location: SanJose, California

Work Authorisation: H4 EAD

Data Engineering Data Analyst Data Warehousing SQL Developer SQL Business

Intelligence Azure Python

OBJECTIVE

A Microsoft SQL/Azure/Python certified Professional with over 10 years of professional experience, in Banking/Insurance/Finance/Mortgage Domain with an expertise in providing Business Intelligence, Data Warehousing solutions using SQL queries, designing and implementing ETL Strategy and designing Data Warehouse Experience in Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.Expert in creation and maintenance of Databases, creating Roles and managing user permissions.

Summary

Technical and functional expertise in Application/ Software Maintenance & Production Support.

●Sound knowledge of SQL, ETL and Data Warehousing methodologies and experience in using Microsoft Business Intelligence stack (SSIS, SSAS, SSMS)

●Analysing data from different source system and help to reduce expenses and improve the revenue of the organisation.

●Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

●Excellent in High Level Design of SSIS Packages for performing ETL operations on data from heterogeneous data sources by using multiple transformations provided by SSIS

●Experience in deployment and performance tuning of SSIS packages

●Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent and schedule SSIS Packages.

●Experience in Star and Snow Flake Schemas.

●Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP

●Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Views, Functions, Data Cleansing, Relational Database models and Data integrity and SQL joins.

●Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler

●Created different Power BI reports utilizing the desktop and the online service and schedule refresh.

●Assist end users with problems installing the Power BI desktop, installing and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users.

●Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data

●Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.

●Involved in UAT and Integration testing with QA team and good experience in AGILE /SCRUM

●Good knowledge on Python language.

●Ensure proper documentation and on-time delivery of all functional artifacts and deliverables

●Strong customer relationship skills with experience interfacing with customers to refine reporting requirements and build trusted relationships.

●Excellent problem-solving analytical, communication, presentation and interpersonal skills that help me be a core member of any team and passionate about innovation

Technical Skills:

●Programming: T-SQL, Python

●ETL Tools: SSIS

●Reporting Tools: SSRS, Power BI

●Database Technologies: SQL Server 2014/2016/2017/2019

●Version Control : TFS, GIT hub

●IDE: Visual Studio 2014/2016, Pycharm, SSMS

PROFESSIONAL EXPERIENCES

Project #1 : Bank Of the West(BNP Paribas)

Role : Senior Data Analyst

Duration : June 2021-Nov 2022

Project Description: Bank Of the West (Marketing Data Mart), Bank of the West offers a variety of financial services; including checking and savings accounts, credit cards, home and personal loans. Ensure and maintain the data quality and integrity of the critical information that supports the business Manage all Loan activity including drawdowns, rollovers, rate fixing, prepayments, fees etc. Administer waivers & amendments Manage and process transfers and assignments Monitor and disburse covenant reporting from clients

Responsibilities:

·Extensively involved in gathering business requirements as an endeavor that will facilitate the planning and the implementation phase of a data warehouse.

·The Marketing DM is maintained, part of an Enterprise Marketing Platform that integrates all sources of data feeds and publishes information on customers within Bank of the West. Developing reports, maintaining report definitions, maintaining report manager portal using SQL Server Reporting Services (SSRS).

·Involved in analyzing data, providing and reviewing monthly audit of cost savings, and liaising and working in relation to generate the revenue of the bank by provided promotional offer to the end user.

·Designed and implemented highly distributed, scalable processes - Staging, Data Enrichments and Strong data delivery techniques using Microsoft SQL Server, SSIS and Power BI.

·Designed and developed SSIS Packages to load data from various sources like Flat files, Excel, CSV and SQL Server etc.

·Extracted various ad-hoc reports using SSIS packages

·Fine-tuned existing SSIS packages and existing store procedures .

·Maintained the existing SSIS packages and SQL jobs.

·Performed data research, analysis, conceptual and logical data modeling to solve data issues, validate and document business data artifacts.

·Designed dimensional models with conformed dimensions, following the business processes.

·Created stored procedures, Views, Triggers and leveraged a variety of other Database Objects to efficiently translate and manipulate healthcare data.

·Supported ongoing ETL efforts for Development, QA and Production environments.

·Provide guidance on use cases for SQL Server. Developing ETL packages using SQL Server Integration Services (SSIS) and bulk-loading utilities. Perform root cause analysis to identify cause of issue or source of discrepant dat

·Develop solutions for structured,semi structured and unstructured data by designing data systems; define physical structures and functional capabilities, security, back-up and recovery specifications .

·Provide data support by coding utilities,responding to user queries and resolving

·problems.Creation of indexes to enhance performance.

·Experience with Red Gate Tools (SQL Source Control, SQL Compare, SQL Data Compare, DLM), to compare data, to fix the data and understand the code change from different versions of release.

·Troubleshoot current processes and maintain business continuity as required .Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures.

·Collaborates with business analysts, development teams and project managers for requirements gathering and to resolve requirements gaps uncovered in design or within specifications or requirements.

·Movement of data from SQL to Tableau, which is primarily used as reporting database.

·Prepares technical documentation for platform, service or infrastructure technical components.Experienced with code management, change management and deployment controls and processes.

Environment: SQL Server 2016, T-SQL, SQL Server Integration Services (SSIS), SQL Profiler, Excel, SSMS, Visual Studio 2017, Power BI

Project #2 : AXIS Bank (Duck Creek Technology),Accenture

Role : Technical Lead

Duration : Aug 2019-June 2021

Project Description: AXIS Bank (Duck Creek Technology) is a financial service company which

provides retail and commercial banking, trust, securities brokerage, mortgage and insurance product and services.

Responsibilities:

·Design, build, and support all components of a data warehouse, such as ETL processes, databases and reporting environments

·Develop and automate ETL processes that involve data cleansing, error, reconciliation handling and process monitoring utilizing Microsoft SQL Server Integration Services (SSIS).

·Analyzing and studying the income and expense trends of the bank, and suggesting measures for the organization to reduce expenses and boost income, thereby adding revenue to the firm.

·Prepared technical documentation for platform, service or infrastructure technical components

·Design dimensional models with conformed dimensions, following the business processes

·Deployed and scheduled SSIS ETL packages using SQL server job agent

·Develop and maintain business intelligence applications including operational reports, dashboards, scorecards, and ad hoc reporting requests.

·Worked closely with business users to congregate and comprehend requirements.

·Responsible for writing T-SQL code and handling data validations.Scheduled Complex Stored Procedures using SQL Server Agent.

·Monitored and modified performance using execution plans and index tuning .Designed and Developed Database Objects like Tables, StoredProcedures, Triggers, user defined data types and functions for the project.

·Involved in project planning, also schedule for database module with project managers.

·Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.

·Involved in planning and preparation for automating the daily build activities.

·Created SSIS Packages using SSIS Control flow Tasks, Transformations(Lookup, Derived Columns, Condition Split and many others) in efficient manner within deadlines as per business requirements.

Environment: SQL Server 2016, T-SQL, SQL Server Integration Services (SSIS), SQL Profiler, Excel, SSMS, Visual Studio 2017, Power BI, Tableau,CRM,MDM

Project #3 : MaritzCX LCC (Oil and Petroleum domain),Cybage Software

Role : Business Intelligence Developer(SQL SSIS SSRS SSAS)

Duration : Sep 2017- Aug 2019

Project Description: MaritzCX LCC (Oil and Petroleum domain) is a customer experience and market research company providing consumer data analysis in real time.The company provides platforms for strategy and design consulting, mystery shopping, data analysis models, comprehensive program management, and data collection and validation service.

Customer feedback is received through various channels and this data is loaded into EDW.

Responsibilities:

·Involved in gathering user requirements, application design and analysis of customer experiences to understand user satisfaction.

·Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.

·Extracted data from various sources like SQL Server 2016, CSV, Microsoft Excel and Text file from Client servers.

·Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

·Designed and documented the entire Architecture of Power BI POC.

·Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical cubes on SQL Server using SSIS,SSAS.

·Monitoring SQL server performance using SQL Profiler to find performance and Deadlocks.

·Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems like MS SQL Server.

·Design and developed new Power BI solutions and migrated reports from SSRS to PowerBI

·Created Datamarts for sales team to create Ad-hoc reports using report builder.

·Developed custom calculated measures using DAX for various Fact calculations for efficient data visualization in Power BI.

Environment: MS SQL Server 2016, SSIS, SSRS, SSAS, Visual Studio 2012, Power pivot, T-SQL, Power BI, MS TFS.

Project #4 : Canadian Imperial Bank Of Commerce(CIBC),TCS

Role : Software Developer

Duration : Mar 2012 - July 2017

Project Description: Canadian Imperial Bank Of Commerce(CIBC) is designed to provide Management Information System (MIS) type of reporting for Telephone Banking Contact Center users and management staff by providing reports used for the analysis of performance effectiveness and sales statistics for the Contact Center.Maintain and manage data from variousLine of Business (LOBs).

Responsibilities:

·Involved in complete database design including conceptual, logical and physical models.

·Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.

·Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.

·Created SSIS packages for loading the data from Excels files, which get triggered when users upload files

·Deployed and scheduled SSIS ETL packages using SQL server job agent

·Wrote stored procedures and User Define Functions (UDFs) to be used in the SSIS packages and SQL scripts.

·Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.

·Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.

·Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on maintaining, generating reports and data migration using SQL Server, SSIS, Power Bi.

·T-SQL development included queries using joins, sub queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, constraints & database triggers

·Implemented custom error logging and event logging in SSIS

Environment: SQL Server 2012 & 2017, T-SQL, SQL Server Integration Services (SSIS), Visual Studio 2012& 2015, SSMS

CERTIFICATIONS ACCQUIRED

1.Introduction To Python-MTA-98-381

2.Azure Fundamental - AZ-900

3.Quering Data with SQL

QUALIFICATION

GRADUATE:

Bachelor of Engineering(B.E) in Information Science - (VTU- Bengaluru, Karnataka)-2011

Contact this candidate