Jiten Patel Email and Phone Number

Quality of service for Network Operations. Network performance data analytics.

Project Details: Tracking operational performance and measure impact and success of projects across all functional groups within Infrastructure Engineering. Consolidating and reporting financial and operational updates for all Infrastructure Engineering projects. Analyzing data, trends or obstacles, identifying root cause and considering available solutions or alternative methods of proceeding.• Worked closely with executives to understand and address their reporting needs.• Preparing and presenting insights to the executives using various business intelligence tools including Tableau and Microstrategy.• Consolidating data from multiple data sources and setup ETL processes. • Automate the existing manual processes to boost productivity, streamline work and reduce errors.

• Worked with Business Intelligent tools like Alteryx, Tableau and Micro strategy, delivering business insights and reports to executives and management teams. • Worked on Oracle, Netezza, Redshift and Hadoop data warehouses.• Performed Data Analysis and Data profiling by writing queries against the database. • Gathered business and system functional requirements, prepared Business Requirement Specification and System Requirement Specification documents. • Facilitated meetings with business users, operational users and management to get their requirements and clarify issues. • Work with Product Development Departments to define reporting requirements, development timelines, and see the project through to completion.• Impact analysis to determine that new requirements can fit into the existing architecture.• Created a test approach document that was used as a baseline while testing and generated test cases in accordance to the Test Approach Document. • Identified and clearly defined functional issues and supported IT development staff throughout the design, development and testing efforts. • Working with subject matter experts or Business Owners to identify and document data elements from sources and determine methodology to support the specified reporting needs.

• Created Test Cases and coordinated with offshore QA team to automate the testing of the business scenarios.• Created process flow and system landscape diagrams using MS Visio for Level 1 TUT Projects.• Performed Gap Analysis between AS-IS and TO-BE business process, which involved requirement gathering from Director and VP of QA. Designed Project Management, collaboration, reporting and monitoring solutions to achieve best possible business process using SharePoint and Excel. All these implementations increased efficiency, improved productivity and management control, facilitated centralized access to information and simplified team working and knowledge sharing.• Developed and implemented Project Management tool in SharePoint for Manual QA team. This involved requirement gathering of QA projects, analyzing the current process, and implementing a solution to improve project management. This tool facilitated project status tracking, resource tracking, and better reporting.• Designed a dashboard using Pivot to display performance related problems in script timings, enabling users to take appropriate actions based on the KPIs. The data was extracted from multiple SharePoint sites in order to generate the dashboard.• Created SQL queries and PERL scripts to pull weekly data of active databases owned by QA. • Designed an Excel and SharePoint solution that analyzes and tracks the database information, allowing QA team to use the database resource sparingly, resulting in cost saving in hardware resources.• Executed database upgrades on client databases; determined SQL procedures that faced upgrade issues; communicated the findings to developers for issue resolution.• Performed DDL and DML database tasks involving table creation, alteration, index creation, data manipulation and SQL procedure analysis.

• Implemented Project management solution and incorporated it with the supply chain process.• Involved in all phases of implementation of NICC process (New Item Creation and Completion), including requirements gathering, design, development, testing, deployment and training.• Conducted JAD workshops with Business Users to understand their requirements and draw specifications about the NICC process. The JAD sessions facilitated better understanding of user requirement and reduced implementation time of the application.• Created UML documents for NICC 2.0 development, which were shared with various development vendors as requirement documents. • Performed data analysis of historical sales, seasonality and penetration for forecasting sales. Issued inventory optimization reports to minimize obsolescence and maximize profitability.

- Assisted Webmaster in tasks such as creating and Editing WebPages.- Research of new technology known as EXT JS.- Created Reports using Mail Merge, SharePoint and Excel.- SharePoint design and development.

Campus Safety

• Supported time critical ETL processes for a Business Intelligence analytical tool developed by Deutsche Bank.• Existing data from diverse data sources were consolidated in an Oracle environment. Data loads were performed using PERL and Bash scripts, data transformation and user interface was developed using java codes. • Troubleshooting of ETL process, which involved debugging PERL/Bash scripts and database procedures.• Solicited requirements from Business Users for developing custom reports and coordinated the implementation of reports with the application development group.• Performed ad-hoc analysis, using historical trade data, to generate performance reports for traders and management.• Interacted with data providers such as Bloomberg, Reuters and Fidessa for data correction and trade mismatch.• Performed ad-hoc SQL queries when access to data was required from the databases. • Led the team of four, motivated team members to learn the business and new technologies; which resulted in increased work efficiency and improved the quality of reports provided to the clients.• Learned about the equity trading market, analyzed the trade data according to client, trader, stock, and sector classification, and prepared reports using excel and database tools.• Performed VWAP, Profit and Loss and TCA Calculation for high volume trades.• Developed monitoring using ITRS’s GENEOS, writing PERL & shell script and PL/SQL procedures.