SUMMARY:

• Seeking assignments as Senior BI Analytics (ETL/ELT+BI Report) Developer across various Data Analytics or Data warehousing/Business Intelligence projects.
• An accomplished Business Intelligence Developer with overall IT experience of 7.5 years, closely involved with Confidential (USA), Confidential (USA) and Qantas Airways (India - Australia) to create BI Platform for Analytics and thus helping top management in Decision Making.
• Thoroughly worked with Client Business Team at Confidential in United States and collected business requirements to build BI Reports using Cognos BI suite and Tableau.
• Extensive experience in developing Business Intelligence for Qantas Airways (India- Australia) using Cognos BI and ODI (Oracle Data Integrator)
• Industry trained or Cross skilled in Tableau and QlikView by BIDC (Business Intelligence Development Center) at JPMorgan Chase.
• IBM Certified Cognos 10 BI Author and Metadata Model developer with around than 7.5 years of experience in data warehousing projects.
• Along with Tableau, QlikView and Cognos BI Analytics, also proficient in Informatica (ETL) and ODI (ELT).
• Undergoing on Machine Learning using Python.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user and support for production environment.
• Experience in Oracle 10g, 11g and Teradata databases.
• Good experience in writing SQL queries and PL-SQL Programming.
• Good knowledge about Defect tracking and process.
• Extensive Knowledge on Data Warehousing Concepts.
• Hard worker, Quick learner and excellent team player with strong interpersonal and communications skills.
• Proven relationship-builder with exceptional interpersonal, communication, and presentation skills
• Ability to work well with a diverse team as well as ability to work independently with minimal supervision.

CORE COMPETENCIES:

Primary Technical Skill: Business Intelligence, Cognos BI 10.2 objects (like Report Studio, Analysis Studio, Query Studio, Event Studio, Transformer and Framework Manager), SQL, PL-SQL, Oracle (TOAD, PL-SQL Developer), Teradata (Teradata SQL Assistant), Tableau, Oracle Data Integrator (ODI), Informatica Power Center (Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer), Informatica Power Center (Various Transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator etc)

Secondary Technical Skill: QlikView, Business Objects (SAP BO)

Domain knowledge: Banking and Finance, Airlines and Insurance

Database: Oracle, Teradata

OS: Windows

Trained Skills: Cognos (v11,v10.2,v8.4), Informatica 9.1, Tableau, QlikView, Business Objects (SAP BO), Oracle Data Integrator (ODI), SQL, PL-SQL, Python(Currently undertaking)

PROFESSIONAL EXPERIENCE:

Confidential, Cedar Rapids, Iowa

Sr.Cognos and Informatica Developer

Responsibilities:

• Working as Senior Cognos Business Intelligence Developer for Onsite Analytics Team and Informatica Developer for Onsite Data Migration Team.
• Closely working with Business Users and collecting BI requirements.
• Closely working with Confidential Business Team and Source Teams for Data Delivery and Migration.
• Conducting various meetings on daily/monthly basis with Business and Confidential.
• Closely working with Confidential Product Solution Team.
• Working with fellow Developers in Onsite to migrate data as part of Conversion Project.
• Working on PL-SQL, SQL and Informatica to extract, transform and load data into Confidential which uses Oracle database.
• Working on Cognos BI to create BI Analytics for Top Management.
• Extensively Working on Cognos Framework Manager and Cognos Report Studio to create dashboards and reports using various complex business logics, Prompts, conditional formats etc.
• Attending Defect Calls/meetings and sending status across all teams and managers.
• Maintaining proper coordination between Offshore and Onsite Dev teams.

Skill Set used: Informatica Power Center (Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer) Informatica Power Center (Various Transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator etc) Cognos BI IBM Cognos BI 10.2 (Framework Manager, Powerplay Transformer, Report Studio, Event Studio, Workspace, Workspace Advance) Cognos (Heavy metadata models and Complex Reports using Conditional formats, drill throughs, prompts etc)

Confidential

Senior BI Developer/Cognos BI SME

Responsibilities:

• Worked as Subject Matter Expert for Cognos Business Intelligence.
• Developed various dashboards using Tableau.
• Closely worked with Business Users and collecting requirements.
• Assisted Business Team and Managers with Data Analysis and decision making.
• Developed BI reports on Cognos.
• Fixied Production bugs.
• Enhanced existing Reports and Framework Data Model.
• Fixed Performance Issues.
• Solely Responsible for implementation from DEV to Prod using ITSM Change requests.
• Worked closely with Cognos Admins during implementation and validation across environments.
• Attended sessions on Tableau and QlikView organized by BIDC (member of Business Intelligence Development Center) across JPMC BI Network and developing sample reports on Tableau.

Confidential

Senior Cognos and Informatica Developer

Responsibilities:

• Delivered projects efficiently and on time with zero defects by adhering to BI/DW and Cognos best practices.
• Worked closely with the End users, Business System Analysts and Business Analysts to develop high-level business process documentation which can be used to define DW/BI project priorities and iterations.
• Worked closely with architects to ensure BI content delivered as per the requirements & standards.
• Cognos BI Framework Modeling, Cognos BI application design & development and obtain appropriate approvals from Business owners/ Architects etc.
• Designed and developed complete reporting solutions for business through Complex Reports and Dashboards.
• Assisted colleagues on fundamental design methodologies, coding, trouble-shooting and other technical issues on Cognos.
• Tracking, monitoring and communicating project progress against project plan.
• Imparted to Freshers about Business Intelligence, Data Analytics and IBM BI Cognos.
• Adept at SDLC including producing documentation (analysis, design and implementation), Standard design methodologies, Coding, Naming standard documents.
• Extensively worked in Informatica Power Center (Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer).
• Informatica Power Center - Used various Transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator etc)
• Attended sessions on Tableau and QlikView organized by BIDC (member of Business Intelligence Development Center) across JPMC BI Network and developing sample reports on Tableau.

Confidential

Senior Cognos and Informatica Developer

Responsibilities:

• Analyzed the requirement and understanding the Requirement specifications.
• Understanding of Existing Legacy reports and build each logical part of existing system and provide thorough and comprehensive view to end user and analysts
• Worked on complex reports which included combinational charts, crosstabs with different date logics for both ad hoc and schedule runs.
• Prepared packages to pull data from semantic tables.
• Prepared Unit Test cases and testing the application.
• Coding and bug fixing.
• Handled unit testing and worked extensively with testing team to help in BI testing and UAT before delivering to the client.
• Involved in data analysis, developing framework model, reports pages and prompt pages.
• Developed few workflows in Informatica.
• Extensively worked in Informatica Power Center (Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer).
• Informatica Power Center - Used various Transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator etc)

Confidential

Cognos and ODI Developer

Responsibilities:

• Involved in Business Users Meetings to understand their requirements.
• Created Models, packages in Framework Manager.
• Published packages from Framework Manager to Cognos connection.
• Developed List, drill through, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Developed Cube model using Cognos Transformer.
• Developed Drill through report for cube in Report studio.
• Resolved UAT issues, if any.
• Thorough testing of reports against database using SQL codes.
• Developed various mappings in ODI using various transformations based on business and technical requirements.

Confidential

Cognos and ODI Developer

Responsibilities:

• Requirement gathering and changing SQL code for reports.
• Thorough testing of reports against database using SQL codes.
• Developed Cube model using Cognos Transformer.
• Developed FM Model against STAR Schema and published Packages to Cognos connection.
• Developed some specific reports with concept of cascading and value prompts as per the business requirements.
• Created calculations, summaries in the reports.
• Customizing reports using filters and sorts.
• Resolved UAT issues, if any.
• Developed various mappings in ODI using various transformations based on business and technical requirements.

Confidential

Cognos and ODI Developer

Responsibilities:

• Developed metadata models.
• Created calculations, filters and testing in framework manager.
• Created the Packages in Framework Manager, publishing the packages to cognos connection.
• Designed Cross Tab Reports and Designing the reports with various data formatting operations.
• Designed the Reports with value prompts, select and search prompts.
• Developed Cube model using Cognos Transformer.
• Developed various mappings in ODI using various transformations based on business and technical requirements.