Sr. Software Engineer/technical Lead Resume
SUMMARY
- Over 7.5+ years of experience in BI Reporting
- Strong experience with Cognos Tools such as Cognos 10.2/10.1/8.4 and Analysis Tools such as Cognos Transformer.
- Certified Cognos reports developer (IBM Cognos 8/10 BI Author) and modeler(IBM Cognos 8/10 BI Metadata Model)
- Having strong and working knowledge on Cognos Connection, Query Studio, Report Studio and Frame work manager
- TEMPHas basic knowledge and working experience on Informatica.
- Also has worked on SAP BO tools like Web Intelligence and Dashboards
- Excellent ability to gather and understand business requirements and translate into IT solutions with teh use of Cognos
- Having rich experience in creating various types of reports using Report Studio
- Experienced with complete application development life - cycle including requirements gathering, analysis and design, implementing, testing and deployment
- Strong working knowledge in tools like SQL Developer, MS SQL etc.
- Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role
- Strong Experience in Unit testing, User acceptance testing, version control, change management and on-site/off-shore coordination.
- Strong team player, team leader and commitment towards learning with good communication and interpersonal skills.
TECHNICAL SKILLS
Cognos: Cognos 10.2 BI, Cognos 10.1/8.4/8.3 Cognos Connection, Query Studio, Report Studio, Frame work manager, Active Reports, Cognos Workspace and Cognos Workspace Advanced
SAP BO: SAP BO 4.0/4.1
Database: SQL Server, Oracle & SAP HANA Studio.
PROFESSIONAL EXPERIENCE
Confidential
Sr. Software Engineer/Technical Lead
Environment: Cognos 10.1, MS SQL, Cognos Transformer
Responsibilities:
- Created List Reports, Cross-tab Reports and Chart Reports.
- Created Query Prompts, Calculations, Conditions and Filters in teh reports.
- Developed Prompt Pages and Cascaded input Prompts to display only teh selected entries in teh report.
- Scheduled and Distributed reports using Schedule Management in Cognos Connection.
- Involved in Documentation and Training Users on Query Studio for Ad-Hoc Reporting
- Received client appreciation for efficient working and providing them with successful implementation.
Confidential
Senior Cognos BI Consultant
Environment: Cognos 10.1, MS SQL, Cognos Transformer
Responsibilities:
- Created various reports using different lists in single and multiple pages according to filter conditions.
- Requirement gathering from business and client interaction.
- Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
- Designed models using Framework Manager and deployed packages
- Used Conditional Variable to display different colors and for text according to format.
- Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
- Created Query Prompts, Calculations, Conditions and Filters in teh reports.
- Developed Prompt Pages and Cascaded input Prompts to display only teh selected entries in teh report.
- Scheduled and Distributed reports using Schedule Management in Cognos Connection.
- Involved in Documentation and Training Users on Query Studio for Ad-Hoc Reporting
Confidential
Senior Cognos BI Consultant
Environment: Cognos 10.1, MS SQL
Responsibilities:
- Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
- Created Reports using Tabular SQL to reduce teh load on teh Framework Manager model
- Created Query Prompts, Calculations, Conditions and Filters in teh reports.
- Developed Prompt Pages and Cascaded input Prompts to display only teh selected entries in teh report.
- Closely worked with team to design data marts by understanding user requirements and increasing teh reporting efficiency.
- Scheduled and Distributed reports using Schedule Management in Cognos Connection.
- Involved in Documentation and Training Users on Query Studio for Ad-Hoc Reporting
- Received client appreciation for efficient working and providing them with successful implementation
Confidential
Senior Cognos BI Consultant
Environment: Cognos 8.4, MS SQL
Responsibilities:
- Gathered Business requirements for creating teh Models.
- Developing Standard Reports, Charts, Drill Through Reports and Master Detail Reports Using Report Studio and Query Studio.
- Created Prompts to User Defined Filters.
- Good knowledge in Unit/integration Testing
- Extensively worked on MS SQL tool for testing teh queries
Confidential
Senior Cognos BI developer
Environment: SAP BO 4.0/4.1, Universe Design Tool, Information Design Tool, BI Workspace, BO Dashboard, Web Intelligence, Oracle, MS SQL, HANA Studio
Responsibilities:
- Worked on various projects with Confidential like Nuclear Reporting, eServices Wheel, Live CRS Automation and Sourcing Analytics
- Involved with business and functional people to collect and gather requirements
- Collecting and analyzing information requirements from users and translate those needs into requirements documentation
- Responsible for Designing and developing teh reports for product.
- Working with Data Warehouse team as needed to define new data warehouse tables needed for reporting,
- Developed List, cross tab, chart and complex reports which involved Multiple Prompts in BO
- Coordinate/assist /develop universe designing tool adjustments to accommodate new and existing business requirements.