SUMMARY:

16 years of IT experience and has extensive experience in Technical knowledge, Domain knowledge as well as Business Implementation & Configuration of Project and Portfolio Management Tools (Microsoft Project Server and HP PPM), SharePoint, ETL Process and MS BI (SSIS, SSRS, SSAS). Confidential ’s technical expertise includes knowledge in C, C++, VC++, C#, Java languages; .Net framework, Web services, SQL - PL/SQL programming on Oracle and SQL Server; CORBA programming; D2K,Forward & Reverse Engineering using ER-Win Tool; Application development using D2K. Confidential has extensive experience with design, development, data migration, implementation and managing all aspects of a project.

TECHNICAL SKILLS:

Platforms: Unix AIX, HP UX, Linux, DOS, Windows, TPF, Main Frame

Databases: Oracle 7, 8i, 9i,10g; SQL Server 2005,2008,2010,2012; Empress

Software Languages: C, C++, VC++, C#, Java, JSP, HTML, XML, ASP .Net, SQL, PL/SQL, COBOL, Assembly Languages 8085,8086,s390

Application: Project Server 2013, SharePoint 2010, 2013, Project and portfolio Management Tool (HP PPM), ETL, MS BI, HP Executive Scorecard, CORBA (Borland Visibroker 7.0,IONA ORBacus 4.1.2), PSI, Web service, Oracle AQ, IBM MQ Series 5.2

Development Tools: SharePoint Designer, Workflows, InfoPath, SSRS, SSIS, SSAS, Excel services, Visual Studio, Project and portfolio Management Tool (PPM 6.0,7.1,7.5, 8.0,9.1) Workbench, Toad, SQL Developer, D2K, ER-Win, X-Window, Motif, Oracle BI, BO/Web Intelligence, Xcelsius, PVCS, VM/CMS and MVS, Rational Purify for IBM-AIX, Silverlight 4

PROFESSIONAL EXPERIENCE:

Confidential

Technologies/Environment: Platform: Windows Server 2012

Development Tools: Project Server 2013 Web App, SharePoint 2010,2013, SharePoint Designer, InfoPath, SSRS, SSIS, SSAS, Visual Studio, C#, .Net, PSI (API) Web Services, SQL, PL/SQL, Excel Services, Event Handlers, Web Parts, SharePoint Web services, JQuery, JavaScript

Backend: SQL Server 2010, 2012

Special Tools: Project Server 2013, SharePoint 2010,2013 and MS Project Professional

Technical Lead

Responsibilities:

• Administration, support and maintenance of the Project Server 2013 and PMO SharePoint 2010 portal for production, development and stage environments.
• Development/configuration of MS Project Server integration with other Enterprise tools and Applications to extract, transform and load the data across multiple systems and sending email notification using SSIS.
• Build ETL solutions using SSIS to integrate data between Project Server, SharePoint and other systems including but not limited to project/portfolio management, Financial system, Invoicing System, PeopleSoft, Active directory etc. And build OLAP Cube as well as SSRS reporting.
• Extracted and loaded data from/to various sources/destination like SQL Server, Oracle, .CSV, Excel Flat file and Text file from Client Servers and through FTP
• Worked on several SSIS Transformations, for example: Slowly changing dimension, Look up, Aggregate, Derived Column, Conditional Split, Multicast, Bulk Insert, Sort, Merge, Union All, Data Conversion etc.
• Reviewed, Tested and Deployed SSIS packages through command line, SQL Server Agent and scheduled through Job Scheduler for nightly and weekly loads of data by creating the corresponding job tasks.
• Create new and/or modify existing Project Server & SharePoint reports such as Complex drill down & drill through reports, Parameterized Reports, Sub reports, Charts, Tabular reports with Cascading parameters, Matrix reports etc. using SSRS and Tabular, Pivot reports using Excel Services.
• Involved in planning and designing SSAS Cubes and building attribute relationships for optimal MDX query and build/design Dimension, Measures, Star Schema, Snow flake, shared connection managers etc.
• Configure standard Project Server 2013 SharePoint project sites, issues & risks and troubleshoot issues associated with the project sites
• Administration and Maintenance of Enterprise Global Template, Project Site Templates, Enterprise Project Types, Project Detail Pages (PDP), Resource Breakdown Structure (RBS), Security Groups & Categories, Custom fields, lookup tables, Formula, Resource, Timesheet Policies and Ms Project Server Views, OLAP cube, backup and restore of projects, custom fields, workflows, workflow stages and phases.
• Development, Customization, and maintenance of PWA & SharePoint Views and Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views, user-defined functions and Adhoc queries using TSQL DDL/DML to support PMO business logic.
• Created SharePoint Sites, Lists, Document Libraries based on custom site template and site definition. Created Master Pages, layout pages, and Web part pages in SharePoint 2010.
• Created and deployed InfoPath form library in SharePoint that enables business users to submit proposals and developed workflow using SharePoint designer to go through several approval processes and notifications for project estimation and budget approval and create a formal project upon approvals
• Build, Maintenance and enhancement of automated custom PWA solutions (Timesheet Creation, uploads of project Budgets and Financial labor hours for employees, contractors and Fixed bid resources FTE hours) using Visual Studio .Net, C#, PSI (Project Server Interface Web service), Event Handlers, SSIS packages, SSRS, SSAS, Custom web parts, SharePoint Web services,CALM queries, JQuery, Javascript etc.

Confidential

Environment: Platform: HP-Unix, Sun Solaris, Windows Server 2003

Development Tools: PPM Tool, JDBC, SQL, PL/SQL, JBoss Application Server, Web Service, JSP, Hibernate technology, Applet, J2EE Application Server, RMI, SRMI, Apache JServ Protocol version 1.3

Backend: Oracle 10.2.0.2 RAC

Special Tools: PPM Tool & Workbench (Version 6.0, 7.1, 7.5, 8.0, 9.1)

Technical Lead

Responsibilities:

• Maintain and Support the Confidential IT PPM Application, keep it running, monitoring the activities and troubleshooting the application after it brought to In-House at Confidential IT division.
• Provide support for the application as an administrator of the tool during the business hours so that all users can use the tool for their daily business process.
• Gather new business requirements of PPM System and translate the user requirements into detailed specifications and design the solution from the detailed specifications.
• Co-ordination of activities to facilitate ease of day to day work for offshore team according to the design specification and clarify questions from offshore team.
• Build ETL solutions using SSIS to integrate the data between PPM and other systems including financial system, EPM, SharePoint.
• Involve in configuration changes of the tool and execute daily and monthly process like Time sheet extract and budget upload to compare actual cost of the project vs. invoice raised by finance.
• Design, development and implementation of any new PPM functionalities (Reports, Portlets, workflow, project/core support process/form, resource pool/staffing profile related changes etc.) using Oracle Package, Procedures, Triggers etc, Change requests and Bug fixes as requested by the users.
• Develop Adhoc queries using SQL, PL/SQL during the business hours to fetch any urgent information from PPM which can’t be fetched using existing reports/Portlets.
• Reviewing of code to validate whether they are working as per the requirement, ensure the technical quality, and assist in identifying all the technical tasks and standards that need to be followed using Confidential ’s highly rigorous quality processes.
• Review test cases and performance of integration tests, some functional testing, performance and acceptance testing.
• Provide expert knowledge in specific business and technical functionalities used in the PPM tool and clarify any doubt that users might be having while using the functionality of the tool being developed.
• Packaging and deploying the objects in QA and Production for any fixes in the Tool or addition of new functionality.
• Analysis and implementation of new Service Packs in PPM and add new licenses in PPM if required.
• Design and Development of new UA/CO Integration related functionalities in PPM and support them.
• Upgrading PPM to version 9.1 to enable and test new Portfolio hierarchy feature in PPM
• Technical support of the different PPM instance used by CRE (“ Corporate Real Estate”) division of Confidential .

Confidential

Environment: Platform: IBM-AIX, HP-Unix v11, Linux, Sun Solaris, Windows 2000

Development Tools: C, C++, VC++ 7.1,Java 5.1, PL/SQL

Backend: Oracle AQ

Special Tools: PVCS, Rational Purify for IBM-AIX, Borland Visibroker 7.0

Senior Developer and Technical Analyst

Responsibilities:

• Develop the Server-side code for Confidential server
• Develop the client side code for Software Development Kit (SDK) APIs that was used by different subsystems in different languages/OS (C, C++, VC++ in Windows/Unix/Linux).
• Build the messaging queue using Oracle AQ and writing stored procedures and triggers in PL/SQL.
• Installing Visibroker in different platform and testing different functionality

Confidential

Environment: Platform: Windows 2000/XP

Development Tools: Visual Studio, VC++ 6.0

Backend: Apollo Mainframe System (CRS)

Special Tools: InfoConnect32

Senior Developer and Technical Analyst

Responsibilities:

• Preparing Impact Analysis & UTP, Coding, Review of code, Unit testing and Delivery of Maintenance Request.
• Maintenance and Enhancement