Candidate Information Name Available: Register for Free Title Power Bi Information Technology Target Location US-IN-Noblesville Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Duke Energy Power Generating Plainfield, IN Sql Server Power Bi Indianapolis, IN Information Technology Intern Indianapolis, IN Sap Business Power Bi Indianapolis, IN Information Security Vulnerability Management Avon, IN Data Analyst Power Bi Indianapolis, IN Quality Assurance Information Systems Brownsburg, IN

Raja Rajeswari PETL Developer/Informatica/Power BI Mobile: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEPROFESSIONAL SYNOPSISOver 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 PowerCenterExperience in complex ETL mappings and SCD type design in Informatica PowerCenterExperience 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 skillsPREVIEWETL/OLAP/BI Tools : MS Power BI, DAX, Informatica PowerCenter 9.5/10.1/10.2Operating Systems : Windows 98, Windows2003 and Windows NT, XP, AIX, UNIX.Scheduling tool : Control-mDatabases : Oracle 19c, 11, 10, MS SQL Server 2012/016PROFESSIONAL EXPOSURENetwork Rail UK (Sep 2018  Nov 2022)Data Engineer/ETL/Reporting DeveloperNetwork 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 BIDeveloped Power BI dashboards and reports.Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository ManagerInvolved 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 InformaticaImplemented 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 migrationDeveloping mappings in Informatica to extract Oracle data to SQL ServerUnderstanding of existing Data Warehousing system and various layersCreate the plan for Deployment for testing and production.Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository ManagerDeveloped Informatica Workflows and sessions associated with the mappings using Workflow ManagerInvolved 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 DeveloperProjects: Track DST, Level crossing, Ellipse upgrade, AMS production support and maintenanceEducation:I finished my Masters in Computer Applications (MCA) 2012 in Manipal universityI completed my Bachelors in Information Technologies (BSC IT) in 2006