PROFESSIONAL SUMMARY

• Fifteen 15 years of comprehensive information technology experience, with profound technical skills and experience in enterprise architecture and management, business intelligence reporting, application development, database design/ administration, network engineering, systems administration, infrastructure development and many other aspects of information technology at a thorough, cross-disciplinary level
• Eight 8 years of Oracle Enterprise 9i, 10, 11g and SQL Server support certified Oracle 9i database administrator data modeling including normalizing and de-normalizing data
• Six 6 years of SAP BusinessObjects architecting, administration, report universe development, security governance management
• Five 5 years of business management experience including marketing, human resources, financial accounting, strategy planning, supply-chain and logistics management and overall operational and process-centric management
• Five 5 years of Project Planning and Management experience including planning, scheduling, resource management, effective team communication, project performance and risk assessment
• Extensive experience in-depth knowledge and understanding of current and future technologies, their capacity to drive business information, and of the business being transformed
• PROFESSIONAL COURSES
• SAP BusinessObjects 4.0 Administration, Security and Capacity Planning, Reporting and Dashboards, 2014
• IBM Information Server, Data Stage 9.1 Administration Support, 2013
• BusinessObjects XIr2 Administration and Security Management, 2006

WORK EXPERIENCE

Confidential

Business Intelligence Developer

• Developed functional requirements design deliverables for various FSD IHR reports
• Developed proof-of-concept reporting for USMS Austin Processing Center APC show casing extended Web Intelligence reporting capabilities including custom hierarchies and OpenDocument drilldown.
• Designed, developed, maintained and optimized the multi-source Universes using Information Design Tool IDT client software troubleshoot aggregates, drill-through and dynamic modules
• Conducted numerous requirements gathering, design reviews and development reviews for APC group

Confidential

• Business Intelligence Center of Excellence Shared Services Governance
• Actively promote Shared Services and manage end-user concerns that have escalated through an established service hierarchy
• Develop and implement strategy and plans for growth, service enhancements, cost reductions, and sustained continuous improvement
• Ensure all business processes are documented and executed appropriately, are cost effective, contain appropriate controls, and incorporate best practices
• Actively participate in the Steering Committee with an emphasis on performance oversight and service expansion
• Create and maintain an engaging, collaborative, and performance-focused work environment
• BusinessObjects 4.0 and 3.1 Administration, Support Performance Tuning
• Business Objects BO 4.0/XI 3.1 installation and administration of entire hardware, network-layer and software products like Tomcat, and Apache Clustered and Standalone environments
• Worked with infrastructure team to provide them with list of specifications need to build the servers for BO4.0
• Worked with Developers to consolidate the Business Objects repository before migrating to BO4.0
• Designed, developed, maintained and optimized the Universes using Designer module troubleshoot aggregates, linked universes, drill-through and dynamic modules
• Effectively administered and supervised the Business Objects SAP BI environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports
• Extensive knowledge and implementation of Business Objects Security Model and experience with Business Objects Security Implementation Row level, Object level
• Created and executed training supported end-user reporting needs using Business Objects.
• Experience with IBM DataStage for ETL Extraction, Transformation, and Loading of data from multiple sources database systems to Data Warehouses
• Developed and supported static and dynamic dashboards using Xcelsius via the web service connectors like QAAWS, Live Office, XML
• Extensively performance-tuned, identified and resolved performance bottlenecks at various levels like source, target, mappings, and session
• Experience in writing system documents, technical documents, and user documentation and also writing training materials helpful for end users
• SQL Server 2000/2008 Support
• Assisted in developing and executing data center migration and version upgrades for SQL 2000 environments to SQL 2008
• Expertise evaluating the performance of SQL statements and PL/SQL modules
• Good knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas
• Extensive root-cause analysis for performance and SQL failures troubleshoot failing SQL connections and SQL fail-overs
• Implemented user security and role management index health review and management

Confidential

Business Intelligence Consultant

• Assessed the current state of GFEBS Business Intelligence BI solution in comparison to the current industry standards and using a strategic organizational overarching approach evaluating people, process, and technology
• Assessment included subject areas of Data Architecture Reusability using Federated Development, Data Quality Management Master Data and MetaData mgmt , and effective functional and technical design process for BI, Report utilization reporting and benchmarking results against original expected usage to identify poor and stellar reports and most importantly effective Change Management.
• Assessed planned future releases/phases as defined by GFEBS BI Program and its viability with the current version and solutions by SAP and non-SAP vendors and environment.
• Assess the planned target-state of the BI solution for full production operations
• Developed a comprehensive BI Road Map that is built on strong program management principals, shared strategic planning among GFEBS Program Management Office PMO , the End-User Financial community representatives, and ITIL service-based process design, implementation, control and accountability reporting
• Provided Government BI leadership team training weekly briefings to panels of Colonels, SA15 on BI and Business Objects BO architecture, BI related technology, data quality, testing, effective-adaptable development lifecycle, performance monitoring and reporting for warning signs to look for effectively and efficiently utilizing current BI/BO tools
• Subject matter expert for design, development, deployment and active management of SAP BI/BW, ETL native Process Chains and Data Sevices, BusinessObjects XI R2, and 4.0
• Performed product assessment and bench-marking of competing technologies including portfolio solutions by SAP and Oracle in the arena of Databases, Big-Data management, and Business Intelligence
• Developed a comprehensive BI assessment briefing and out-briefing report that identified current gaps within the BI Program including knowledge management and strategic requirements for its people, process implementation, accountability, reporting, and SAP BI solution effectiveness in its current-state implementations and recommendations for improvement for short, medium, and long term duration

Confidential

Oracle Database Administrator

• Installed Oracle 9i, 10g, 11g Enterprise Server Upgrades and Patches software
• Developed shell scripts to monitor and report database performance
• Monitored tablespace, sessions, database status and automated alert messages of database resource issues to pagers
• Monitoring Alert log and Trace files to trouble shoot and resolve performance issues.
• Identifying, resolving and providing recommendations to different performance problems to the Application Support team
• Developing procedures including SQL scripts to identify data objects including tables and indexes that need reorganization and rebuilding
• Assisted in designing and documenting Oracle Backup Recovery using RMAN/ Netbackup and Oracle Export/Import utility
• Developed audit scripts to monitor intrusion and account lockouts in compliance with EPA's Security measures and procedures.

Confidential

BusinessObjects Report Developer

• Assisted in development of BusinessObjects Universes and preset canned WebI Reports.
• Universe development implemented following rigorous life-cycle development standards including strategizing, analysis, design, build, quality assurance and deployment.
• Slice-and-Dice capability implemented by implementing each object as dimension, detail, and/or measure
• Developed WebI reporting using identical life-cycle process to ensure customer requirements are accurately and effectively captured and implemented in the canned reports
• Tested reports for conformity, design and output requirements
• Assisted customer-site administrative team in installation and configuration of BusinessObjects XI R2 including troubleshooting infrastructure issues regarding security, load balancing and fail-over support.

Confidential

Project Lead Architect

• Developed an aggressive project plan to accommodate the breadth of EIM, EPM, and Reporting products deployed closely followed the plan to identify slips and show stoppers participated in weekly status meetings
• Scheduled iterative stakeholder interviews to identify requirements and gaps in the existing BusinessObjects implementations to primarily identify which gaps had the potential to transform into business development opportunities
• Developed a production, development/test Enterprise Reporting and Performance Management and Enterprise Information Management framework architecture for the AWG. The BusinessObjects XIR2 architectural specification is deployed as a multi-tiered architecture with clustered web application servers and clustered Central Management Servers to leverage BusinessObjects internal load-balancing and failover capabilities.
• Architected the AWG's BusinessObjects integration with AWG's Knowledge Management System based on single sign-on and trusted authentication implementations using BO Java SDK.
• Designed and deployed a robust, secure, and industry best-practiced security architecture for the new XI system. This security approach leveraged content and application access groups to ensure security was granular to the lowest degree yet clean implementation based on the inheritance model.
• Enterprise Information Management architecture included deployment of Data Integration XIR2 Accelerated, Data Composer XIR2 Accelerated, Data Federator XIR2 Accelerated, Metadata Manager XIR2 Accelerated, Data Quality and Insight XIR2, and BusinessObjects Text Analysis and Intelligent Search Inxight products.
• Managed a team of 4 developers including Reports developers, DI developers, and Inxight Developers.
• BusinessObjects Developer
• Installed BusinessObjects XIR2 on all the development/test production servers deployed the BusinessObjects web applications to Tomcat on the DoD SIPRNet secure network
• Installation conformed to DIACAP/DITSCAP Certification Accreditation process to ensure all security and management vulnerabilities are addressed including failover, backup/recovery, high availability, support, access control lists, and auditing
• Applied BusinessObjects service packs monthly hot fixes and critical fixes to installation
• Performed unit testing and system testing to ensure stable system,
• Developed compliant Administrator's Guide, End-User Guide, Install Guide, Computer-Based training CDs and numerous deliverables for every phase, and product deployed.
• Developed significant BusinessObjects SDK solutions that served as an extension to the Business Objects Central management console SDK implementations included trusted authentication login, managing group memberships via bulk-approach, and numerous other custom suite of tools and functions to make day-to-day administration simple giving more time to important tasks including Performance management.

BusinessObjects EIM Developer

• Installed BusinessObjects EIM framework for the AWG.
• Developed Inxight/ Text Analysis Intelligent search prototype for the AWG to show case the products features in parsing documents for various types to extract essential entities for analysis and review.
• Created highly customized visualization trees VizTree to display entity relationships and document relationships.
• Created guided navigation within trees to allow users to crawl through the trees in search of intelligence data and identify source documents of high importance.
• Deployed Data Integrator to extract data from the D6-DCGS data architecture and load this data on to the customized AWG data warehouse.
• Data Quality/ Data Insight are being deployed to work alongside Data Integrator for data cleansing and truth queries.

Confidential

Enterprise BI Reporting Strategy Analysis

• Jointly conducted numerous interviews to identify SEC's current reporting environment. Documented the array of disparate and ad-hoc tools and processes deployed by groups, sub-groups, and individuals for day to day reporting needs.
• Discussed reporting strategy requirements with the SEC CIO, CTO, and OIT management to determine the goals that SEC intends to achieve within the Business Intelligence strategy.
• Developed a multi-tiered framework for intelligence reporting including operational reporting, management reporting, and executive reporting.
• Conducted meetings with vendors including Business Objects to identify how their product lines can be deployed across the various levels of reporting requirements.
• Currently developing a near term, medium term, and a long term strategy for BI reporting.

BusinessObjects Developer

• Installed BusinessObjects XIR2 on all the prototype servers
• Applied BusinessObjects service packs monthly hot fixes and critical fixes to installation
• Performed unit testing and system testing to ensure stable system
• Gathered requirements for the SEC's data and reporting requirements to determine optimal method for deploying the BI strategy.
• Developed crystal reports and universes for the operational users, performance reports using the WebIntelligence product suite, and Performance Dashboards using performance metrics for the SEC executives.
• Guided navigation is deployed to allow executives to drill-down from dashboards to operational reports and allow management to drill-across reports for dimensional profile reporting to view the same data from different perspectives.
• Developed a reporting catalog and a unified reporting portal that allows SEC users access to all reports across domains within a single interface. All reports available to users are validated against the security and content management strategy deployed within the BusinessObjects XIR2 enterprise repository.
• US Food Drug Administration CFSAN/OFAS BusinessObjects Dashboard Consultant Jul'07 Dec'07
• Project Management Lead Architect
• Developed a multi-phase multi-resource and a multi-task project plan to manage an aggressive timeline to migrate Oracle Discoverer reports to BusinessObjects XI platform and develop and deploy a fully-functional set of dashboards to track OFAS Performance, Strategy, and Operational goals.
• Actively abide by the project plan developed to ensure tasks are started/finished within the specified deadlines
• Engaged clients in meetings to extract/gather feedback on requirements assessments, and other deliverables to ensure their continuous participation and support for the recommended solution.
• Managed a small team of developers performed resource planning and allocation

Dashboard Architect

• Deployed BusinessObjects XI Performance Manager, setup System Repository, Connections, System User, Calendar Time Periods including Custom-Periods
• Developed a metrics-universe for the OFAS's Food Additive Regulatory Management system to help the office track and manage key performance indicators for its submissions, employees, and strategic goals.
• Developed custom analytic calendars including Fiscal Year calendars for the office to support the development of analytics for Fiscal years, Calendar year, Fiscal Quarter, Month, Week timelines.
• Several different Dashboard Analytics are being developed including Interactive Metrics Trend, Speedometer, Barometer, Thermometer, traffic lights.
• Implemented Report Linking and Analytic Linking to ensure all reports and analytics allow user to review data under the graphics
• Implemented Business Rules/Alerts to inform managers, directors about milestone achievements and performance alerts
• Deployed Dashboards with a hierarchical menu that suits best for the OFAS with the analytics developed for the FARM system.

Confidential

Project Management Architect

• Developed an aggressive project plan to accommodate a short timeline closely followed the plan to identify slips and show stoppers participated in weekly status meetings
• Scheduled iterative stakeholder interviews to identify requirements and gaps in the existing BusinessObjects implementations to primarily identify which gaps had the potential to transform into business development opportunities
• Co-authored a detailed BusinessObjects XIR2 architectural specification a multi-tiered architecture with clustered web application servers and clustered Central Management Servers was proposed and deployed a second architecture was developed for GSA PBS's new shared development/test environment with CMS clustering
• Architected the BusinessObjects integration with PBS's Oracle Portal based on single sign-on and trusted authentication implementations.
• Designed and deployed a robust, secure, and industry best-practiced security architecture for the new XI system. This security approach leveraged content and application access groups to ensure security was granular to the lowest degree yet clean implementation based on the inheritance model.
• Presented different approach to resource allocation and pricing models for a shared services approach to make this BusinessObjects implementation available to other groups within the division.

BusinessObjects Developer

• Installed BusinessObjects XIR2 on all the development, test production servers into deploying the BusinessObjects web applications to Oracle Application Server 10g
• Applied BusinessObjects service packs monthly hot fixes and critical fixes to installation
• Performed unit testing and system testing to ensure stable system,
• Deployed BO java application on Oracle Application server 10g system deployed to leverage SSL to encrypt data for the external users BusinessObjects configured to work in a heavily fire-walled environment with firewall between each architecture tiers
• Performed extensive troubleshooting to ensure transition from the old to the new system was smooth and effective
• Developed compliant Administrator's Guide, End-User Guide, Install Guide, Computer-Based training CDs
• Developed significant BusinessObjects SDK solutions that served as an extension to the Business Objects Central management console SDK implementations included trusted authentication login, managing group memberships via bulk-approach, and numerous other custom suite of tools and functions to make day-to-day administration simple giving more time to important tasks including Performance management.

Migration Specialist

• Migrated 1000 users approximately 5000 desktop intelligence reports for various user/groups including personal documents, inboxes, and corporate documents, 200 Groups, 55 Universes, 5.1.6 Security As-Is
• Performed advanced troubleshooting to identify migration application failure its recurrence patterns and documented where and why the failures were occurring
• Performed detailed validation and verification including inventory confirmation of migration objects and rights to that of the source system validation/verification required the use of an Oracle database to keep track of existing inventory and migrated inventory and performing query analysis to confirm migration effort
• Training
• Developed a comprehensive training analysis and recommendation deliverable to describe various training options available to their users
• Recommended GSA PBS deploy computer-based training and instructor-led sessions over the Webex
• Conducted several training analysis meetings with various stakeholders within the project
• Developed Computer-Based training using the Adobe Captivate software. The training was developed to be highly interactive to allow trainees to participate in the learning of InfoView and WebIntelligence applications.
• Delivered On-Line training via the Lotus Notes SameTime portal to key BusinessObjects group members to train them on the new features of the XI platform including Universe Designer

Confidential

BusinessObjects Developer

• Developed complex universes using fully derived tables and aliased derived tables to support reporting requirements for the Office of the Chief Financial Officer
• Universes will often try to leverage a transaction data source to support queries that more suited to run against data warehouses
• Developed reports that leveraged multiple data providers, and merged dimensions to display data similar to the canned reports from their legacy Brio reporting system.

Confidential

Project Management

• OFAS BusinessObjects project required me to perform different roles including managing various project tasks, functional requirements assessment, design development, and technical implementation such as testing, training, and deployment
• Developed/ managed a detailed project plan for this project and discuss progress, problems-solutions, recommendations, and business development opportunities with the project manager as well as the client
• Actively abide by the project plan developed to ensure tasks are started/finished within the specified deadlines
• Engaged clients in meetings to extract/gather feedback on requirements assessments, and other deliverables to ensure their continuous participation and support for the recommended solution.

Architect/Functional Analyst

• Performed functional requirements analysis for OFAS reporting strategies
• Identified gaps in the existing reporting solution to ensure they translate effectively into requirements for the BusinessObjects system
• Developed a detailed content management plan to identify reporting strategies and corporate document structure including folders/reports/universes/users/groups/group memberships/access-levels etc
• Iteratively reviewed and updated the content plan by engaging clients in review sessions to ensure system design is as per expectations
• Developed a robust security management plan to identify and document security recommendations for OFAS BusinessObjects implementation. Security recommendations included detailed permission descriptions assigned to different functional and access-level groups for different BusinessObjects applications, corporate folders, categories, and universes.

BusinessObjects Developer

• Performed technical design of the reporting environment,
• Implemented testing strategies to verify and validate security access for different groups users
• Developed OFAS user acceptance testing schedules and independent validation verification by third-party testers
• Developed extremely detailed testing scripts to ensure that all unique security conditions of the developed solution is tested completely and accurately
• Personally performed unit system level testing engaged and supported UAT and IV V testing
• Developed training recommendations for the client to make them aware of various different training solutions that can be developed for their users including technical tool training, functional training, and computer based training all to be developed using the client's data and environment to ensure maximum adoption
• Ensured timely deployment of the BusinessObjects production infrastructure by FDA's shared services
• Successfully adopted delegated administration methodology as the premiere mode for managing OFAS BusinessObjects implementation to ensure support availability and timely problem resolutions without reliance on off-site technical resources.
• Pursued business development opportunities with client to request addition of tasks to the project for additional training, report development, and more importantly to showcase BusinessObjects Performance Manager XI tools.

Training Development

• Developed technical training guides and training schedules to train OFAS users within InfoView and WebIntelligence applications.
• Scheduled multiple sessions for the two-day session for InfoView and WebIntelligence Reporting training and a 3-hour session for InfoView basics.
• Personally conducted all training sessions, which included imparting BusinessObjects education, hands-on walkthroughs, and active question-answer sessions to ensure maximum user adoption.

Confidential

Business Objects - Enterprise Reporting

• Collaborated directly with business analysts and system owners to develop cross-functional enterprise report specifications
• Worked with and mentored several developers during the development of enterprise reports using Business Objects Web-Intelligence
• Mapped reporting requirements to Business Object Universes Webi Reports
• Developed and tuned Business Objects Enterprise XIR2 Web Intelligence documents, reports and underlying SQL queries and universes
• Created and managed users, group, profiles, and rights using the Central Management Console.
• Created reports using the universes as the main Data providers and writing the complex queries including sub-queries, unions, intersect and aliases
• Reports created to support user selection prior to displaying the information. This enabled the users to extract details portions of only required data and not the entire repository
• Formatted reports to the users requirements using all features of Business Objects including Drill Down, Functions, Formulas, and Alerters
• Implemented Reporting-Linking to allow users to view detailed dimensional data from the master detail report
• Developed templates to speed up the report implementation and deployment. Template developed used the header, body, and footer to store the HHS logo, report title, the data grid, and page numbers
• Report developed were targeted for senior HHS personnel with minimal technical expertise but extensive appetite for up-to-date information
• Helpdesk Design
• Developed requirements and support plan for an integrated Metis Helpdesk for the HHS EA Program. This integrated helpdesk was designed to minimize cost by re-use existing HHS ITSC call-center resources and the Peregrine Incident Management System.
• Developed detailed process flow charts on how the Metis Helpdesk Level 3 integrates with the HHS ITSC's Level 1 and Level 2 helpdesk
• Drafted service level agreements SLA and reporting requirements for Metis Helpdesk
• Developing a set comprehensive knowledgebase document comprising of frequently asked questions and answers, best practice guidelines for EA modeling, and call-center triages scripts.

Enterprise Architect

• Designed and extended the Metis User Interface Components UIC to develop the presentation/reporting framework for Metis users
• This presentation architecture required the use of Metis meta-modeling expertise and advance querying capabilities to develop the dynamic queries and dashboard
• Researched COTS products and assessed alternatives to find solutions that satisfied all functional, technical, and operational requirements identified for the HHS EA Change Management process
• Developed the HHS EA Metis Team server administrative guide that will serve as a reference guide to aide HHS System Administrators in managing the EA Model Repository
• Developed EA Change Control Management process documentation
• Deployed EA Configuration Item Change Request Support System CRSS to manage and log change requests for the EA Infrastructure, models and meta-models
• Developed End-User and Administrative guides for the change request support system.

Confidential

Senior System Architect Data Modeler

• Managed a team of four data modelers to develop a Logical Data Model LDM for New York City Housing Association's Residential Property Management RPM Customer Relationship Management CRM System
• Ensured that the LDM provided a concise, rigorous description of the data needed to support the RPM CRM business processes
• Incorporated best practices that introduce a change to existing data standards and adjusted the Master Model accordingly
• Successfully Translated RPM CRM business requirements into conceptual and logical data models
• Developed a comprehensive Data Entity/Attribute Naming and Modeling conventions to ensure consistent and quality were always maintained during the data model development
• Developed Models normalized up to level 2 as requested by the Clients
• Developed CRUD and Interaction Matrices across RPM CRM processes and data entities to identify data entities that interact with each process and the interaction privileges required including create, read, update, and delete.

Confidential

Senior APHIS Data Modeler

• ERWIN Data Modeling tool used for data modeling purposes to both reverse engineer previously database instances and to create models for new database instances.
• Normalized and De-Normalized tables were created according to usage.
• Logical design included table referential integrity, constraints, table and index creation, and primary and foreign key assignment.
• Data definition language DDL of new physical database instances was created using the new logical design, which was derived from end-user input.
• Models developed using both IDEF1X Integration DEFinition for Information Modeling and IE Information Engineering data modeling notations
• Developed the Database Design Description DBDD , Security Risk Analysis documentation.
• Designed and developed the VIES database.
• Performed requirements assessment, cost/benefit analysis, and developed design of the VIES system.
• Documentation developed in compliance with the National Institute of Standards and Technology NIST and IEEE guidelines.
• Responsible for the installation and configuration of database enhancements and maintenance of Oracle development and testing environments.

Confidential

Data Architect/ Modeler

• Developed Logical Data Model LDM for Defense Personal Property System DPS that is fully complaint with the USTRANSCOM Master Model per guidance identified in the USTRANSCOM Data Management Handbook.
• Ensured that the LDM provided a concise, rigorous description of the data needed to support the DPS business processes.
• Incorporated best practices that introduce a change to existing data standards and adjusted the Master Model accordingly.
• Prepared the USTRANSCOM data standardization change packages in accordance to the USTRANSCOM Data Management Handbook.
• Successfully Translated DPS business requirements into data models
• Models were normalized up to level 3 and sometimes level 4 to achieve some abstractness.

Functional Analyst

• Participated in capturing all of DPS functional requirements in detailed Business Process Flow Diagrams. Analysis included a rigorous business process analysis, requirement analysis, and COTS evaluation.
• Extensively participated in Formal and Informal Peer-Reviews and adhered to the use of Document Defect Logs.
• Participated in Gap Analysis to identify functional and technical requirements for a successful transition to the new systems.

Confidential

Design and Build

• Designed database technical architecture for development and testing environments for 3 projects.
• Installed Oracle 8.1.7 and 9.2.0 along with Oracle tools and maintained development, product test, system test, and regression/performance test.
• Analyzed management and end user requirements, coordinated operations with the development team in designing databases and tuning application SQL.
• Wrote PL/SQL Packages, Procedures and Triggers.
• Installed Oracle Upgrades and Patches software.
• Implemented Oracle Partitioning for large database tables to speed up data retrieval and increase data manageability.
• Assisted in the technical architecture designs on a new project involving high availability and scalability solutions of Oracle 9i Real Application Clusters RAC .
• Given presentations to technical architects and senior managers on the high availability and scalability options of RACs.
• Performance Tuning
• Developed shell scripts to monitor and report database performance.
• Monitored tablespace, sessions, database status and automated alert messages of database resource issues to pagers.
• Performing tuning using Explain plan and Statspack reports.
• Assisting development team in optimizing SQL statements
• Monitoring Alert log and Trace files to trouble shoot and resolve performance issues.
• Identifying, resolving and providing recommendations to different performance problems to the Application Support team.
• Developing procedures including SQL scripts to identify data objects including tables and indexes that need reorganization and rebuilding.
• Backup and Recovery
• Assisted in designing and documenting Oracle Backup Recovery using RMAN/ Netbackup and Oracle Export/Import utility.
• Wrote scripts to automatically refresh development/testing instances based on current db release.
• Technical Architect
• Designed, developed and deployed development architectures for numerous projects based on Accenture's Development Architecture Framework.
• Performed hardware requirement analysis for an upcoming project requiring high availability solutions from Oracle including Oracle 9i Real Application Clusters.
• Analyzed and proposed EMC solutions to assist database clustering and support disk shadowing for cold backups.

Confidential

Web Administrator Application Developer

• Designed and developed 3 major applications over the course of three years using most if not all SDLC phases including analyzing requirement, gathering user feedback, developing models and implementation. All applications were developed using J2EE technology including Enterprise JavaBeans, Servlet, and JSP and XML/XSLT.
• Participated in extensive requirement analysis, user feedback analysis, development of logical DFDs models and physical ERDs models.
• All web applications are designed with strict Model View Controller MVC architecture guidelines. Extensive reusability has resulted in tremendous success in design and development of new customizable surveys to collect user feedback on usability and performance of all web-sites and applications deployed.
• Recorded and maintained extensive documentation and user manuals for the various applications using Javadocs.
• Aggressively promoted and participated in Unit testing, Integration testing and User Acceptance testing.
• Gathered requirements and performed feasibility checks for a discussion board application. This colloboratory application is aimed at bridging the gap between our global users, permitting them to share their customized data products and its uses, discuss scientific problems and solutions.
• Integrated Commercial-off-the-Shelf COTS Web and FTP Log processing software within company Intranet to aid in analyzing server and network usage. This integration has aided in purchase of additional Web and FTP Servers to help balance load and decrease response time drastically. This new hardware implementation provides seamless access to 5 terabytes of uncompressed data residing on multiple raids and tape archives and handles over quarter million web hits and over 2 terabytes of half million downloads every month.
• Employed marketing strategies to promote awareness of over 2 dozen remotely sensed products and services to the widest possible science and non-science communities.
• Designed, developed, and managed website structure and content by frequently analyzing company requirements and user needs using Dreamweaver MX and Fireworks MX

Database Developer

• Designed, Installed Oracle 9i RDBMS and applied patches on regular basis on Sun Sparc 8.
• Migrated data from IBM Informix database to Oracle and rewrote numerous perl scripts as PL/SQL procedures.
• Performed Extensive tuning on the new database due to significant change in technical architecture.
• Monitored Alert log and Trace files during troubleshooting and performance checks.
• Designed logical and physical data models using ERWIN data modeler.
• Implemented database Backup Recovery strategies using Oracle Import/Export Utilities.
• Using Explain plan to optimize SQL statements and increase index usage.
• Developed and monitored Shell Scripts and Procedures which checked index fragmentation on weekly basis and rebuilt all indexes as required.