Sai Ram Kakumanu

CISCO Information Server (CIS) and DENODO Developer

Data Virtualization Expert

Phone: 425-***-****

Email: ac2gnh@r.postjobfree.com

Professional Summary

Overall 5.5 years of experience working on Data warehousing, Data Virtualization and Data Modeling in Finance, Banking, Healthcare, Transportation business domains. Efficiently carried out Agile, Waterfall Software Development Life Cycle methodologies.

Over 3 years of experience in Data Virtualization using CISCO(Composite) Information Server on development and admin related tasks

Excellent knowledge on Data Modeling e using Erwin, ER Studio IBM Rational System architect for Dimensional Modeling, Relational Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data mart, OLTP, OLAP, FACT Dimensions tables, Physical and Logical data modeling.

Strong knowledge in business analytics using SAP and Microsoft business intelligence products.

Developed TIBCO Spotfire dashboards and reports on top of large datasets with data virtualization techniques using CISCO Information Server (CIS) tool

Experience in data cleansing procedures and data transformation and mapping from source to target database schemas using ETL tools.

Experience with Data Visualization tool like TIBCO Spotfire version 5.x/6.x Configurations

Experience configuring and administering Spotfire Server components TIBCO Spotfire Application Data Services, Automation Services.

Over 3 years of Experience in Data Virtualization with Denodo.

Experience in creating Base Views, Derived Views, Joins, Unions, Projection, Selection, Union, Minus, Flatten Views, Interface and associations of data service layers in Denodo.

Worked on development projects that were based on Data Virtualization concepts and creating web services in Denodo.

Implemented best practices designed to optimally retrieve and process data from various interfaces going into and out of CIS Virtualization layer.

Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball and Inmon data warehouse methodologies.

Proficient in forward and reverse engineering using tools like CA Erwin, ER/Studio

Proficient in developing reports using Microsoft Reporting Services SSRS with Report Authoring, Report Management, Report Delivery and Report Security.

Professional skills

Data Modeling /

Design Tools

CA Erwin 9.5/7.3.3/7.1/4.1, ER/Studio 8.0.3, Sybase PowerDesigner, Oracle SQL Developer Data Modeler 3.1

Other Tools

Toad, SQL Developer, Query Analyzer, SQL*Plus, SQL*Loader, XML,, Quality Center, SQL Server Management Studio, MS Office (Word, Excel, PowerPoint), MS Project

Data Virtualization Tools

CISCO (Composite) Information Server – CIS, Familiarity with Denodo, VMware.

Scripting

Unix K-shell Scripting

RDBMS & Reporting

Oracle 11g/10g/9i, SQL Server 2008/2005/2000, DB2, and MS Access 2010/2003, Teradata, SQL, PL/SQL, T-SQL, Tibco Spotfire

ETL Tools

SQL Server Integration Services(SSIS)

Professional Experience

FedEx Services, Milwaukee, WI Aug 2014 – Aug 2017

CISCO Information Server (CIS) Developer

Project Description:

FedEx is one of the world's largest logistics companies that revolutionized the delivery of packages and information. Corporate, Field Sales, Inside Sales, World Wide Sales (WWS) representatives will generates reports to check territory productivity.

Responsibilities:

Developed TIBCO Spotfire dashboards and reports on top of large datasets with data virtualization techniques using CISCO Information Server (CIS) tool

Devise and implement best practices designed to optimally retrieve and process data from various interfaces going into and out of CIS Data Virtualization layer.

Involved in Cisco Information Server (CIS) initial setup, installation and admin related tasks to implement Logical layer

Created scheduled jobs for data extracts and report reloads by Denodo Scheduler.

Designed Logical data model and Physical Conceptual data model using ER/studio Data Architect.

Involved in data cleansing procedures and data transformation and mapping from source to target database schemas using SSIS ETL tool.

Designed the ER diagrams, logical model (relationship, cardinality, attributes, and candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements using ER/studio.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Involved in Data analysis using Data Visualization tool TIBCO Spotfire version 5.x/6.x Configurations Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Environment: Cisco Information Server (CIS), Tibco Spotfire, SQL Server 2012/2008, SQL Server Integration Services (SSIS), SSRS, Business Intelligence Development Studio, Visual Studio, Denodo Express 6.0.

Discover Financial Services, Phoenix, AZ Jan 2013 – July 2014

Data Virtualization Consultant (CIS)

Developed TIBCO Spotfire dashboards and reports on top of large datasets with data virtualization techniques using CISCO Information Server (CIS) tool

Implemented best practices designed to optimally retrieve and process data from various interfaces going into and out of CIS Virtualization layer.

Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.

Developed, deployed, and monitored SSIS Packages.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.

Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQL Server 2008, Cisco Information Server (CIS), SQL Integration Services (SSIS), MS Access2010, Office2010, Windows Server 2008.

St. Jude Research Hospital, Memphis, TN May 2012- Nov 2012

MSBI Developer

Create new tables, views, indexes and user defined functions.

Actively designed the database to fasten certain daily jobs and some stored procedure.

Created SSRS reports for Franchise Health Reports.

Created User list first title played reports.

Created reports by retrieving the data from cube using MDX reports.

Designed reports, Graphs and deployed reports to web applications using SSRS.

Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.

Designed MDX queries to retrieve data from SSAS cubes.

Created SSIS packages for File Transfer from one location to the other using FTP task.

Designed Cube partitioning and incremental synchronization for SSAS cubes.

Involved in performance tuning of TSQL queries and Stored Procedures.

Optimized query performance by creating indexes.

Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.

Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.

Environment: Windows XP, Windows 2008, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2008, SSIS, SSRS, SSAS, ERWIN.

Lend Key, Orlando, FL OCT 2011 - APR 2012

MSBI Developer

Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.

Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.

Performed Database code Migration from SQL Server 2000 to 2005 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.

Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.

Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.

Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.

Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.

Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: Windows 2008 Advanced Server, MS SQL Server 2008, MS Outlook, TSQL, Erwin, SSIS, SSRS, SSAS, VB

Contact this candidate