Resume

Sign in

Developer - ETL Informatica Powercenter and SAP Business Objects

Location:
Toronto, ON, Canada
Posted:
March 06, 2018

Contact this candidate

Resume:

Business Intelligence Developer - ETL Informatica PowerCenter / SAP Business Objects

Skilled, passionate and professional developer with 3.5 years of experience developing, enhancing, testing, migrating and providing support for complex Informatica workflows and Business Objects reports. Proven success in the field of automation.

Professional Experience

Inautix Technologies India Pvt. ltd, A bny mellon company Jan’14 – Jun’17

Location : India

Client : Bank of New York Mellon, New York, US.

Project : SI-Analytics & Reporting Services/DSPR

iNautix Technologies India Private Limited is a group company of Bank of New York Mellon - a leading financial services provider. It provides technology development, business & technology operations and remote infrastructure management services for BNY Mellon and its subsidiaries. iNautix also develops and delivers comprehensive technology solutions and software development products for customers of BNY Mellon.

INFORMATICA

Spearheaded the automation process of manual reports with Informatica Powercenter and SAP Business Objects that were earlier prepared with Microsoft Excel and VBA macros thereby significantly reducing more than 10 hours of manual work every month.

Created performance tuned workflows that included different combination of transformations to improve data messaging and to migrate clean and consistent data.

Formulated the design and constructed the target tables(Oracle, SQL) to be populated by the workflows.

Extracted data from various sources across the organization (Oracle, SQL Server and Flat files).

Worked with SQL tools like Oracle SQL developer to validate the data loaded into the warehouse and troubleshooted data issues.

Modified and updated UNIX shell scripts for static and dynamic workflow execution.

Proficient working with Harvester and Repository Manager for promotion of workflows to higher regions.

Good understanding of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle and SQL server.

BUSINESS OBJECTS

Developed reports using the Metrics and Availability Data for the applications recorded in Daily Support Production Report(DSPR) analyzing the Business Requirement Documents (BRD) provided by the client.

Worked with Alerts, Breaks, Sections, Ranks, Cross tables, Drill down wherever necessary.

Implemented report bursting with the reports being automatically delivered to the corresponding managers.

Worked with Microsoft Powerpoint Live Office importing the report objects.

Unit tested the data underlying charts, tables etc. with custom SQL queries and validated the results.

Migrated reports and universes to higher regions from development region.

Constructed performance tuned universes with Information Design Tool (IDT).

Technical Skills

ETL Tools : Informatica PowerCenter 9.5.1

Analytical Tools : SAP Business Objects 3.1, Business Intelligence (BI) Platform 4.1, Tableau 10

Scripting Languages : UNIX

Database : Oracle 11g, SQL Server

Other Tools : Harvester, Central Management Console (CMC)

Testimonial

“ Nivedhitha recently worked for me on my Analytics & Reporting Services team. When I took the team over, more than a year ago, Nive was one of the 1st members to step up and prove herself to me. Not only was she a team player, she also had the skill- set fit for our development needs. She handed in all assignments and met all deliverables that management requested from us, and majority of the time before they were even due. We used her for things like report development, requirements gathering, ETL workflows, databases support, analytics, etc. I highly recommend Nivedhitha for any IT Positions she applies for, she has a wide variety of skills in IT and will be a great asset. She was one of the main reasons our team "Exceeded" Senior Management expectations, and why we won plenty of awards throughout the year. I was very sad to see her go, and wish her the best. Any company will be lucky to steal her away! “

- Jeff Adamski

Manager of SI - Analytics & Reporting Service Team at BNY Mellon

(A LinkedIn Recommendation)

Recognitions at work

Recognized for ‘BRAVO DRIVES AND DELIVERS EXCELLENCE – Delivering Excellence Above and Beyond Expectation’ for work on Automation and report development by Bank of New York Mellon.

Awarded with ‘BRAVO CULTIVATES A HIGH-PERFORMANCE CULTURE’ for migration of Business Objects reports by Bank of New York Mellon.

Education

Bachelor of Engineering in Computer Science and Engineering,

Bannari Amman Institute Of Technology, Affiliated to Anna University, 2014, India.



Contact this candidate