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 LeadTools: 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 LeadTools: 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 /AdministratorTechnology: 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 DeveloperTools: 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.
