CAREER SUMMARY:

• 10 years of professional IT experience in Business Intelligence (Teradata, Informatica, SAP Business Objects, Oracle Sql, Plsql, DBA, Netizza, Unix ) design, development and implementation having expertise on Data warehousing, Data mapping, Data Modelling,Reporting and Business requirement gathering.
• Experienced in Design, implementation, upgrade and support projects.
• Extensive experience in design, implementation, maintenance and support of business intelligence tools using Informatica, Teradata, SAP Business Objects, Netizza, Oracle DBA,SAP BI
• Seeking for opportunities to explore on Big data Hadoop Integration with ETL,Teradata, Data analysis
• Expertise in DWH, ETL, Bteq scripts(Teradata),SQL,PL/SQL, Complex mapping (Informatica), Universe designing, Webi, Deski Reports, Xcelsius dashboards (SAP Business objects XIR2,R3), Complex queries (Oracle 9i,10g) for the development of Business Intelligence to address business solutions
• Strong experience in Performance tuning of applications using built - in Teradata using teradata view point, Bteq, MLOAD, FLOAD, Fast Export, Explain plan & Oracle utilities like Explain Plan, SQL Trace & TK-Prof, and using Optimizer hints
• Strong knowledge in Health care with expertise in Clinical, Claims, Member and provider subjects areas
• Strong knowledge of versioning tools like Share point, TortoiseSVN, Rational clear quest IBM
• Strong application/ process testing skills, created and executed UTP (unit test plan), SITP (system integration test plan), UATP (User acceptance test plan)
• Strong analytical skills, solution providing skills and result oriented
• Strong knowledge of GDM (Global delivery model) and SDLC (Software Development life cycle), have done two full life cycle 2 implementation, 1 design,1 upgrade project.
• Strong knowledge in Microsoft Office (word, excel, PowerPoint), Microsoft Visio and Microsoft Project Planner
• Well versed with SAP Business Objects Administration responsibilities Like Creating Users, Groups, Authentication etc. in XIR2/R3
• Good knowledge of migration activities from development instance to production instance using Import Wizard
• Good project management and team building skills

SKILL SET:

Technical Knowledge: DWH, ETL, Bteq scripts, MLOAD, FLOAD (Teradata), SQL, PL/SQL, DBA (Oracle 9i, 10g), Complex mapping (Informatica), Universe designing, Webi, Deski Reports, Xcelsius dashboards, Import wizard, CMC (SAP Business objects XIR2, R3)

Functional Knowledge: Banking, Health care industry with expertise in Insurance, ClinicalClaims, Member and Provider subject areas

RDBMS: Teradata, Oracle 9i, Oracle 10g, Netizza, DB2

Tools: Informatica 8.0, 8.6, 9.1, 9.6, Toad, SQL Assistant, SAP Business Objects

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Platform: Teradata, Informatica, Business objects, Autosys, RCQ

Modules: Claims, Member, Provider, Pharmacy, Clinical

Responsibilities:

• Planning project execution strategy and project charter
• Analyzing ETL,Reporting requirements and working on implementation strategy
• Designing the integration Interfaces and data mapping activity
• Lead a team of 8 offshore & 3 onshore folks at the peak time and Delegated the technical work
• Tracked and reviewed the work done by offshore, onshore team.
• Created and reviewed Approach, design & Test plan documents
• Conducted Technical response, Detail design, Test strategy, Test plans review session with Client
• Implementing Teradata, Informatica, Business objects best practices by formulating process in coding and documentation
• Created Bteq scripts(Teradata), MLOAD, FLOAD, Fast Export, Mappings(Informatica),Webi reports(Business objects),shell scripts as per business needs
• Being the configuration controller for the project and managed the cutover activities and code migration
• Conducting SIT/ UAT session with client to obtain their approvals for implementing the developed solution
• Coordinating with various teams (Data modelling,Data integration support, Production control team) during different phases of project
• Creation of training manuals and conducting Business/ User Training
• Supporting the BI application post production Go-live

Confidential

Technical Lead

Platform: SAP BO 3.1(Designer, Web Intelligence), Xcelsius, SAP BI 7.1, HP Quality Center

Modules: FI, MM, SD

Responsibilities:

• Understand business process and draft technical design documents based on the functional documents
• Coordinate with BW/Onshore
• OLAP Universe creation and report development using Webi against Bex queries built on SAP BW Info Providers
• Designed dashboards in Xcelsius based on their requirement
• Test, review code & documentation for the deliverable
• Perform Technical Unit Testing and support Functional Unit Testing

Confidential

Senior Developer

Platform: Business Objects - Xcelsius

Modules: NA

Responsibilities:

• Designed dashboards in Xcelsius based on their requirement
• Designed the dashboard with MS-Excel as the source for data
• Used various chart items like Pie chart, bar chart, column chart, combination charts, stacked bar chart
• Used various components sliders, Gauges, Selectors, Containers.
• Maps and Texts
• Stacked area chart, etc.
• Enhanced the look & feel of the dashboard by using combination of client templates and custom templates
• Published the Xcelsius dashboard to Business Objects environment, MS word, MS PowerPoint and SWF file
• Manual document for refreshing the Excel data
• Toshiba Europe R12 upgrade and IFRS compliance (Chandigarh, India)

Confidential

Offshore Developer

Platform: BO R3, SSIS, SSRS, SQL Server 2008, Xcelsius 2008

Responsibilities:

• Daily involving in meetings with customer and discussing about status and new requirements of the project
• Analyzing reporting and universe requirements
• Creating universes and Reports as per the requirements
• Creating some dashboards
• Working with CMC for Auditing and security purpose
• Maintenance and enhancements of existing reports
• Development of the new reports in webi, Deski, Crystal reports and to support the existing reports for the Business Users
• Addressing the issues reported by client if any
• Addressing User concerns with reports and resolving them

Confidential

Developer

Platform: BO XI R2/R3, Oracle 10g, Informatica, Autosys

Responsibilities:

• Extensively involved in Created Mappings (Informatica),Design and Developing of various Universes and Reports (Deski, Webi) using Business Objects (XI R3/R2).
• Extensively involved in designing of OLAP universe using SAPBI query as source.
• Designed & Implemented security architecture for (BASEL II REPOSITORY) Implemented Security Features of Business Objects like Row level, object level and report level to make the data secure.
• Migrated & upgraded Business Objects from XI R2 to XIR2 sp1 to XIR2 Sp4 to XIR3 and installed hot fixes and patches
• Creation of Filters, prompts and setup Hierarchies for Multidimensional Analysis to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Bug Fixing (Resolving the traps and loops in universe).
• Created complex reports using the multiple data providers and synchronized the
• Data providers by linking the common objects to create the common report for
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Linking Deski and Webi reports by using Hyperlinking.
• Exported the Universes to the Repository to make resources available to the
• Checkin and checkout process and maintaining the previous versions
• Bo Administration Like Creating Users, Groups, Authentication etc in XIR2
• Creating packages (BIAR File) using import wizard.
• Performed unit testing, system testing and for universe, reports and security management.