Business Intelligence,Data Warehousing,SQL,SSIS,Ssrs,Ssas,Sas,Bo

Navneet Kaur

Sunnyvale, California Mobile No: +1-669-***-****

Email: *******.****@*****.***

Profile Summary

** ***** ** ********** ** Software Development & Production Support projects with core focus on Data Warehousing and Business Intelligence tools.

The key qualities that highlight my professional capabilities are:

Result oriented, self-motivated and able to work with minimum guidance.

Good analytical, logical, & debugging skills with high problem solving capability.

Excellent team player with effective communication skills.

Experienced in understanding business problems and applying technology to formulate workable solutions.

Good at mapping business requirements to the available technology options and providing customized, viable and cost effective solutions in liaison with cross-functional activities

Technology Skills Summary

Core Competency : SQL, PLSQL, SSIS, SSRS, SAS Customer Intelligence 5.41 & Data Integration 4.3,

Business Objects, Shell Scripting

Databases : Microsoft SQL Server 2000/2005/2008, Oracle 10g/11g, Vertica 5.1.0

Tools : SQL Server Integration Services, SQL Server Reporting Services, SAS

9.3 suite/SAS 9.4 suite (SAS Marketing Automation, Customer Intelligence

Studio, Data Integration Studio (ETL), Web Report Studio, BI Dashboard, Information Maps, SAS EG, SAS Management Console, OLAP Cube Studio), BOXIR3 server, Toad for Oracle, Remedy User

Operating System : UNIX, Windows

Projects Undertaken

1.MBONUS – MTS

Duration: January 2014 – January 2017

Company: Infosys

Role: Technology Lead

Description: A Loyalty Based Rewards program for MTS Telecom. Mbonus Program is a combination of SAS CI and SAS BI as front end, with Vertica and Oracle DBs as backend with Java and Unix Backbones

Responsibilities: Working as an Infosys onsite consultant & coordinator for requirement gathering and analysis, doing feasibility analysis and providing appropriate and viable solutions; Data modeling and data warehouse design, High level and Detailed Level Design Development and estimate documents; Data ETL, Coding, Code Review, Debugging and Testing for Change Requests; Managing the deployment and release of the modules to customer; Assessing impact, risk and cost benefit analysis of client requirements; Customer UAT and RA Testing; Presentations and Trainings on SAS features for business users, client IT and new team members.

Environment Details: SAS Marketing Automation suite 9.3 that includes, Customer Intelligence studio, Data Integration Studio, OLAP Cube Studio, Web Report Studio, BI dashboard, SAS BI Portal, Information Maps, SAS Enterprise Guide, SAS Management Console; Oracle 11g, Vertica 5.1.0, Linux (Red hat), HP UX.

2.CMER - Dish TV

Duration: December 2012 – December 2013

Company: Infosys

Role: Technology Analyst

Description: A SAS BI project on Campaign Management and Enterprise Reporting system built upon data warehousing concept involving PL/SQL programming aimed at improving the reporting needs of the organization as well as streamlining the campaign management process.

Responsibilities: As Infosys Onsite coordinator, the primary responsibility included in understanding client requirements and translating them to requirement specification; Data modelling, Designing, Coding, System Data Preparation/loading, Testing and Bug Fixing; Created SAS DI jobs for data extraction, transformation and loading; Created the data model for the data marts and source to target mapping of the required fields; SAS Customer Intelligence for campaign designing; Information Map for reporting purpose based on star schema; Created SAS BI Dashboards and exposed them on BI portal as the one stop shop for management level users to gauge into the company’s overall performance; Created SAS OLAP Cubes based on star schema for slicing, dicing, rolling up-down and filtering data for analysis purpose. Customer UAT and 3 weeks of Training on all SAS Tools and features for Business Users & Client IT Team enabling them to use and create new objects on their own.

Environment Details: SQL Server 2008, SAS BI Portal, SAS BI Dashboard, Web Report Studio, SAS OLAP Cube Studio, SAS Information Maps, SAS Enterprise Miner, SAS Data Integration Studio, SAS Enterprise Guide, SAS CI Studio, SAS Management Console

3.Global on Boarding - Cummins

Duration: February 2012 – November 2012

Company: Infosys

Role: Technology Analyst

Description : Portal Based application for Cummins Intranet Portal which was to be used by Cummins’ Hired Employees to complete the joining process, attend trainings and getting access to required resources.

Responsibilities: I was involved in requirement gathering and analysis; Built an Enterprise Data Mart for all employees; Extracted, transformed and data load from various systems using ETL; Development and Deployment of stored procedures, packages and reports to meet the various requirements; Preparation and execution of Test Cases; Involved in creating High and Detailed Level Design Documents;

Environment Details: Microsoft SQL Server 2008, SSIS, SSRS,

4.Business Objects - Citi Bank

Duration: March 2011 – January 2012

Company: Infosys

Role: Technology Analyst

Description : Support and maintenance project which involved migration, testing and publishing of Business Objects Reports for over 50 BO Applications.

Responsibilities: Support & administration of BO along with migration BO Objects between Dev, QA and Prod environments; Testing & publishing of BO reports using Business Objects XI R3; BO/BI installation and Upgrade from XIR2 to XIR3, XIR3 to BI4; Responsible for applying Service packs and Fix packs; Creating Unix Scripts to automate current manual activities; User Ticket analysis and resolution.

Environment Details: Business Objects xiR3 SP3 FP3.6, Unix, Oracle 10G

5.Concentrix - Deutsche Bank

Duration: April 2010 to March 2011

Company: HCL Technologies

Role: Software Engineer

Description: Development of Data Marts to accommodate the new components & maintenance support for Concentrix application (online bank trading tool); understanding the root cause of the problem and providing the fix within the specified Service Level Agreement.

Responsibilities: Analyzing the current system and building data marts; Perform data analysis and derive relationship; Transform and load data using ETL; Development and testing of code for new features; Maintaining the existing and new components built by debugging and resolving the production issues thus providing permanent fix. Providing the reports from existing system as required.

Environment Details: Microsoft SQL Server 2005, SSIS, SSRS

6.Senior Market Re-Entry & Billing Fixing - Well Point

Duration: February 2007 to March 2010

Company: UST Global

Role: Senior Software Engineer

Description: Developed a reporting system for metrics related to Billing, Enrollment, Claims, Service, Reconciliation and Acumen data which helped Well Point for their re-entry preparation into the MA/PD & PDP markets.

Responsibilities: System Analysis and requirement understanding, Data modelling and source to target mapping, Designing, Coding, System Data Preparation/loading, Testing, Bug Fixing; Creating the Design Document of the functionalities; Developing the Stored Procedures and packages; Data Transforming and Loading using ETL; Report creation as required by Business Users.

Environment Details: Microsoft SQL Server 2000/2005, SSIS, SSRS

Educational Qualification

Bachelor of Technology in Civil Engineering from Govt. Rajiv Gandhi Institute of Technology, Kottayam with 79% marks (Sep 2002 - June 2006).

Twelfth standard with Physics Chemistry Mathematics from Govt. Model Senior Sec. School, Andaman with 78.8% marks (June 2001 - March 2002).

Matriculation from Vivekananda Kendra Vidhyalaya, Andaman with 85.2% marks (June 1999 - March 2000).

Trainings & Certifications

Oracle Certified Professional (1Z0-007 Introduction to Oracle 9i: SQL Certified & 1Z0-147 Program with PL/SQL certified).

Microsoft Certified Technology Specialist for Microsoft SQL Server.

Trained in Agile Scrum and have hands on JIRA tool.

On the job training on SAS 9.3/9.4, Business Objects xiR3, SSIS, SSRS

Classroom training on Informatica Power Center v 8.1

Personal Details

DOB : September 22, 1984

PASSPORT : Z3623320

LANGUAGES KNOWN : English, Hindi, & Punjabi

HOBBIES : Dancing

Contact this candidate