Quality Assurance Data

Venkat Kannepalli Cell: 732-***-****

Email: ***********@*****.***

PROFESSIONAL SUMMARY

Over 19 years of IT experience in software development and leading with BI Enterprise Reporting, Relational Databases,

Data Warehousing, Client Server applications and Mainframes. This includes 9 years of OBIEE / Siebel Analytics and data

warehousing experience and over all 14 years of Enterprise Reporting experience. Experienced in all aspects of the

software development life cycle (SDLC); such as Project Management, Requirement Analysis, Design, Build, Integration,

System Test, Quality Assurance and implementation. Strong ability to analyze and translate business needs into broad based

technology and process efficiencies.

Tools & Technical Skills:

• 18+ years IT experience, 9 yrs focus on BI OBIEE 11g & 10g, OBIA Case Management and Siebel Analytics 7.8.x

and 13 years of Enterprise reporting experience

• OBIEE 11g, OBIA (Case Management module) & BI Publisher

• OBIEE 11g, Data Warehousing, ETL, Informatica, DAC, Oracle, MS SQL server, ERWIN, Microsoft Visio

• Configuration of Metadata, evaluation and review, dashboard/answers, Reports & Charts and Agents / iBots in

OBIEE 10x, Siebel Analytics 7.8.x/7.7.

• Data modeling, ETL Source & Target data mapping

• Level based measures, dimension hierarchies, complex metrics, aggregation, embedding content and Briefing

books configuration

• Siebel tools BI apps (Siebel CRM) Call Center Analytics

• Siebel Call center, Siebel Services & Siebel Sales

• DAC configuration

Databases: Oracle 11g, MS SQL Server 2000 & DB2

Languages: PL/SQL, XML, HTML, Java Script, COBOL

Industries: Finance, Government, Services, Railroad, Telecommunications, Insurance & Manufacturing.

PROFESSIONAL EXPERIENCE

BI Lead / Architect

City of New York

New York City Housing Authority (NYCHA), New York, NY

May 2012 – Present

• Currently leading and managing end to end development of 2 different OBIEE and one OBIA (Case Management) BI

Dashboards/ Reporting projects.

• Lead the Oracle BI Team thru complete life cycle of the BI projects

• Using SDLC methodology to form the framework for planning & controlling the creation of dashboards & Reports for

3 different teams.

• Evaluates options for meeting user needs, and ensures that system requirements are identified, prioritized and

incorporated in an effective, efficient manner.

• Developed and managing project plans through overseeing the on time completion of all work.

• Create, design, deliver and facilitate meeting agendas, meeting minutes, and document and refine work flow

processes and stakeholder notification, etc.

• Converted existing Oracle Apex reports into OBIEE and BI Publisher Reports (

XML Reports) and embedded into the dashboards

• Did GAP Analysis for integrating the data into Data warehousing from multiple sources using ETL Source Target

mapping for BI reporting

• Did Data modeling and build Star and Snowflake schemas for BI Metadata (RPD)

• Designed & Implemented the BI Security Model

• Responsible building new RPD plus enhancements & modification.

• Built OBIEE Dashboards, Reports and BI Publisher Reports

• Be a point of contact for all OBIEE & Data Warehouse & ETL (Informatica) configuration related issues

• Oversee test plan(s) development, test cases, tracking issues & resolution, go/no go checkpoints.

• Work with Business Team to understand the requirements and built the dashboards based on the requirements.

• Working closely with database team about data architecture, data modeling & ETL related activities and data loads.

• Trained Business users on OBIEE.

BI Architect

Citco (Hedge Funds Financial Services), Jersey City, NJ

January 2010 – January 2012

• Lead end to end management and developed of various Hedge Fund Portfolio Risk Reports and Dashboards for Citco

Hedge Fund clients Risk Data warehouse in OBIEE 10g/11g environment.

• Lead BI developers through complete project lifecycle.

• Built data models, Star and Snowflake schemas.

• Used SDLC methodologies in the complete life cycle of the project.

• Lead team to provide problem analysis, proactively manage problems and make decisions to reach resolution and

closure.

• Responsible for RPD enhancements and modification.

• Worked closely with Financial Risk Data warehouse team to build complex financial reporting aggregates into

database views.

• Built all the new Financial Hedge Fund Risk reports and OBIEE Dashboards, BI Publisher Reports and complex

financial reports and their maintenance.

• Be a point of contact for all OBIEE configuration related issues

• Worked with the Business Team to understand the requirements and built the dashboards based on the requirements.

• Worked with QA team in writing test scripts and OBIEE related fixes / questions.

• Helped the Production support team as Level 3 support.

• Worked closely with database team about data architecture, data modeling related activities and data loads.

• Managed all QA and Production releases.

• Migrated all the 10g Catalog, RPD to 11g environment.

• Trained Business Users team on OBIEE Reporting & dashboard usage.

Computer Systems Manager

City of New York

Department Of Information Technology & Telecommunications (DoITT), New York, NY

April 2005 – January 2010

• Be a point of contact with development team, QA team, production support team and technical architecture team for

properly completion project and deployment of OBIEE metadata RPD, Webcat, Informatica objects, DAC from

Development into Test, Stage and production environments

• Develop high reports consisting of complex charts and graphs in BI Publisher

• Defects Management, managing weekly minor releases, major releases

• Tracking post deployment issues

• Be a point of contact for all configuration related issues

• Integrated Weather data with the 311 Call Center data to see the call volume against varying weather conditions

• Built Dashboards, Reports, iBots (Scheduling Reports/Dashboards), Security, Metadata (building Physical, BMM &

Presentation layers)

• Built Informatica Mappings and workflows.

• Built and maintained and configure DAC for scheduling workflows.

• Translating logical business dimensional models in base physical DB design; Identifying necessary aggregations and

defines aggregate requirements and strategy, and Creating analytics server meta data.

• Translating high level business requirements into logical business dimension model; Defining various logical subject

areas and organization of presentation layer metadata; Understanding and defining key metrics, dimensions,

hierarchies and attributes.

• Coordinate Unit Test, Peer Review, and Siebel Expert Service Reviews to ensure quality of configuration.

• Work with the Testing team to create test data and develop a test plan, when necessary.

• Configure and develop the Analytics application according to approved 311 application design documents.

• Logging defects / Change Requests in Mercury Quality Center and follow up of the same.

• Documenting Design, Data Dictionary, Task Inventory, and Security, Deployment and Defects Tracking.

Seibel Reports Lead

July 2004 – April 2005

• Lead the team of 2 Actuate report developers.

• Developed, modified and maintained various complicated Actuate reports as per 311 Call Center requirements.

• Develop high reports consisting of complex charts and graphs in BI Publisher

• Developed parameterized reports.

• Extensive experience in Siebel Tools for reports libraries, parameter applets, adding reports to the views etc

• Maintained Actuate report server encyclopedia.

• Be the point of contact for all Actuate Reports issues.

• Ensure that you review your team’s work for quality assurance purposes.

• Coordinate Unit Test, Peer Review.

• Involving team in integration, system, and performance testing as needed and in coordination with the 311

Application Lead.

• Work with the Tech Arch team to identify proper solutions, when necessary.

Siebel Reports Lead

American Red Cross, Washington, DC

June 2003 – May 2004

• Lead the team of 2 Actuate reports developers.

• Developed, modified and maintained various complicated reports as per 311 Call Center requirements.

• Extensively in Siebel Tools for reports libraries, parameter applets, adding reports to the views etc

• Developed parameterized reports.

• Maintained Actuate report server encyclopedia.

CRM Senior Services Reporting Developer Consultant

Union Pacific Rail Road, Omaha, NE

October 2001 – May 2003

• Gathering report requirements from end users,

• Wrote technical specification for the reports and report documentation for future reference.

• Developed, modified and maintained various Sales & Marketing reports based on client’s requirement.

• Built Actuate Libraries using Siebel Tools and Actuate.

• Unit testing of reports using Siebel Thick Client and Siebel Thin Client.

• Customized 150 Siebel shipped Actuate reports as per client’s requirement.

• Converted all existing Actuate reports from Actuate 4.1 to Actuate 5.0.

• Trained couple of UPRR employees in Advance Actuate reporting techniques

• Administered the reporting server.

• Wrote training documents for Marketing & Sales employees for the best use of the reports

Senior Actuate Developer and Administrator

Qwest Communications, Denver, CO

April 2000 – August 2001

• Gathered the reports requirement from the client.

• Built reports as per Clients requirements.

• Built report libraries

• As a report server administrator I created User IDs, passwords, Folders on Actuate Report Server for various users

groups and maintained them.

• Maintained the Reports Inventory and documented all the report designed and report calculations for future

reference.

• Upgraded Actuate e. Reporting System from 4.x to 5.x.

Actuate Reports Developer

Alison Associates, Detroit, MI

January 2000

• Built reports as per Clients requirements.

• Built report libraries

• Modified existing Actuate Reports

• Trained an employee in the advance techniques in the Actuate Reporting System.

Actuate Reports Developer

BMC Software, Houston, TX

August 1999 – December 1999

• Design, development, testing and deployment of reports on Report Server

• Modified many reports as per client’s requirement

• Maintained reports inventory using PSVS Version Control Manager

• Maintain the report server encyclopedia on day to day basis

Mainframe Developer

All State Insurance, Northbrook, IL

April 1998 – June 1999

• Analysis, enhancement, and modification of online entry screens

• Built batch report modules for Client Technology Services (CTS) application

• Involved in modification, analysis and testing various COBOL and PL1 programs of CTS modules for Year 2000

Compliant (Y2K)

• Modified exiting JCLs

• Wrote COBOL and PL1 Subroutines for date expansion, conversion and used the Windowing Techniques

• Migrate the Batch & Online modules to QA using TOOLBOX

• Also involved in documentation of modified and developed modules

Mainframe Programmer

Unisys, Dallas, TX

September 1997 – March 1998

• Involved in Designing and development of an integrated system to handle basic functions of Medicaid Program of the

Social Security Act of Oklahoma state

• Involved in analysis, code, and modification of Medicaid Program using COBOL II, CICS, VSAM, DB2, and JCL

modules as per the request of the client

• Built testing environment and tested Batch modules

• Modified CICS entry screen as per client’s requirement

Mainframe Programmer/Analyst

Carrier Aircon Limited, Jamshedpur, India

August 1994 – February 1997

• Designing various Order Entry Screens using CICS, COBOL, and DB2

• Involved in the design, development of the Reporting System developed for Customer Services, which would enable

the schedule of services of air conditioners installed at customer locations COBOL II, VSAM and JCL

EDUCATION

Degree College/Organization

Bachelor of Sciences Government College, Rourkela, India

Post Graduate Diploma In Systems National Institute Of Information Technology (NIIT),

Management Visakhapatnam, India

Certified as Actuate Developer/ Actuate Certified Partner, USA

Administrator in Actuate e. Reporting

Suit

Contact this candidate