SUMMARY:

• 8 years of IT experience involving various aspects of Data Warehousing and Business Intelligence. Well versed with complete Life Cycle Development process including requirement analysis, documentation, development, testing, implementation, and maintenance.
• 6+ years of strong experience in designing and implementing complex reporting solutions using Cognos Suite 10.x / 8.x / series 7 ver. 4.
• 6+ years of strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• 3+ years of strong experience in developing TM1 applications using Architect, Contributor, Perspectives and Turbo Integrator.
• Developing metadata models in Framework Manager following best practices
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Strong understanding of designing dimensional and relational models, star and snowflake schemas and different DW design paradigms.
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for Change data capture (CDC).
• Worked for performance tuning by finding out the bottlenecks in various mappings.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Involved Testing, Debugging, Validation and Performance Tuning of data warehouse.
• Experience in PL/SQL and query optimization techniques
• Mid - level knowledge of Netezza, MS SQL Server, Sybase, Oracle databases.
• Mid-level knowledge of Cognos administrative and security tasks
• Exceptional ability to quickly master new concepts and technologies
• Capable of working in groups as well as independently with excellent communication skills
• Good in trouble shooting with quick turnaround in fixing the issues.

TECHNICAL SKILLS:

Database Management Systems: Netezza, SQL Server, Oracle, Sybase

Data Integration: Informatica, SSIS

Database Architecture: Dimensional Modeling (Star, Snowflake)

Business Intelligence Tools: IBM Cognos BI, Cognos TM1

Operating Systems: Windows 95/98/NT/XP/2000

Programming Languages: SQL, PL/SQL, Unix,C++,C#, Java Scrip,HTML

WORK EXPERIENCE:

Confidential

Environment: Informatica 9.5, IBM Cognos BI 10.2, Netezza, SQL Server

Senior Consultant

Responsibilities:

• Understanding business requirement and delivering the code to solve business purpose.
• Analysis of the Business/Functional model of the project.
• Created mock ups sample reports through sql using ODS as the source.
• Created a FM model and reports in Cognos 10.2 using EDW as source for the Finance Accretion Project.
• Implemented security, edited the governor setting, defined determinant in Framework Manager.
• Performed Cognos administrative tasks including security, user accounts and deployments.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Create workflows based on Dependencies in Informatica for the code changes.
• Unit test the data mappings and workflows.
• Validate the data loaded into database.

Confidential

Environment: Informatica 8.6, Cognos BI 10.1, MS SQL Server

ETL/BI Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Authored various types of reports in Report Studio using relational data sources.
• Implemented report bursting to distribute reports effectively.
• Worked on performance tuning of the existing models and reports

Confidential

Environment: Informatica 8.6, SQL Server, Oracle

ETL Developer

Responsibilities:

• Involved in analysis, designing, developing, testing and enhancing various modules of the Interfaces.
• Creating Business Technical documents for different interfaces.
• Creating ETL design documents as per the business requirements.
• Extensively worked in data Extraction, Transformation and Loading from Source to target.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, SQL Server, flat files and loading to Oracle target database.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
• Used various transformations like Lookup, Expression, Filter, Joiner and Stored Procedure.
• Involved Testing, Debugging, Validation and Performance Tuning of data warehouse
• Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads) via DAC.
• Monitoring jobs every day using Workflow monitor.

Confidential

Environment: IBM Cognos TM1 10.1, IBM Cognos 10.1, SQL Server

Cognos Developer

Responsibilities:

• Design, develop, and implement Cognos TM1 10.1 Applications for Financial Planning and Budgeting models with complex rules.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles and security.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Created complex Active Forms and enhanced the performance of existing Active forms.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Created TI Processes to transfer currency data to currency cube.
• Created rules to transfer data between cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using Turbo Integrator.
• Import the data from ODBC and Text files using TM1 Turbo integrator.
• Reviewed Business Requirement Document (BRD) for Completeness, Gather and analyze financial planning, budgeting and reporting requirements.

Confidential

Environment: IBM Cognos BI 8.4, Oracle, BMC Service Desk

Cognos Developer

Responsibilities:

• Developed a metadata model in FM by following the best practices.
• Developed reports using customized prompts, advanced filters and conditional formatting.
• Supported the existing reports in Production environment.
• Creating change requests and performing impact analysis before deploying the change in the production system.
• Analyzing the production support issues that are logged in the form of trouble tickets through BMC Service Desk and resolving them within the SLA window.
• Responsible for reducing EQA (External Quality Review) defects by implementing best practices in the project.
• Provide Cognos access to users and resolve issues of the users.
• Unit testing for the reports.

Confidential

Environment: Cognos Impromptu 7.3, Cognos 8.3, Oracle 10g, Sybase

BI Developer

Responsibilities:

• Migrated catalogs and reports in Cognos 7 series to Cognos 8.
• Implement security levels in the framework manager.
• Used Life Cycle Manager for validating/testing of reports.
• Deployed packages and reports to the production.
• Perform unit testing of each reports.
• Created star and snow flake schema.
• Created and modified the existing FM models.
• Authored various types of reports in Report Studio using relational data sources.
• Applied different conditional formatting and drill through capabilities in the reports.
• Created different prompt reports, used style variable and render variable in the reports.
• Prepared Technical Design documents and Test cases.

Confidential

Environment: ASP.Net 3.5 framework, SQL Server

.NET Developer

Responsibilities:

• Involved in requirement analysis and study of existing system
• Developed web application GUI using ASP.Net, C#.Net, JavaScript, AJAX, HTML
• Involved in interaction with business analyst in issue tracking and implementing.
• Experience in Preparing Test Plan, Test Conditions, Test Data & test cases for the application.
• Designed and implemented reusable user controls developed in ASP.Net
• Helped to set up development processes, conducted code reviews
• Developed database schemas using SQL Server 2005 such as tables, stored procedures, views, triggers
• Involved in implementing the relationships between entities by creating the primary and foreign keys
• Deploy and configure the application on the Development, Testing Production environments.