Data Analyst Manager

Ketan Patel

Rancho Cordova, CA l Phone: 626-***-**** l Email: adfyjk@r.postjobfree.com

Objective

IT Exposer with rapidly learn new technology, equally effective in both team and self-directed settings and capable in a range of computer systems, languages, tools and testing tactics.

Extensive understanding of Business Requirement elicitation, BRD, FRD and all facets of the Business Analysis Life Cycle.

Project Planning Experience– capable of planning and managing analytical components of projects to ensure deadlines are met.

Strong knowledge of installing, configuring, tuning, maintaining and monitoring Windows Server 2008/2012 Enterprise server

Strong knowledge of Remote server administration

Strong knowledge of SQL, data visualization and analysis with the help of different reporting tools.

Strong knowledge of websites using WordPress and specialized plugins for SEO and Customized WordPress installations using Dreamweaver, tracked campaign results using Google Analytics and Stat Counter.

Strong Coding of custom Word press theme and template files using HTML, CSS, Java Script PHP, and Bootstrap 3 framework, Strong knowledge of network engineering and Virtual Machine

Acquired experience in working for different modules such as SAP FICO (Finance Controlling), SAPPP (Production Planning), SAP MM (Materials Management), etc.

Skilled at operating SAP FICO, SAP MM, SAP PP as required for the organization

Experience with a BI solution and Reporting/analyses tool (e.g. OBIEE, SSRS, QlikView, Tableau)

Hands-on practical experience Network Engineer with experience in Network Security and troubleshooting LAN and WAN issues

Certification

Microsoft certified in Database and Network

Couchbase (Date Science: Data Modeling, NoSQL, and Data Management)

Skills

Languages: HTML, CSS, Java, JavaScript, PHP, SQL, PL/SQL

Oracle Tools: Relational Databases, HDFS. OBIEE 11g/10g/12c, BI Publisher, Forms Report Righter11g, ODI.

Server and Tools: Windows Server 2008/2012/2016, SCCM, VMWare, Tableau, Toad, MS Project, MS Visio, MS Office, Microsoft AZURE,SAP, Spark(Data bricks),WORDPRESS

Education

California State University, Los Angeles, CA M.S. in Computer Information Systems (2016)

Charusat University, Changa, Gujarat, India B.S. in Information Technology.(2014)

Experience

Client: Accenture (Google) –State of California, Rancho Cordova, CA Feb’18-Till Date

Role: System Admin/ Report Developer

Managing over 100+ VMware servers 2003, 2008, R2 and 2012 with VSphere client 5.1 and managing VPN users and Active Directory by resetting passwords, unlocking accounts, adding users, and GP.

Configuring AD on Windows 2012 Server

Managed Microsoft Patch Tuesday's testing, deployment, and reporting through SCCM resulting in a 95% success rate.

Perform analysis of organizational capacity and performance management.

Performs regular system maintenance, backups, hardware upgrades, software upgrades, performance tuning and physical to virtual migrations.

Manage and implementation of provisioning storage resources

Root Cause Analysis and Problem Management for organizational Identity Management environment.

Push Information Assurance Vulnerability Alert using SCCM to the machines which are non-compliant systems.

Develop, implement and manage existing monthly agency operating reports to assist the management team with resource planning and overall agency portfolio management.

Deliver analysis using standard operating reports for creative development and approval activities by gathering data, working with data in spreadsheets and identifying and researching anomalies. This includes performing ongoing QA analysis and communicate findings to the leadership team.

Coordinated with BA group for better understanding of functional requirements analyzed and designed the business requirements to documented and implemented.

Install, upgrade and configure all components of OBIEE 12c in all dev server for developer

Worked on OBIEE Repository to create Facts and Dimensions and different Subject areas as per the requirements from Finance and Revenue reporting management. And deployed the .rpd by using Oracle Enterprise manager.

Experience working with Hyperion workspace to view the existing IR and WA reports

Designed and developed reports using Oracle BI Answers and BI Publisher using the data from different data sources.

Created repository Variables, Level based measures and Dimension Hierarchies and worked on OBIA Financial analytics to generate reports and Dashboards.

Worked with OBIEE Analysis, Intelligence Dashboards and various functionalities like Prompts, Views, global filters, scheduling, guided navigation, conditional formatting, and complex union reports.

Worked on Web logic console to create users and define security.

Consolidating with Business users for report requirements, migrating reports from Hyperion to OBIEE, report testing and development.

Actively supported and trained Users for their regular reporting needs, closed the tickets within the schedule. Received appreciation from Manager and Business users for recreating reports.

Created presentations, Reference guides and FAQ’s for end users.

Designed and developed BI- Publisher Reports Layouts using BI-Publisher Desktop using sample Xml data source & Answers request as data source and Deployed on to the BIP server.

Worked closely with Oracle support and also worked on applying patches to OBIEE 11g environment suggested by oracle after identifying the bugs.

Implemented BI Publisher Bursting for scheduling the reports to deliver based on user email and share folder.

Devised strategy for refreshing report query by both purging and seeding cache

Scheduled the OBIEE analysis using BI delivers and setting up Agents to run reports on schedule.

Created CR in Changed Management Report tool for any movement in Prod Instance.

Created the High Level Design Document (HLD) and Technical detailed design document (TDD) of Repository and Web Catalog file (reports/dashboards).

Written Technical design Specs and converted functional to Technical Specs and Production Support document.

Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.

Environment: OBIEE 12c, OBIA 7.9.6.3, SQL Developer/Toad, Hyperion 11.1.2.2 IR/ WA reports, Oracle 11g, Teradata, Windows.

Paychex

Rochester, NY

Business Intelligence Developer Dec 2016 to Jan2018

Coordinated with BA group for better understanding of functional requirements analyzed and designed the business requirements to documented and implemented.

Working IN high profile OBIEE12c upgradation process.

Understanding business requirements and translating them into specific software requirements

Analyzing and documenting the required data and information.

Develop Organization Dev Server For the developer with Linux operation system.

Developed Physical, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool by following standard OBIEE practices.

Designed the Star Schema for different subject areas and build hierarchies, level-based measures, Aggregate level and Alias tables.

Extensive use of Image prompts, Action Links, Go-URL functionality for the development of Interactive Dashboards and Business Intelligence reports, Create and manage KPI dashboards for management.

Customized reporting with OBIEE Answers and integrated them into the Dashboards

Work in collaboration with Project manager as well as Delivery manager (includes working as assistant project/delivery manager

Trans American INC (Internship by AG SOFT) Dallas, TX

Intern Front End Developer Oct 2016 to Dec 2016

Coordinated with BA group for better understanding of functional requirements analyzed and designed the business requirements to documented and implemented.

Responsible for Design and development of Web pages using HTML, CSS including Ajax controls and JSON.

Developed UI using JavaScript, HTML, CSS, JavaScript validations and XML.

Implemented applications in JavaScript, and MYSQL.

Worked extensively with the File management and image libraries.

Performed Client-side validations using JavaScript.

Created an inline-edit and widget-collapse feature for the web page.

Added an inline Video Player feature that supported Quick Time, Window's Media, and Real-Player.

Met one-on-one with clients in exploring the best possible options for their web presence.

AgSoft (Tanning)

Data Analyst, Dallas, TX Jun 2016 to Oct 2016

Requirement Gathering for OBIEE Reports

Understanding business requirements and translating them into specific software requirements

Involved in developing measurement dashboards using Tableau desktop.

Developed Physical, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool by following standard OBIEE practices.

Designed the Star Schema for different subject areas and build hierarchies, level-based measures, Aggregate level and Alias tables.

Extensive use of Image prompts, Action Links, Go-URL functionality for the development of Interactive Dashboards and Business Intelligence reports Customized reporting with OBIEE Answers and integrated them into the Dashboards

Involved in representing data using crosstab-scatter plots, geographical maps-pie charts and bar

oCharts, motion charts-small multiples, heap maps-density charts for Tableau

Create and manage KPI dashboards for management for both OBIEE and Tableau

OmInfoSolution

Business System Analyst, Anand, India Jan 2013 to May 2014

Act as a primary resource for enterprise business analysis including the planning and scoping of several inter-related initiatives

Support the organization key business processes and applications recommends business process redesign where applicable

Gather documents related to business requirements for large complex projects.

Responsible for writing and maintaining Functional Requirement Specifications (FRD) and Requirements Traceability.

Translate requirements into business functional use case documents and build wire-frames for large complex projects.

Prepare and deliver well-organized proposals to senior management.

The new website has made it much easier for the users to access the page and check the required info.

Created Stored Procedure, Trigger for database access and events

Academic Project

Cal State University Los Angeles, CA

Project Analyst Sept 2014 to June2016

Introduced ways to accelerate the application development lifecycle without compromising the quality of deliverables.

Provides overall management to the project. Accountable for establishing a Project Charter, developing and managing the work plan for insuring successful completion of the project

Coordinating with project team member, who analyzes, designs and ultimately improves or replaces the business processes. This includes collaborating with teams to develop high level process designs and models, understanding best practices for business processes

Gained IT project management experience, assisting PMs in developing project scopes, budgets and schedules. Helped manage each phase of the SDLC

Computer Life Cycle Management Charusat University

Software Developer January to May 2014

Utilized PHP, HTML, Flash and CSS to create University web site.

Developed and coordinate with the java developer team who design an algorithm that collect the computer configuration from each PC in the university.

In secondary phase collect congregation data and analyze the data.

Independently develop the web portal that visualize the live feed of each PC that was in working or non-working condition

NY Traffic parking visualization Hadoop Cal State University

Data Analyst – Horton Sandbox and Windows Azure as Platform January to June 2016

Gathered NY Traffic and Parking violation data.

Manage each phase of the SDLC — from requirements definition, solutions design and testing through implementation

Analyzed real time data. Used partitioning and bucketing concepts using hive.

Create tables using Terminal and hue query editor, exporting them to MySQL and then importing back to hue.

Used Tableau and Zipline for data visualization and plot places per the use case requirements

Contact this candidate