SUMMARY

• Application Developer/Database Administrator with over 15 years of hands - on experience in the use of relational and object oriented database concepts in the design, development and administration of Oracle, Sybase, Microsoft SQL Server and Access databases, data warehouses and data mining environments.
• Practical knowledge and experience using contemporary lifecycle methodologies- notably Custom Design Methodology (CDM), IDEFIX, Dimensional Lifecycle Methodology, Agile, Scrum - in business requirements gathering and analysis, and translating business requirements into logical data models and physical database designs for new business solutions.
• Extensive experience in building and supporting OLTP and OLAP systems - ability to tailor transactional and data warehouse architectural approaches to business requirements.
• Extensive experience interacting and providing recommendations to clients on systems development and enhancement requirements, with specific emphasis on database related requirements.
• Extensive practical experience with large-scale relational and multidimensional database design and strong hands-on experience troubleshooting database anomalies.
• Knowledge and experience using SQL, PL/SQL, TSQL, Unix Shell Scripting, C, Java, ProC, R language, Visual Basic, Perl, TOAD, Developer 2000, Oracle reports, Crystal Reports, Business Objects, Informatica, Microstrategy, AbInitio, Hadoop in meeting data warehouse and business intelligence application development requirements, including the design of forms and reports.
• Hands-on experience with the installation, configuration, administration and troubleshooting of most Unix and Windows Operating Systems as platforms for client/server databases.
• Networking essentials, particularly in the in the administration of Cisco routers and switches and in setting up desired LAN, VLAN and WAN network environments using X25 and TCP/IP.

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows 2000, AIX, Sun Solaris, HP-UX, Unixware.

Languages: SQL, UNIX Shell Scripting, PL/SQL, Transact SQL, C, Pro*C, VBA, Java, Perl, R

Database Servers: Oracle 7.3.4, Oracle 8.0.5, Oracle 8i, Oracle9i R 9.0.1,Oracle 10g, Oracle 11, Sybase SqlServer 10, Sybase SqlServer 11, MS SQL Server 2000, MS Access.

Tools: ERwin, Designer 2000, Sqlplus, Svrmgr, Exp, Imp, Sqlloader, Bcp, Oracle forms, Oracle Reports, Oracle Portal, Crystal Reports, Business Objects, Oracle E-Business Suite 11i.10, TOAD, Dbvisualiser, Oracle Enterprise Manager, SqlServer Enterprise Manager, RMAN, Oracle DRDA, TCP/IP, Sqlnet, Robohelp, DOORS.

OLAP Tools & Analytical Tools: Cognos, Microstrategy, Informatica.

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Senior Application Developer

Responsibilities:

• Gathering, analyzing and assessing the impacts of reporting requirements from business users.
• Design and develop database and reporting solutions for the implementation of specific reporting requirements.
• Develop, test and deploy backend codes (tables, views, stored procedures, unix shell scripts), schedule and monitor the jobs for incoming and outgoing feeds for order entry requirements.
• Develop front end crystal reports and make the reports available, through Crystal Enterprise, to business users. Provide users with administrative support, using Crystal Management Console, for access to specific reports.
• Create documentation, in accordance with SOX and development methodology guidelines, for requirements, design, test cases, production launch guides and plans.
• Interact with business, development team and production support teams in the resolution of specific Order Entry reporting requirement issues.

Confidential, Cockeysville, MD

Data Analyst/ System Administrator

Responsibilities:

• Daily monitoring, using Active Monitor, of the Fraud Center’s network links to the various data sources that provide both real time and delayed data files for generating call data records (CDRs). Troubleshouting and restarting the links when prompted by email alerts for breaks in data feeds, as well as communicating with appropriate data source personnel in process of reestablishing data feed supply.
• Daily monitoring, using the Mantas Server Administrator and Server Monitor applications, of the transfer and loading process of the call data records (CDRs) from the connectwave server to the Oracle datawarehouses (Infowave servers), ensuring their integrity and availability for the Secureware front end applications where they are used in the detection of fraud patterns.
• Provided system administration support to FPC users of LEC MANTAS Securewave front end applications for fraud detection, in terms of implementing system security procedures for access through user creation and password resets, as well as other user requests like case reopening and unlocking cases.
• Served as FPC liaison person with the MANTAS Support Center in the tracking and resolution of specific system enhancement requests. Testing and debugging the patches and releases before implementation to production.
• Tested and implemented detection procedures against new fraud patterns: Tweaking rules and thresholds and tracking the triggering of resulting alerts and fraud cases.
• Participated in the weekly and monthly gathering and analysis of data on specific fraud detection metrics and implementing the resulting rules change requests from team of business analysts.
• Coordinated on behalf of the Fraud Prevention Center, Confidential ’s Company-wide network conversion process from X25 to TCP/IP. Making appropriate preparations for conversion implementation, participating in all meetings with data source personnel, testing new links and ensuring data integrity through new TCP/IP links.
• The design, implementation and monitoring of a data purge job for the Securewave Oracle 9i database to meet the system performance tuning requirement.
• The design and generation of weekly and monthly metrics reports using crystal reports on a SqlServer 2000 reports database, for use by management team in the analysis of specific system and user performance metrics.
• The Implementation and monitoring of the weekly hot backup of an oracle 9i database on a feeds support Sun OS unix server.
• The design, building and maintenance of a Quality Control Access database for storing and tracking quality control audits. Designing and generating monthly crystal reports for analysis of team and individual quality control performance.
• The conversion of reports stored procedures for Confidential ’s Training and Employee Development Reporting System from Sybase to Oracle using PL/SQL, SqlWays and TOAD.

Confidential, Bethesda, MD

Database Consultant

Responsibilities:

• Performed requirements analysis and designed the entity-relationship data model for the development of Oracle 8i and 9i databases for Comcast Baltimore's FMIS application.
• Installed, configured and created all the Oracle 8.1.6 and 9i databases for development, staging and production on AIX and HP-UX platforms.
• Developed and implemented an Oracle 9i Data Guard Stanby database Solution as the base for continuous database availability and reliability.
• Implemented specific security requirements including the use of Oracle 9i label Security as a solution for fine-grained access control.
• Developed PLSQL stored procedures, functions, packages and triggers for use in application development.
• Provided technical support to in-house team on Oracle database administration by developing and implementing crontab enabled scripts for scheduling and monitoring specific production jobs and processes, and for meeting database storage, security, performance and backup and recovery requirements.
• Implemented process for the periodic migration and integration of data from multiple sources into unified repositories for new canned and ad-hoc report development and analysis for the FMIS system.
• Provided support to internal and external Comcast customers with audit and reconciliation of data flow through the FMIS application.
• Participated in the development of a data warehouse effort for Paribas Bank. Worked in consultation with client team in developing the strategy, analysis and requirements gathering plan for the Paribas data warehouse project. Provided input in selection of infrastructure type, vendor and software best suited for client's devepolment and implementation requirements.
• Designed a dimensional model from requirements gathered by analysts.
• Analyzed the extraction, cleansing and transformation of source information.
• Setup the decision support environment (DW, DM, OLAP Systems and end-user query tools).
• Supported all three layers in terms of data modeling, metadata and data import, and interfaces with the various third-party tools

Confidential, Gaithesburg, MD

Oracle and Sybase database Administrator

Responsibilities:

• Setting up AIX Unix servers for database installation by partitioning the drives, creating the DBA group and Oracle user, and creating and sizing the filesystems.
• Installing, configuring, building to specification and maintaining all client and in-house Oracle 7.2.2, 7.3.4, 8.0.5, 8.1.6 and Sybase SqlServer 11 database environments, ensuring their availability through consistent monitoring of database storage, growth and performance patterns, and implementing and monitoring database backup and recovery procedures.
• Developing and executing Crontab scripts to automate and monitor scheduled jobs in production.
• Setting up and administering database security by creating new users, roles, profiles and views, as well as providing specific user privileges in development, test and production databases.
• Developing, testing and rolling over PLSQL stored procedures, functions, packages and triggers for use by development, product delivery and production teams in development and implementation endeavors.
• Maintaining and making available documentation on all database development and enhancement procedures using ERwin.
• Holding regular and ad-hoc meetings with client to discuss and draw up necessary systems and database enhancement implementation plans.
• Providing periodic instructional classes to development and operation teams in SQL and Transact SQL, data modeling, Oracle fundamentals, database network configuration and connectivity.
• The development and implementation of a cron-enabled daily export backup procedure, an online backup procedure, and a standby database backup and recovery system for specific databases.
• The successful implementation of Y2K compliant databases requirements.
• The successful upgrade of Confidential ’s Oracle databases from Oracle 7.2.2 to Oracle 7.3.4, and the subsequent migration of all Oracle databases to Oracle 8.0.5.
• The design and implementation of business critical quotes usage and user statistics accounting reports using Crystal Reports software.
• The successful development and implementation of procedures for the industry-wide data conversion requirements to decimal pricing.
• The successful implementation of the data migration process for the Old Kent and Fifth Third merger.
• The successful conversion, migration, and integration of the databases of non-clearing clients from the IWB1/VRU1 platform into Confidential 's IWB2/VRU2 platform.
• The successful implementation of an advanced replication system.
• The development of a securities vocabulary update recording and tracking system (VOX Database).
• The development of the new IWB3/ACOP platform, specifically in the logical and physical database designs, and in the design of Crystal reports for the generation and online viewing of securities, quotes and user statistics information.
• Successful implementation of the daily monitoring and monthly cleaning process of Morgan Stanley Sybase databases and the migration of historical data into an Oracle database ( using bcp and sqlloader) for convenience in detailed reports.

Confidential, Rockville MD

Oracle Developer/DBA

Responsibilities:

• Took part in the analysis, design, development and implementation of the TCRS data storage and management subsystem, using Oracle 8.0.5 in a client server environment running on Windows NT and Sun solaris platforms.
• Participated in the TCRS logical and physical database design using ERwin.
• Built the TCRS databases for the development, testing and production environments.
• Developed, tested and made available numerous stored procedures, packages and triggers used by transaction developers in the development of objects for processing transactional requirements, as well as enforcing predefined business rules.
• Wrote scripts used to migrate data from the staging server to the production server.
• Additional tasks included giving assistance to web and transaction developers with database performance issues, implementing database enhancement issues as they arose or were needed, carrying out daily export backup of development databases.

Confidential, Bowie MD

Systems Analyst/ Programer

Responsibilities:

• As a member of the team for the INS User Fee Collection project, I took part in the analysis, design, development and implementation of database system using Oracle 7.2.2 and Designer 2000 in a client/server environment running under Windows NT.
• Considerable input in the strategy and analysis phase of project, including identifying business processes, business rules, entities and their attributes, building E/R diagrams and normalizing the resulting logical model.
• Vital input in generating and refining table and column definitions from logical models.
• Developed the process model and using Developer 2000 forms 4.5 and reports 2.5, designed a few front-end application modules for the system.
• Further accomplishments included the use of ERwin in designing a logical model and implementing a system enhancement project through reverse engineering using Designer 2000.