We provide IT Staff Augmentation Services!

Bi Tech Lead Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • A competent professional with 9 years of experience in Data warehousing and Business Intelligence.
  • Working with cognizant as an Associate.
  • Expertise in business requirement understanding and its deployment through the technical team.
  • A project planner with experience in spearheading projects and ensuring delivery of projects within the time & cost parameters.
  • Have extensive knowledge on ODI Repositories, Knowledge Modules, Designer, Topology Manager, Operator Windows, ODI agent, variables, and procedures.
  • Good Knowledge of PL/SQL stored procedures, functions and tables.
  • Have worked in the following databases Oracle 10g/11g.
  • Have involved in creating reports in multiple tools OBIEE 11g 12c, Cognos 8 10 and BIRT.
  • Knowledge on designing/loading forecasting and budgeting applications in TM1.
  • Hands on experience in Project Estimation, Business Analysis, Creative Layout Designing and Software Planning.
  • Maintained internal BI data warehouse, ETL and reporting systems
  • An energetic team member with skills in business analysis, requirements gathering, handling the team, application development and deployment.
  • Developed Data Warehouse application.
  • Knowledge of Kimball data warehouse principals
  • Have excellent written and interpersonal communication skills.
  • Experienced in communicating with US clients.
  • Maintain a positive attitude in the face of changes in work assignments.
  • Excellent skills in understanding business needs and converting them into technical Solutions.

TECHNICAL SKILLS

  • Operating Systems: Windows 2000 XP, Vista
  • Languages: C, C++, VB 6.0, PL/SQL
  • Databases: Oracle10g/11g, SQL Server
  • Technology: Data warehousing, ETL, Business Intelligence, Data m odeling
  • ETL Tools: ODI 11g,12c, ODI 11 x, Solix EDMS 5.1
  • Data Model: Erwin
  • Business intelligence Tools: OBIEE 11g 12c, BIP 11.1.1.6 x, COGNOS 10, TM1
  • Products Tools: FERMAT 8.0, Track IT, QC, Cognos Life cycle manager
  • Change management tools: Cherwell PVCS & Clear Quest

PROFESSIONAL EXPERIENCE

Confidential

BI Tech Lead

Tools: Oracle 11g, ODI, OBIEE,SOlix

Responsibilities:

  • Identifying the client requirements.
  • Developed Specification documents for Reports as per client requirements
  • Created ETL Design document
  • Involved in Data modelling
  • Created interfaces, packages, procedures
  • Verified the correctness of report data with the data from the backend.
  • Developed different types of Simple and Complex reports.
  • Resolve the data issues and formatting concerns in the reports and troubleshoot the job failures and perform data recovery in case needed.
  • Managing scheduled Reports and Jobs.
  • Involved in Local and Production testing.
  • Involved in Unit testing of the reports
  • Involved in tracking the issues found during the migration process

Confidential

BI Tech Lead

Tools: OBIEE 11g,12c compass

Responsibilities:

  • Create implementation plan of upgrade
  • Periodically deploy reports from current production to new 12c lab environment
  • Validate the known errors in 12c and apply the fix in reports and dashboards
  • Validate the integration of report in new environment
  • Address issues during upgrade
  • Co ordinating with multiple teams to have smooth upgrade

Confidential

BI & Cognos Developer /Administrator

Technology: Cognos 8.4 administration, Power play cube and Framework Manager

Responsibilities:

  • Scheduling Cognos reports.
  • Reports scheduling based on triggers
  • Rebooting production Dispatchers
  • Addressing space issue
  • Granting access through Cognos administration
  • Termination of users through Cognos administration
  • Publishing Cubes through Cognos administration
  • Publishing cubes through framework manager
  • Spinning cubes and publishing to the portal
  • Troubleshooting of Issues.
  • Validating and fixing reports.
  • Verified the correctness of report data with the data from the backend.
  • Involved in Local and Production testing.
  • Involved in Unit testing of the reports

Confidential

Data Warehouse Developer

Tools: Oracle 10g, ODI, OBIEE

Responsibilities:

  • Worked as an Offshore Team Lead
  • Worked with Onsite team to gather business requirements
  • Estimated the project based on the tables/interfaces/facts/dims etc.
  • Analyzing all source system to find the data to be converted.
  • Architected and designed the ETL solution which was done using SQL
  • Architected and designed the BI solution
  • Validated the ETL strategies for implementation
  • Coordinated the development, testing and implementation
  • Conducted User Acceptance Testing by providing needed extracts
  • Involved in fixing issues and production code drop.
  • Evolved to take over primary responsibilities for all conversion.

We'd love your feedback!