Business Analyst Information Technology
Resume:
DEVEN J PATEL (PMI-PMP, PMI-ACP)
Palmdale, CA 93550
*****.*.*****.***@*****.***
Objective To work in the exciting field of Information Technology
Skills Summary
Over 20+ years of experience in Systems Integration, Application Development and Managing BI Applications,
Current expertise comes from experience in successfully fulfilling various roles as a Programmer Analyst, Consultant, Senior Architect, Technical/Development Lead and Business Analyst.
Knowledge of Project Management using Agile Scrum and Waterfall development methodologies.
Excellent Data Warehousing skills, Star and Snowflake Design, Data Modeling and Normalization
Proficient in Cognos BI, Sql Server, Oracle, ASP, C#.Net, VB.Net, Web Api, MVC, Entity Framework, Java, C, C++, Visual C++, Win32 SDK, JavaScript, Unix scripts, NodeJs, MongoDB
Knowledge of Salesforce, PeopleSoft, Puredata(Netezza), Azure, MySql, Sybase, Banner Systems and Developer 2000.
Experience
Los Angles Department of Water and Power
(9/2020 – Present)
Senior Programmer Analyst
Migrating the Sharepoint site from 2013 server to 2019 server and its integration with different VBA applications and tasks.
Maintaining the operations and processes related to Patch Management, Change Management, Baseline Management…etc and the applications used in managing these processes in scada network.
Migrating the Corporate Sharepoint site from 2013 server to 2016 server and integrating it with the external DocRead functionality.
Creating and maintaining Asp.Net applications for the Load Dispatchers and Engineers (Eccload, Eccweb website)
Creating Pi Asset Framework and Pi Vision Vizualizations to monitor the health of Cyber Assets in the Scada network.
Worked on the new Timesheet application using Asp.net Blazor.
Fixing and maintaining the PowerBuilder Timesheet application
Board of Public Utilities
Consultant
(3/2019 – 9/2020)
Managing the Cognos BI conversion project, Gathering requirements, providing status reports to senior management.
Creating Data Analytics environment in the organization by creating Dashboards and Analytical reports using Cognos 11, creating templates and standardizing the reporting process.
Converting Actuate Reports to Cognos and integrating them with the Cayenta ERP system.
Creating Reports and Dashboards in Tableau for the Proof of Concept project for choosing the Enterprise wide Business Intelligence Platform at BPU.
DPW – LA County
(5/2017 – 12/2018)
Consultant
Creating and updating Asp.Net Applications for the Engineering Division at Department of Public Works – Los Angeles County.
Creating and updating Cognos Framework Manager Models for use in reports by Users. Clearly defining Database, Business logic and the presentation layers and making sure that the correct data is presented in the reports.
Helping the customer with Cognos Reports migration from 8.4 to 11.
Worked on Flood Fund Budget project for managing the Budget Fiscal using ASP.Net.
Worked on conversion of DPW Infrastructure Project from VB.Net to C#.Net.
Created Dashboards for the Road Maintenance Division and Reports for the Aviation Division.
Creating models in Framework Manager using Denodo for use in Cognos.
Creating Crosstab, Master-Detail, Pageset, Repeater Table reports in Cognos.
Cognizant
(3/2017-5/2017)
Sr. Technical Architect
Worked as a Subject Matter Expert for taking over Tier 4 and Tier 5 applications from Diablo Canyon Nuclear Power Plant.
Scheduling WebEx meetings with Subject Matter Experts, Providing Minutes, Creating Application Handbooks, Application Maintenance
University of Southern California
(1/2012 – 4/2017)
Programmer Analyst IV
Maintaining $6 Billion Campaign data with Annual Fundraising of $800 million by creating Analytical Reports and Dashboard Visualizations.
Worked as a Project Leader for Creating Datawarehouse using SQL server, SSIS, Creating Functions and Stored Procedures in SQL and Oracle to Populate/Load the aggregated data into the Warehouse. Gather Requirements from different departments for their Reporting needs, Schedule the work process, Design and Development, Testing and Documentation.
Writing complex PL/SQL, T-SQL Queries, Creating and modifying reports using Cognos, Cognos Administration, Adding Disptachers and Load Balancing, Scheduling jobs, Managing User Groups and Roles, Creating DataStores, and Creating maps using Informatica.
Developed an Event Bursting application using Cognos, VBscript, Batch Files, Triggers, Sqr and PeopleSoft interface.
Worked on Salesforce implementation of our CRM system. Agile team environment with daily briefs with Operations and Technical teams. Made sure the data flow is correct and consistent from Salesforce into our Datawarehouse and into the reports.
Optimizing Queries and Performance tuning, Creating OLAP Cubes and Data Visualizations using Dashboards.
Sungard Higher Education
(8/2011 - 12/2011)
Systems Analyst 2
Creating and modifying reports using PL/SQL, Oracle and Argos, Troubleshooting, Creating and Maintaining Banner accounts, Patches, System maintenance, Processing Common Applications and Transcripts.
Texas Tech University
(6/2005 – 8/2011)
Programmer/ Analyst II
Creating and modifying Reports using Cognos Reports on Banner system; Creating packages using Framework Manager; Analyzing, designing, development and maintenance of software applications for Institutional Research and Surveys; Consulting users in the areas of data retrieval and analysis; Error message interpretation and analysis.
Developed a Student Report Generator application called MyStudents using ASP,SQL and VB.net for retrieving information from Student Information System.
Internship at High Performance Computing Center (HPCC)
Duties involve installation and maintenance of Grid networks and submitting jobs, learning about cluster computing or distributed computing architecture and creating a web interface for grid clients using java.
Orient Information Technologies
(10/2000 – 8/2001)
Software Engineer
Online inventory management and plant maintenance system using Java Server Pages, Java Web Server and Oracle 8i. Involved in designing and coding of the system.
Developed an Intranet chat server using Java and Java Web Server.
MCS Software Solutions
(1/2000 – 10/2000)
Programmer
Electronic brokering portal using XML Server, XML, Java, JavaScript, Apache Web Server and MS-SQL. Involved in designing, implementing and troubleshooting the portal.
Online foreign exchange website for TataAmex using XML Server, XML, Java, JavaScript, Apache Web Server and MS-SQL. Involved in coding and debugging the system.
Self Projects
Stock Portfolio
Created a Stock Portfolio Application using C# and MongoDB and Authentication using another Application which uses SQL Session sharing between the two applications.
Curriculum Projects
Texas Tech University
Developed a Business Intelligence project for Prosper Corporation using SQL server, BIDS, SAS EG and Excel.
Designed and developed a Food Preparation System using Systems Design and Project Management Concepts in ASP.
California State University
Consolidated a strategic plan for the use of Information Technology at California State University, San Bernardino.
NCST
Programmed Multitasking shell on Unix using C, which includes command parsing, piping, redirecting and job control. Involved in parsing stage of the project.
Engineered a TCP/IP protocol simulation. Involved in creating an Address Resolution Protocol table using C.
Built a DFD editor using C++ concepts on SDK.
Education
01/2003 – 12/2004
Texas Tech University
MS in Telecom and Network Management with GPA of 4.0, Overall GPA 3.909
Graduated on December 2004
09/2001 – 12/2002
California State University, San Bernardino
MBA in Information Management with a GPA of 3.857
Graduated on June 2003.
Certifications
Project Management Professional (PMP) Certification from Project
Management Institute (PMI)
Agile Certified Practitioner (ACP) Certification from Project
Management Institute (PMI)
Contact this candidate