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 implement in the universe using joins and contexts.• Responsible for SQL, PL/SQL performance tuning in warehouse & datamarts• Written complex queries including Sub queries, Joins, Unions, Intersect and Aliases.• Developed complex reports for data analysis using drill down, filters, dynamic cascading prompts, LOVs, custom hierarchy’s.• Developed well-formatted reports involving cross tab, sub-reports, table/section breaks, summary and running totals using Crystal Reports for Enterprise.• Extensively involved in using formula fields, created custom functions that were promoted to the repository to be used in multiple reports using Crystal Reports for Enterprise/Crystal Reports 2013.• Converted crystal reports with universe as a data source to use tables/views and/or stored procedures by using Crystal Reports for Enterprise. • Created complex PL/SQL stored procedures to drive complex PEIMS, ECDS and UID reports spanning thousands of pages and complex calculations.• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.• Involved in fine tuning the queries for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.• Working with an Agile (Scrum) methodology to ensure delivery of high quality code.• Working in an Agile process environment.• Documenting technical documents related to any new enhancement in the application and make sure they are maintained.

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. • Providing technical support to the end users (5000 users). • Testing the Android and web application and interacting with the developer to report bugs identified during testing

Master'S Degree, Computer Science, 3.83

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

Associate’S Degree, Information Technology, 3.5