LiveCareer-Resume

data analyst and report developer resume example with 7+ years of experience

JC
Jessica Claire
, , 100 Montgomery St. 10th Floor (555) 432-1000, resumesample@example.com
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
01/2021 to Current Data Analyst and Report Developer 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

04/2016 to 03/2018 ETL Developer and Tester 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.
06/2014 to 04/2016 ETL Tester 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.
09/2010 to 06/2014 ETL Developer 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
Expected in 2009 B.E | Electronics & Communication KLN College of Information Technology, Madurai, Tamilnadu, India, GPA:
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.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

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

  • B.E

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: