Sign in

Sr SAS Developer & Analyst

Santa Clara, California, 95050, United States
March 03, 2011

Contact this candidate

Sreenivasa Rao. M


Professional Summary

• 10+ years of technical expertise in data warehousing analysis, design, development, testing and maintenance of large data warehousing projects on Oracle and Teradata.

• Expert data analyst/architect who can provide hands on data solutions featuring ETL, Data Quality, Aggregations, OLAP, and Analytics.

• Very strong knowledge in providing solution architecture and provided solutions for acquisitions integration.

• Extensive Business Intelligence experience using Business Objects versions XI R2/6i/6.0/5.1 (Web Intelligence 2.5, Business Objects Designer, Broadcast Agent, Supervisor, InfoView).

• Creative problem solver/engineer who excels in conceptualizing, analysis, and rapid development of Proof of Concepts, prototyping of industry and company specific data/information solutions.

• Expertise in defining the overall data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts).

• 7+ years of technical and functional ERP experience in Cisco.

• Knowledge on using Teradata tools like Fastload, Multiload, Fastexport, bteq and Tpump.

• Experience in Physical Database Design, Tuning and Optimization on Teradata.

• Expertise in defining technical requirements, technical and data architectures for the data warehouse.

• Expertise in data modeling, logical designing, physical modeling using Relational data Model (3rd Normal form) and Dimensional-Modeling (Star Schema & Snow Flake Schema) techniques.

• 10+ years of experience in Oracle Sql and Pl/Sql.

• 5+ years of experience in Teradata.

• 8+ years experience in Business Intelligence tools Business Objects and Hyperion Essbase.

• Technical expertise in Oracle Goldengate.

• More than 8+ years experience in Informatica (5.x, 6.x, 7.x, and 8.x).

• Strong knowledge in Oracle Forms 6i, 9i and Reports 6i.

• Technical expertise in Essbase Maxl API.

• Expertise in using Unix shell scripts and PL/SQL scripting for batch processing, regular maintenance and production support to load the warehouse in regular intervals.

• Technical expertise in SQL Loader, Export/Import and TKPROF utilities.

• Strong experience in SQL tuning, Data base tuning, Query optimization and indexing creation.

• Effectively managed security provisioning for diverse users & groups for Essbase applications using Shared Services.

• Extensive functional knowledge of Oracle ERP Order Management, Account Receivables, Account Payables, Purchase Order, Purchase Requisition, Fixed Assets and General Ledger.

• Strong knowledge in $U and Appworx scheduling tools.

• Very strong knowledge in Oracle Database Administration and Teradata Database Administration

Software Skills

RDBMS : Oracle 8.0, 8i, 9i,10g, Teradata 5.1,12, MS Sql Server

ETL : Informatica 5.x, 6.x, 7.x, 8.x

BI Tools : Business Objects 6.5,XI, Hyperion Essbase 7, 11, EIS, OBIEE

Languages : SQL, PL/SQL, Java 2.0, PERL, Unix shell Scripting and Maxl API

Tools & Utilities : Toad, Sql Loader, TKPROF, Export, Import, Tpump, Multiload and Fastload

Middleware : Oracle Goldengate

Data Modeler : Erwin 3.5/4.0 5.1, 6.5

Web Servers : Java WebServer 2.0, Web Logic Server 5.0

GUI : Developer/2000 (Forms 4.5 and Reports 2.5)

Oracle Internet Developer Suite (Forms 9i, 6i and Reports 6i)

Operating Systems : Windows 95, NT, 2000, XP, MS-DOS and Unix


• Teradata Certified Master

Work Experience

CISCO SYSTEMS, San Jose, CA 02/2005 – Present

Role: Architect and Technical lead

• Capturing the requirements from legacy applications.

• Involved in delivering standard reports to the executive management

• Involved in designing and creating a Universe with multiple fact tables and several dimension tables

• Implemented Row level and Object level Security and automation of the user upload through SDK

• Involved in logical and physical database design.

• Lead the team in both technical & functional aspects during life cycle of the project.

• Involved in unit and system integration testing.

• Lead and developed FINBI FETCH Universe design & development.

• Presented on Essbase architecture and functionality to both technical and business audiences.

• Helped business users for migrating their reports from legacy to new FINBI Tools.

• Developed the Maxl security code for Teradata FETCH & COA applications.

• Set up SFTP between Cisco server and Acquisition Servers.

• Developed informatica mappings to process Amex pre-trip and post-trip xml files.

• Understood ERP FSG table structures and implemented same in COA Essbase cube.

• Understood the Oracle ERP General ledger functionality.

• Lead the Financial Data Integration project and worked with all Cisco Acquisitions.

• Created dynamic reporting hierarchy based on ERP FSG reports.

• Created a shell script to invoke essmsh scripts to create security filters for users.

• Understood the Cisco business Revenue, Bookings, Expense, Headcount and Chart of Accounts from ERP to data warehouse.

Gymboree, San Francisco, CA 10/2004 – 02/2005

Role: Data Warehouse Architect/lead

• Uploading price lists, changing price lists and discounts.

• Upload and maintain new inventory items.

• Fulfill Adhoc business requirements to analyze various promotion programs.

• Production Job Monitoring and Scheduling adhoc Requests using Appworx

• Performance tuning of long running jobs and implementing alternative approaches.

• Analyze Data issues and Implementing Data fixes.

CISCO SYSTEMS, San Jose, CA 07/2003 – 09/2004

Role: Onsite production support team lead

• Familiar with all the modules in Enterprise data warehouse.

• Migrating the mappings and sessions to Production folder after testing.

• Testing the standards of Pl/Sql code before moving it to production.

• Testing the standards of mappings.

• Testing the mappings in debugger mode.

• Monitoring the jobs using $U and from UNIX shell

• Analyze the long running queries and tune the queries if they weren’t properly tuned

• Listing down all the activities caused to miss the service level agreement of a job.

• Holding some jobs during month end load in $U.

• Resolving data issue cases opened by Business.

GE Plastics, Netherlands 01/2003 – 06/2003

Role: Team lead

• Involved in business Requirements Analysis

• Logical and Physical Design of the proposed data mart Approach to management of Meta data.

• Development, Testing, Integration of the solution

• Deployment of Direct Material Cost Data mart.

• Distributing work to the team members

British American Tobacco, Dubai 08/2002 – 12/2002

Role: Team lead

• Study of functional requirement specifications.

• Analysis and design of requirements.

• Design the data model.

• Involved in database programming with SQL and PL/SQL

• Designing unit test cases

• Developing Forms and Reports

Strabus, India 06/2000 – 07/2002

Role: Developer

• Study of functional requirement specifications.

• Analysis and design of requirements

• Design the data model

• Involved in database programming with SQL and PL/SQL

• Developing Forms and Reports

• Designing unit test cases

Educational Qualifications:

• Master of Computer Applications from Regional Engineering College ,India

Contact this candidate