Data Analyst Power Bi

Summary

Highly skilled and results-driven Data Analyst with over 6 years of experience in data

transformation, ETL development Informatica power center 10.5.2,10.4.1, 9.6.1 and Microsoft SSIS, and reporting using Power BI and Tableau.

Design and Implemented ETL workflow in IICS to process and transform large datasets from multiple cloud and on-prem sources.

Hands-on experience in dealing with Microsoft SQL, DB2 and Oracle Database servers on developing queries to extract the data and developing and maintaining the stored procedures.

Hands-on experience in extracting and transforming raw data from files, MQ, Database to JSON files and Payload.

Implemented a solution for API vendor integration using Informatica power center and 10.4.1.

Hands on experience in integrating API with HTTP(S) and OAuth Integration using Informatica power center and 10.4.1.

Integrated IICS with REST and SOAP APIs seamless data exchange between applications and external services

Designed and developed ETL workflows and data pipelines using Azure Data Factory to automate data extraction, transformation, and loading processes.

Integrated Azure Data Factory with Databricks to process large datasets. Prepared various key documents including ETL Specifications, Data Mapping documents, Test Cases, and Test Results to ensure clear and accurate communication of project requirements and outcomes.

Implemented a Java Transformation on extracting JSON files and looping through the data and transforming to flat files and Database.

Hands on creating report and Dashboard using Power BI and Tableau

Worked in the full development life cycle of developing and deploying ETL programs for supporting data extraction and data cleansing via Informatica power center to deliver compelling business value for clients.

Experienced in troubleshooting Informatica jobs, enhancement of jobs, and addressing production issues like performance tuning and enhancement.

Hands-on Experience in Performance tuning, Optimization in Informatica and Databases.

Hands-on experience in the reconciliation process and audit tables.

Experience in handling larger Teradata database queries and applying transformations to make the business solution applicable to the project.

Expertise in relational databases, data management, cloud technologies, and data visualization tools such as Tableau and Power BI.

Experienced in the UNIX work environment, file transfers, job scheduling, and error handling. Worked extensively in design and analysis of Requirements, Development, testing, and Shajidha Mohamed – Technology Analyst (ETL Developer) Contact No: 913-***-**** Current Location: Dallas-Texas Email id: ********.******@*****.***

deployment.

Prepared various types of documents like ETL specification, Data Mapping, Test cases, Test Results, etc.

Developed Data Integration tasks, mappings, and Task flows to automate data movement across salesforce, AWS S3 and Oracle

Proven ability to collaborate with cross-functional teams to deliver innovative, data-driven solutions that drive business growth and efficiency.

Key Domain and Technical Knowledge

• Domain : Transportation (Freight), Banking, Healthcare

• Technical : Informatica Power Center 10.4.1 and 10.5.2, Oracle, SQL Server, Db2, SSIS,UNIX, Teradata, IDQ, Informatica Intelligence Cloud Service, UNIX Shell Scripting, Power Center Repository Management, MS-Excel, MS-Access, PL/SQL, Java, Tableau, DBeaver, TOAD, Control-M, Autosys,WinSCP, Putty, Zena, Service Now, GitHub, Jira, Postman, SOAP UI, Junit, Amazon webservices -EC2

• Training : Informatica Cloud (IICS), GCP services, Tableau Academic Qualification

• Bachelor of Engineering in Electrical and Electronics Engineering from Madurai Kamaraj University, Madurai, Tamil Nadu, India.

Foreign Languages known:

• Arabic

Professional Experience:

Sr.ETL Developer/Onsite Coordinator Feb’23 – Till Date Transportation (Freight)/Infosys Technologies Pvt Ltd Dallas Fort Worth, TX One of North America’s leading freight transportation companies, operating a rail network of 32,500 route miles in 28 states and three Canadian provinces. They are one of the top transporters of the Industrial products like coals, petroleum, etc. throughout America and the world. They move those goods more safely and efficiently, on significantly less fuel, with fewer emissions than the all-highway alternative. Software Development Life Cycle

Played a key role in requirement gathering and creating a mapping document between the source and target.

Involved in meeting with owners of key systems to understand data and systems.

Involved in the project estimation and scheduling.

Collaborated with business stakeholders to define and understand reporting requirements, developing and configuring data models and analytics solutions.

Provided a weekly update of project to stakeholders.

Co-ordinated and handled the offshore team.

Involved in gathering the source data structure requirements and developing the mapping and flow documents for Price Authority Application and synchronizing with different sources like Mainframe, Sales force.

Involved in the Solution Design of converting the on-premises Data source to Vendor based Cloud Solution

Provided Knowledge Transfer to the end-users and operations team and assisted in developing run book.

Data Integration and Transformation

Developed Informatica workflows, mappings, and transformations. implementation of ETL processes to extract, transform, and load large volumes of data from multiple sources into the data warehouse.

Developed a custom Java Transformation for parsing the JSON Payload

Integrated the Informatica power center with their vendor API Solution using OAUTH and HTTP (S)

Analyze source system for pricing Application and cleansing the data before loading into Target system.

Using Informatica Power Center tool extracted data from multiple sources (Flat Files, DB2 and MQ), transform the data according to business logic, and load the transformed data into a JSON REST API to vendor Database Targets

Developed Informatica workflows, Custom Java transformation, HTTP(S) transformation, mappings, and transformations through Informatica power center.

Created automated dashboards and reports in Tableau and Power BI, providing business units with actionable insights to improve operational decision-making.

Performed data validation, QA testing, and root cause analysis to ensure the accuracy of data loads, resolving discrepancies and aligning data outputs with business logic.

Integrated the Informatica mapping through HTTP(S) and OAUTH

Developed and deployed complex data transformations using SQL, Java for ETL processes, increasing data processing efficiency by 25%.

Integrated IICS with REST and SOAP APIs from a vendor Applicatiion and seamless data exchange to Azure Cloud

ETL Management

Defined a custom Java Transformation for JSON Parser in Informatica Power center.

Defined webservice invoker for built in SOAP webservice in Informatica Power center.

Defined and used MQ Connection to GET and PUT messages in the workflow.

Extracting, Scrubbing, and Transforming data from Flat files, Database and then loading it into vendor system through REST API.

Worked on optimizing ETL procedures in Informatica.

Performance tuning of the Informatica mappings using various components like Parameter files, Variables, and Dynamic Cache.

Reduce data processing time by 20% through performance optimization in IICS workflow Testing and Troubleshooting

Developed test plans and test scripts to administer unit and Integration testing and created SQL/Unix shell scripts.

Performed validation for transaction records and initiated corrective action to resolve data anomalies.

Tracked and triaged the production Incidents through service Now.

Handled the Change request process through Service Now

Compared the Price Authority Sync back data in unit and QA testing process using various functions in Excel and determine the improper data and mapping logic bugs. Business Intelligence/DB-ETL Developer Dec’21 – Jan’23 Health Care/Infosys Technologies Pvt Ltd Richardson, TX One of the leading health care solution companies that delivers care like no one else can. They help people navigate the health care system and their personal health care by improving access, lowering coset and being trusted partners.

Software Development Life Cycle

Played a key role in requirement gathering and creating a mapping document between the source and target.

Involved in meeting with owners of key systems to understand data and systems.

Involved in gathering the source data structure requirements and developing the mapping and flow documents for Invoices and Rebates data source.

Provided Knowledge Transfer to the end-users and operations team and assisted in developing run book.

Data Integration and Transformation

Developed Informatica workflows, mappings/maplets and transformations.

Developed and optimized data pipelines using MS SQL Server and IBM DB2, ensuring efficient data extraction, transformation, and loading.

Created ad-hoc reports and visualizations in Power BI, allowing business users to track key performance indicators and make informed decisions.

Developed View and Tables using the PL SQL functions, and DDL Scripts

Analyze source system for Rebates and Invoices data and cleansing the data before loading into Target system.

Using Informatica Power Center tool extracted data from multiple sources (Flat Files, DB2 and SAP), transform the data according to business logic, and load the transformed data into a DB2 Database Targets to target 3 different lines of business for Analyst, Managers and Executive

Developed Informatica workflows, mappings/maplets and transformations through Informatica power center.

ETL Management

Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate, and Summary facts.

Scheduling of Jobs by using Control-M and AutoSys Scheduler.

Extracting, Scrubbing, and Transforming data from DB2, and then loading it into DB2 database using Informatica.

Worked on optimizing the ETL procedures in Informatica.

Performance tuning of the Informatica mappings using various components like Parameter files, Variables, and Dynamic Cache.

Configured incremental aggregator transformation functions to improve the performance of data loading. Worked on Database level tuning and OLTP Databases.

Developed UNIX Shell scripts for calling the Informatica mappings and running the tasks daily.

Conducted data analysis to support business reporting and process improvement initiatives, providing valuable insights to senior leadership.

Testing and Troubleshooting

Developed test plans and test scripts to administer unit and Integration testing and created SQL/Unix shell scripts.

Performed validation for transaction records and initiated corrective action to resolve data anomalies.

Tracked and triaged the production Incidents through service Now.

Assisted in designing and executing QA test plans to validate the accuracy and integrity of data and reports, identifying areas for improvement in ETL processes. Informatica Developer Jun’20 – Dec’21

Insurance Industry/Consultant Hartford,CT

One of the leading insurance provider for Auto, Commercial Property causality insurance and personal insurance through independent agents. It has different lines of business (LOB) like Agency, Certified Business, Bond, Claim, E-Business.

Informatica Developer Mar’19 – Jun’20

Health Care Industry/Consultant Cypress,CA

One of the leading HealthCare providers, which providers the HealthCare Products in United States. Through its wholly owned subsidiaries and unconsolidated strategic investments, the company offers HealthCare and Insurance products. PacifiCare is the one of largest private HealthCare Company in United States.

Contact this candidate