EXPERIENCE SUMMARY:

• Business Intelligence Developer wif 7 years of experience in Reporting and BI Solutions
• 4+ years of IT experience as Cognos developer specialized in OLTP/OLAP/Data Warehousing, BI tools and in analysis, design, testing, development and providing business intelligence solutions
• 3+ years of experience as SAP Business Objects Developer
• 5 years of experience as ETL Developer (SSIS and Informatica)
• 9 months of experience in Tableau Desktop
• Extensive experience working wif Cognos 11.x/10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio, Cognos Access Manager)
• Hands on Experience wif Framework Manager (Physical Layer, Business Layer, Presentation Layer) and Importing Meta Data from Different Sources, Dimension Hierarchy and setting up Determinants
• Created and published packages wif Object and Data level security using Framework Manager and created complex Reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail and Cascading) and Dashboards building wif Report Studio
• Created Active Reports which made offline analytics easy to get truly portable business intelligence
• Knowledge of data warehouse techniques and practices, including BI Reporting, Relational Modeling, Star schema & Snowflake schema
• Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Scheduling and Bursting of Reports and various kind of prompts (Value prompt, Date prompt, Textbox prompt)
• Good knowledge on troubleshooting and resolving complex Production and Performance issues
• Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business requirements, technical design documents, development, integrating, Implementing and Production Support using Cognos as a BI tool
• Experienced in using Java script and HTML to create prompts
• Provided extensiveEnd User TrainingandSupport
• Experienced in Migration of other reports into Cognos (BO to Cognos) and version up-gradation in Cognos
• Proficiency in working wif Relational Databases like Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000,DB2
• Developed SSIS packages using various tasks, containers, data transformations, for each loop and for loop sequence container
• Comprehensive knowledge of enterprise Data Warehouse including OLTP/OLAP, Dimension/Fact tables
• Expert in SQL, Query Optimization, Normalization, Creation of Views, Triggers, User-defined Functions, Stored Procedures, subqueries, and joins
• Skilled in using ETL packages to apply control flow tasks (For Loop, For Each Loop, Execute SQL task), and data flow tasks using various transformations (Conditional Split, Data Conversion, Look up, Derived Column, Merge, Union all)
• Used Informatica ETL to load data from flat files and other databases
• Implemented SCD (Slowly Changing Dimensions) Type 1 and 2 for data load
• Ability to write and maintaintechnical documentationto describe Reports development, logic, coding, testing, changes, and corrections
• Strong interpersonal and communicative skills. Strong analytical-problem solving and trouble shooting skills. Ability to balance flexibility and task priorities to meet internal customer demands and meet project deadlines
• Experience in creating the Universe in the Information Design Tool (IDT) and Universe Design tool (UDT)
• Good knowledge on SAPBusinessIntelligence 4.1(Universe Designer and Webi)
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports usingBusinessObjects
• Good knowledge onBusinessObjectsreporting functionalities such as Master Detailed, Slice and Dice, Filters, Ranking, Sections, Graphs and Breaks
• Worked on complexBusinessObjectsReports using Input Controls, Drill Filters and Hyperlinks

TECHNICAL SKILLS

BI Tools: Cognos 11.x, Cognos10.x, Cognos Business Intelligence (8.1 to 8.4), Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Configuration Manager, Cognos workspace advanced, Cognos administration, Cognos Access Manager, Business Objects XI 3.1, Cognos Framework Manger & Business Objects Universe Designer and WebI, Tableau, MS Power BI, SSIS and Informatica

Querying Tools: Toad, SQL Management Studio

ETL Tools: SQL Server Integration Services and informatica

Languages: MSSQL, PL/SQL

RDBMS: Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, and SQL Server

Operating Systems: Windows 2003/2008/2012 R2

PROFESSIONAL EXPERIENCE

Confidential, New Jersey, USA

Lead Cognos Developer and SSIS Developer

Roles and Responsibilities:

• Analysing the existing Cognos environment, Reports, Packages and backend Databases
• Prepared design and test case documents for migration activities
• Worked on migrating the Reports across all the environments
• Testing Reports, Packages and other components in Cognos 11 environment
• Analysing on JavaScript issues which were not compatible wif Cognos 11 after migration
• Working closely wif IBM on migration issues
• Finding the root cause for migration issues and fixing them
• Moving the Reports and Security settings from Old environments to New environments
• Attending regular calls wif Business Users and updating them on migration status
• Co-ordinating and communicating wif Admin team on migration activities
• Giving production support after the migration went live into Production
• Developing SSIS packages. Experience in Migrating SSIS Packages from 2008 to 2015 version
• Designed ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets/flat files using SQL Server Integration Services (SSIS)
• Performance Tuning and Query Optimization. Applying stats on key tables to improve SQL performance
• Created and updated Data Mapping Documents for ETL packages
• Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column

Environment: Cognos10.1 BI,Cognos10.1 Framework Manager, Cognos 11.x, Report Studio, Query Studio

Confidential

BI and ETL Developer

Roles and Responsibilities:

• Designed the ETL process; accessed, manipulated, analyzed, interpreted, and presented information from multiple sources
• Confidential and De- Confidential of existing tables wherever needed, for faster query processing
• Developed SSIS packages to validate, Extract, Transform and Load (ETL) data into Data Warehouse and Data Marts using Pivot Transformation, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Conversion
• Performed the extraction, transformation and loading of data directly from different source system like Oracle database, XML, Excel, Flat Files, and SQL Server
• Created Informatica workflows and sessions for each source file to load data into data warehouse
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Sequence generator, Union and Update Strategy transformations
• Using Mapping parameters created an incremental approach to take fresh data from sources daily
• Used Inter process communication table logic to track status of each Informatica load for easy debugging of unforeseen issues
• Worked closely wif Users in creating Functional Requirement Specifications for report development, creating Prototypes before starting actual development
• Designed the model based on the requirements for different subject areas and by analyzing the underlying data. Developed customized packages to be used by the query studio users, as per the business specifications
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts, conditional formatting, filters, multi - page, multi-query reports to meet the business user requirements while increasing the accuracy and amount of data presented
• Responsible for the delivery of solution-oriented complex reports using Report Studio.
• Created the documentation for all the developments along wif the technical specifications
• Good experience in creating canned and ad-hoc reports inTableauDesktop
• Worked on configuring reports from various Data sources using Data blending in Tableau
• Capability of doing data visualization, Reporting, Analysis, Pie Charts, Bar Charts, Cross Map, Scatter Plots, Geographic Map inTableauDesktop
• Good knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, Transformations, filters, Sets, Groups, prompts, Parameters etc inTableau

Environment: Cognos10.1 BI,Cognos10.1 Framework Manager, Informatica, Report Studio, Query Studio, Analysis Studio, SQL Management Studio, Tableau 10.2

Confidential

BI and ETL(SSIS) developer

Roles and Responsibilities:

• Gathering Business Process Requirements from business users, for the reports to be developed.
• Developing technical specifications documents by analysing the business from the gatheird BPR.
• Developed various relational models using Framework Manager forCognosupgrade.
• Created SSIS packages to extract data from various sources and loaded data into target database
• Set up parameters to make SSIS packages configurable in target environment
• Tuned the performance of SSIS packages by examining execution tree, checking run-time environment variables and identifying and address the bottle-neck executable
• Designed ETL (Extract, Transform, Load) strategy to transfer data from heterogeneous data sources (OLAP database) to staging and staging to target tables in the data warehouse by using SSIS package in Visual Studio
• Implemented Error Handling by using SSIS packages and create notify to process results by using SSIS mail task to related users
• Developed various reports, and they include, simple lists, cross tabs, charts, complex reports wif tables in them, conditional block, static choices in prompt, bursting etc.
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Fine Tuning PL/SQL queries, views and stored procedures.
• Designing and developing prompt pages and cascaded input prompts.
• Extensive interaction wif Business community and Team members.
• Created / Modified Universes, Reports from the underlying Databases for differentbusiness modules
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins
• Created Universes using @functions for specifying the query script forobjects
• Imported/ Exported the Universes from/to repository to make them accessible to end-users.
• Created Web Intelligence and Desktop Intelligence reports wif multiple data providers like Universes and free-hand SQL
• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc

Environment: Congos 8.4 (Framework Manager,CognosConnection, Report Studio, Query Studio, Analysis Studio, Metric Studio), Oracle 9i, Toad, Business Objects XI 3.1

Confidential

Business Objects Developer

Roles and Responsibilities:

• Gathering Business Process Requirements from business users, for the ETL process and reports to be developed.
• Developing technical specifications documents by analysing the business from the gatheird BPR
• Training users to use theCognosconnection to access their corresponding reports and cubes
• Ability to work independently wif minimal supervision and TEMPeffectively meet project deliverables on time.
• Developed various reports, and they include, simple lists, cross tabs, charts, complex reports wif bursting etc.
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Fine Tuning PL/SQL queries, views and stored procedures.
• Designing and developing prompt pages and cascaded input prompts.
• Extensive interaction wif Business community and Team members.
• Follow quality standards and best practices for the development tasks.
• Provided administration support and Development support for development and productionissues.
• Created / Modified Universes, Reports from the underlying Databases for differentbusiness modules
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins
• Created Universes using @functions for specifying the query script forobjects
• Imported/ Exported the Universes from/to repository to make them accessible to end-users.
• Created Web Intelligence and Desktop Intelligence reports wif multiple data providers like Universes and free-hand SQL
• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc

Environment: Oracle 9i, Toad, Business Objects XI 3.1