Amrin Kaur

Status: U.S Citizen

( : 732-***-****

* : adhjl7@r.postjobfree.com

OBJECTIVE: Highly motivated Professional over 6 Years of experience in IT includes extensive Functional and Technical experience in Business Intelligence (BI) product development and reports generation experience along with Business Analyst experience of translating business needs into long-term business intelligence solutions with the Power BI, Business Objects, Crystal Report, Tableau, MS SQL Server platform with SSIS and SSRS and other related tools.

SUMMARY

Over 6 years of experience in RDBMS technologies like SQL Server, MySQL and PL/SQL

Experience as Business Analyst in understanding business requirements and processes, leading ongoing reviews and developing optimization strategies for those.

Worked with end users and stakeholders to understand business requirements, recommended technical solutions and documented functional requirements

Experience in Extracting, Transforming and Loading (ETL) data flow among different source and destination files formats

Experienced in SQL Server 2008, 2012 and 2014

Experienced with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting business requirements, Design, Development & implementation

Worked with T-SQL, DDL and DML Scripts, Joins and established relationships between tables using Primary Keys and Foreign Keys

Experienced in MSBI using Business Intelligence Development Studio (BIDS) and SQL Server Development Tools (SSDT) to create packages SSIS and SSRS

Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Crystal reports

Developed, modified and troubleshot new and existing Crystal Reports

Expertise in creating complex SSIS and DTS packages for ETL purposes

Used advanced concepts of SQL including Joins, Sub Queries, Set Operators, Tables, Views, Indexes, T-SQL & PL/SQL Stored Procedures, Triggers, Functions, Packages, Cursors, Exceptions and Dynamic SQL

Expert in Database Designing/Modeling for new applications (OLTP & OLAP systems) and Database changes to existing applications

Expert in creating, configuring and fine-tuning ETL workflows designed in Server Integration Services (SSIS)

Experience in integrating data as per the requirement from multiple databases like Oracle, DB2 etc (Excel, CSV, flat file, etc.) by using multiple transformations provided by SSIS

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables

Strong in Analyzing Business Specifications and in developing appropriate Test Plans, Test Scripts and Test Cases based on customized needs

Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger

Knowledge of NoSQL databases like MongoDb and Cassandra

Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation

An excellent Inter-personal skill with ability to develop creative solutions for challenging client needs using design pattern

TECHNICAL SKILLS

Languages

SQL, PL/SQL, TSQL

Data Modeling

MS Visio, Visual Paradigm

Databases

MS SQL Server 2014/2012/2008/2005/, Oracle 11g/10g/9i/8i, MS Access, MySQL

BI Tools

Tableau10, SSIS, SSRS, Crystal Repot, DTS Import/Export

Project Management Tools

JIRA, SharePoint, Team Foundation Server, Pivotal

Operating Systems

Linux, Windows, Mac OS X, Android, iOS

PROFESSIONAL EXPERIENCE

Fond Du Lac Cold Storage Inc [Edison, NJ] Database Developer Jul 2019 – Present

Actively participated in interaction with business users, Director, VP and CFO to fully understand the requirements of the system

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers and schema for all the project applications of warehouse

Integration of scanning tools and apps with the SQL server database and transfer of data from the scanner to database

Setup issue tracking system for the whole warehouse for the tracking of the items and delivery

Generation of reports in Quickbooks from the data coming from SQL server database

Wrote stored procedures for the automation of the data coming from SQL server into Quickbooks for the daily generation of reports

Implementation of window servers and the web servers to run the integrated tools for the warehouse

Administered the SQL server database and the IT systems

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

Knowledge of SSIS Packages user data from the Flat files on monthly and weekly basis

Knowledge of views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation

WebMD [NYC, NY] SQL & BI Developer July 2017 – Oct 2018

Wrote queries for retrieving data from the Various databases and formats like (SQL Server, Excel, Flat file, Oracle, MS Access

Daily generated reports using SSRS & Tableau for our internal clients

Worked on few Outcomes Medic internal applications to pull data from databases using SSIS and run report with SSRS then upload to Workfront & Box tools

Involve in Planning, Defining and Designing data based on business requirements and provide documentation

Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information

Used various dashboard objects like horizontal, vertical, text, image and webpage to integrate all the worksheets together

Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server

Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau

Create Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps

Accomplished reports deadlines assigned in Workfront and uploaded in Box

EY [Secaucus, NJ] SQL & BI Developer Aug 2016 – May 2017

Used SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reports

Developed rich interactive graphics and data visualizations of large structured data in browser-friendly formats.

Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).

Planned, Defined and Designed data based on business requirement and provided documentation

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access

Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS

Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps

Generated parameterized reports, sub reports, tabular reports using SSRS 2012

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio

Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Multi-valued parameters and also understanding of the tablix control and Dashboard reporting, Share Point with Power View tool etc

Citigroup Inc. [San Francisco, CA] SQL/BI Developer Oct 2014 – May 2016

Actively participated in interaction with users, team lead, DBA and technical manager to fully understand the requirements of the system

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

Responsible for writing T-SQL code for creating cursor and handling data validations

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for the project

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

Knowledge of SSIS Packages user data from the Flat files on monthly and weekly basis

Created Database objects views, and functions and developing procedures for implementing application functionality at the database side for performance improvement

Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tables

Knowledge of views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status

Created datasets, data source and involved in deploying the reports in to the report server

Created reports using SQL Server 20012(SSRS) and integrated into the web front end

Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance

Money Gram Inc. [Burlingame, CA] SQL Database Developer Sep 2013 - June 2014

Writing queries for retrieving data from the database

Efficient in creating joins and sub-queries for queries involving multiple tables

Worked with different teams such as DBAs and Data owners during the business rules and data validation process

Experienced in creating SSIS package to extract and load data from the different sources and destination

Worked on creating ad hoc reports creating and running SQL queries and providing reports out to different departments in Excel and Access

Gathered requirements to identify and create database objects such as tables, views, triggers and indexes

Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity

Created ER diagrams using Visio

Created Views to enforce security and data customization

Created Non-Clustered indexes to improve query performance and query optimization

Involved in the performance tuning and optimization of T-SQL queries

Created Stored Procedures for commonly used complex queries involving join and union of multiple tables

EDUCATION

BS, San Jose State University San Jose, CA

PERSONAL SKILLS

Passionate about learning new technologies and business processes

Leadership skills with detail orientation and self motivation

Efficient in decent written and spoken skills

Interacting with different technical meet up groups

Superior documentation and organization skills

Contact this candidate