Summary:

• Over 8 years of IT experience and 6+ years of Data warehousing experience which includes ETL and Business Intelligence
• Hands on expertise in conceptualization to implementation of business intelligence and data warehousing applications/solutions
• Experience in implementing BI Life Cycle Development, which includes Requirement Analysis, Technical Documentation, Development, Administration, Security, Testing, Implementation and Maintenance.
• Have a strong understanding of relational database design concepts and in depth knowledge of OLAP solutions.
• Experienced in using modeling tools such as ERWIN 4.0, Toad Data Modeler 3.0, MS Visio in implementing Physical, and Logical database models.
• Proficient with Business Intelligence tools using: Cognos Impromptu V7.x, 6.0, Impromptu Web Reports (IWR), Cognos Power Play Transformer V7.x, 6.6, PowerPlay Web, Impromptu Web Reports (IWR), Cognos Upfront, Access manager, Cognos Power Prompts, Cognos ReportNet 1.1, Framework manager, Report Studio, Query Studio, Cognos 8.2/8.3/8.4
• Have Administration experience in Cognos 8.2/8.4 and applied data level and user level security for Framework Manager Packages, reports.
• Involved in installation of Cognos 8.4 suite of tools and configuring LDAP for the secured authentication
• Designed and developed reports using Cognos Report studio and Dashboard reports using Analysis studio
• Designed and developed Cognos power cubes using Cognos Powerplay Transformer 7.X
• Automated Reports and generated documents using Scheduler.
• Created projects, models and published packages in Framework Manager.
• Involvement in administration of Cognos packages and reports.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica PowerCenter 7.3/6.2.
• Worked with transformations such as Source Qualifier, Aggregate, Lookup- Transformation, Rank, Joiner, Filter, Router, Sorter, Sequence Generator, Union, Update Strategy, Stored Procedure, Normalizer extensively in Informatica 7.1/7.1.1.
• Thorough knowledge of Ralph Kimball’s Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Slowly Changing Dimensions (Type1, Type2, and Type3) and Surrogate keys.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access, Sybase, and DB2 and worked on integrating data from flat files.
• Experience in indexing and performance tuning for development, test and production environments.
• Hands on experience with SQL, PL/SQL, SQL*PLUS, T-SQL, TOAD 8.5. Experience in using Oracle 10g/9i/8i/7.x, MS SQL Server 2000, for scripting and application development. Experienced writing, modifying and maintaining scripts and stored procedures for use with query and analysis and with ETL tools.
• Proficient in creating and maintaining PL/SQL packages, procedures and functions. Expertise working with triggers for database maintenance and auditing. Experience maintaining PL/SQL procedures and triggers to enable BI tools and applications.
• Developed UNIX shell scripts to be used as pre-session and post session commands and having knowledge in AWK Programming.
• Worked as a dynamic and contributing member in a multi-member team.

Tools and Technologies

Etl Tools :

Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor) and PowerMart 7.x/6.2/5.1,Informatica Repository Manager 7.1

Data Modeling Tools :

Erwin 4.0/3.5, Toad Data Modeler 3.0 , Microsoft Visio

Business Intelligence Tools:

Cognos 8.4/7.1(Impromptu, PowerPlay Transformer, Access Manager, IWR, Power Prompts, COGNOS query, Cognos ReportNet 1.1

Databases:

Oracle 10g,9i/8i,SQL Server 7.0/2000,Microsoft Access 97/2000/XP/2003, DB2 UDB

Database Tools:

SQL*Plus, SQL*Loader, TOAD 9.0, SQL Navigator 4.x

Development Languages / Tools:

SQL, PL/SQL, T-SQL, UNIX Shell Scripting, C, C++,
Matlab 6.0,Query Analyzer

Operating Systems:

UNIX, Windows 2003/XP/2000/NT/9x

Methodologies:

Ralph Kimball’s Data modeling, Star Schema and Snowflake Schema Modeling

Workflow Tools:

Microsoft Office, Macromedia Dreamweaver, Adobe Photoshop

PROFESSIONAL EXPERIENCE:
Confidential,Mar’08-Jun’10
Confidential, Chicago, USA
Data Analyst/ Cognos Administrator/Developer

Confidential,is a group of Community colleges run by the government of Illinois. It has a group of 7 community colleges with its district headquarters office building located in downtown Chicago. The department of IT has a PeopleSoft implementation for the Student Administration and financial modules and uses Cognos as their enterprise BI tool.

Responsibilities:

• Analyzed the Functional requirement document with the Business Analyst to confirm the business logic involved in computing the KPI’s for the dashboard
• Created a Technical document for the Dashboard, translating the business logic to technical details which included the design and specifications of the dashboard
• Performed preliminary data analysis of the PeopleSoft Student Administration module related to the dashboard KPI’s and created a data mapping between the source PS system to the BI data warehouse
• Wrote extensive complex SQL’s to extract data from PeopleSoft Student Administration module to the BI data warehouse
• Was partly involved in building the data warehouse using PL/SQL packages and stored procedures.
• Involved in SQL tuning analyzing the Explain Plan and suggested the DBA if the indexes needed to be rebuilt or new indexes were to be added to specific tables
• Designed the Cognos architecture based on the number of users logging into the application and the amount of traffic at any given point of time
• Installed and configured the Cognos 8.4 BI application with its complete suite of tools
• Installed and configured Microsoft IIS web server
• Determined the size of the content store forecasting the amount of reports, dashboards which were going to be developed
• Configured the LDAP namespace for the Novell Directory server to be used as the 3rd party authentication tool for Cognos 8.3 application
• Installed and configured Framework Manager Client tool to build metadata models for the reports
• Created IQD files using Framework Manager relational model
• Designed and developed power cubes using Cognos PowerPlay Transformer 7.3 with IQD file as the source
• Designed cubes for 7 campuses which part of this college community
• Optimize the performance of the cubes by partitioning and enabling the local processing option. Store the Cube in a compressed format.
• Created and published cube based package to be used in Analysis studio
• Designed and developed CCC Dashboard using graph and the cross tab display to slice and dice the KPI measures across multiple dimensions
• Dashboard had the flexibility of generating approximately 4000 static reports with multiple hierarchies, drill ups and drill downs
• Developed drill through detailed level reports from summary level Dashboard reports using Report Studio
• Built interactive and complex dashboards using Cognos Go! Dashboard.
• Set up user level security for the users of Cognos Go! Dashboard
• Set up user level, data level security for the published Cognos packages
• Administered by setting up the Cognos security settings at package, report level using the Cognos connection administration portal with restricted features depending on the class of user
• Worked on performance tuning of the dispatchers to handle requests better and optimize the performance of the application
• Tested the security settings using authentication information of different classes of users
• Maintained Development and Production instances of Cognos 8.3 BI
• Worked with DBA’s in devising back up strategy for the Cognos Content store database
• Troubleshooting the environment in case the BI server goes down or contact the DBA in case of the down time of the content store database
• Involved in data Validation and creating SQL test cases
• Was partly involved in building the data warehouse using PL/SQL packages and stored procedures
• Supported and modified PL/SQL packages
• Supported and executed UNIX shell scripts

Environment: Cognos 8.4, Cognos PowerPlay transformer 7.3,Oracle 9i, DB2, People Soft SA, Microsoft IIS V6.0 Web server, Toad 9.0, SQL Plus, IBM Cognos Go! Dashboard

Confidential,Apr’07- Mar’08
Confidential,GA, USA
Cognos Developer

Confidential,vast array of services including logistics for an efficient supply chain system for industries, Transportation & Freight, IT support for the clients, International trade, Consulting Services etc.
Project Background:
Confidential,is a front end application provided by UPS Supply Chain Solutions for its customers to track the status of their shipments. Flex Global View Cognos Reports are developed for different modules such as Purchase Order, Transportation, Customs and Brokerage, Warehouse Management.

Responsibilities:

• Analyzed and discussed Functional Design Documents (FDD) with the Business Analyst
• Created a Technical Design Document (TDD) for every report developed
• Followed the complete SDLC process involving analyzing FDD, creating TDD, developing reports in dev environment, migrated to UAT environment and then finally to production after getting the approval from QA & testing team
• Involved in administration of Cognos Reports and models by applying the security settings at the data and user level using the Cognos portal.
• Used Framework Manager to build models, packages and publish packages to the Cognos connection
• Used Report Studio to build multi-page, multi-query reports against Oracle database. Developed Standard Reports, List Reports, Cross-tab Reports, Charts, and Multiple levels of Drill through Reports using Report Studio
• Extensively used Tabular SQL in developed reports
• Created templates for standard reports and extensively used various formatting features
• Created Calculations, Prompts and Filters queries for usage in various Reports
• Involved in administration of reports by assigning appropriate user classes and providing permissions.
• Deployed reports in different environments using Import, Export utility.
• Provided permissions to the users at the package level using the Cognos Connection portal.
• Created and modified Catalogs in Impromptu based on user requirements and changing business needs
• Created Impromptu Web Reports and published them on the web server and later on Upfront
• Worked with administrator in providing user class security on different servers.
• Maintained & updated power cubes based on changing business requirements by adding new Dimensions, Levels and Measures
• Published Cubes and Reports through PowerPlay Enterprise Server Administration and integrated access to information using Cognos Connection
• Used Java Scripting to customize and create standard report templates
• Analyzed Explain Plan using Toad for tuning and improving the performance of the SQL used in the reports
• Worked with DBA in rebuilding the required indexes for performance improvement of views and materialized views
• Maintained versions of the code developed and the technical documents in ‘PVCS’ version manager
• Worked with simple UNIX file commands

Production Support

• Member of a “Quick Turn Team” and handled tickets from Prod. Support level III
• Fixed bugs and resolved data inconsistencies in the reports with a fast turn around time
• Conducted knowledge sharing teams with the various Prod. Support teams

Nokia Project

• Acted as one of the Principal Investigators in the project
• Coordinated with the BA and facilitated meetings involving other team members
• Made modifications in the existing code of a PL/SQL procedure and fixed the bugs
• Created temporary tables to improve the performance of the PL/SQL procedure
• Conducted unit testing on the code
• Worked with DBA in the code release

Environment: Cognos series 7.0/8.2, Access Manager, Impromptu7.1, Cognos Upfront, Toad 8.6, SQL Plus, UNIX, Ultra Editor
Confidential, Jan’06-Mar’07
Confidential,KS, USA
Cognos/Informatica Developer

Confidential, is a large telecommunications corporation in the US. It has a long story of mergers and acquisitions, which have made it an important player and an IT integration challenge.
Project Background:
Existing systems had a strong focus on services provided and functionality. The marketing department’s CRM required improved customer information, which the system was not made to handle. The marketing department pushed for a new CRM system, more powerful and which would not be dependent on the billing DWH. This required upgrading the Data Mart, re-designing of the ETL, and rebuilding of reports.

Responsibilities:

Cognos Developer:

• Identify and gather the requirements for a maintenance data warehouse, maintenance procedures analysis, corporate budget analysis on maintenance activities along with Data Store and data mart requirements, made plan of transformation of data to the data warehouse, data architecture modeling, create transactional and dimensional models and documented the process.
• Used Framework Manager to build models, packages and publish packages to the Cognos connection.
• Created and modified Catalogs in Impromptu based on user requirements and changing business needs.
• Created Impromptu Web Reports and published them on the web server and later on Upfront.
• Created Calculations, Prompts and Filters queries for usage in various Reports.
• Used Report Studio to build multi-page, multi-query reports against multiple databases. Developed Standard Reports, List Reports, Cross-tab Reports, Charts, and Multiple levels of Drill through Reports using Report Studio.
• Added Security for transformer models and Power Play cubes using Access Manager.
• Making Cubes & Reports centralized and accessible through a customizable interface to the unique needs of different types of Users using Upfront.
• Improved the design and performance of existing Catalogs and also created a new Catalog for development of new reports.
• Expertise in creating and analyzing the complex reports (Cross tab, drill-thru reports, Prompts, filters, and calculations) and in creating reports from the multiple data sources. Used prompts like Type-in, file pick-list, report pick-list and catalog pick-list for filtering data in Impromptu.
• Analyzed data for trend analysis and finding patterns in consumer behavior. Worked closely in a multi-member team environment.
• Using the multidimensional features in PowerPlay, tracked sales and costs by district, type of product, and size group of the product.
• Used drill-down features to integrate PowerPlay and Impromptu, to analyze cost detail to an activity level for any customer order.
• Created Dash boards and Score cards in metric studio to keep track of various parameters like products costs, profitability, sales etc.
• Helped in identifying the Key Performance Indicators (KPIs) of the maintenance activity, like maintenance planning Index. Defined and analyzed KPIs for the maintenance environment.
• Generated maintenance planning index Digital dashboards to help maintenance executives see performance data in real-time and make adjustments to meet goals, including outsourcing maintenance personnel and increasing frequency of preventive maintenance tasks.
• Created scorecards to track machine breakdown rate trends against workload.
• Involved in Business Data Analysis, Design, Development of Multidimensional OLAP Cube including deployment and maintenance of cubes.
• Created drill-through targets to another Report or Cube using Impromptu reports, ReportNet reports and PowerPlay Reports.
• Published Cubes and Reports through PowerPlay Enterprise Server Administration and integrated access to information using Cognos Connection.
• Used PowerPlay Transformer with a variety of imported data sources and combined them into Multi-Dimensional Cube.
• Created Macros and Batch files for automating tasks and Job Scheduling.
• Used time state rollups, average rollups and external rollups in some Transformer Models.
• Worked as a dynamic and contributing member in a multi-member team.

Informatica Developer:

• Worked on Informatica PowerCenter 7.1 tools - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• As part of ETL process, loaded data from Flat files, Heterogeneous Database tables and Excel spreadsheet into target Oracle 10g database and applied Business Logic on Transformation Mapping for inserting and updating records when loaded.
• Worked on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Update Strategy, and Sequence Generator.
• Created Stored Procedures and used them in the mappings by using them as Connected and Unconnected Stored Procedure Transformations in the mappings.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Worklets and Sessions and scheduling them to run at specified time before creating Jobs.
• Written PL/SQL subprograms i.e. procedures and functions for value calculations, and manipulations of the data.
• Involved in User Acceptance Testing (UAT) just make sure the data was migrated according to the requirements and that the marketing team had no trouble retrieving the data.

Environment: Cognos series 8/7.x ReportNet, OLAP builder, Analysis studio, Metric studio, Access Manager, Impromptu7.1, Toad, MS-Excel and Windows NT. UNIX.
Informatica PowerCenter 7.1, Oracle 9i, DB2, Sql Server 2000, Microsoft Visio, SQL*Plus, PL /SQL, Toad 8.6, Windows NT, UNIX

Confidential, Jun’04-Dec’05
Confidential,St.Louis, MO, USA
Cognos Developer

MetLife is one of the US largest insurers. The company offers the same to groups and individuals in the Asia/Pacific region, Europe and Latin America. The company’s Reinsurance Groups of America, but serves customers around the world.
Project Background:
The purpose of this project was to create a business-level extract of insurance data for management-level decision support. The claims, policies, quote, and premium data from different regions was collected and transformed as input into a data-warehouse. The data elements were manipulated and scrubbed according to business requirements before being loaded into Oracle data-warehouse.

Responsibilities:

• Analyzed current business processes, assessed opportunities for redesigning these processes, and defined Business Intelligence requirements that will support newly designed processes. Interacted with different system (Application & Database) administrators to collect the requirements for the above analysis.
• Imported metadata from sources such as Relational Databases, ReportNet models, Impromptu Catalogs into the Framework Manager.
• Created xml from the impromptu catalog and exported into the ReportNet Metadata. Created Models and Packages based on business user requirements using Framework Manager.
• Developed the metadata layer in Framework Manager in conjunction with the logical and physical data models.
• Mappings to build the Frame work Manager Models and Packages with customized Query Subjects and Query items were built and these were published as packages from ReportNet Framework Manager to Cognos connection.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio. Worked on Standard Reports in Report Studio and Ad-hoc reports in Query Studio for users.
• Expertise in creating and analyzing the complex reports (Cross tab, drill-thru reports, Prompts, filters, and calculations) and in creating reports from the multiple data sources. Created templates for standard reports and extensively used various formatting features.
• Used prompts like Type-in, Value, pick list for filtering data in report studio.
• Used prompts like Type-in, File, Catalog and Report pick-list for filtering data in Impromptu.
• Based on the requirements made various types of reports including cross tab, list and graphical reports.
• Worked on bursting reports for the web users or email users or to directories.
• Prepared on demand ad hoc and professional reports in Impromptu.
• Automating of cubes in scheduler (generating the models and refreshing the cube during off-peak hours).
• Maintained & updated power cubes based on changing business requirements by adding new Dimensions, Levels and Measures.
• Added Security for transformer models and Power Play cubes using Access Manager.
• Analyzed data for trend analysis and finding patterns in member responding to promotions.
• Worked closely in a multi-member team environment.

Environment: Cognos ReportNet 1.1, Transformer 7.1, PowerPlay 7.1,Impromptu, PowerPlay Enterprise Server 7.1 PL/SQL, TOAD, Oracle 9i, MS SQL Server 2000, Windows 2003/2000 Server, UNIX.

Confidential, Aug’03-May’04

Confidential,Chicago, IL
Cognos/Informatica Developer

Confidential,is one of the largest electricity and Gas Company in the United States.
Project Background:
The company needed to develop this data warehouse to provide billing history to its customers. The sales, commission and internal revenue analysis data mart was integrated with global data warehouse. This data mart is built to do vendor performance analysis, to monitor receipts, track & record deliveries.

Responsibilities:

Cognos Developer:

• Gathered user requirements and business analysis reports from various business owners.
• Created and modified Catalogs based on user requirements and changing business needs.
• Created ad hoc reports using Cognos Impromptu tool.
• Created periodically and on demand List Reports and Cross Tab Reports and Drill Through reports.
• Created standard filters, calculations, prompts and conditions in catalog to meet user and business requirements. Customized data by adding calculations, summaries and functions.
• Reports included features such as exception highlighting, sorting, ranking etc.
• Created summary and detailed filters to assist in focused analysis and accurate decision-making.
• Created Impromptu Web Reports and published them on the web server and later on Upfront.
• Created Trend over Time reports, Top Ten Reports and Exception Reports Accessed data from data marts using Impromptu & PowerPlay extensively.
• Used Report Studio to build multi-page, multi-query reports against multiple databases.
  Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Good in creating Query Prompts, Calculations, Conditions, Filters, Bursting Reports and Multilingual Reports Using Report Studio and Query Optimization.
• Analyzed reports and standardized those using Power Prompts and Charts.

Informatica Developer:

• Interacted with functional teams and users for finalizing the data models and reporting structures.
• Complete understanding of the applications of oracle for building clear and error free mappings, extraction routines.
• Performed data modeling using Erwin tool and standard RDBMS Database design concepts.
• Participated in designing of dimension model (star schema), prepared ETL standards, naming conventions and wrote ETL flow documentation.
• Involved in analysis, design and development to ensure the successful execution of the data loading processes.
• Created, launched and scheduled session, batches using Power Center Server Manager. Scheduled session tasks comprising of different mappings in order to load data into oracle Database.
• Optimized/Tuned mappings for better performance and efficiency. Involved in performance tuning of SQL Queries, Sources, Targets and sessions. Designed and developed Informatica mappings for data loads and data cleansing.

Environment: Informatica PowerCenter 6.2, Cognos ReportNet 1.1, Transformer 7.1, PowerPlay 7.1,Impromptu, PowerPlay Enterprise Server 7.1,Oracle 8i, SQL Server 2000, Toad, Sql*PLUS, PL/SQL, Sun Solaris, UNIX, Windows NT,

Education:

• Master of Science in Engineering