Resume

Sign in

Manager Data

Location:
Hyderabad, Telangana, India
Salary:
760000
Posted:
May 14, 2019

Contact this candidate

Resume:

MANEESH JUVELLY

E-mail : ac9dm4@r.postjobfree.com

Mobile : 91-965*******

Curriculum Vitae

Professional Summary

Over 5+ years of IT Experience in System Design, Development and Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) and T-SQL.

Experience in creating master and child packages, package configurations and logging.

Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, and Bulk Insert).

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.

Experience in creating Star Schema and Snow Flake schemas

Good proficiency in SSAS cubes development and processing including Dimensions and Measures design.

Proficient in writing MDX query and good knowledge in MDX Functions.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Generated various monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.

Designed and created Report templates, Bar graphs and Pie charts based on the financial data.

Developed various types of complex reports like Drill Down, Drill Through, Cross tab, Matrix reports, Tabular reports.

Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.

Involved in scheduling, creating subscriptions for the reports using SSRS.

Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentation and a good team player.

Expertise in Power BI, Power BI Pro, Power BI Mobile.

Expert in creating and developing Power BI Dashboards in to rich look.

Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.

Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Technical Skills

ETL Tools : SQL Server Integration Services(SSIS 2008 r2-2014)

Reporting Tools : SQL Server Reporting Services (SSRS 2008 r2-2012)

OLAP Tools : SQL Server Analysis Services(SSAS 2008 r2-2012)

Database : MS SQL Server (2008-2016)

Other Tools : MS-Office, MS-Excel

Operating System : Windows Family

Visualization Tools : Power BI

Academic Details

BTech from JNTU University in 2007.

Advanced Diploma in Business Management from London Research Academy in 2009.

Professional Experience

Currently working with Navigantbpm India Pvt Ltd from 2017 May till Date

Worked with Aerosoft Technologies Pvt Ltd from 2013 January to April 2017

Project Experience

Project#1

Client : ARIZONA PUBLIC SERVICES

Project : APS MER Research

Domain : Energy

Client Location: USA

Sr ETL Developer (May-2017 – till date)

Team Size : 5

APS : 02 (Manager, Lead Coordinator)

Navigant : 03 (Manager,BA, TM)

Project Overview

Arizona Public Service Company is the largest electric utility in Arizona, United States and the principal subsidiary of publicly traded S&P 500 member Pinnacle West Capital Corporation (NYSE: PNW), which in turn had been formerly named AZP Group, when Arizona Public Service reorganized as that holding company in 1985.

APS is regulated by the Arizona Corporation Commission (ACC), the state agency that, by mandate of Article 15, Section 2 of the state's constitution, regulates energy utilities in Arizona, with the notable exception of SRP, the rural electrical districts, and the City of Mesa electric utility serving Downtown Mesa and the immediate vicinity (with the rest of the city being served by SRP).

The utility company also operates three nuclear reactors. Its Palo Verde Nuclear Generating Station in Arizona, the largest plant in the U.S., came under scrutiny by the Nuclear Regulatory Commission in 2005 when operational problems began to cause prolonged outages.

APS has been collecting data on the utilization of energy for different type of customers, APS is collecting data since Jan 2015 and wanted a database to store the data and do some analysis on the energy consumed and saved by different customers.

.

Responsibilities

Involved in extracting data (920 GB) for cleansing activity from Flat file source (815 files) then transformed and loaded into Data Warehouse Targets using SSIS.

Understanding the business needs and provide the solutions accordingly.

Extensively working in Data Extraction Transformation and loading from source to target system using SQL Server Integration Services

Importing source/target tables from the respective data base by using execute package task using control flow tasks in SQL Server Integration Services.

Created transformations using data flow tasks.

Created event handlers per the package using event handler tab.

Used transformations like Derived Column, Conditional Split, Aggregate, Lookup, Data Conversion and Script Task to load data into Data Warehouse.

As the data was huge, have implemented Parallel load through ssis and

Used Columnar index on the datasets for getting the data much faster while using joins in SQL.

Created and Automated the process using ssis package for the daily load from SFTP server.

Monitoring the Automated SSIS package frequently.

Technologies:

MSBI Stack: SSIS

DBMS: SQL Server 2016

Operating System – Windows10

Project#2

Client : PECO (Philadelphia Electric Company)

Project : PECO PY8 & PY9 All Quarters

Domain : Energy

Client Location: USA

Sr ETL Developer (AUG-2017 – till Date)

Team Size : 3

PECO : 01 (Manager)

Navigant : 02 (BA, TM)

Project Overview

PECO, formerly the Philadelphia Electric Company, is an energy company founded in 1881 and incorporated in 1929. It became part of Exelon Corporation (NYSE: EXC) in 2000 when it merged with Commonwealth Edison's holding company Unicom Corp.

The company has approximately 2,300 employees; its call center and field craft personnel are members of IBEW Local 614. PECO serves about 1.6 million electric and over 511,000 natural gas customers; it is the largest combination utility in Pennsylvania, and has a franchise utility service area of 2,100 square miles (5,400 km2) with a population of 3.8 million people.

The PECO transition period for the competitive electric generation market ended on Dec. 31, 2010, when caps on retail rates and competitive transition charges on customer bills ended. PECO electric rates had been capped for 12 years. PECO expects to purchase all of its wholesale electricity from competitive market sources subsequent to 2010 with retail customers charged the actual costs of procurement.

PECO has data for every quarter and needs to be loaded into the existing database and once loaded PECO what to generate some reports for analyzing the costs involved as per the quarter or sometimes the year and the requests are so frequent as they have multiple types of customers.

Responsibilities

Involved in extracting data for cleansing activity from SQL source then transformed and loaded into Data Warehouse Targets using SSIS.

Understanding the business needs and provide the solutions accordingly.

Extensively working in Data Extraction Transformation and loading from source to target system using SQL Server Integration Services

Importing source/target tables from the respective data base by using execute package task using control flow tasks in SQL Server Integration Services.

Developed Power BI model used for financial reporting of P & L and Headcount.

Designed and documented the entire Architecture of Power bi Poc

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.

Weekly presentation to the business users about the reports and their changes as required.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Worked on all types of transformations that are available in Power bi query editor

Created stored procedures and SQL queries to pull data into power pivot model.

Used stored procedures to load the data into data warehouse, Configuration, Logging and Auditing.

Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Used various report items like tables, sub report and charts to develop the reports in SSRS.

Produced various monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.

Created reports using Global Variables, Expressions and Functions using MS SQL server Reporting Services

As a Developer I have implemented SSRS Business Intelligence Life cycle such as Configuration of Report Server Configuration, Deployment of reports, creating report subscription (Data Driven) in Development, Test, Production environments.

Technologies:

MSBI Stack: SSIS, SSRS

DBMS: SQL Server 2013,2012 & 2008R2

Visualization Tools : Power BI,SSRS 2012

Operating System – Windows7

Project#3

Client : APRIL UK

Project : SMC portal integration

Domain : Health Insurance

Client Location: UK

MSBI Developer (Nov-2015 – April-2017)

Team Size : 9

April Uk : 02 (Manager, BA)

AeroSoft Vendor : 07 (Manager,TL TM)

Project Overview

April Uk Insurance is a global insurance provided. We have a major presence in United Kingdom, the world’s specialist insurance market provider, and a significant UK and international reach and is a group of Spire Healthcare.

We underwrite a broad class of health insurance with a strong focus on individual requirements. Our capabilities are underpinned by our strong financials. is listed on the UK Stock Exchange.

Responsibilities

Involved in extracting data for cleansing activity from SQL source then transformed and loaded into Data Warehouse Targets using SSIS.

Understanding the business needs and provide the solutions accordingly.

Extensively working in Data Extraction Transformation and loading from source to target system using SQL Server Integration Services

Importing source/target tables from the respective data base by using execute package task using control flow tasks in SQL Server Integration Services.

Created transformations using data flow tasks.

Created event handlers per the package using event handler tab.

Used transformations like Derived Column, Conditional Split, Aggregate, Lookup, sort, Data Conversion and Script Task to load data into Data Warehouse.

Used stored procedures to load the data into data warehouse, Configuration, Logging and Auditing.

Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.

Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Used various report items like tables, sub report and charts to develop the reports in SSRS.

Produced various monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.

Created reports using Global Variables, Expressions and Functions using MS SQL server Reporting Services

As a Developer I have implemented SSRS Business Intelligence Life cycle such as Configuration of Report Server Configuration, Deployment of reports, creating report subscription (Data Driven) in Development, Test, Production

Technologies:

MSBI Stack: SSIS, SSRS & SSAS

DBMS: SQL Server 2012 & 2008R2

Operating System – Windows7

Project#4

Client : HSH NordBank

Project : HSH NordBank DWH upgrade

Client Location: Germany

MSBI Developer (Sept 2014 to Oct 2015)

Team Size : 10

HSH Bank : 2 (Manager BA)

AeroSoft Vendor : 8 ( Manager, TL, Developer)

Project Overview

HSH Nordbank is a commercial bank in northern Europe with headquarters in Hamburg as well as Kiel, Germany. It is active in corporate and private banking. HSHs main focus is on shipping, transportation, real estate and renewable energy. The bank was created as a result of a merger between Hamburgische Landesbank and Landesbank Schleswig-Holstein on June 2, 2003. HSH has significant operations in Luxembourg, New York, London (the Bank no longer has an office in London) and Singapore.

Responsibilities

Involved in developing ETL for loading data into Database.

Creating Packages on SSIS by using different data Transformations like Derived Column, Conditional Split to load data into Data Warehouse.

Involved in extracting data for cleansing activity from SQL source then transformed and loaded into Data Warehouse Targets using SSIS.

As per the requirement developed the reports in the form of Matrix, Table and Chart using SQL Server Reporting Services.

Generated the Reports weekly, monthly, Quarterly and Yearly basis as per the client requirements.

Generated Sub reports, Drilldown reports, Drill through reports, parameterized reports and linked reports from queries in SSRS as per the Client Requirements.

Technologies:

Operating System – Windows7

DBMS: SQL Server.

MSBI Stack: SSIS, SSRS & SSAS

Project#5

Client : Eastern Bank

Project : Banking

Client Location: Canada

Developer (January 2013 – Aug 2014)

Team Size : 8

Eastern Bank : 2 (Manager, Lead Coordinator)

AerSoft Vendor : 6 ( Manager, TL, Developer)

Project Overview

Eastern Bank is an innovative financial services company offering a full suite of easy-to-use online brokerage, investing and related banking solutions, delivered at a competitive price. We empower individuals to take control of their financial futures by providing the products, tools and services they need to meet their near- and long-term investing goals.

Responsibilities

Involved in designing of Conceptual Logical Model and Physical Model.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in Development and Production environment for SQL Server.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.

Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures

Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data

Technologies:

Operating System – Windows7,Xp

DBMS: SQL Server.



Contact this candidate