close
  • Dashboard
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Customer Service
      • Education
      • Sales
      • Manager
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Microsoft Word
      • Professional
      • Modern
      • Traditional
      • Creative
      • View All
    • Resume Services
    • Resume Formats
      • Resume Formats
      • Chronological
      • Functional
      • Combination
    • Resume Review
    • How to Write a Resume
      • How to Write a Resume
      • Summary
      • Experience
      • Education
      • Skills
        • Skills
        • Hard Skills
        • Soft Skills
    • Resume Objectives
  • CV
    • CV
    • CV Examples
    • CV Formats
    • CV Templates
    • How to Write a CV
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Customer Service
      • Marketing
      • Sales
      • Education
      • Accounting
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Questions
  • Resources
  • About
    • About
    • Reviews
  • Contact
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Data Analyst and Report Developer
Please provide a type of job or location to search!
SEARCH

Data Analyst and Report Developer Resume Example

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
  • SQLand PL/SQL
Work History
Data Analyst and Report Developer | 01/2021 to Current
Cognizant Technology Solutions - Hillsborough , NJ, 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
Jpmorgan Chase & Co. - Warrington , PA, 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
Cognizant Technologies Solutions - 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
Igate Global Solutions - 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.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

86Good
Resume Strength
  • Completeness
  • Formatting
  • Word choice
  • Measurable results
  • Strong summary
  • Clear contact info
  • Typos

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

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Sr.-Data-Analyst-&-Report-Developer-resume-sample

Sr. Data Analyst & Report Developer

Cognizant Technology Solutions

Framingham , MA

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

Senior Data Analyst and Report Developer Reporter Developer

Cam Services

San Diego , CA

Tableau-Report--Developer/Business-Analyst-resume-sample

Tableau Report Developer/Business Analyst

Wells Fargo

City , STATE

  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Work Here
  • Contact Us
  • FAQs
  • Accessibility
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2022, Bold Limited. All rights reserved.