Sr. Technical Specialist Resume

SUMMARY

10 years of IT experience in which 7 years of Data ware - housing, Business Intelligence, wif specialization in Design
Development and Deployment of Business Objects XI-XIR2-XIR3/XIR4 using heterogeneous database.
Good Understand of Banking & Finance Domain and had Managed mid-sized projects in data warehousing, Business Objects’ wif MSBI ETL tools.
Proven abilities in leading pre sales activities, preparing SOW, people management, resource planning, SLA management
noledge management, technical trainings, building & managing teams and team performance management.
Experience of universe creation wif Universe designer on teh top of Database Tables & Derive Tables
Experience of universe creation wif Information design tool on teh top of Database Tables
Experience in identifying teh loops in teh joins and resolving them by using teh context and alias methods.
Experience on creation of teh web intelligence reports on teh top of teh Universe ad-hoc and Qwaas query.
Experience on creation Dashboard Report using Qwaas query and excel sheet for higher management.
Experience on creation Crystal report on top of teh database tables

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Technical Specialist

Responsibilities:

Understand teh current reporting system
Working at Onsite in Memphis for Business Object infrastructure support and Development
Working on migration from BOXI- 3.1 to BI 4 using UMT (Upgrade Management Tool)
Working wif SAP representative to resolving issue on which has been assign to SAP.
Responsible for daily Ticket resolving and interaction wif FTE User
Deployment of Universes, Reports, Access Level, dependencies using LCM (Promotion Management)
Development of dashboard reports using QWAAS query
Performing quality checks on teh deliverables before they are migrated to production.
Created Unit test documents while developing teh reports and get teh approval for release.
Day to day support and debugging of customer issues and providing solutions.
Used Report Conversion Tool to convert desktop intelligence reports to web intelligence reports.
Designed new Universes based on teh DB table for adhoc report requirements.
Created Master/Detail, Cross Tab by using Drill down and Slice and Dice in Business Object Report.

Confidential, WI

Sr. Report Designer

Responsibilities:

Involve in Analysis and validation of BO reports & Database structure
Responsible for end to end design, prototype, DDS, work assignment, supervise team
Worked on different projects ITG that contains different level of reports developed using Business Object XI 3.1 & 4.0
Worked on Teradata SQL for verifying report related data
Worked on Teradata ETL created several BTEQ’s for extracting teh data from source and loading into teh EDW data warehouse.
Developed Universes using Start schema methodology
Created Web intelligence reports wif using Universe wif derived tables.
Created new BO Universe in star schema wif Teradata as data source.
Resolved loops and assigned row level security for different users.
Created Generic ODBC and client connections for Teradata.

Confidential

Sr. BI Consultant

Responsibilities:

Involve in Analysis and validation of Shredding Database structure
Design & development of different techniques/approaches used in a Data warehousing project
Provide technical expertise to peer team members on SSIS/data ware housing concept
Developed optimize ETL SSIS Packages in SQL Server Integration service(SSIS)/ETL in SQL Server 2008 to load data from operational data store to Data ware house
Analysis and Validate teh Master table/Lookup Table from teh source and load into teh target
Worked on teh report (WebI), Universe

Confidential, Atlanta

BI Consultant

Responsibilities:

Involve in Analysis and validation of Shredding Database structure
Design & development of different techniques/approaches used in a Data warehousing project
Provide technical expertise to peer team members on SSIS/data ware housing concept
Developed optimize ETL SSIS Packages in SQL Server Integration service(SSIS)/ETL in SQL Server 2008 to load data from operational data store to Data ware house
Analysis and Validate teh Master table/Lookup Table from teh source and load into teh target

Confidential

Sr. Consultant

Responsibilities:

Work on SQL Server Integration service (SSIS)/ETL/SQL Server Analysis Services (SSAS) in SQL Server 2005/2008.
Create Reports based on Business Objects 6.5, XI R2 & XI R3.1
Sizing and Scaling for performance optimization.
Deployment of BI-4 on Linux-5.5 and Tomcat as WAS.
Up-gradation from BOXI-R2 to BI-4 (Universe/Reports/Dashboard).
Performing a migration of distributed BO system from R2 to R3
Execute change management tickets promptly
Supporting 600+ users for problems related to their Universes, Webi/Web Intelligence reports, Deski/Desktop Intelligence reports, queries, folder access, group permissions, connections, new comers and leavers procedures
Contributing towards and coordinating in teh development of new and existing projects, resolving all kinds of incidents while supporting clients; suggesting enhancements and “Standard Operation Policies”
Execute change management tickets promptly