Deepak Barhate

ac8hcy@r.postjobfree.com

Cell: +91-996**-*****

Professional Summary

I have worked in various roles and capacities with a wide variety of industry during my career.

I have used and would like to grow on the skills of people management with the Strong Technical background and project management that I have had in my career as an Asset.

Technical Skills

Languages: C, PL/SQL, JavaScript, XML, GEL, Python

Databases: Oracle 11.x, SQL Server, MS-Access.

Portfolio Management Solutions: CA Clarity PPM 8, 12,13,15.X

Reporting Tools: Tableau, Crystal Reports, Xcelsius, Jasper soft.

Cloud Solutions: Sound knowledge of AWS (Amazon Web Services)

Project History

Wipro Technology

Lead Consultant Nov 2010 - Present

Working for one of the major swiss based Investment banking. (Credit Suisse)

Participate in the business-requirements process for enhancing existing PPM tools.

Develop technical design specifications to meet approved business requirements.

Configure and customize the Clarity PPM application according to approved business requirements and design specifications.

Design and develop custom GEL scripts, NSQL, Stored Procedure and processes to enable advanced features and to automate workflows.

Maintain configurations and customizations between the Clarity PPM application’s Dev/QA/UAT/Training and production environments.

Thoroughly review all enhancements in the Dev/QA environment before migrating them to the production environment including test and deployment script.

Research and evaluate additional PPM tools as needed to assess their technical capabilities for meeting new business requirements.

Convert report into complex portlets for dashboard.

Respond to and resolve technical issues received directly from users or end user support team (EUS team).

Identify root cause, investigate issues and provide recommendations, workarounds, resolutions and benefits by minimizing risk and cost.

Document detailed business requirements, functional specifications, use cases, test plans and test cases and deployment procedure. Manage offshore team to deliver the releases well within timelines and support the team of any technical assistance.

Coordinate with internal technical support teams and the CA support to resolve product issues through CA Tickets and implement releases, patches and fixes.

Coordinate production deployments with several teams over the weekend and validate the artifacts and system once it’s deployed successfully.

Environment: CA PPM (12.X,14.X,15.X), Business Objects XIR2, Oracle, Windows, Crystal, SAP BO Universes, WebI Reports

Rolta India Limited Nov 2009 - Nov 2010

Actuate to Crystal Report Conversion. Multilingual of Crystal Reports.

Conversion of Actuate Reports to Crystal Reports for Project management, Resource Management, Finance Management module’s reports. Multilingual of crystal Reports.

Implementation for CA Technologies

Understanding the Actuate Report Design & Code.

Creating test environment to generate sample data.

Designing & Developing Crystal Report exactly as Actuate Report.

Modifying the report to support Multilingual Functionality (To Support French, German Italian and Spanish languages)

Creating Unique Key for each label, Creating Query for Sub-report and creating link between sub-report and main report, Creating Formula based on Unique key, Creating Shared Variables.

Translated the reports to support Multilingual by creating and compiling the insert Statements for Spanish, German, French and Italian Languages.

Implemented the layout according to the requirements by adjusting the Width of each label depending on the maximum length of the label for each language

Published report in BO & tested each phase of the project.

Detailed Testing against use-cases, UAT

Testing of Crystal Report against clarity data & for Multilingual

.

Environment: Clarity (7.X,8.X), Actuate (7.2), Oracle, SQL Server, Business Objects, Crystal Reports

Rolta UK Limited Jan 2008 – Oct 2009

PPM Implementation & Maintenance. The project involved implementation and Maintenance of various module of CA CLARITY PPM Center for tracking PPM work of employees in order to have better visibility and more managed IT Governance.

Implementation for Leading Oil & Gas Industry Organization in the Europe (Saipem Italy)

Creating custom gel scripts required for many processes like creating a project from template, ETC approval, import projects and project data from SAP, Project dates shifting, Sending mails on specific events.

Oracle stored procedures for calculating allocation curves from BLOB, aligning assignment and task dates with the project dates etc.

Oracle triggers for controlling user inputs for the clarity attributes and notifying the incorrect inputs by raising application errors on clarity screen.

Development of a custom object to create, update and close work services in multiple projects. Development of related processes, triggers and stored procedures.

Migration of Clarity configuration from Development to Production environment.

Handled issues related to Clarity data model and database related incidents.

Handled issues related to Clarity Configuration, Administration.

Environment: CA PPM 8.X, Oracle 8.X

Rolta UK Limited Jul 2007 – Dec 2007

Importing Resources, Project, Resources, Skill data in CA PPM Instance

Implementation for CA UK Limited.

To Import project data along with resource allocation information from the legacy application to the Clarity.

To import users and resources with along with their access rights from a spreadsheet to the Clarity

To import skill set matrix containing proficiency and interest levels of the skills for the resources from the spreadsheet to the Clarity.

Developed custom portlets to list resources by their skills, OBS and the Manager id

Environment: CA PPM 8.X, Oracle 8.X

Rolta UK Limited Aug 2006 – Jun 2007

Implementation of Various modules in CA Clarity to support the Sales Pipeline Management, Project Management, Tracking Resource visa details, Time & Utilization details.

Implementation for Rolta UK Limited.

Installation of Clarity 8.1 with MSSQL 2005

Creating OBS, Resource, Groups, Configuring user profiles, Timesheets, Resource Object view, Project Object view, Lookups, Time Slices, and Default Portlets. Customize Idea Object to be used as Sales request tracking and approval.

Creating Custom Objects – For resource Visa information management and validity tracking

Process Designing – Customize Idea approval process to go through certain chain of approvers and finally convert to Project when the sales lead is materialized, Customize Timesheet approval process.

Portlets – Portlets to view Resource Visa information, Weekly and Monthly Resource Utilization, Pipelined opportunities, Comparing resource headcount by skills area using Bar Graph.

Gel Scripting – To convert Sales lead in to Project, Send a mail if the Visa validity reaches to its expiry. Importing Project data, resources and resource skill matrix from legacy application to Clarity

Triggers and Stored procedures – MSSQL Stored procedure to be scheduled as a job which updates Visa validity on daily basis.

Support – Supporting ongoing operations of the organization, system maintenance.

Environment: CA PPM 8.X, MSSQL 2005

Rolta UK Limited May 2006 – Jul 2006

The project required establishing an effective Vulnerability Manager & Security Command Center to assimilate and correlate security event information captured from different operating systems to provide centralized security management

Implementation for Tesco – Turkey.

Installation of one eTrust SCC Server (eSCC server & Database) and one eTrust Audit Server (Policy Manager, Data tools and Collector database) on Microsoft Windows 2000 server

Installation and Configuration of PIKs for MS-NT Event Log, Integrated threat management, eTrust Vulnerability manager, eTrust Secure Content

Installation and Configuration of eTrust Vulnerability Manager

Installation and Configuration of eTrust Vulnerability Manager Agent, eTrust ITM, UAM Agent through Unicenter Software Delivery

Creation of Asset groups, assigning assets to respective asset groups

Environment: CA PPM 8.X, MSSQL 2005

Rolta India Limited Jan 2005 – Apr 2006

This project was iRecorder development for Open-LDAP on Suse Linux. The iRecorder is iSponser Shared Object file, which fetches logged events from product server (which are generating on the client machine) to eTrust Audit server, and Security Command Center.

On the Audit server policies are configured which filters the fetched events. Then the events are passed to Security Command Center for Decision Making.

Analysis of Open-LDAP application

Creation of Software Requirement Specification and Design document specification

Architect solution

Creation of Development Environment

Development of code to capture the events details from the log file of Open-LDAP and to show that events in Security Command Center and eTrust audit Security-Monitor.

Testing the code on Open-LDAP application

Creation of Custom PIK to integrate iRecorder with eTrust SCC

Education

Bachelor in Engineering (Information Technology)

Training and Certifications

CA Clarity Functional Boot Camp Certified Consultant

CA Clarity Technical Boot Camp Certified Certified Consultant.

Machine Learning by Stanford University on Coursera.

Neural Networks and Deep Learning on Coursera.

Contact this candidate