Summary
Overview
Work History
Education
Skills
Work Availability
Timeline

Vinay Jain

Technology Analyst
Pune,MH

Summary

Working with Infosys Limited from Jan 2018 - Present

● Over 3.7 years of dynamic career experience in BI technologies as an ETL and Reporting application developer.

● Expertise in complete life cycle development process of a reporting solution that involved gathering business requirements, analyzing business needs, documenting business information

● Strong development skills with Power BI, Tibco Spotfire, Informatica PowerCenter, Oracle.

● Experience in Designing, Developing, Documenting and Testing of Informatica ETL jobs to populate the data in Data Warehouse and Data marts and Extensive experience in troubleshooting of Informatica jobs, and performance tuning.

● Experience in Erwin’s AnalytiX DS Metadata Management and Data Governance solutions tool.

● Good work exposure in Agile Scrum Methodology.

● Experience in working closely with client side business analysts to understand business requirements and translating those requirements into technical solutions.

● Strong analytical skills, proven ability to work well in a multi-disciplined team environment, quickly learn and getting trained in new technologies and work on it.

Overview

1
1
Language
6
6
years of post-secondary education
3
3
years of professional experience

Work History

Reporting Developer

Infosys Limited
Pune, MH
07.2020 - Current
  • Project : Site Profile.
  • Client : Pfizer Inc
  • Tools : Power BI, Amazon Redshift DB
  • Tool that leverages known information about investigators and facilities through use of Shared Investigators Platform and historical Pfizer data captured in Supplement.
  • Responsibility: Analyzes data to determine its accuracy according to business needs and fix any inaccurate data.
  • Develop and deploy dashboards, visualizations and autonomous and dynamic reports using Power BI.
  • Strong SQL experience with ability to write SQL statements over complex database structures.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Identified issues, analyzed information and provided solutions to problems.

ETL & Reporting Developer

Infosys Limited
Pune, MH
01.2018 - 06.2020
  • Project : Medical Data Cloud
  • Client : Pfizer Inc
  • Tools : Informatica PowerCenter, TIBCO Spotfire, Oracle
  • MDC application is data-hub to integrate source systems and address consumers and reporting needs for regulatory and compliance organizations across Regulatory, Clinical and Safety domains of Pfizer.
  • Responsibility: Actively supported business users for changes in reports as and when required using Spotfire.
  • Gathered, organized, validated and distributed extract data files required by business users.
  • Good at DataSource setup on development server machine to make all sources available for reporting purpose.
  • Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use.
  • Developed Spotfire Dashboards / Reports Using Action Control, Property Control to navigate from one page to another page and also to access data dynamically.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Joiner, Router, Sorter and Union.
  • Developed Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored results using workflow monitor.

Education

Bachler of Engineering - Information Technology

Sinhgad Academy of Engineering, Pune
07.2014 - 07.2017

First Class with Distinction

Diploma - Computer Engineering

Government Polytechnic, Pune
07.2011 - 07.2014

First Class with Distinction

Skills

    Reporting Tools : Power BI, Tibco Spotfire, Tableau

undefined

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Reporting Developer - Infosys Limited
07.2020 - Current
ETL & Reporting Developer - Infosys Limited
01.2018 - 06.2020
Sinhgad Academy of Engineering - Bachler of Engineering, Information Technology
07.2014 - 07.2017
Government Polytechnic - Diploma, Computer Engineering
07.2011 - 07.2014

Similar Profiles

CREATE PROFILE
Vinay JainTechnology Analyst