Lopamudra Manadhata

adjr9b@r.postjobfree.com

Cell No: 615-***-****

SUMMARY:

•6+ years of experience as Business Intelligence Developer and Data Analyst in various Environments.

•Strong Communication & Management skills with Excellent Role playing capabilities.

•Experience in Installation, Configuration and Updates of SQL Server.

•Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS.

•Experience in MSBI Development and Deployment of DTS, SSIS packages from MS-Access, Excel.

•Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS, Crystal Reports, Power BI, Alteryx, Tableau, SAS reports.

•Developed and maintained Microsoft SSAS multidimensional data cubes and MDX queries.

•Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources.

•Experienced in Performance tuning, Optimization, Data integrity.

•Experienced in data warehousing including business intelligence tools- DTS, SAS, SSIS and SSRS, Tableau.

•Utilized SAS to analyze real data provided by leading insurance and healthcare companies.

•Collected and reviewed industry and competitor data and built customized databases

•Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014/2016 with T-SQL.

•Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data Flow, Process Models, E-R Diagrams, Data Modeling.

•Experienced in Installation, Configuration and Deployment of SSRS.

•Experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

•Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

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

•Working knowledge of .Net Framework 3.5 (ASP.NET and C#.NET), IIS Web Server.

•Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

•Proficient with MS word, Excel, Macro, Access and Power Point.

TECHNICAL SKILLS:

Databases

SQL SERVER 2008/2012/2014, Oracle,MY SQL,DB2 Database,Snowflake, Teradata

Data Analytics/Dash board Tools

Alteryx, Tableau, Power BI, SAS

Languages

C#, C, C++, SQL, Python, R

.NET Technologies

ASP.NET, C#.NET, XML, UML

Web Technologies

Web Services, AJAX, HTML, CSS, Java Script, jQuery, SOAP, IIS

Operating Systems

Windows 2008/2012, Windows 7, Linux

Application Servers

IIS 6.0

IDE / Utilities

Visual Studio .NET 2010/2014, MS Visio

Source Control Tools

MS Visual Source Safe (VSS), TFS.

Methodologies

Agile, Waterfall

PROFESSIONAL SUMMARY:

Client: The General

Place: Nashville, Tennessee

Role: Data Services Analyst

Duration: April 2019 to May 2020

Project Description:

The purpose of this project is to create a visual Corporate Dashboard for the end users being as customers and leadership team for creating the business insights regarding the performance of the sales and profits that incurred during the period of Month to Date (MTD), Year to Date (YTD) and 12 month for forecasting better performance and increase in sales. This application provides BI reports consisting of interactive dashboards using Tableau for Loss Ratio, New business retention, Claims, Purchased Clicks and Calls on available data that is currently being used to provide better insights of overall performance of the business.

This project was built for improving the company standards by getting trend analysis using Tableau and giving better performance to the customer.

Was responsible for generating reports for Corporate Dashboard.

Performed ETL data integration using Alteryx for Workflow.

Performed ETL data integration using Alteryx and developed Tableau applications to analyze KPI’s and trends to improve performance of the firm.

Designed and implemented data models, generated insights on 14 Investment Strategies to facilitate decision making.

Perform data discovery, profiling and data quality using SQL and various other tools, like Alteryx ETL Tool for running SQL jobs.

Develop data analytical databases from complex underwriting, claims, finance, and external source data.

Develop data warehouse and business intelligence architecture, technical standards, centralized technical metadata, data quality scorecards, dashboards and ad-hoc reporting.

Design, develop, implement and maintain data governance tools for data management including data glossary, metadata, master, reference data management and data quality. Assisting in migrating reports from Alteryx to Tableau and successfully archived reports.

Created and imported SAS reports in Tableau.

Environment:

MS SQL Server 2016, TOAD, Alteryx, Tableau, MSBI, MS SQL Server Integration/Reporting Services/ Analysis Services 2015(SSIS/SSRS/SSAS), SAS, Excel, Macros.

Client: Pharm MD

Place: Brentwood, Tennessee

Role: MSBI Developer

Duration: June 2018 to March 2019

Project Description:

STARS is a Centers for Medicare and Medicaid Services (CMS) regulated quality measurement system which offers products to various medical insurance clients.

This project is about managing medical therapies and medical risks for different insurance companies. Insurance companies shared their membership information and claims data with us on a regular basis. We evaluate the data by filtering patient’s proper medication usage and send reports back to insurance companies.

This involve following steps:

-Enter into contract negotiation with prospective client.

-Onboarding team identification.

-Contract agreement

-File transfer

-QA smoke test of incoming files

-Raw imports

-Stars evaluation process

-Evaluation validation

-DTP identification and call list process

-Client feedback

-Go live

-Billing

-Reporting

I was involved in Stars evaluation process and DTP identification and call list process.

The ETL is written to import client data into STARs system tables.

After the evaluation data is validated and shown match expected outcomes, the ETL identified DTPs and produce the call list is developed.

Responsibilities:

Designed database, tables and views structure for the application.

Involved in Analysis, Planning and Defining data based on business requirements

and provided documentation.

Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into database using SSIS Packages.

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

Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2014 and Flat files.

Responsible for optimizing SQL queries, stored procedures to improve the performance time.

Used SAS reports using Power BI.

Environment:

MS SQL Server 2016, MS SQL Server Integration/Reporting Services/ Analysis Services 2015(SSIS/SSRS/SSAS), SharePoint365, SAS, Excel, Macros, formulas.

Client: M&T Bank

Place: Buffalo, New York

Role: SQL Server Developer

Duration: Jan 2017 to May 2018

This project is for a leading retail financial institution to design and implement their KYC AML system.

Responsibilities:

•Involved in the analysis of the requirements and gathering requirements for closed loop project.

•Involved in creating tables and their relationships in the data warehouse.

•Created Technical Report Requirement document for the Standard Reports.

•Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.

•Developed Dynamic Report Engine for creating the customized reports in SSRS.

•Involved in creating Dynamic Stored Procedures and views.

•Involved in analyzing and gathering the requirements for Row level Security and Role based security.

•Created the technical requirement Documentation for Row level Security and Role Based Security ETL’s.

•Implemented Row level security and Role based Security in the Standard Reports.

•Involved in creating the tree view folder structure in the application using C#.net to handle different reports.

•Involved in Creating and Testing the SSIS packages developed for security.

•Involved in creating SSIS packages to migrate large amounts of data.

•Involved in using SSAS data sources in SSRS, Tableau reports.

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

•Generated Crystal reports from existing .Net applications.

•Involved in performance tuning of queries for query efficiency.

Environment:

MS SQL Server 2014, MS SQL Server Integration/Reporting Services/ Analysis Services 2015(SSIS/SSRS/SSAS), XML, TOAD, Excel, Formulas.

Client: Semantic Space Technologies

Place: Hyderabad, India

Role: .Net Developer

Duration: April 2010 to June 2012

Description:

This project was for a petroleum exploration and production company operating in Sudan. It was undertaken construction of the Greater Nile Oil Pipeline which links Sudan's inland oil fields with refineries at Khartoum and Port Sudan. This project was to provide an intranet portal to the employees for their travels and accommodation booking.

Roles and Responsibilities:

•Involved in the design and offshore development of the Web Application.

•Worked Closely with Database team and architects to design the database of the Application

•Involved in developing both the Admin and Client module.

•Developing UI Layer, Business Logic Layer, created database Stored Procedures, * Unit and Integration testing of the application, Created GUI using ASP.NET, C#.NET and style sheet.

• Used Ajax Control tool kit of .NET 4.0 frameworks to improve the look and feel and the Usability of the application.

•Data binding was extensively used to bind various server controls to the data from Database,Grid View control and Repeater control were used in displaying rows of data in a customized template format.

•Extensively used ADO.NET objects to communicate with SQL Server 2008 database.

•Involved in writing stored procedures for use in different modules of the application.

•Used Visual Source Safe (VSS) as the Source Control in the entire development of the project.

•Generated Crystal reports from .Net applications.

•Performed Functional Testing to check the stability of the product.

Environment: C# 2.0, ASP.NET 4.0, WCF, SQL Server 2008, ADO.NET, Visual Studio .NET 2005, XML,Ajax, Excel.

Client : GEETUP

Place: Bhubaneswar, India

Role : Database Developer

Duration: Sept 2007 -December 2009

HR management is an Intranet web based application, which is used for all HR related activities like Maintaining the Employs Personal information, Salary structure, Outsourcing candidates information, Resume

Responsibilities

• Installed and configured the database server (SQL Server 2000) in production, development and testing environments

• Developed the Stored Procedures, Triggers, Functions, and T-SQL scripts

• Writing new stored procedures and modifying existing ones and tune them such as they perform well.

• Implemented auditing using triggers and enforcing business rules via checks and constraints.

•Proper use of views to prevent unauthorized access to sensitive data.

•Created Database Tables and database views.

•Created batch job processing, scheduling and production support.

•

Environment: SQL Server 2000.

Training

•SQL Server 2014

•MSBI

•.Net

Education

•Master in Computer Application from Biju Patnaik University of Technology, Orissa in 2007.

Contact this candidate