Resume

Sign in

Power Project

Location:
Mississauga, ON, Canada
Salary:
50 per hour
Posted:
February 28, 2020

Contact this candidate

Resume:

SUMMARY

I have *.* years of experience in the IT field with working experience on Data Warehouse & BI technology, with focus on MS Power BI, Crystal Reports, SAP Business Objects 4.2 and Informatica 10.1 and 10.2

Have experience in Banking and Insurance domains. Have closely worked with different clients to understand the requirements and build concepts and skilled at analyzing business requirements and preparing high level detailed designs and Data modeling.

Worked in all phases of software lifecycle including analysis, design, development, system testing and implementation.

I have also been successful in providing BI solutions and also has exposure to certain business products like universe designer, info view and a very good experience with the ETL tool like Informatica.

Owns a good database knowledge and experience in SQL SERVER and Oracle, and maintains a very good rapport with the client.

Am an effective communicator with strong Interpersonal Skills.

TECHNICAL SKILLS

Operating System

Windows 2000, Windows XP, UNIX, Windows 10

Programming Languages

SQL, ORACLE

Databases & Tools

Crystal Reports, MS Power BI, Business Objects, Informatica

PROJECT PROFILE:

Project Title

Lincoln AD Interim SteadyState

Duration

July 2019 – Jan 09th 2020

Location

Mississauga, Canada

Operating Systems

Windows 10

Programming Languages

ORACLE

Tools

Informatica 10.2, Business objects 4.2, MS Power BI

ROLES AND RESPONSIBILITIES:

I was responsible for migrating Business Object 4.2 reports to MS power BI for more user-friendly reports. The main requirement from the client was to have the exact data as it was available in the Business objects reports. Developed complex Power BI model for the proper data flow and used complex DAX functions in Power BI and Power Pivot. Worked on the data cleansing part before importing the data to excel. Worked on the creating the new measures, parameters, filters, calculated columns and almost with all the transformations used in power BI query editor. Worked on almost all the graphs available in the visualization part of the BI desktop which include bar chart, line chart, cards, tables, power map etc.

I have also created workspace for business users to view the developed reports and scheduled automatic refresh, scheduling dashboard refreshes in Power BI Service and also providing row level security.

PROJECT PROFILE:

Project Title

Lincoln AD MSP Program

Duration

Jan 2017 to June 2019

Location

Kochi, India

Operating Systems

Windows 10

Programming Languages

Oracle

Tools

Informatica 10.2, MS Power BI

.

ROLES AND RESPONSIBILITIES:

I was responsible for refactoring the complex access database codes into Oracle queries and used Informatica 10.2 to create complex mapping using various transformation followed by

Workflows and sessions. Created AutoSys jobs for the data load in Dev, UAT and Prod environments. Finally, reports are created using Power BI tool. Complex DAX functions were

Used. Different Graphs were used during the creation of reports to make the reports more user friendly. Also created workspace for business users to view the developed reports and scheduled automatic refresh, scheduling dashboard refreshes in Power BI Service and also providing row level security.

PROJECT PROFILE:

Project Title

Cognizant Internal project

Duration

Feb 2013 – Dec 2016

Location

Kochi, India

Operating Systems

Windows 10

Programming Languages

Java scripting, HTML, Greenplum

Tools

PENTAHO 4.0 PENTAHO 5.0.4

ROLES AND RESPONSIBILITIES:

I was responsible for developing application mainly reports and dashboard using Pentaho. Used JavaScript and HTML for developing dashboards which will incorporate reports, and also used fusion charts to make the dashboard more user friendly and easy to understand.

PROJECT PROFILE:

Project Title

PBRPTDEV

Duration

May 2010 – Jan 2013

Location

Chennai, India

Operating Systems

Windows

Programming Languages

SQL, Oracle

Tools

Business Object, Crystal Report10, Crystal report 2008, Excel writer

ROLES AND RESPONSIBILITIES:

This project mainly handles the reporting requirements of T360. T360 is a hosted matter management and electronic billing application used extensively by Morgan Stanley in North America for matter management and for electronic payment of legal invoices. In this project, the requirements were gathered directly from the client and reports were developed using Crystal Report. Used SQL server as the database. The reports were tested in all three environments (DEV, QA, and PROD) after getting signoff from the respective client.

EDUCATION

Title of the Degree with Branch

College/University

Year of Passing

Bachelor of Technology in Computer Science and Technology

Cochin University of Science and Technology

2009



Contact this candidate