|
| Senior Database Administrator, Data Warehousing Engineer |
| Sports & Fitness : General |
| 03/15/06 |
*******************************************************************************
If interested in this candidate, please email us at mike@ists-inc.com
*******************************************************************************
Raj
OBJECTIVE: I desire a position with the kind of leading firm that delivers and expects excellence in Database Administration, Data Warehousing, OLAP development, Project Management and Quality Assurance.
EMPLOYMENT HIGHLIGHTS: Demonstrated track record in managing IT operations and delivery. Executed long-term technical plan for enterprise hardware and software infrastructure.
EDUCATION: M.S. in Mathematics
SKILLS / PROFICIENCIES:
Certified Project Management Professional from Project Management Institute, USA
Key member of the team in ISO and CMM certifications for the organization
Good at six sigma methodology
Good at Oracle PL/SQL and DBA skills
Programming - Fluency in C++, C, Perl, SQL, and various scripting languages. Familiarity with markup languages including XML, HTML and good at Sybase replication server administration.
Databases Oracle, Sybase, MS-SQL server, MS-ACCESS
Networking - Experience with TCP/IP networking, client/server and n-tier server architectures.
Internet Infrastructures - Familiarity with common internet software technologies including web servers, applications servers (BEA Web logic.
ETL Tools Informatica Power Center, Oracle Warehouse Builder
Operating Systems - Knowledge of and development experience on Windows and UNIX based platforms.
Data Warehousing - Fluency in enterprise Data Warehousing architecture and OLAP applications.
OLAP Products - Siebel Analytics , Hyperion
EMPLOYMENT HISTORY:
Cisco Systems San Jose, CA (working as contractor)
Business Intelligence Consultant August 2005 until date
Successfully implemented Data Warehouse.
Architected the data model and lead development team.
Led development team and over all responsible for Dashboard delivery.
Prepared Kimball matrix for repository model.
Designed specifications for ETL and developed mappings in informatica.
Import of metadata into the Siebel Analytics Administration tool and demonstration of the data in Siebel Analytics Web.
Database Systems Management including data warehouse performance tuning.
Created of Siebel Analytics Dashboards Repository
Perot Systems San Francisco, CA
Sr. Specialist, Database Management October 2000 July 2005
Served as an onsite IT consultant for an Asset Management and Leasing company. Worked to design, implement, and maintain software to support Tritons billing, reporting, Data Warehouse, OLAP, Business continuity plan and operational needs.
Managed the team responsible for systems availability to users in 24X7environment.
Set and enforced standards and policies with respect to security, backup, disaster recovery, hardware and software compliance. Managed the database storage structures and user access and security.
Worked closely with user groups to determine appropriate data warehouse architecture and data modeling designs in order to maximize benefits.
Developed scripts using perl, k-shell in HP-UNIX to monitor systems health and pro-active tasks.
Delivered Data Warehouse Architecture roadmap definition and documented System requirements, ETL design and process automation , OLAP architecture and design, Metadata management design.
Established, met and reported on service levels agreements such as system availability, problem resolution times. P&L responsibility for approximately $500,000 annually.
Worked with account leadership team and provided inputs to budgeting, forecasting, new Project scope.
Served as primary liaison between users and the information systems management team. Communicated concerns bi-directionally, and worked to resolve issues of concern.
Performed upgrades of the database and software to new release levels. Proactively monitored the database's health and took preventive or corrective action as required. Tuned performance to optimal level.
AMS Informatics Inc., San Jose , CA
Lead DBA May 1997 September 2000
AMS is a software development-consulting firm having presence in USA, UK, Germany and India. Worked with Wells Fargo, Cisco Systems, PG& E for software development/consulting projects.
Installed Database servers on HP-UX, upgraded and maintained in 24X7environment.
Developed scripts in K-shell and Perl for scheduling jobs and day-to-day DBA tasks.
Set up 3-way replication between OLTP, Reports and Disaster servers.
Developed stored procedures / triggers and scripts to populate data to Data Warehouse.
Developed thresholds in databases for better monitoring log space and data space issues.
Conducted training to developers for new features in the upgraded environments
Provided technical leadership, project management, and personnel management
AT & T, Redditch , UK
On-site DBA May 1996 April 1997
Lead the on-site Development team for the Insurance product for General Accident Life, York, UK. Interacted with offshore development team based in India.
Managed schema objects, such as tables, indexes and views. Created database backups and performed recovery when necessary.
Role involved substantial interaction with client, including frequent onsite visits for meetings to discuss product requirements and project progress.
Square D Software Ltd., Chennai, India
Associate Consultant May 1995 April 1996
Lead software application development projects with compliance to CMM Quality Process level V for various clients in UK and India.
Rizvi Software Consultants, Mumbai, India
Project Leader December 1992 April 1995
Lead a team of programmers. Design, develop and implement UNIX based client-server applications using ORACLE and third party tools.
Physical database design using Oracle. Forward and Reverse engineering of databases using CASE tools. Document technical specifications for program development.
Implement ISO standards for software development.
OMC Computers Limited
Sr. Systems Analyst October 1990 November 1992
Systems Analysis and develop software for the computerization of Foreign Exchange department of Dena Bank, India using Oracle and COBOL.
Total Branch Computerization using COBOL, Oracle and third party tools under HP_UX and DRS IRIS systems.
Responsible for design, development and implementation and team performance.
Hyderabad Allwyn Limited, Hyderabad, India
Systems Analyst March 1988 September 1990
Developed UNIX based distributed database applications using ORACLE and related tools.
Designed and implemented UNIX based financial applications and production-planning using UNIFY.
Team member in Programming, documentation of user manuals, Co-ordinate with user departments, data verification and validation and user training.
*******************************************************************************
If interested in this candidate, please email us at mike@ists-inc.com
*******************************************************************************
|
|
