MONIKA SHEORAYAN

832-***-****

adhw7s@r.postjobfree.com

PROFESSIONAL SUMMARY

-Over 5+ years of IT industry experience in Microsoft Technologies. Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications.

-Knowledge of relational database design principles, data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling, strong development experience in SQL Server databases.

-Knowledge of DAX Expressions, advanced skills in creating Reports, Dashboard and performing Data Visualization using Power BI.

-Experience in Error handling and debugging coding issues and troubleshoot production problems.

-Proficient in Object Oriented application development and programming concepts. experience designing, implementing and testing Microsoft .NET applications.

-Experience implementing latest features in Power BI, .NET Framework, C#, SQL Server, MVC.

-Experience working in Agile SCRUM environment rolling out modules amid aggressive timelines.

-Passionate and hardworking programmer and a team player.

-Strong problem solving, analytical, verbal and written communication skills.

PROGRAMMING SKILLS

Core Skills: Power BI, DAX, MDX, Power Query, Power Apps, Microsoft flow, C#, MVC, ASP.NET, VB Script, SQL, Entity Framework andADO.NET.

IDE, Tools: Visual Studio, SQL Server Management Studio, Code.

RDBMS: SQL Server 2019/2016/2012/2008 R2

Source Control: Team Foundation Server 2012, Azure DevOps (ADO).

Testing Tools: DAX studio, MOQ, QTP, QC, Coded UI

SDLC: Agile (SCRUM) and Waterfall

WORK EXPERIENCE

Insight Global, Inc (Microsoft Project) Nov 2019-Current

(Redmond, WA)

Business Intelligence Analyst II

DATA CENTER HEALTH (Ops Excellence)

Working with the Data center Health team. Work responsibilities include, providing insights into datacenters operations and report statistics on operational quality of Datacenters. Built matrix based on the business requirement along with required OKRs(objective key results). The goal is to surface accurate data on the reports to help leadership make critical business decision. Created overall health and efficiency reports to some very target reports. The datacenter operations report helps the business to manage their campus effectively.

Responsibilities:

-Worked closely with our BI team to develop our data infrastructure to provide access to information and expand reporting capabilities.

-Work on Business Intelligence tools such as Power BI, DAX studio and Business Objects to develop reports and to provide meaningful data representation to the stakeholders.

-Imported data from SQL Azure to power BI and used DAX Queries to generate computed columns.

-Working with senior management and operation-level managers to design and maintain OKRs and operations-based metrics.

-Analyzed source to identify the required data for reporting and also morphing the data to meet the reporting needs.

-Imported data into fact tables and dimensions tables to create the report model.

Environment: Power BI (August 2020), DAX Studio, SQL Server Integration Services (SSIS), VS Code, SQL Server Analysis Services (SSAS, SharePoint, TFS, Power Pivot, Power View, MS Office, Microsoft Visual Studio 2015.

Sonata Software (Microsoft Project) Jan 2017-Jul 2018

(Bellevue, WA)

Business Intelligence Analyst

Customer 360 and Partner Value Index

Worked on the Customer 360 and Partner Value Index dashboard. It was a R&D initiative. The dashboard is used to consolidate the most relevant insights for a customer on a given project on a single place, and same for the partner. The purpose is to show the end-to-end implementation and operation experience of the customer.

Responsibilities:

-To gathered project information through project manager and Solution Architecture, and make sure the solution implemented satisfied the requirements.

-Worked with Project owner to groom the backlog and to plan a sprint.

-Imported data from SQL Azure to power BI and used DAX Queries to generated computed columns.

-Explore data in a Variety of ways and across multiple visualizations using Power BI.

-Developed SSIS jobs and scheduled for data transformation and database updates.

-Identified fact tables and dimension tables, and created data marts for various subject areas as required.

-As part of a team including management and process owners, identified KPIs and analytic needs such as dashboards and scorecards.

Environment: Power BI 2017, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS, SharePoint 2017, TFS, Power Pivot, Power View, MS Office, Microsoft Visual Studio 2015.

Logic Spice Consultancy Private Ltd. Dec 2013 – June 2015

(Jaipur, INDIA)

Software Developer

Micro-flux Control System

The Petronet Micro-flux managed pressure drilling system enables real-time detection and control of minute down-hole influxes and losses in gallons rather than barrels. Scalable to address a range of pressure-related challenges in nearly any operational environment, the system can minimize the risk of catastrophic well-control incidents, enhance drilling efficiency, and reduce costs.

Responsibilities:

-Implemented MVC based user interface to enable user to add well information, equipment details and run different kind of analysis.

-Involved in reviewing existing application for enhancements and bug fixing

-Performing various types of testing, such as functional, regression, user acceptance and integration.

- Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework in MVC

-Used Agile Scrum for software development and TFS for version control and project tracking.

Environment: MS Visual Studio 2012, C#, MVC, SQL Server 2012, .Net Framework 4.5, Entity Framework and TFS 2013

Risk Management System (Sevron Limited)

Sevron Limited business encounters a lot of risks everyday like duplicity, theft and misuse of the cards. The Risk Management System is a web portal used all across the business to manage those risks.

Responsibilities:

-Designed Business components and Data Access Layer using C#, ASP.NET.

-Used SQL server 2008 R2 to write stored procedure and SQL Profiler to debug and optimize data access.

-Created process documentation and knowledge articles for the support team.

-Involved in gathering the requirements from clients for product design and enhancements.

-Created SSIS Packages to perform scheduled batch jobs.

Environment: Microsoft .Net Framework 3.5, C#, ASP.Net, SQL Server 2008 R2, SSIS and TFS

EDUCATION

Master of Computer Applications, Rajasthan Technical University, India May13

Bachelor of Computer Applications, Rajasthan University, India May10

Contact this candidate