PROFESSIONAL SUMMARY

• 10 years of experience in Information Technology including 8 years as Business Intelligence Developer/Architect, 2 years as Database Architect/Database Administrator comprising
• Expertise in wide spectrum of business applications in the areas of Banking, Insurance, Retail, Energy, Automobile and Market Research with different clients in USA having global operations
• Infrastructure support and development of applications on SAP BO technology stacks
• Multiple full life cycle DW/BI projects with end to end solution build including business requirements gathering, source systems analysis, data model and architecture design both relational and dimensional modeling , ETL Extract, Transform and Loading design, reports design, development of Dashboards, Scorecards in complex reporting environments
• DW/BI architecture and database assessment, recommendation of future state roadmap for scalability and performance on various DW/BI and database environments
• Expertise in applying best practices in databases, DW and BI domain to manage applications, systems and databases and also in ensuring desired Service Level Agreement SLA for customers
• Performance monitoring and tuning of databases, DW/BI applications
• Design and deployment of high availability OLTP, OLAP databases
• Management, administration and pro-active monitoring of 24x7 VLDB on Oracle including Real Application Cluster RAC on Unix/Linux on Windows platforms, management and administration of 24x7 SQL Server databases on Windows
• Project management, project planning, requirements definition, capacity planning, technology evaluation and recommending appropriate system solution to business units including consolidation of servers and databases to reduce cost

SKILLS SUMMARY

BI Tools SAP BusinessObjects BI 4.0/BOE XI 3.x consisting of Central Management Console CMC , Universe metadata modeling tool , Web Intelligence ad-hoc query/reporting , Xcelsius dashboard tool , Desktop Intelligence, Live Office Query as a Web Service connectivity tools for external data sources , InfoView Portal, Life Cycle Manager LCM , Report Conversion Tool

DW ETL Tools Informatica PowerCenter 8/9, MS SQL Server Integration Services 2008/2012 SSIS , MS SQL Server Analysis Services 2008/2012 SSAS , Oracle PL/SQL

Databases Oracle 11g, 10g, 9i, 8i, 8, SQL Server 2012, 2008 2005, DB2 LUW v8/v9 on Unix

Application Servers Apache, Oracle Application Server 10g, 9i

Other Tools SQL Server Management Studio, BMC Pro Active Net and Xymon for server monitoring, Spotlight and Foglight from Quest for database monitoring, Oracle Grid Control, ERWin Data Modeler 4.x including ModelMart, Tool for Oracle Application Development TOAD from Quest

Operating Systems Red Hat and SuSE Linux, Sun Solaris, HP Unix, IBM AIX, Windows

EXPERIENCE PROFILE

BI Architect/Developer, Project Manager Confidential

• Primary responsibilities include managing multiple project teams and providing technical and project support on DW/BI project implementations.
• Some of the project related tasks included the following:
• BI Analyst and Developer for gathering business requirements, prototyping, design, build and implementation of reporting solutions, dashboards and scorecards using various BO offerings including Web Intelligence, Desktop Intelligence, Xcelsius Dashboard, Live Office, Query as a Web Service
• Design and creation of report metadata by business function in BO Universe Designer tool for end user analysis, ad-hoc query and self-service reporting needs
• Report design of different types including parameterized, cross-tab, drill-down, drill-thru, summary and burst reports using BO tool set v3.x and v4.0 such as Desktop Intelligence and Web Intelligence
• Performance tuning of BO reports end-to-end including tuning of SQL statements on back-end databases such as Oracle, SQL Server and DB2
• Migration of BO client Desktop Intelligence reports to web version Web Intelligence using BO Report Conversion Tool
• Management of BOE BO Enterprise systems in Development, Stage and Production environments using Central Management Console including various services and jobs on Windows platform
• Infrastructure support role in installation, migration of BO 5.x to BOE 3.x, upgrade of BOE 3.x to BO BI 4.0, adding of new BO server instances for load balancing, migration of applications to different BOE environments on a continuous basis using BO Lifecycle Manager LCM tool
• Management of Informatica 9.x/8.x servers in Development, Stage and Production environments including ETL jobs on IBM AIX platform thru Informatica Administration/Support console and by using Informatica Metaquery tool, SQL statements
• Analyst and Developer for design and deployment of data warehouses, data marts comprising various transformations and integration of end-to-end ETL data loads sourcing data from databases including Oracle, SQL Server, DB2 LUW, SAP R/3 and BW. The ETL tools used included Informatica PowerCenter 9.x/8.x, SQL Server 2008/2012 Integration Services SSIS , Oracle PL/SQL
• Delivery Lead responsible for client project deliverables with onsite/offshore model consisting of both technical and project management staff

Database Architect/Database Administrator Confidential

• Reporting to IT Director, primary responsibilities included managing a team of database administrators supporting Oracle databases on Sun Solaris, Linux and Unix platforms, SQL Server databases on Windows platform.
• Some of the project related tasks include the following:
• Managing and migrating Oracle 9i, 8i, 8 databases to 10g RAC, providing high availability and scalability of applications by managing 3-node Oracle 10g Real Application Cluster RAC database using PolyServe Matrix Server cluster software
• Management of Oracle Application Server 10g, 9i as mid-tier including Collaboration Suite for web based applications and email system
• Streamlining of backup procedures using Recovery Manager RMAN and Legato media management software for Oracle databases
• Pro-active monitoring of database instances by configuring Oracle Grid Control using Oracle Management Server OMS and Oracle Enterprise Manager OEM
• Performance monitoring and tuning using Automatic Workload Repository AWR and OEM
• Administration of SQL Server 2005/2000 databases on Windows platform
• Replication setup of distributed data for Oracle and SQL Server databases in different geographical locations spread across the globe for external clients
• Additional responsibilities included:
• Evaluation of existing database instances and consolidation of servers to reduce costs
• Supporting a large team developers with logical and physical database design, data model, implementation of database changes, design and build of ETL and Reporting solutions for various clients on Microsoft BI and Oracle BI platforms