Jay Patel Email & Phone Number

Mumbai, MH, IN

Pune, Maharashtra, India

Austin, Texas Area

• Responsibilities –
• Responsible to work with Business Analysts to analyze requirements and translate into technical solutions.
• Key resource in designing TSDS/PEIMS reporting framework, configuration tables and run-time tables design and configuration.
• Created Joins, defined Contexts and Aliases for resolving loops in the universes. Created Derived tables and Calculated columns to implement complex business logic in the universe, which is not otherwise possible to.
• Responsible for SQL, PL/SQL performance tuning in warehouse & datamarts
• Written complex queries including Sub queries, Joins, Unions, Intersect and Aliases.

Austin, Texas Area

Kingsville

Converting WebFocus database queries into SQL queries to generate reports.

Austin, Texas Area

Information Development as well as doing some software development work related to my team.

Mumbai Area, India

• Responsibilities:
• Maintaining database for in-house Android and web application which was used for order booking, order tracking, quotation, vendors and sales information.
• Generating meaningful reports for analysis of sales and vendor information, fetching latitude and longitude of vendors and performing quantitative analysis based on geographical regions.
• Writing SQL queries to generate the reports
• Writing Procedures and triggers to automate the queries to run weekly for report generation which reduced efforts by 60%.
• Maintaining planned and unplanned schedules for 5000 users, their daily activities and tracking the data feed to the system.

Master'S Degree, Computer Science, 3.83

Bachelor Of Engineering (B.E.), Information Technology

Associate’S Degree, Information Technology, 3.5