Sekhar Mandava Email & Phone Number

New York, New York

Edison,Nj

Application Portfolio Governance Tool Support

Edison,Nj

Centralized Reporting/Operational Data Store • Remediated Sql server 2000/2005 to 2008 by consolidating servers.• Created Application Technical Recovery Plan and Application control Plan. • Involved in onshore/Off shore consultant recruitment process. • Designed and Implemented NPI Data restrictions. • Lead the offshore and onshore consultants as part of Application Manager Role. • Migrated 700 + SSRS reports to 2008 SSRS • Lead the ODS cutover project and… Show more Centralized Reporting/Operational Data Store • Remediated Sql server 2000/2005 to 2008 by consolidating servers.• Created Application Technical Recovery Plan and Application control Plan. • Involved in onshore/Off shore consultant recruitment process. • Designed and Implemented NPI Data restrictions. • Lead the offshore and onshore consultants as part of Application Manager Role. • Migrated 700 + SSRS reports to 2008 SSRS • Lead the ODS cutover project and provided the Impact/Gap analyses.• Deployed 100’s of SSIS to pull the As 400 data. Show less

Secaucus,Nj

Supported Year\Quarter end Global Financial Reporting activates.Developing/Modifying ETL process for FR11 and FR10 Applications.Created and maintained Control-M jobs.Hyperion Essbase Data verification and validation for Statuary close process.• Implemented and Customized LCM.• Cross Functional Team Leadership.• Involved in design and development and coordination with PSsoft vendor and Users.• Designed and developed out of the box correlation module using… Show more Supported Year\Quarter end Global Financial Reporting activates.Developing/Modifying ETL process for FR11 and FR10 Applications.Created and maintained Control-M jobs.Hyperion Essbase Data verification and validation for Statuary close process.• Implemented and Customized LCM.• Cross Functional Team Leadership.• Involved in design and development and coordination with PSsoft vendor and Users.• Designed and developed out of the box correlation module using ASP.Net.• Designed and implemented the software Usage rules to identify the software Usage. Show less

Project: Global Client Asset Transfer and Tracking System (GCATTS)Role:Responsible for gathering user requirements and define the scope of the project utilizing UML concepts.Design 3-Tier architecture and developed the business access layer and the data access layerBusiness Access layer was developed using Visual Basic and the Data Access layer was developed in OracleVisual Basic GUI design, development and testingDeveloped COM objects and deployed the components in… Show more Project: Global Client Asset Transfer and Tracking System (GCATTS)Role:Responsible for gathering user requirements and define the scope of the project utilizing UML concepts.Design 3-Tier architecture and developed the business access layer and the data access layerBusiness Access layer was developed using Visual Basic and the Data Access layer was developed in OracleVisual Basic GUI design, development and testingDeveloped COM objects and deployed the components in Microsoft Transaction Server (MTS)Developed Customized Active X /OCX Controls for the effective user interface(UI Screens)Tools: Visual basic 6.0, Oracle 8.0,Db2, Windows NT/95,IIS 4.0, Object Model (Active X DLL/OCX Show less

Project: Online Product listing and Selling System Role:Integrated the above system into the corporate Intranet. Used HTML, VB Script extensively for effective client side scripting.Used ADO to access the data from SQL Server Database. Used Stored Procedures for generating reports.Developed an ActiveX Control for effective User-Interface.Tools: Visual Interdev1.0, MS FrontPage 97, ASP, ADO, VB Script, HTML and MSSQL Server 6.5; Resume of