Power Bi Information Technology

Raja Rajeswari P

ETL Developer/Informatica/Power BI Mobile: 317-***-****

Email: ********.*************@*****.***

PROFESSIONAL SYNOPSIS

Over 4 years of experience in Information Technology with complete Life Cycle Implementations in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms, Operational databases, Enterprise Data Warehouses, data marts, Transformation and Loading Methodologies, Reporting Tools, OLAP tools & environments with strong analytical skills of structured methodology for reporting / BI design, specification and development.

in design and development of ETL workflows, mappings in Informatica PowerCenter

Experience in complex ETL mappings and SCD type design in Informatica PowerCenter

Experience in designing visualizations using MS POWER BI software and publishing and presenting dashboards on web and desktop platforms.

Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in E-commerce software, Utility, Health Care, Rail and Manufacturing industries.

Understanding Business Requirements Document (BRD), System Requirements Specifications (SRS), System Design Specifications (SDS) and functional requirements by working with the client, IT staff and project managers.

Extensive experience in MS Power BI technical support, troubleshooting, report design and monitoring of system usage.

Extensively worked on Enhancing the Data Model by Creating New Columns,

Hands on Experience on writing SQL Queries as part of testing the Data.

Strong Analytical & problem solving skills

PREVIEW

ETL/OLAP/BI Tools : MS Power BI, DAX, Informatica PowerCenter 9.5/10.1/10.2

Operating Systems : Windows 98, Windows2003 and Windows NT, XP, AIX, UNIX.

Scheduling tool : Control-m

Databases : Oracle 19c, 11, 10, MS SQL Server 2012/016

PROFESSIONAL EXPOSURE

Network Rail UK (Sep 2018 – Nov 2022)

Data Engineer/ETL/Reporting Developer

Network Rail is the "not for dividend" owner and operator of Britain's railway infrastructure, which includes the tracks, signals, tunnels, bridges, viaducts, level crossings and stations -- the largest of which we also manage. We aim to provide a safe, reliable, and efficient rail infrastructure for freight and passenger trains to use.

Responsibilities:

Analyzing the requirements and technical specifications by partnering with Business Analysts to develop the reports that conform to the enterprise standards.

Involved in all Agile-Scrum meetings like standup meetings, Sprint planning and Sprint review and retrospective meetings.

Backtrack analysis of attributes from Power BI tool to Informatica mappings and identifying the source fields and source systems.

Worked on Power BI reports to understand the production issues.

Created multiple reports in Power BI

Developed Power BI dashboards and reports.

Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager

Involved in Root cause analysis in source systems, creating new table structures and modifying existing tables.

Worked on Informatica variables and parameters.

Designed and developed complex mappings by using Lookup, Normalizer, Joiner, Expression, Update Strategy, Sequence generator, Aggregator, Filter, Router, SQL transformation, Sorter, etc. transformations to implement complex logics while coding a mapping.

Developed staging (Truncate & Load method), Foundation (Type2), Business Model (Type2) and Reporting Model (Type1) mappings.

Implemented relational Error Logging in Informatica

Implemented record versioning for AUDIT tables and designed the logic within Expression Transformation in Informatica mapping level.

As part of SQL remediation, oracle analytical queries are converted into Informatica mappings.

Worked on Production support and debugging data issues.

Worked on Faults, Assets, Repairs, Work orders, Failures data marks.

Deployed the code using pre setup UNIX code migration scripts with PMREP commands.

Prepared release notes documents for code migration

Developing mappings in Informatica to extract Oracle data to SQL Server

Understanding of existing Data Warehousing system and various layers

Create the plan for Deployment for testing and production.

Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager

Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager

Involved in Unit testing, debugging, and identifying the issues in Informatica mapping.

Environment: MS Power BI, Informatica PowerCenter 10.1, SQL Server 2016, Oracle 19, ER Studio, Control-m, PL/SQL Developer

Projects: Track DST, Level crossing, Ellipse upgrade, AMS production support and maintenance

Education:

I finished my Masters in Computer Applications (MCA) 2012 in Manipal university

I completed my Bachelor’s in Information Technologies (BSC IT) in 2006

Contact this candidate