PROFESIONAL SUMMARY:

• Enthusiastic, proven Technology Solutions Leader with over 18 years in technical management, development and delivery of enterprise solutions and consulting services across diverse markets.
• 16+ years of Business Intelligence, tools like Oracle APEX, Japsersoft, Tableau, Business Objects, Crystal Reports, Actuate
• 10+ years of PPM primarily using CA PPM (Clarity), Primavera
• 6+ years of Project Management using a vast array of Software Development Life Cycle methodologies

IT SKILLS:

Languages: ‘C’, ‘C++’, java, java script, JSP, ASP.NET, XML,HTML, VS COBOLII, Cobol85, Basic, Pascal, TACL, JCL

Operating Systems: Windows XP and preceding, Sun Solaris UNIX, Guardian90, MVS/ESA

Hardware: , Intel i7 and preceding, Windows2007 Server, IBM ES 9000, TANDEM Mainframe System Cyclone /R, Fujitsu mainframe

Web/APP Servers: WebSphere, IIS, Tomcat/Apache, BEA - Web logic

Software Tools: Oracle APEX 5.1, CA Clarity 14.x 13.x,12.x, 8.1, 7.5.x, TFS, Jaspersoft, Crystal Reports XI R3, Business Objects 3.1, XCelisus, Actuate 11SP1 and preceding, SQL Developer and similar, erdPro, eSpreadsheet, Actuate Query, Information Objects, Oracle BI Publisher, Oracle Answers, Callidus TrueInformation 5.2.1, LDAP MS Active Directory

Databases: Oracle 12c, 11g & preceding, Sybase11.1, Informix, DB2, MS Access, MS SQL Server 2012 & preceding

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Project Lead

Responsibilities:

• Responsible for the design, development, deployment and maintenance of crucial business applications
• Gather user requirements defining high level business process flows using Visio to simplify development efforts.
• Reviewed / conducted interviews to gain understanding of legacy applications and the end-user pain points to recommend new system processes with improved functionality.
• Provide “Level of Effort’ to help Project Managers with Project and Resource scheduling.
• Responsible for collaborating with ETL teams to define appropriate data mapping solutions for critical business needs
• Ensured Audit Compliances by creating / gathering relevant documentation including detailed design documents, data dictionary etc. are uploaded into TFS during all project phases
• Developed several business objects reports designing the underlying Universe
• Conducted technical workshops to define product development strategy.
• Developed Oracle Apex Interactive reports
• Developed reusable complex multiple tabular forms in single page, to reuse across multiple applications.
• Responsible to coordinate with Business UAT teams to ensure requirements / timelines are met
• Worked closely with Receiverships and Asset Management to design the application to manage their assets in litigation
• Built a user management application, integrated with windows AD to administer, monitor and report user accounts for business applications, which minimized the turnaround time for user access approvals and provision.
• Mentored other developers on the team to jump start / finish the project task within the time lines.

Confidential, Celebration, FL

Clarity SME

Responsibilities:

• Responsible for setup & configuration of all aspects of Project Management, Resource Management, Time Management
• Setup Financials, Rate matrix
• Created custom data extracts and scripts to load custom tables for reporting purposes/
• Designed Custom roles & security groups
• Redefined Time slicing based on customer data needs
• Created multiple custom workflow processes.
• Coordinated with CA to resolve multiple technical/functional issues
• Created custom portlets and data extracts to serve business needs
• Worked closely with the Solutions Architect to design and implement POCs
• Reviewed CA PPM 14.2 DWH features and designed solutions to address future reporting needs
• Reviewed Advanced Reporting to identify OOTB solutions with minimal customizations for client specific needs.
• Design, Development and Implementation of various reports and drilldown dashboards
• Created custom domains, fact and dimension tables to address Disney’s reporting needs.

Confidential, CA

Clarity Technical Architect

Responsibilities:

• Responsible for Upgrading CA Clarity PPM V 12.0.5 to V 14.1 (includes installations in multiple environments)
• Redesigned roles, security groups
• Responsible for incorporating Financials
• Redefined Time slices
• Coordinated with CA to resolve multiple technical/functional issues
• Created multiple custom crystal reports, portlets and data extracts to serve business needs
• Implemented Integrations with SharePoint, PeopleSoft etc.,
• Created necessary processes utilizing XOG, Gel Scripting.
• Coordinated with the DBAs to migrate, backup, restore multiple db instances in SQL Server 2008, 2012
• Coordinated with the BA and Functional analysts to design the necessary scalable/reliable technical architecture required for PPM.
• Reviewed CA PPM 14.2 to utilize the latest Data warehouse features
• Install Jasper Report server and develop reports using Jaspersoft studio created custom report/domain prototypes
• Responsible for providing Tier-2 technical support, administration creating necessary custom db components, forms, views, lookups, objects etc.,
• Created multiple POCs, custom login screens, single-sign on etc., to serve client needs

Confidential, Houston, Tx

Sr. Clarity Techno Functional Support Lead

Responsibilities:

• Created an ITIL process centric Clarity Support for the Client managing a team of a team of 6 people, 2 onsite/4 offshore.
• Created SOP to successfully lower turnaround time On SLA Timelines.
• Responsible for Providing weekly and monthly status reports to both the end-client (BHI) and customer (TCS)
• Conducting necessary JAD sessions where applicable to review/investigate/design/re-design functionality tailoring the PMO personnel needs
• Provided functional/technical solutions to the customers as a part of on-going support
• Coordinate with CA Support on defects and unexplained technical issues to obtain the necessary solution/work-around
• Installed and trained/supported PMs on the integration of how to utilize the Clarity MSP plugin
• Worked on regular Clarity refreshes from PROD environment to 3 lower environments, after each monthly/bi-monthly release cycle
• Coordinate with other teams like SAP, CA Service Desk, Rally, Sharepoint to resolve several integration issues
• Coordinate with the Development teams and our team to code review and complete UAT to learn new custom functionalities implemented
• Worked on several minor to moderately complex bug-fixes/enhancement requests
• Addressed data load requests by creating the necessary XOG scripts to read from Excel spreadsheets
• Investigated performance issues to redesign some time-consuming SQLs within the underlying reports and dashboards.

Confidential, Plano, Tx

Sr. Clarity / BI Consultant

Responsibilities:

• Worked on End-to-End implementation from Ideas to Delivery utilizing the SR process.
• Research, Analyze, Design, Develop prototypes and present to the client for approvals, followed by presentations to the offshore team for actual developments
• Troubleshoot all Issues, Bug fixing, Development on Quick Hits following a strategic Agile process/methodology
• Created Several Data Extracts both Adhoc and utilizing the DataExtractionConfig
• Coordinate with CA Support on defects, setup/configuration issues and get answers for “How to” questions.
• Design, Create, Implement custom work-flow processes, objects based on client business rules utilizing GEL Scripting, WSDL etc.,
• Extensively utilize XOG for migrations to higher environments
• Mass Data loads using Integration Bridge
• Lead Developer on complex Report and Portlet development from requirements phase to deployment and maintenance.
• Responsible for Overall Project Management activities like Project Plan, Requirements Approvals, Weekly Status reports, meeting minutes/Action items etc.
• Created POCs and recommended design changes where necessary.
• Investigated performance/latency to recommend appropriate measures from both technical and business policy changes.

Sr. Systems Admin /Architect

Confidential, Pittsburgh, PA

Responsibilities:

• Installed TEST Actuate 11SP1 environment to migrate data from Actuate V9 SP3 environment.
• Implemented Usage logging consolidator creating necessary Oracle db objects
• Supported the application teams for database version upgrades on the application
• Coordinated with the Actuate Support for solving production issues on the Actuate server
• Installed and Configured new Actuate 9 servers with RSSE enabled security for the DEV and UAT environments in the Corporate Trust division
• Coordinated with the application teams and setup archival policies for the reports on the Actuate server thus reducing space utilization on the server
• Created several UNIX scripts to perform log and tmp file cleanups, resource and space utilizations, automated mailing etc.,
• Monitoring clustered environment and up’ing factories etc., to meet the volume demands
• Scheduled reports on the production Actuate servers based on the requirement
• Implemented and tested shell scripts on the Actuate server to clean up the log and temp files.
• Installed and configured Active portal war files on the Weblogic server hosted on the UNIX machines.
• Worked with NFS Team and UNIX Administrators troubleshooting several issues
• Responsible for monitoring space utilization on the UNIX file system, NFS mounts etc.,
• Responsible for creating and maintaining snapshots for online backup

Sr. Clarity/Actuate Consultant

Confidential, Glendale, CA

Responsibilities:

• Gathered Requirements for the Onsite/Offshore engagement model.
• End-to-End coordination from Ideas to Delivery
• Served as an Infosys’s face to the Client.
• Research, Analyze, Design, Develop prototypes and present to the client for approvals, followed by presentations to the offshore team for actual development
• Created processes with Automated Action items and custom email notifications utilizing GEL Scripting
• Troubleshoot all Issues, Bug fixing, Development on Quick Hits following a strategic Agile process/methodology
• Research into newest version/fix packs release documentation to provide guidance to the Client.
• Coordinate with CA Support on defects, setup/configuration issues and get answers for “How to” questions.
• Design, Create, Implement custom processes, objects based on client business rules
• Extensively utilize XOG for migrations to higher environments
• Lead Developer on Report and Portlet development from requirements phase to deployment and maintenance.
• Responsible for Overall Project Management activities like Project Plan, Requirements Approvals, Weekly Status reports, meeting minutes/Action items etc.
• Create/modify custom Gel Scripts for db updates, email notifications etc.

Confidential, Dallas, TX

Sr. Clarity/SharePoint Specialist

Responsibilities:

• Design, Develop WSS sites, lists etc., required for the PMO
• Coordinate and Train the PMs to utilize Project Management module within Clarity
• Administrative activities involved XOG activities to creating resources, groups, define projects etc.,
• Research into Integrating Clarity & WSS to create and deliver reporting utilizing both databases.
• Designed a solution to utilize MSP efficiently with multiple linkable Project Plans to successfully allow schedule changes
• Researched into designing Position Control Objects for Employee and Contractor Management within Clarity.
• Mentor PMs to perform normal day-to-day activities

Confidential, Louisville, KY

Lead Clarity/Actuate Developer

Responsibilities:

• Design, Create, Maintain, Document and Support ORACLE data mart environment for PPM related Metrics & Dashboards
• Consolidated regular data requests into portlets to provide a self-serve mechanism to the end users
• Served as the single point of contact for all data related queries
• Worked on adding custom attributes to Core Objects to implement several screen changes
• Created creating custom objects/sub-objects and Processes to handle baselines, lock and unlock releases, resource primary role archival, creating history to track project status changes, Portfolio sub objects etc.,
• Created custom Operating Plan objects to assist CBA process.
• Implemented a structural change on the cost/budget plans to provide additional levels of sub-grouping
• Created custom job definitions and XOG into and out of different environments to implement updates.
• Created reports to provide multi-select functionality
• Experienced in using XML Spy to create custom GEL Scripts, utilizing SOAP messaging, creating custom XOG XMLs
• Created multiple data audit SQLs and N-SQLs to create new and update existing reports and portlets
• Mentored other members of the ITRM group and Business users on utilizing the available features
• Support Infrastructure team to troubleshoot Actuate architecture and configuration issues
• Worked closely with the clarity administrators to provide Tier-2 technical support
• Created custom db objects (tables, views, stored procedures, functions etc.,) to aid development efforts

Confidential, Chicago, IL

Architect/Lead Report Developer

Responsibilities:

• Led the design, development and tuning of Actuate reports and portlets.
• Customized out of the box Clarity-Actuate reports to fit the corporate reporting needs
• Customized NIKU Actuate libraries and created new libraries to serve Confidential needs
• Created several stored procedures and views to aid report and portlet development
• Created custom extracts for quick hit data requests/queries
• Designed custom chart components to dynamically change the orientation based on input
• Research and analysis to come up with technical solutions on Clarity/Actuate configuration
• Created Custom Objects, Queries, Portlet Pages utilized NSQL constructs to create Portlets using Clarity Studio.
• Involved in Data administration activities like creating lookups and job definitions
• Involved in Administration of resources, projects, groups and OBS
• Gathered reporting requirements working with the business users
• Assisted in overall project management and administration activities
• Provided technical guidance regarding report capabilities in ACTUATE
• Mentored Clarity PPM Group (ITG) Associates on ACTUATE

Confidential

Sr. Actuate Architect/SME

Responsibilities:

• Review Click Commerce’s Actuate environment.
• Review architecture
• Review customizations
• Propose recommendations based on the above review
• Created Tips and Tricks for Actuate Report Developers and explained the need for a framework
• Reviewed basic and advanced performance tuning options available with Click’s Actuate Admin
• Proposed solutions to use clustering and plan for upgrade to a higher supported version
• Suggested a reliable backup methodology
• Troubleshoot PROD report failure issues for Click Commerce’s client AMEX
• Created Best Practices document for the Actuate implementation both in terms of report development and deployment

Confidential

Architect/Lead Developer

Responsibilities:

• Lead Actuate Report Development process to design, code, test, and tune a variety of reports against a DB2 data warehouse database for the Compliance Reporting Application.
• Mentor other Actuate developers in and outside the team under the global Application development umbrella.
• Manage migration process of reports through test environments
• Working with project manager and business analysts to estimate effort to build reports based on business requirements
• Working with project manager to assign tasks to Actuate developers
• Working with business analyst, other team members, and data management team to determine data sources for reports and resolve report defects and performance issues
• Used source code repository tools such as VSS, Harvest and SQL query tools like Rapid SQL, Toad, SQL navigator etc,
• Working in a large database environment with large number of database objects and large amounts of data
• Working in a structured testing environment that includes development, system testing, user acceptance testing, and performance tests environments.
• Proactively identify potential issues and design potential solutions with prototypes wherever applicable
• Design, code, and test a variety of reports which include creating reports within Actuate as well as writing all SQL for the reports

Confidential

Practice Manager

Responsibilities:

• Reviewed server setup, configuration and administration procedures (backup/archive etc.) and make Best Practices recommendations
• Reviewed Actuate clustering technology; design a load-balanced, clustered Actuate server configuration.
• Perform detailed analysis and design of Dev, QA, Services (Staging), Production Actuate Systems
• Reviewed server administration procedures (backup/archive etc.)
• Reviewed existing reports to arrive at an approach and estimate for conversion to Actuate
• Reviewed Executive Summary Demo of the Actuate product suite
• Reviewed Single Sign-on requirements and made design recommendations.
• Discuss options to integrate Actuate with an external security model - based on the existing security model or an updated security model design.
• Mentor the development team members with Report development best practices, including overview of report development framework.
• Revisited prototype development work conducted during the Proof-of-Concept around embedding reports in email and discussed best practices for managing it.
• Reviewed web interface (Active Portal) based on a .NET implementation

Confidential, Norwood, MA

Sr. Architect/Consultant

Responsibilities:

• Create an Upgrade Strategy by reviewing the infrastructure and app requirements and created documentation.
• Implementation of the upgrade (v6 to v8SP1) and basic performance tuning,
• Mentored the Administrators and Application developers to utilize the best of V8.
• Troubleshoot an eSpreadsheet issue using an old jar with the new version.
• Analyze and create a report archival strategy for storage and future retrieval (PDF-based offline storage or ROX+ROI offline/online.
• Designing and implementing an archiving solution for long-term report storage and retrieval of reports.

Confidential, Chicago, IL

Sr. Architect/Consultant

Responsibilities:

• Reviewed the Architecture and identified some issues in the clustered environment
• Analyzed the issue and suggested changes in settings to troubleshoot prod to minimize impact on business
• Coordinated with Actuate Adv. Support to debug and create the appropriate logs
• Identified a bug in the Requester API report and recommended a work around
• Recommended changes to the report service running off of a web logic server
• Involved in re-design sessions with BEA Web Logic, JPMC Infrastructure/Technical teams and Actuate to identify and eliminate the root cause of the issue

Confidential, St. Louis, OH

Sr. Architect/Consultant

Responsibilities:

• Designed architecture for the Security Integration for Windows 2003 Actuate server with Active Directory
• Involved in installation and customization of Active Portal for .NET
• Created and Implemented APSE to used Windows NTLM Ids
• Created and Implemented a LEVEL 2 RSSE integration against Active Directory
• Created the necessary OUs and other related objects for users and groups for integration
• Documented the design, approach and steps to implement and maintain the APSE and RSSE

Confidential, Lebanon, OH

Sr. Consultant

Responsibilities:

• Upgraded the environment from Actuate 7.0 to 8.0
• Mass Compiled version 7.0 RODs in version 8.0 to create roxs
• Customized Active Portal templates to integrate with the Client’s portal environment
• Installed Active Portal for .Net on IIS on win2k SP4 server
• Reviewed the importance of server sizing and Tuned for Performance
• Configured the Oracle database drivers
• Created and presented a Single Sign-on Strategy to utilize Active Directory
• Created a generic component library for connecting to different databases
• Recommended best practices in report development, deployment and accessibility