SEARCH

Data Analyst and Report Developer Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
DATA ANALYST AND REPORT DEVELOPER
Professional Summary
  • Having overall 7.5 Years of Experience in Designing, Managing, Developing and implementing various Business Intelligence (Data Warehouse) applications.
  • Good expertise in using Informatica 8.1.0 & 9.1.0, Cognos reporting tool.
  • Strong exposure to Data warehousing concepts.
  • Extensive in reviews for Technical Requirements, Impact Analysis, application Design and code walkthroughs.
  • Proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
  • Motivated achiever who guides organizations in applying technology to business settings, provides added value, and creates project deliverables in a timely manner.
  • Good communication and interpersonal skills.
Skills
  • Informatica Power Center 8.1.0, 9.1.0
  • Cognos 8.4 Reporting tool
  • Windows XP, Windows 8, UNIX
  • Oracle 9i, 10g, Sql server
  • SQL and PL/SQL
Work History
Data Analyst and Report Developer | 01/2021 to Current
Company Name - City, State, India

· Responsible for Business Analysis and Requirements Collection with banking customers.

· Understand the data of various Finzly products and its relationship

· Extract transform and create sophisticated business intelligence reports using the data in SwapsTech products to meet the requirements.

· Support, troubleshoot and maintain reports from SwapsTech systems

· Participate in daily scrum meetings and provide timely updates of the project

· Lead and guide a team of junior developers and analysts

· Write and maintain documentation for all features in development

· Support a culture of forward and innovative thinking; be curious and looking for new problems to solve

ETL Developer and Tester | 04/2016 to 03/2018
Company Name - City, State, India
  • Responsible for Business Analysis and Requirements Collection.
  • Design, development, Unit Testing and Extract transform Load (ETL) software components using Informatica Power Center.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Responsible for monitoring client Production jobs using UC4 tool.
  • Handling the failure jobs and monitoring without any issues.
  • Supporting outages for restarting client servers.
  • Created various transformations in designing the mapping like aggregator, expression, update strategy, router, expression, stored procedure and look up transformation.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Coordinating the project activities with onsite.
  • Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL
  • Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
ETL Tester | 06/2014 to 04/2016
Company Name - City, State, U.S.A
  • Involved in requirement gathering and converting business system design to High Level and Low Level technical system designs.
  • Developing the ETL codes based on the Technical mapping Specification Document.
  • Performing the Unit Testing of ETL mappings and creating Unit test cases and Unit test results.
  • Responsible for monitoring client's Production jobs.
  • Used Debugger to test the mappings and fixed the bugs.
  • Coordinating the project activities with onsite., Requirement gathering, design, coding and unit testing.
  • ETL Specification Documents preparation at all stages in the project.
  • Performing the Unit Testing of ETL mappings and confirming the code developed as per the business requirement.
  • Responsible for Defect Fixing, Regression Testing.
  • Involved in Enhancements and creating of new reports as per the end user requirement.
  • Responsible for creating the unit test cases and deploying the same into the HPQC.
  • Creating the Change Request.
  • Directly interacted with clients and understood business domain, developed reports as per requirement.
  • Page 2 of 4.
ETL Developer | 09/2010 to 06/2014
Company Name - City, State, U.S.A
  • Requirement gathering, design, coding and unit testing.
  • ETL Specification Documents preparation at all stages in the project. · Created various transformations in designing the mapping like aggregator, expression, update strategy, router, expression, stored procedure and look up transformation in Informatica Powercenter
  • Data from the Sources (Oracle database) will be loaded using Informatica into Teradata Tables (Data warehouse) after applying Business rules
  • Responsible for Defect Fixing, Regression Testing.
  • Involved in Enhancements and creating of new reports as per the end user requirement. Responsible for creating the unit test cases and deploying the same.
  • Creating the Change Request.
  • Directly interacted with clients and understood business domain, developed reports as per requirement.
Education
KLN College of Information Technology - City | B.EElectronics & Communication, 2009
Additional Information
  • To work for a well-reputed organization where I can constantly enhance my technical skills, grow and lead to the growth of the organization. A growth oriented challenging position in the field of Data warehousing where I can provide and share my experience and the best practices of DWH followed in the industry to implement innovative and cost effective solutions with remarkable quality of delivery and to meet the needs of the organization by being motivated, motivating the team and providing leadership.
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • KLN College of Information Technology

Job Titles Held:

  • Data Analyst and Report Developer
  • ETL Developer and Tester
  • ETL Tester
  • ETL Developer

Degrees

  • KLN College of Information Technology - City | B.E

Similar Resumes

View All
Senior-Data-Analyst-and-Report-Developer-Reporter-Developer-resume-sample

Senior Data Analyst and Report Developer Reporter Developer

Miami, Florida