KAWALJEET KOUR

Data Analyst/Business Intelligence Developer

New York, USA Phone number: 631-***-**** adkfpb@r.postjobfree.com

PROFESSIONAL SUMMARY

●Over 5+ years of diverse experience Business Intelligence Administration and Development, Business Analysis, Data Analysis, Requirement Gathering, Business Development, Project Management and Dashboard.

●Microsoft Certified DATA ANALYST passed DA-100 Microsoft Certification Exam.

●Experienced in Data warehousing -development and enhancement of cubes (SSAS) in Multidimensional and Tabular model.

●Experienced on ETL Architecture, DTS, Control Flow, Transaction and Data Flows in SQL Server Integration Services (SSIS).

●Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

●Extensive expertise in reporting tool (SSRS) and dashboards development using POWER BI Tool.

●2+ Experience with Microsoft Power Platform solutions (Power Apps, Power Automate (Flow), and Power BI).

●Experience in automated workflows design using power automates.

●Schedule task using power automate.

●SALESFORCE CRM - database integration using DBAMP and SSIS.

●Experienced in workload automation tools (WLA) such as Control-M, CA-WLA.

●Actively exploring Cloud BI using Azure.

●Lead or actively managed team of EDW engineers on Projects.

●Involved in data migrations, transfers, BI Development, and Deployment of SSIS packages from MS-Access, Excel and CSV, SQL SERVER, MYSQL.

●Experienced in SSRS to POWER BI Migration.

●2 years of experience with Snowflake Db.

●Familiarity with Waterfall and Agile methodology in Project Management.

●Hands on experience of MS Excel functions, formulas, VLOOKUP function and pivot tables.

●Experienced in creating Jobs, Scheduled SSIS Packages.

●Experienced in dimensional modeling using ERWIN tool.

●Experienced in Stored Procedures, Dynamic Queries using SQL Server.

●Good Communication & Management skills with Excellent Role playing and Problem-Solving capabilities.

●Proven Record of Consistent, Strong dedication towards work to ensure delivery of projects according to the Schedules.

●Strong organizational, prioritization and communication skills and passionate about learning new things.

TECHNICAL SKILLS

Operating Systems : Windows Server 2008, XP, Vista.

Databases : SQL Server 2005/2008/R2/2012/2014, MS-Access, MYSQL, SOQL.

Tools : MSBI (SSRS/SSIS/SSAS), Tableau, MDX, DAX, Radar,

DB amp, CA - WLA (Workload Automation), ERWIN, Azure

IDE : Visual Studio 2010/2008, Business Intelligence

Source Control : TFS, SVN, GitHub, AzureDevops

Workload Automation : Control-M, CA-WLA

EXPERIENCE

Team Consulting USA April'20 - June '20

Business Intelligence Developer

Domain - Logistics

Environment: SSIS, Power BI, SSAS-Multidimensional &Tabular, SQL Server 2012, T-SQL, TFS 2012, GitHub, WLA, MDX, ERWIN

Project Abstract:

The project involved enhancement of multidimensional and tabular cubes to examine Logistic supply by integrating multiple application data using ETL system. Project was based on Ticket generation tasks to resolve critical issues on production environment in predefined release.

Responsibilities:

●Worked closely with the Business users and warehouse team to understand the requirements and analyzing the issue.

●Analyzing product, market, and share trends to build warehouse data.

●Responsible for task identification, work effort estimates and work schedules for the development.

●Created project artifacts (Unit Test Plan, Technical Design Document, Defect Tracker etc) to ensure quality deliverable.

●Provide recommendations on evolution of the architecture by designing Approach Document and Impact Analysis for Client Issue.

●Responsible for estimation and finalizing testing scope.

●Responsible for the Creating/change in packages/cubes/Reports.

●Performed Unit and Integration testing of the SSAS cubes and SSIS Packages and involved in bug fixing and troubleshooting.

●Handling issues in PowerBI dashboards by building model from different sources.

●Responsible for monitoring and optimizations of warehouse load using WLA tool.

●Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business.

●Developed and modified procedures in database using SQL.

●Creating schedule batches for tasks.

●Involved in Ticket Generation project to resolve critical issues in predefined release.

●Responsible for handling Production Job failure, Scheduled SSIS Packages and reports errors.

●Mentored new members of the team in Functional and Technical aspects of the project.

●Perform code reviews if any changes required in production environment.

●Core Team member of Business Intelligence Development Team.

MIDHA AUTO CORPORATION, NEW DELHI, India feb'17 - Jan '20

Business Intelligence Consultant, Technology

Domain – Automobile

Environment: SSIS, SSRS, SSAS-Multidimensional &Tabular, SQL Server 2012, T-SQL, SVN, WLA, ERWIN, Salesforce Integration (DB Amp)

Project 1

Project Abstract:

The project involved development and enhancement of multidimensional and tabular cubes to examine Automobile data by integrating multiple application data including Salesforce using ETL system. This process generates the Enterprise Access Layer for Higher management and providing the highest value proposition.

Responsibilities:

●Collaborated with a cross-functional team of developers, project managers, product owners and quality assurance to report and mitigate project risks and ensure timely delivery of the product.

●Worked closely with the Business users and warehouse team to understand the requirements and analyzing the issue.

●Responsible for task identification, work effort estimates and work schedules for the development.

●Created project artifacts (Unit Test Plan, Technical Design Document, Defect Tracker etc) to ensure quality deliverable.

●Provide recommendations on evolution of the architecture by designing Approach Document and Impact Analysis for Client Issue.

●Responsible for Integration of data into Azure environment using Azure Data Factory.

●Responsible for estimation and finalizing testing scope.

●Responsible for the Creating/change in packages/cubes/Reports.

●Performed Unit and Integration testing of the SSAS cubes and SSIS Packages and involved in bug fixing and troubleshooting.

●Responsible for monitoring and optimizations of warehouse load using WLA tool.

●Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business.

●Generated Dashboards and reports using Power BI as per business requirement.

●Developed procedures in database using SQL.

●Creating schedule batches for tasks.

●Involved in Ticket Generation project to resolve critical issues in predefined release.

●Presented Demos to the client during meetings.

●Mentored new members of the team in Functional and Technical aspects of the project.

Project 2

Project Abstract:

The project involved in centralization of data of multiple outlets and generating reports and cube on top of that. Data has been taken from the source servers to the staging database and finally make transfer to another database for Reporting and analysis purpose so that all manual reports can be converted into Automated reports/Dashboards using MSBI solution.

Responsibilities:

●Work directly with functional analysts and Chief Technology and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.

●Transfer data from Source server to Data warehouse Server using the SSIS ETL Architecture.

●Using the SSIS ETL Architecture to transfer data from Source servers (all Outlet) to destination as Centralized database.

●Support and Developing SSAS as per client’s requirement.

●Developed SSRS Reports as per client requirement.

●Generated SSRS Reports like Drill Down, Drill through, Gauge, Map, Matrix.

●Log Shipping for Report Database.

●Cube development using SSAS.

●Perform code reviews if any changes required in production environment.

Pyramid Consulting, India Jun'14 - Jan '17

Software Developer, Technology

Domain – Health Information Systems

Environment: HTML/CSS, SSRS, SQL Server 2012, T-SQL, SVN

Project 1

Project Abstract:

The project involved development of website and creates reports for users.

Responsibilities:

●Design, Create and maintain websites by using HTML/CSS.

●Integrating data from various back end services and databases using SQL server.

●Writing well designed testable code by using best software development practices.

●Migrate MS-Access DB to SQL Server

●Responsible for estimation and finalizing testing scope.

Project 2

Project Abstract:

The project involved enhancement of existing website and integrate SSRS reports into application so that user can view reports from application.

Responsibilities:

●Worked closely with the Business users and warehouse team to understand the requirements and analyzing the issue.

●Generated Dashboards and reports using SSRS as per business requirement.

●Deliver production and ad hoc reports using SSRS within agreed upon time frame.

●Embed a report in a web page using Report Viewer.

●Responsible for estimation and finalizing testing scope.

●Generated SSRS Reports like Drill Down, Drill through, Gauge, Map, Matrix.

●Log Shipping for Report Database.

●Developed procedures in database using SQL.

●Creating schedule jobs for tasks.

●Presented Demos to the client during meetings.

EDUCATION

●Bachelors from Jammu University, India

CERTIFICATION AND ACHIEVEMENTS

●Microsoft Certified DATA Analyst using PowerBI

●Achieved Star Performer Award multiple times

OTHER INTERESTS

●Exploration – Cloud BI (Azure Platform, Azure Data Factory, Azure Data Lake, Azure Analysis Services )

●Regular volunteer, community kitchen for homeless people

Contact this candidate