Manu Kaur

( : 208-***-****

* : add4rw@r.postjobfree.com

OBJECTIVES:

Proactive and Solutions driven professional with 7+ years Experience in Microsoft technologies, Database and Business Intelligence Technologies, Deployment and support with SQL Server technology on different platforms.

SUMMARY

Experienced in Database technologies like SQL Server, MySQL and Oracle.

Experienced as BI developer/analyst on designing, developing and implementing reporting systems using tools like SSRS, Power BI and Tableau.

Experienced on various SQL server services like SSIS, SSAS and SSRS.

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

Experienced in creating the and maintaining the SSRS Reports. Communicate with the clients and end users for the requirements so that they get what exactly they want.

Worked on various Microsoft technologies tools and different third party tools for reporting.

Experienced in publishing Power BI Reports of dashboards in Power BI Server and Scheduling the dataset to refresh for upcoming data in Power BI Server.

Experienced importing data from different data source to create Power BI reports and dashboards.

Good understanding about Microsoft Dynamics NAV.

Worked on Azure SQL Datawarehouse.

Good understanding of Data warehousing and Data marts.

Experienced with the SDLC process - performing detailed analysis, collecting business requirements, Design, Development & implementation.

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

Worked on Tableau Desktop, Tableau Reader and Tableau Server.

Ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision.

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

TECHNICAL SKILLS

Database Languages

SQL, PL/SQL, TSQL, RQL

Data Modeling

MS Visio, Visual paradigm

Databases

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

Database Tools

Power BI, Tableau, SSMS, SSIS,SSAS, SSRS, Crystal Reports, Microstrategy, Informatica

Development Tools

JIRA, SharePoint, Team Foundation Server, Github

Operating Systems

Window, Mac, Linux, Android, IOS

Web Technology

HTML, XML, JSON, Java

EDUCATION

Masters of Computer Science, Marshall University, Huntington WV

Bachelors of Computer Science, Chandigarh University, India

PROFESSIONAL EXPERIENCE

Harbor Foods Group, [Lacey,Washington]

Business Intelligence Developer Sept 2017 – Present

Experienced with DDL and DML Scripts, Joins and established relationships between tables using Primary Keys and Foreign Keys for T-SQL and PL/SQL.

Developed various operational Drill-through and Drill-down reports using different reporting tools.

Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).

Deployed and Subscribe Reports using SSRS to generate all daily, weekly, and monthly Reports

Created ad-hoc reports using SQL server 2008, 2008 R2, 2012 Reporting Services (SSRS).

Published the Weekly Status report to the customer on Test Status and highlighting the issues to address immediately.

Good experience in conducting Triage Meetings with Business, Development and Test Teams.

Perform Query and report optimization to increase performance of legacy reports

Experienced on validating data and test the reports to sure data accuracy and quality so that the SSRS reports are visually appealing and providing correct data.

Developed complex SQL queries to support reporting requirements and SQL Server's stored procedures/functions and verified data accuracy.

Used Team Foundation server for project management, track the work, version control and for build automation.

Provided full SSRS reports documentation and the infrastructure for better understanding.

Worked with different departments and Clients to identify how to meet the requirements, create, modify and schedule the SSRS reports. Worked on various SSRS Reports, maintained the design and ensure that the data is accurate and reports are visually appealing.

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

Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Worked with the other team members how to prepare and make the SSRS reports and improving process in the reporting system in the organization.

Bed Bath & Beyond, [Union, NJ]

Business Analyst/Report Developer Aug 2016 – May 2017

Developed and delivered the Progress reports, Documentation, Proposals and the presentations as they required.

Consulted with the team and resolved the issues with project stakeholders.

Conducted data gathering and analysis to understand the business strategy requirements.

Communicates and developed the business requirements and functional specification to implement the business solutions.

Discussed work process, strategies and obstacles in the project.

Managed customer expectations and informed them about the problems and the issues.

Contributed to business short- long term planning sessions and provides direction to ensure the understanding of the business goals.

Experienced in making documents like Business Requirement Documents and Functional Requirement specifications

Created reports by collecting, analyzing the data and summarize the information by using various reporting tools.

Participated in the sprint planning and review meetings for finalizing the sprint backlogs.

Also worked with technology team to troubleshoot and resole the issues and track the production issues and target dates.

Worked with the project managers in the development of project schedules, timelines and development of the requirements.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Created KPI, Clustered column chart, Slicers for better understanding of the report.

Worked in joining the queries and merging the tables in Power BI.

Utilized Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Worked in generating Monthly, Yearly, Quarterly and daily reports in Power BI.

Designed reports in Power BI utilizing various with chart and graph features such as gauge, funnel, line better business analysis.

Experienced in creating DAX Expressions and implement partitions in Tabular Models for Power BI.

Experienced in create reports in Power BI Desktop and Service utilizing the connectors and content pack

Using Microsoft Power BI (Power Pivot, Excel pivot tables, DAX).

Experienced in creating dashboards with Microsoft Power BI desktop for early cancer detection analysis to improve decision-making in specific case scenarios.

Created reports in Power BI desktop preview portal utilizing the SSAS Tabular via Analysis connector.

Gathered requirement and designed technical document to implement the application.

Created Databases, Tables, Cluster/Non-Cluster Index, Check Constraints, Views, Stored Procedures, Triggers.

Esferasoft Solutions [Mohali, India]

Database Developer Jan 2013 – Dec 2014

Experienced in BI solutions using T-SQL, SSRS and Programming using DDL, DML, DCL commands and stored procedures for various business applications.

Establish and maintain backup and recovery policies and scheduling of SQL jobs.

Developed SQL scripts, indexes, and complex queries and experienced in Optimizing and performance tuning database activities.

Experienced on Data Loading in SQL Server 2008 using SSIS ETL and worked on developing packages in SSIS.

Using all kinds of SQL Server Constraints like Primary Keys, Foreign Keys, Defaults, Check, Unique.

Worked in Creating Tables, Views, and Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T-SQL statements for various applications.

Worked in SQL Server and T-SQL in constructing Tables, Normalization techniques on database Tables.

Excellent T-SQL skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.

Experienced on Data analysis and data migration by transferring them using the SSIS package.

Experience in Database Normalization, Designing, Creating Indexes, Developed Queries in MS SQL.

Also Experience in SSAS and Tabular DAX Modeling and Worked on developing and improving Microsoft Analysis Services Cubes.

Experienced in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports.

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

Worked on creating SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Have hands on experience and proven track record of expertise with performance tuning.

Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.

Writing T-SQL Code, SSIS Packages and managing SQL Server Jobs on daily basis.

Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server.

Experienced in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).

Experienced in building SSIS packages involving ETL process, extracting data from various heterogeneous sources like flat files, excel files, legacy systems and loading into SQL Server.

Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

NEC Technologies India Pvt.Ltd. [Delhi, India]

Database Developer Feb 2011 - Dec 2012

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

Writing complex SQL code and testing long running procedures to minimize run time.

Documentation of incident management and reporting.

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

Maintained close collaboration with Clients to ensure timely support whenever necessary.

Designed tables, views, various SQL queries, stored procedures, and functions.

Involved in T-SQL code review and modification for the development of new requirements.

Worked with Dynamic SQL, Composite data types & Global Temporary Tables and involved in partitioning of very large tables. Used list and range partitioning.

Creating and Managing users, roles and assigning necessary permissions. Experienced in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.

Expert in creating semantic layer in Tableau desktop and often-used data blending to connect to different databases.

Developed various types of complex reports like Tabular, Matrix, Drill Down, Drill through, Cross tab reports, Sub-Reports, parameterized reports and charts using Tableau.

Involved in scheduling, creating snapshots and subscriptions for the reports using Tableau.

Followed project management methodologies, utilizes required tools, documents and Templates.

Worked as project manager where Identified and managed projects dependencies with Critical path.

Developed and delivered the Progress reports, Documentation, Proposals and the presentations as they required.

Consult with the team and resolved the issues with project stakeholders.

AcmeMinds [Panchkula,India]

Jr. Database Developer/Tester Jan 2010- Dec 2010

Experienced on querying and debugging SQL scripts including DDL, DML and DCL commands.

Experienced in creating stored procedures, table valued functions, triggers and views using base tables.

Worked on transactional queries and prevented dirty reads, non-repeatable reads, phantom reads and deadlocks using isolation levels.

Experienced in database integrity checks using DB utilities and maintenance plan configuration wizard.

Used ALTER statements to check and manage database consistency, statistics, index fragmentation.

Updated the Error Logs and documented the resolutions.

Moved files between the File Groups and partitioned the tables to improve the performance.

Monitored SQL server performance using profiler to find performance.

Implemented different types of constraints on tables and monitored Scheduled jobs and alerts.

Development and implementation of backup and recovery strategies.

Performed database consistency checks at regular intervals.

Worked on modifying existing database by adding tables and relationships

Used SQL Indexes for improving query performance, lower storage and maintenance.

Created Jobs for database maintenance Index fragmentation, database statistics.

Database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.

Performed Cross Browser testing using different browsers like IE 8, Firefox, Safari and Chrome.

Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Experienced in reviewing/reporting, tracking and maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, Clear QUEST, Bugzilla, and Email.

Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures, Reporting and Tracking the defects.

Involved in Functional, System, Regression and smoke testing.

Extensively used Defect Management tool for Defect Reporting & Tracking using HP Quality Center.

Generating Test Summary and Sign off Reports.

PERSONAL SKILLS:

Leadership skills

Self-Motivation and ability to take initiative.

Interacting with different technical meet up groups.

Decent written and spoken skills.

Quick learner and keen to learn.

Expert in documentation, designing and developing database

Contact this candidate