SUMMARY:

• Seasoned IT professional with 20+ years of experience, overseeing areas of IT policy, strategic planning, and project implementation and have seen just about every problem and issue relating to infrastructure/database and IT technology.
• I have a forward looking global perspective of all issues at hand as well as how the technology details can impact the bottom line and its macro implications.
• My decisions are based on my 20 + years of experience, determining the risks involved, the long term ROI, and also having seen and experienced similar circumstances.
• I also have excellent conflict resolution and negotiating skills.
• Always learning/reading on new IT technologies and how they can be adopted.
• Senior Project Business Systems Analyst/Technical Lead, with 20+ years of experience, overseeing areas of IT policy, strategic planning, and project implementationwith strong experience with infrastructure/database and IT technology.
• Adept in analyzing and creating detailed specification documents BRD and FRD, user stories, test cases, define deliverable content, and ensure buy - in of proposed solutions from top management levels of the client
• Expertise in studying existing Business Processes, check existing data and systems to check feasibility of process changes, drawing up requirement for improvements.
• Convert the changes into detailed business requirements, Worked closely with the IT Management to prioritize and coordinate individual project tasks and assess time on development tasks
• Experienced with the full software development life cycle (SDLC) Adept at overseeing all facets of project lifecycle, including initiation and planning; change, risk, and issue management and guiding project teams.
• Exceptional verbal and written communication skills. Able to successfully build strong working relationships with coworkers and clientele, while ensuring cooperation among company departments.
• Hands on ability to troubleshoot any system performance issue and immediately pinpoint the problem (server, database, sql statement, software design, network, infrastructure design, etc.) and tune/fix or remediate it.
• Expertise with complex data structures and a proficiency in SQL.
• Excel skills including (but not limited to) VLOOKUPS, pivot tables, formulas, functions and reporting.
• Expert in agile and waterfall project management methodologies.
• Known for ability to produce high-quality deliverables that meet or exceed timeline and budgetary targets.
• Excellent at multi-tasking; able to efficiently plan and prioritize projects.

KEY ABILITIES:

• Exceptional verbal and written communication skills.
• Excellent ability to quickly learn new technologies and applying them.
• Self starter and inquisitive. Willingness to learn new business domains
• Able to successfully build strong working relationships with coworkers and clientele, while ensuring cooperation among company departments.
• Worked 4 years as a Senior Managing Principal Consultant at Oracle Corporation managing 10+ DBAs on various projects.Technical Team Lead/DBA/Supervisor10 years.
• Taken class for preparation for PMI (Project Management Institute) Exam and also familiar with best practices in project management from PMBOK book.
• I am currently a Manager/Project Managerfor Production Services for Global Risk Management at Confidential working with business project managers, analysts, and developers.
• Making recommendations, plans, processes, and procedures for the adoption of new database related technologies.
• Also working on new strategic applications, development/production projects.
• In addition, I have experience as a software developer with full SDLC experience.
• I'm an experienced IT professional who has dealt hands-on with all aspects of IT infrastructure design and planning.
• My strong database knowledge includes Oracle, MS SQL Server and UDB/DB2 and I'm an expert senior Oracle DBA and experienced in the design and architect of databases for high availability and security.
• I have also worked with Oracle 11gR2, 10g, RAC, Linux, UNIX, and Windows environments.
• My ERP implementation experience have been with PeopleSoft (3 major upgrades), Oracle, and BaaN. Knowledge of CISSP, ITIL. I have always been a believer of putting in solutions which are best practices and re-usable.

TECHNICAL SKILLS:

Hardware: Linux x86 Servers, Sun Enterprise Servers, Wintel, HP-9000, Dec Alpha, IBM, EMC SRDF, Veritas

Operating Systems: UNIX, Linux Redhat, Solaris 5.8, HP-UX 10.2 - 11.0, IBM AIX 4.3, LINUX, Windows XP/7, DEC Alpha OpenVMS, Databases ORACLE, UDB DB2, MS SQL Server 2008/2012

Programming Languages: Unix Shell Scripts, SQL, PL/SQL, C#, .NET,VB.NET, COBOL, FORTRAN, C, C++, Java, HTML, Visual Basic, Basic, Pro*C, Pro*COBOL, IBM Report Writer

Networking: SQLNET, TCP/IP, Novell, Banyan Vines, Ethernet 802.3/802.5 , IBM Token ring

Other Software Tools: Autosys, FTP/SFTP, Microsoft Word, Excel(Pivot tables, VLOOKUP, HLOOKUP), PowerPoint, Access, Project

Oracle Products: Oracle 7.3 - 11gR2, Oracle Enterprise Manager, PL/SQL, SQL*PLUS, SQL Loader, SQL Server Migration Workbench Oracle Java Developer Workbench, Oracle Parallel Server, SQL*Net, Flexfields.

PROFESSIONAL EXPERIENCE:

Confidential

Manager/Technical Project Manager

Responsibilities:

• Resource management and single point of contact
• Involved with high transactional systems (eg. P&L systems, order entry systems, trading activity systems)
• Running/working with reconciliation systems, attention to details and matching incoming requests and keeping track of transactions completed and in error is required. Monitoring of FTP and SFTP files to production systems.
• Working with data analytics/BI and data team with minimal direction on problem statements with various production support personnel.
• Monitoring Informatica/operation and usage of ETL routines, and Qlikview (dashboards/reports)/MathLab
• Involved with recording and position balancing systems with specific technical skills in Unix shell scripting and deep knowledge in Perl.
• Responsible for coordinating, defining, staffing, and managing one or multiple projects. Working across the business, IS management, Quality Assurance and Testing, Systems Analyst, Software Development, and Technical Writing teams to ensure the delivery of a high quality software application.
• Primary technical point of contact with management and various technical personnel on project from project inception through completion. Develops project schedules, coordinates project status meetings, manages resources in all phases of software development lifecycle.
• Working with the project business owner to oversee delivery performance, ensure delivery quality and report schedule, cost, and execution performance.

Confidential

Proj. Mgr./Lead Oracle DBA

Responsibilities:

• Resource management and single point of contact
• Worked closely with multiple application development teams offering technical solutions to their new and current projects needs
• Work alongside multiple Production Support, Application Development, System Admin, Project Managers and Engineering teams
• Provide database design, configuration, end to end support for Oracle databases, upgrades, query performance & tuning analysis and best practice implementation for distributed and clustered forms, data center migration planning/logistics, platform migration
• Database security/hardening, security using Vormetric encryption, and RMAN recovery, understanding of Data Guard and Active Data Guard
• Install/troubleshoot CRS, ASM, and RAC configurations in Oracle 11gR2 on Linux
• Oracle Monitoring with Grid Control, AWR analysis
• Working with Development teams - Design & Code Reviews, SQL support, Change Request validation
• Oracle query Performance Analysis & Tuning, including maintenance of monitoring scripts and reporting their results
• Act as point person for application delivery and engineering group when defining how databases should be used in new applications
• Managing incidents, ensuring rapid restoration of service, thorough root cause analysis (RCA) and implementation of corrective measures
• Lead other team members, work with Application Delivery teams to drive improvement in the processes and tools used
• Implementing new upcoming projects and upgrades
• Definition and implementation of data archiving strategies
• Writing Tools and Utilities - unix shell, awk, sed, SQL, Perl, and Python
• Control-based remediation work e.g. of database permissions
• Maintain, develop and co-ordinate releases application, and access control software
• Financial knowledge: Actimize, AML, Prime Brokerage Services. Credit Risk, IT Governance, KYC, Auditing and Compliance, Fixed income, Derivatives martket, Foreign Exchange, Back Office Trading operations

Confidential

Proj. Mgr./Senior Architect/Technical Database Lead

Responsibilities:

• Hands-on role - Involved with performance tuning of MDM (Master Data Management) application for development, UAT, QA, and production Oracle 11gR2 RAC environment.
• Worked as Technical Project Lead to upgrade all Oracle database versions (8i and 9i) at a major Financial company to Oracle 10GR2/11GR2 RAC, Oracle Clustering and ASM in anOracle Solaris/Linux RAC environment.
• Hands on and ensuring that the requirements of the business users are captured, documented and clearly understood by development, QA, and other IT groups before a solution is developed and implemented while being sensitive to risks and controls.
• Working with Program Managers/DBA Manager and application team project leads to coordinate database testing of newly migrated environments.
• Production application and development application database support.
• Coordinating work with off-shore IT team as well.
• Last major project was a very aggressive deadline to upgrade 50 Oracle databases from release 8i/9i to Oracle 10g/11gR2.
• The sizes of the databases ranged from 5GB to 1TB. Also worked as Project Lead for a data warehouse team at Confidential Insurance.
• Hands-on role -Proj. Mgr/Senior Technical Lead Oracle DBA .
• Hands-on role - working in the Enterprise Management Systems area in the role of Oracle database SME and advisor to the applications team and ensuring best practices are being used with regards to the Oracle database application.
• Responsible for analyzing the needs of users to help identify database problems and initiate the process for proposing solutions.
• Also ensuring that the requirements of the business users are captured, documented and clearly understood by development, QA, and other IT groups before a solution is developed and implemented.
• Also responsible for database performance tuning and issues during development.In-depth knowledge of AWR, ADDM reports.
• Coordinating/working with off shore database team members. Planning and executing new database projects and applications. responsible for”MODEL N”database development and testing of new consolidated contract billing application to replace approximately 45 disparate contract and billing applications. analyzing existing ETL processes and making recommendations for improved performance, application rewrite, SQL tuning working on operational data stores (more than 3 TB) with data architects and implementing/creating physical models from data models using ERwin, assist in performance and loading issues

Environment: HP-UX, IBM AIX, and Oracle RAC on Linux on RAC (10g/11g). Using ERWin ver. 8 to view entity relationships and translating logical models to physical models for a datamart of 10TB.

Confidential

Proj. Mgr/Senior Technical Lead Oracle DBA and Assistant VP

Responsibilities:

• working with business application stakeholder to meet project schedules interfacing with business analysts to define functional requirements advising and acting as database subject matter expert to PL/SQL and Java application developers with regards to schema objects and application design and best practices (SQL code review/consulting).
• Impact analysis of changes of how entity attributes affect dependencies in the database and physical structures hands on operational production and development support, release management, and ensuring SLAs are met, working with Oracle Support to identify and resolve database issues.
• This was for the corporate systems of HR and compliance system performance tuning, query tuning and optimizing, and configuring hardware and software to support the global infrastructure, developing scripts to automate processes do the strategic planning and analysis of the new and existing databases and infrastructure needs forecast data storage capacity needs and Unix host machine requirements planning/coordinating/migration of database infrastructures from current to new data centers - this involved working closely with Unix SA teams, storage teams, network teams and the user community plan new database project requirements and also securing the data making sure application adheres to the Sarbanes-Oxley regulations as set forth by the Government actively involved with configuring and planning of EMC storage requirements/SAN and SRDF for the production databases and also configuring them for HA (High Availability)and scalability participate in scheduled disaster recovery drills for the database and infrastructure environments to satisfy the firms Business Continuity Planning efforts. creating new databases instances, using RMAN for backing up/restoring and recovering databases, database cloning upgrading of databases from major releases, Oracle 8i to 9i, Oracle 9i to 10g, Oracle 10g to 11g, and also applying needed patches and Critical Patch Updates (CPU) migrating of production, development, and UAT databases to newer and faster Sun hardware creating Unix shell scripts, Perl scripts, SQL scripts, SQL report queries, and writing PL/SQL applications (materialized views, stored procedures, packages, triggers, sequences, functions) as required working with Oracle CDC (Change Data Capture) and Streams for maintaining tables synchronization supported Options trading applications, financial applications, and Corporate payroll, benefits and Bonus Systems, Employee Performance Management, CRM, Employee and, New Hire On-boarding, Contactor/Consultant Time and Attendance, Stock Bonus application supported 24x7 Global PeopleSoft HR OLTP system (version 7.0 to 8.9) and PeopleSoft Financial applications through major release upgrades, also supported and configured PeopleSoft PIA infrastructure (Application servers using BEA Weblogic and Tuxedo) rotation support of databases as well as weekend and holiday support as needed worked on asset and configuration project for data and data warehouse which required analyzing data, data modeling, physical data modeling, and performance tuning.
• Additional skills needed were PL/SQL, materialized views, writing complex sql queries, extracting data from different sources, and data replication, database partitioning.
• Logical modeling of the data data, and using ERWin to create lview entity relationships and translating logical models to physical models. keeping abreast of new, and advanced database technologies and how they can used

Confidential

Senior Managing Principal Consultant

Responsibilities:

• Oracle Professional Consulting Services, responsible for managing a team of 10 - 15 Oracle DBAs at various customer locations in the relationship building, and interfacing with client management in determining the kinds of Oracle on-site project management support needed.
• The projects included providing DBA production and development support, performance tuning, database design, and databases for high-availability.
• Analyzing and determining the scope and objective of projects and managing of the projects at the customer site.
• Solving complex and difficult database and infrastructure issues.Delegating responsibilities and also being hands-on while supporting the client.
• I was also part of a PeopleSoft Center of Excellences team providing technical assistance for PeopleSoft ERP modules for performance and tuning.