Summary

• Over Nine (9) years of extensive experience in IT industry in the areas of analysis, design, development in client server environment. With focus on Data warehousing applications using ETL and OLAP tools like Informatica, Cognos with Oracle, SQL Server
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL), Cognos 10, Impromptu and Powerplay.
• Expertise in Cognos series 6.x/7.x/8.4/10 (Impromptu Administrator, Impromptu Web Reports, PowerPlay web, PowerPlay Enterprise Server (PPES), Decision Stream, Access Manager, Upfront) , ReportNet1.1MR1, MR2,MR3 and Cognos 10/8.4, MR2 (Framework Manager, Query Studio, Report Studio, and Cognos Connection)
• Experience in Cognos Reportnet developing, ReportNet, FrameWork Manager Installation & configuration with a full project in Cognos 10/8.
• Expertise in version Upgradations of Cognos suite such as Cognos 7.3 and Migration of Catalogs and Reports from Impromptu, Powerplay Cubes using Migration Utilities and mapping to corresponding metadata of ReportNet and Cognos8.
• Worked on Security access to clients using Access Manager and worked with Data Access, Object Access, and Package Access in Frame Work Manager.
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Extensive experience in Developing List, Cross Tab, Chart, Dynamic Reports and Drill Through Reports in Report Net & Cognos 10/8.
• Expertise in Developing Complex Reports and high impact dashboards using Report Studio in Cognos 10/8 BI Suite.
• Used Cognos ReportNet as the Web Reporting Solution of choice to improve business performance at all levels of the enterprise
• Eexperience in developing different reports using Crystal Reports and Administration.
• Excellent Knowledge in Data modeling, Logical/Physical model & ER-Diagrams
• Excellent knowledge in data warehouse development life cycle, gathering requirements and analysis, dimensional modeling, metadata management and implementation of STAR, Snowflake schemas, Incremental loads/Change Data Capture and slowly changing dimensions
• Worked with heterogeneous data sources like Oracle, SQL Server 2005, Essbase, Sybase flat files, XML files, DB2 files
• Strong experience with client interaction, understanding business applications, business data flow and data relations
• Good communication skills with strong ability to interact with end-users, customers, and team members

Technical Skills
OLAP/BI Tools: Cognos 10/8.4, Cognos Report Net 1.1MR1, MR2 ( Cognos Connection, Framework Manager, Report Studio, Query Studio, Matrics Studio, Event studio, Analysis studio ), Cognos EP Series 7.1(Impromptu Administrator, PowerPlay, PowerPlay Transformer, Enterprise Server, Architect, Decision Stream 7.1.5, Access Manager, Visualizer, Upfront, Cognos Query), TM1, Hyperion 8.3, Brio 8, Business Objects 5.1, Crystal reports, OBIEE 10.3.4.1.
ETL Tools: Informatica (Power Center/ Power Mart) Client Tools (Repository Mgr,
Designer, Server Mgr and Informatica Server), Informatica, SSIS, Talend RTX 4.1.
Languages: Java, Java Script, .Net, HTML, XML, SQL, PL/SQL and C.
O/S: UNIX, LINUX, Sun Solaris, HP-UX, IBM AIX 4.3/4.2, IBM OS/390, IBM OS/400, Windows 98/NT/2000
Tools: Dimensional Data Modeling, Star Join Modeling, Snow – flake Schema Modeling, Erwin 3.5.2/4.0, Microsoft Visio, SAS, Ratinal Clear Quest 7.1.
Databases: Oracle 7.x/8.x/9.x, Teradata, Essbase, SQL Server 2000/2005, Sybase, FACETS, MS Access, SAP BW.
CRM: SalesForce, Siebel 7

Educational qualification

• Master of Science in Information System

Professional Experience

Confidential,Bethasda, MD
May12 – Present

As Confidential,has grown to be a leading lodging company with more than 3,700 properties in 73 countries and territories worldwide. Marriott has been tasked with continuing the maintenance and development of the Marriott reservation Data Wherehouse (MRDW) as an efficient data warehouse and reporting solutions using Cognos BI tools.

Role : Sr. ETL / Cognos10 Developer / Administrator.

• Gathering and analysis requirements definition meetings with business users and document meeting outcomes.
• Design and implement the ETL Data model and create staging, source and Target tables in Oracle database.
• Design and develop star schema and snowflake schema model in Cognos Framework Manager 10.1.1
• Created folders, filters, prompts, and complex calculations in Framework Manager and Report Studio.
• Created charts, lists and crosstabs, using Report Studio and ad hoc reports using Query Studio.
• Design and Developed interactive Dashboards using Business Insight.
• Developed simple and complex reports in Report Studio.
• Trouble-shoot query build issues and errors.
• Implemented JavaScript to add functionality to report in report studio.
• Improved several reports performance by writing SQL queries.
• Created different joins and applied filters as per the user requirements.

Environment: Cognos 10/8.4, Cognos Transformer 8.4, WinSQL, SQL Developer, Informatica 8.X, UNIX, Java, J2EE, IBM RAD 7.5, DB2, Netezza , Windows 2000/XP, QC 10.

Confidential,Westpoint, PA
Jan 12 – May 12
Sr. ETL / Cognos10 Developer / Administrator.
Merck & Co. is one of the largest pharmaceutical companiesin the world.It is currently one of the World\'s seven largest pharmaceutical companies bymarket capitalizationand revenue. Data Warehouse was created that involved source data from different Flat files and using Informatica ETL tool transform the data and loaded in to Oracle data base. Using Cognos 10 BI tool develop an AMS BLUE KPI report.

Role : Sr. ETL / Cognos10 Developer.

• Developed Models in Framework Manager in Cognos BI version 10.
• Interact with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.
• Involved in creating security, and deployment (exports and imports).
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created complex reports with Dashboards, Scorecards
• Created charts, lists and crosstabs, using Report Studio and ad hoc reports using Query Studio.
• Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, usergroups and roles in the organization. Worked on bursting reports for the web users.
• Working closely with the ETL Team in the troubleshooting the data issues
• Design and develop ETL Design Documentation.

Environment: Cognos 10/8.4, WinSQL, SQL Developer, Informatica 8.X, UNIX, Java, J2EE, Oracle 11 , Windows 2000/XP, QC 10.

Confidential,Greensboro, NC,
Aug 10 – Dec 11
United Guaranty’s primary product is private mortgage insurance. The coverage we provide – which is called mortgage guaranty insurance, mortgage insurance a house with only a modest down payment. My responsibilities included developing and maintaining efficient ETL Talend and reporting using Cognos 8 BI.

Role: Cognos Developer / Administrator / ETL Developer

• Installed, Configured Cognos8.4/10 and Talend ETL on single and multi server environments
• Extensive Knowledge on Cognos Architecture and implementation.
• Analysis of the performance issues in different environments like Dev, Prod, Test
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to Cognos8 server.
• Involved in understanding existing Business Model and Customer requirements by participating in the Design Phase and user requirement gathering.
• Analyzing objectives processes and resources, and suggesting ways by which re-design, or improvements could be made by using business process modeling.
• Involved in modeling as for the user requirement using Framework Manager and also created models using different hierarchies.
• Created Metadata models using Framework Manager and published the packages to Cognos Connection.
• Built Framework Manager Model and established the cardinalities to suit the business needs.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Used the Schedule Management in the Cognos connection to schedule the reports and scheduled to run the reports on a monthly, weekly and daily basis.
• Added Package level security to the packages and Object level security.
• Maintained Security at Query Subject as well as Query Item level for labor cost views.
• Used different types of Aggregate functions (including specialized calculated functions) to display detail and summarized values at different grouped levels.
• Migrated reports created in Cognos 7 into Cognos 8.4. This migration was handled on a report-by-report basis as the seamless migration resulted in a report feature conflicts between Impormptu and Cognos 8.4.
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports.
• Developed complex reports like Drill Throughand Dash Boards and Created reusable templates for developing reports.
• Implemented Conditional formatting for highlighting rows and columns, and hiding individual rows.
• Performed comprehensive Unit testing by comparing the cognos reports against the database using sql in Toad and documented the same.
• Deployed the packages to testing and production environments.
• Created extremely big OLAP cubes using a Poweplay Transformer and Analysis studio.
• Worked on Talend RTX ETL tool, devalop jobs and scheduled jobs in Talend integration suite. Extensively used the concepts of ETL to load data from AS400, flat files to Saleforce .
• Extensively worked with tools like WINSQL and SQL developer.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and Users in development and staging environments.

Environment: Cognos 10/8.4, Cognos Transformer 8.4, WinSQL, SQL Developer,Talend 4.1. UNIX, SAS, SVN, Java, J2EE, IBM RAD 7.5, AS400 DB2, AIX, Windows 2000/XP. SalesForce ( CRM ), QC 10.

Confidential,Richmond, VA
Oct 09 – April 10
SunTrust Mortgage, Inc. continues to grow and expand its network of qualified listing agents to maket and manage the properties. SunTrust objective is to sell the properties at fair market value and maximize the net retun. Data Warehouse was created that involved source data from different departments like Finance, Sales, Mortgage and Marketing and provided complete BI solution.

Role: Cognos8 Developer / Administrator

• Installed and Configured Cognos 8.4, Report net MR3 on multi server environments.
• Analysing and gatharing the requirements from end user.
• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Made Models and Packages in using Frame work manager and published
• Developed List, Cross Tab, Chart and Drill Through Reports in Report Studio
• Created Prompt pages according to the requirement of business user and added Conditions and Filters
• Securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace.
• Involved in Migrating metadata and reports from , Crystal reports, Cognos 7 and Cognos 8 using utilities.
• Develop new reports on timely bases, by importing SAS data ( Flat files ) from MS Access database and rebuilding the OLAP cubes
• Generated Cubes using Cognos PowerPlay Transformer.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.
• Administering the business users in the portal based on the requirements. Participated in Enhancements meeting to distinguish between bugs and enhancements.
• Working closely with the ETL Team in the troubleshooting the data issues.
• Worked on Informatica tool-Source Analyzer, Warehouse designer, Mapping & Mapplet Designers and Transformation Developer. Extensively used the concepts of ETL to load data from Oracle database and flat files to Oracle database.

Environment: Cognos Reportnet 1.1, Cognos 8.4, Impromptu, Cognos PowerPlay 7.3, Access Manager 6.5,Remedy 6.3, Crystal reports 6 , SQL Navigator 4, Informatica 7X, UNIX, SAS, .Net, Sql server 2005, SSIS, SSRS, SSAS, Oracle 10g on Windows 2000/XP.

Confidential, (CDPHP) provides quality healthcare services for its members in 29 counties in New York and 7 counties in Vermont. As a part of enterprise data warehouse team, my responsibilities included developing and maintaining efficient reporting infrastructure for CDPHP using Cognos 8 BI. Scope of the project was building models from the existing data warehouse for summary level and detail level reporting of the claims, members/subscribers, brokers and employee\'s information

Role: Cognos8 Developer/Administrator

• Installed and Configured cognos ReportNet 1.1 MR3
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to ReportNet server.
• Involved in design and development of Joins, filters, calculations, prompts and conditional variables in Packages in Framework Manager.
• Involved in scheduling and Administering Cognos ReportNet reports using Schedule Management in Cognos Connection.
• Peer Reviewed Design and Code of other Developers, prepared defects list and modified design docs and code as per defects list
• Worked on summary reports and detail Reports.
• Developed standard historical reports in Report Studio for use of Call center Mangers
• Worked on scheduling and publishing the report to the Cognos Connection.
• Secure Cognos Connection and setup ReportNet Security by assigning user to the groups and roles defined in Cognos Namespace.
• Worked on Security access to clients (using Access Manager and ReportNet with LDAP also worked with Data Access, Object Access, and Package Access in Frame Work Manager).
• Created drill through reports with different parameters and associated with the summary reports to get details.
• Sql Tuning to enhance the performance of the reports.
• Created Prompts, Calculations, Conditions & Filters and creating New Jobs using Impromptu Administrator.
• Administered ReportNet server with the primary objective of tuning server performance to optimize speed and efficiency.
• Created Models by using various data sources in PowerPlay Transformer.
• Created User Classes and Users in Access manager and provided the user credentials
• Created extremely big OLAP cubes.
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to the Upfront.
• Working closely with the ETL Team in the troubleshooting the data issues
• Worked with Maintenance and Production support team in Scheduling activities
• Deploying the packages and reports to production environment.

Environment: Cognos ReportNet 1.1 MR3, Cognos PowerPlay 7.3 (Windows / Excel / Web), Matrics Studio, Event studio, Access Manager 6.5, Oracle 9i, Sybase, FACETS, Informatica 7.1.3, CITRIX, Oracle HRMS, Toad 8.5, Solaris, Deltek Performance Manager, CostPoint, Windows XP.

Client: Confidential,Baltimore, MD.
Jun 07 to Nov 07
Confidential,has been tasked with continuing the maintenance and on-going development of the National Data Warehouse (NDW) as an efficient and cost-effective data warehouse and reporting solution that provides timely, accurate, consistent, comprehensive, and relevant information at all times. The NDW provides critical reporting and analysis on the Center for Medicare and Medicaid’s (CMS) Medicare contact center operations.
Role: Cognos Developer/Administrator

• Installation and Configuration of ReportNet.
• Configured Content Store and Web Server to ReportNet.
• Administering and monitoring the Cognos Server on UNIX platforms
• Analyzed and Developed Standard Reports with Report Studio.
• Created List, Cross tab, Chart, Repeater, Conditional block and Book mark reports.
• Created complex reports using Tabular Set (Union, Intersect, Exclude) and Tabular SQL.
• Designing and Developing PL/SQL Procedures, functions, and packages to create Summary tables.
• Developed reports’ using various prompts (value prompt, text prompt, time prompt) and Drill through in ReportNet.
• Converted Reportnet reports into various formats like HTML (default), PDF, Excel, CSV and XML.
• Overriding the access permissions from Frame work manager using Cognos connection.
• Configured Access Manager & Directory Server
• Published reports on Upfront
• Provided production support and training to end-users

Environment: Cognos ReportNet 1.1 MR3, Cognos PowerPlay 7.3 (Windows / Excel / Web), Event studio , Access Manager 6.5, Hyperion 8.3, Brio 8, Oracle 9i, Teradata, Informatica 7.1.3, CITRIX, Siebel 4.9, Oracle HRMS, Toad 8.5, Solaris, Deltek Performance Manager, CostPoint, Windows XP.

Client: Confidential,Boston.
APR 2006 – March 2007
Confidential,as part of its strategic objectives, launched a project called Medical Informatics which was about performing several data analyses to help various business decision makers in the company take decisions to better manage health care delivery. I worked on this initiative as a Report Developer in the Business Intelligence Delivery team creating dashboard-type reports.
Role: Cognos8 Developer/Administrator

• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to ReportNet server
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements
• Built and Published the Packages to Cognos ReportNet according to user requirements
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio
• Worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations, conditional highlighting
• Created Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Migrated reports created in Cognos 7, CRN 1.1MR3 into Cognos 8. This migration was handled on a report-by-report basis as the seamless migration resulted in a report feature conflicts between CRN 1.1MR3 and Cognos 8.
• Worked on creating Prompts and Cascading Prompts Pages
• Worked on summary reports and detail Reports, drill-thru reports
• Created drill through reports and associated with the summary reports to get details
• Validated report results with the source data and sanctioned the reports to production environment
• Worked on scheduling and publishing the report to the Cognos Connection
• Worked on securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace
• Worked on administering ReportNet server to tune server performance to optimize speed and efficiency. Performed daily monitoring of Dispatchers & Services and logs
• Used PCOPTIMIZER (power cube optimizer) to optimize cubes created in series 7 when used in Cognos 8.
• Created complex metadata models based on multiple data sources (different databases), used dimensional framework to assemble a model based on multiple stars-schemas for generating highly complex cross-tab reports.
• Used powerplay cubes as datasources for generating models in Cognos 8.
• Used Framework Manager to externalize query subjects in order to generate IQD data sources for Powerplay cube creation in Powerplay Transformer.
• Acted as lead in troubleshooting Report performance problems.

Environment: Cognos 8, Cognos ReportNet1.1, Framework Manager, Query Studio, Report Studio, Matrix Studio, Cognos Configuration, Poweplay Transformer, LINUX, SAP BW 5.1, SAS DataFlux, IBM DB2, SQL SERVER200, WinSQL, Windows.

Client: Confidential,Georgia.
April 2005 – MAR 2006
Confidential,is one of the largest producers in the world of equipment for professional cooking and washing.
Electrolux has leading market positions in white goods products in both Canada and US. Electrolux is a world leading producer of appliances and equipment for kitchen, cleaning and outdoor use. Electrolux has two business areas, Indoor Products and Outdoor Products, both of which include products for consumers and professional users. Report Net is used to provide reporting and analytical support for the Electrolux management team. The solution will be used to generate pre-defined (standard) reports, such as Product and Region Reports.

Role: Cognos ReportNet Developer

• Installed and Configured cognos ReportNet 1.1 MR3
• Imported Meta Data from Multiple Sources like Oracle 9i , Flat files in to Framework Manger
• Created Business Views and added business values specific to reporting requirements
• Created, modified and Published Framework Manager Packages on ReportNet Server
• Implemented security using Framework Manager on Package Level, Object Level, Data Access Level For Groups, Roles and Specific Users
• Generated Ad-hoc Reports, Standard Reports Using Query Studio and Report Studio
• Created Reports different formats like HTML, PDF, EXCEL and Delimited Text.
• Created Parameters, Prompt Pages using various Prompt types (Value Prompts, Text Box Prompt, Date Prompt, Select & Search Prompt, Interval Prompt on the reports).
• Developed reports using List, Crosstab, Chart, Repeater and Blank Reports.
• Created standard Calculation on Query Item and applied various Filters to Data like Tabular, Group Filters on Query items and formatted the Reports.
• Created Drill-through connection to link 2 Reports, Book Marks and Conditional Block Lists.
• Used Tabular SQL and Tabular Set for Complex Reports.
• Provided End user Support & training to the ReportNet users on Report Studio and Query Studio.

Environment: Cognos ReportNet1.1, Framework Manager, Query Studio, Report Studio, PowerPlay Transformer, PowerPlay Enterprise Server (PPES), Deployment Manager & Cognos Configuration, Access Manager, Oracle 9i, Toad, SAP BW, Windows.

• San Francisco-based Providian Financial is a leading provider of credit cards to Middle America customers throughout the U.S. By combining experience, analysis, technology and outstanding customer service, Providian seeks to build long-lasting relationships with its customers by providing products and services that meet their evolving financial needs. As an ETL Developer was responsible for retrieving and transforming the sources from DB2, Essbase, Sybase and Flat files and load it into Oracle, also served as an administrator in installing and configuring the systems in Informatica environment.

• Worked on Informatica Power Center 5.1 tool (Source Analyzer, Warehouse designer, Mapping & Mapplet Designer and Transformation Developer) to transform data mainly from DB2, Essbase, Sybase and Flat Files and load that data to Oracle.
• Understanding of Financial Services Accounts and sales process.
• Analysis of Logical and Physical design documents to derive Detailed Design.
• Implemented Business Logic by developing Informatica mapping using various transformations like Source qualifier, Aggregator, Connected & unconnected lookups, Filter, Update Strategy, Rank, Expression and Sequence Generator for analyzing CAIM (Customer Account Information & Management)
• Hands on experience with administrative issues, which required the working knowledge of Repository Manager and Server Manager.
• Worked on Identifying and Performance Tuning by implementing optimizations of transformations like look-up, Aggregator, Filter, Expression and Partitioning.
• Development of Unit Test Plans, Integrated and System test plans and testing the same.
• PL/SQL queries were written to perform operations like joins in the source database. UNIX scripts were written at for Pre-Load and Post-Load Jobs, Scheduling of production load based on source data frequency.
• Participated in walkthrough and defect report meetings periodically.
• Built the Transformer model and Created Power cubes using the powerplay Transformer.
• Organize accessed data sources into Transformer models, Dimensional maps and developed Power-Cubes, which can be changed in many ways to ‘Slice and Dice’ and drill-through data for further multi dimensional analysis.

• Environment: Oracle 8i, DB2, SQLServer7.0, ERWIN, PL/SQL, Informatica Power Center 5.1.1, Essbase, Hyperion, Cognos EPseries 7.x, Cognos EP, Windows NT 4.0, Sun Solaris 2.5, Teradata.
• Client: Confidential,Atlanta
• Nov 2002 to April 2004
• General Electric Power Systems (GEPS) - Enterprise Data warehouse (EDW) is one of the largest data warehousing projects in the world currently in progress. The objective of the project is to build an Enterprise wide Data warehouse Solution for GEPS, which consists of Design, Development, Coding, Testing, Integration, Deployment and Maintenance of the Enterprise Data Warehouse and also to coordinate their various sources of information for better decision-making. GE Power Systems Data Warehouse is built upon integrated legacy system data feeds received from many GE-based business data sources. This process involved creation of various individual data marts and merging those data marts for final digital cockpits. This enterprise Data Warehouse project consists of around 213 data marts.

• Created the repositories and user groups using Informatica Repository Manager.
• Worked on Informatica tool-Source Analyzer, Warehouse designer, Mapping & Mapplet Designers and Transformation Developer. Extensively used the concepts of ETL to load data from Oracle database and flat files to Oracle database.
• Source qualifier, Aggregator, Connected & unconnected lookups, Filter, Update, Rank, Expression and Sequence Generator are some of the most often used transformations while transforming the customer and product data.
• Analyzed the specifications and identified the source data that needs to be moved to the data warehouse. Involved in Logical and physical database design using ERWIN.
• Created, scheduled, and monitored the sessions and batches on the basis of run on demand, run on time using Informatica Power Center Server Manager.
• Developed Aggregated Drill Down Reports based on Zip code, Location and Account Info using Drill Across on Time
• Environment: Informatica Power Center (Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer), Oracle 8.0, UNIX, LINUX, and Windows NT, Cognos EPseries 7.x.