Vinit Kothari Ph. No: +91-905*******
HYDERABAD Email id: ac0jcp@r.postjobfree.com
PROFILE SUMMARY:
4+ years of onsite/offshore experience as a technical lead in Business Intelligence, ETL and data warehousing projects.
Hands-on experience with various tools like Tableau Desktop/Server, Informatica powercenter, OBIEE, Tidal.
Possesses good written and verbal communication skills.
Highly motivated with an enthusiasm to learn, fast-learner, resourceful, committed, hard-worker.
COMPETENCIES:
Category
Primary Skills
Secondary Skills
Domains
Business Intelligence, ETL, Data Warehouse
ERP
Programming Languages
SQL, PL/SQL
Unix
Tools & Techniques
Tableau Desktop / Server, Informatica Powercenter, OBIEE 11g
Tidal Enterprise Scheduler, BiApps, DAC
Databases
Oracle 10/11g/12c
MYSQL
Operating Systems
Windows XP/7/10
Linux
EXPERIENCE SUMMARY:
Category
Description
No of Projects
Role / Lifecycle
Team Lead / Application Development, implementation and Maintenance
2
EMPLOYMENT HISTORY:
Employer
From
To
Designation
Area
Zensar
Jan 13
Oct 14
Software Engineer
Business Intelligence
Wipro
Oct 14
Till Date
Project Engineer
Business Intelligence
ACADEMIC PROFILE:
Degree/Certification/Publication
Percentage
Year of Passing
B. Tech (Information technology),
JNTU Hyderabad, A.P
78%
2012
Board of Intermediate – A.P
95 %
2008
SSC – A.P
87 %
2006
PROFESSIONAL EXPERIENCE:
Project 1:
Project / Client Name / Location:
Business Intelligence / Electronic Arts / Guildford
Technologies:
Tableau Desktop and Server / Informatica Powercenter / SQL and Pl/SQL / BiApps / DAC /
Tidal Enterprise Scheduler
Project Profile:
Electronic Arts is a gaming company project. The revenue, invoice, shipping details etc. are maintained in the data warehouse and data mart. This is an Application development, enhancement, maintenance and support project, where the reports are developed, generated and data loads are scheduled on a daily basis and then loaded to the data warehouse and data mart. Sales and Finance reports are generated on top of the data mart which is used by the customer.
Role: Technical & Project Lead / Onsite Coordinator / Developer / Team Lead
Responsibilities:
As a team lead in this project,
Develop production ready Tableau worksheets/dashboards from heterogeneous data sources using data Blending, joins, publishing customized interactive reports, report scheduling using Tableau server.
Create action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Restrict data for particular users using Row level security and User filters.
Experienced in Dimensional Modeling, Fact & Dimensional Tables, Star and Snow Flake Schema.
Extensively worked on data extraction, Transformations involving complex logic and loading data from various sources like Oracle database, SQL Server and Flat files, deploy code from test to production environment
Analyze requirements and designs solutions for projects and change requests.
Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
Develop test plans to verify logic of new or modified programs.
Worked independently with minimum guidance, Perform code reviews for other team members.
Ticketing system, which involves creating the tickets, handling issues and closure of ticket on providing the resolution, timely response to teams in the upstream, downstream applications and customer.
Ensure the smooth operation of data loads and reports in order to provide maximum performance and availability for users.
Handled complex situations, aggressive customers and difficult situations.
Maintain detailed documentation throughout the project.
Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance.
Work with business team and other software developers in completing software development and enhancement tasks.
Contribution / Highlights:
Got an excellent opportunity to work from Client location in Guildford (UK) as well as offshore Client location (Hyderabad)
Using complex LOD expressions, Window functions in Tableau to develop solve user critical and build smart reports.
Preparation of High Level & Low Level Design documents.
Development of code as per the business requirements, ensure code is compliant with best practices, standards, and enterprise architecture.
Unit testing of the developed code.
Providing fixes to the issues identified in testing phase.
Packaging of the developed component to be deployed in production environment.
Performing code reviews.
Been a part of SIT, UAT.
Received many Outstanding Performer Award from the client.
Project 2:
Project / Client Name / Location:
Business Intelligence / Electronic Arts / Redwood Shores
Technologies:
OBIEE / Informatica Powercenter / SQL and Pl/SQL / Tidal Enterprise Scheduler
Responsibilities:
As a team member in this project,
Create dashboard prompts and advanced filter criteria in OBIEE, many ad-hoc reports to support various needs of business.
Involved in different types of testing such as unit testing, regression testing of existing reports and Informatica mappings.
Back tracing of data from target to source in case of issues and implementing the required changes in the mappings.
Have good exposure in debugging complex mappings, mapplets, sessions and workflows.
Worked and understood complex Source Qualifier queries, Pre and Post SQL queries in the target.
Experienced in upgradation and migration of OBIEE reports between dev/test/prod environments.
Created OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
Creates appropriate technical documentation.
Shares knowledge within a dynamic team.
PERSONAL DETAILS:
Name : Vinit Kothari
Nationality : Indian
Gender : Male
Date of Birth : 24 September 1990
Languages Known : English, Hindi, Marathi and Telugu.
DECLARATION:
I hereby declare that the information provided above is true to the best of my knowledge.
Place: Hyderabad
Date: Name: Vinit Kothari