Summary

I have over 12 years of experience in executing medium to large scale IT projects involving SDLC and Agile methodologies. Working in different industries and functional groups insurance, financial, marketing and media gave me a very good understanding of different challenges involved in IT projects. My experience implementing projects from scratch to final roll out and exposure to various technology tools helped me learn various design patterns and techniques to select right solution for successful project execution. I have strong experience in executing Data Warehouse and BI projects and extensive experience in ETL and BI tools. I have strong analytical skills and inclination towards data analysis which helps implement right data model and put right process for technology solutions.

Technical Experience

• Project Management:
• Manage Project Plan, deliverables, task allocation, track risks/issues status reporting
• Prioritize deliverables with team and business users
• Coordinate requirement with regional functional users and assist them in UAT phase
• Manage development across onsite offshore teams
• Ensure quality deliverable by peer review of design, documentation and testing
• Coordinate production releases with support change management team
• Tools: Microsoft MPP, Excel, Visio, JIRA, QC
• Data warehouse Architect:
• Data modeling for OLAP and OLTP systems using various modeling tools
• Implemented various techniques like ODS, Functional Data Mart, Enterprise DW
• Good understanding of normalization and de-normalization techniques
• Design process flow dependency diagrams, maintain data dictionary database standards
• Tools: Erwin, ER Studio, Vision

ETL:

• Design, develop, standardize, and review of Informatica ETL mappings
• Developed ETL design standards and performance tuning guidelines
• Design complex ETLs involving various transformation such as XML, Loaders Webservices
• Use of PowerExchange for connectivity to disparate source target systems
• Maintaining reusable objects such as mapplets and transformations in global repository
• Scheduling programs using scheduler such as Autosys, Appworx, Cronjob Maestro etc.
• Tools: Informatica Power Center, Data Stage, Power Exchange
• Business Intelligence Reporting:
• Expert in Universe design for ad-hoc reporting
• Extensively used features such as Joins, Alias, Contexts, Aggregate tables
• Developed various Web Intelligence report and dashboards using Xcelcius
• Used advance reporting techniques such as Filters, Prompts, Drill-thru, Sections, Breaks etc
• Administration and deployment using CMC and CMS
• Tools: IBM Cognos 10

Database:

• Extensive experience in various databases
• Strong experience in T-SQL PL/SQL
• Extensively used loaders utilities Bulk loader, B-TEQ, Fast Load, MultiLoad, FastExport
• Effectively used advance SQL such as Hierarchical queries, analytical functions
• Performance tuning using appropriate Indexes, Partitioning, Aggregate storage, MVs etc
• Databases: Oracle, Teradata, DB2, Sybase ASE/IQ, SQL Server, MS Access
• Tools: Rapid SQL, DBArtisan, TOAD

Industry Domain

• Financial: Executed projects for GECF and TMNAS Insurance companies. Developed applications and data warehouse for different functional groups.
• Media and Marketing industry: Worked on various report generation for Time Warner Group

Project Details

Confidential

Role:

• using Business Insight Advanced.
• Acceptance Testing CAT , and Performance Testing.
• HTML items.
• parameter displays, Conditional blocks,Bookmarks, Render Variable, applied Javascripts in
• Oracle, DB2, Teradata Flat Files.
• entire range of enterprise reporting requirements.
• provided deliverables on data mapping documentations, and reporting matrix.
• Involved in the development of High Level Design and translating business requirements
• technical documentation to accelerate project development.
• Analyzing ongoing data feed to defined benefits database and developing reports for continued functional reconciliation purposes as well as conforming to new system requirements.
• Developing customized reports for Business Users and implementing modifications as per requests form client CRAs and BAs
• Using Framework Manager, developed business model to adhere with user specifications
• Created various report types like list reports, cross tab, charts, Dashboards. that cover the
• Created OLAP cubes using PowerPlay Transformer against various data sources like
• Used various functionalities in report studio like drill throughs, conditional formatting,
• Created Dashboards and implemented various functionalities like Dynamic Sorting, Dynamic selection of columns using Cognos Report Studio.
• Working with DBAs to ensure table structures adhere with end-user reporting needs
• Developed testing strategies in-accordance with different environments to test and validate reports ensuring apt specifications and requirements for Systems Acceptance Testing SAT , Client
• Providing internal and external walkthroughs for translating online application GUI into backend data to developers, testers, business users, and systems analysts
• Working with quality-assurance management in implementing dashboards for Metrics analysis Scheduling jobs to run reports in Cognos to distribute financial reports to various user-groups in the organization to conduct performance-testing in different environments
• Responsible for handling production support by reviewing report data, conducting data analysis and escalating issues and concerns to upper management
• Providing end-user training during post-production phase and guiding them with using Cognos and understanding of Data Setup.
• Created and share interactive dashboards by using Business Insight.
• Pull information from multiple prebuilt reports or other sources and combine them into a
• single dashboard style interface by using Business Insight
• Created reports with multiple query objects Charts, Lists, Crosstabs by
• Environment: Cognos 8.4/8.3/10.2.1 Report Studio, Analysis Studio, Query Studio Cognos
• Transformer, Power play 7.3, Oracle 11i,DB2 and Toad

Confidential

Role

• Designed models using Framework Manager and deployed packages to the Cognos8 server.
• Built Framework Manager Models, and established the cardinalities to suit the business needs.
• Imported various data sources such as Relational Databases, flat files, PL/SQL Procedures into the Framework Manager.
• Created OLAP cubes using PowerPlay Transformer against various data souces like Oracle, DB2, Teradata Flat Files.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Optimized the performance in power play cubes by reducing the query time and partitioned cubes.
• Created Custom Exceptions in Cubes for better presentation.
• Created various report types like list reports, cross tab, charts, Dashboards. that cover the entire range of enterprise reporting requirements.
• Used various functionalities in report studio like drill throughs, conditional formatting, parameter displays, Conditional blocks,Bookmarks, Render Variable, applied Javascripts in HTML items.
• Created Dashboards and implemented various functionalities like Dynamic Sorting, Dynamic selection of columns using Cognos Report Studio.
• Created summary tables to increase the performance of the Dashboard reports.
• Worked with the users for report enhancements and other data related issues.
• Used Java Scripts to enhace report functionalities like for default selections, saving picklist to local file, Colapsible Hierarchies etc.
• Worked on Cognos Go office to show Cognos repots in power point and excel.
• Created portal tabs to show report on Cognos connection.
• Personalized Cognos Connection, Specified display options, regional options and personal information.
• Used busrting options and scheduled reports to run at a different time to send e-mail to users.
• Involved in setting up the Cognos 8.3,8.4 environment in the organization on windows environment.
• Used Informatica Client tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Informatica Power Center is used to extract the base tables in the data warehouse and the source databases include Oracle,DB2, Flat files, MS Access.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Cognos 8.4/8.3/10.0 Report Studio, Analysis Studio, Query Studio Cognos

Transformer, Informatica, Oracle 11i, DB2 and Toad

Confidential

• Involved in Planning and implementation of Cognos8 BI Suite.
• Involved in migrating data from cognos Planning tool to Cognos BI server
• Created OLAP cubes by using cognos Powerplay transformer
• Created Metadata Modeling by using multiple databases in Cognos 8 BI Modeling.
• Created and published packages from Cognos 8 BI Modeling.
• Created Complex Reports in Cognos 8BI Report Studio.
• Created PowerPlay Reports by using Analysis Studio.
• Created Scheduled Jobs by scheduling multiple reports in a job.
• Published PowerPlay Cubes onto Cognos Connection by using Cognos 8 BI Modeling.
• Integrated Series 7 Security within Cognos 8BI.
• Upgraded ReportNet Reports, Packages and Data Source Connections into Cognos 8 BI.
• Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.
• Created Metadata modeling by using Framework Manager.
• Imported metadata from various sources such as Relational Databases, Report Net models, Impromptu Catalogs into the Framework Manager
• Used Query Studio to develop ad hoc reports
• Created Power point Slides using Cognos GO Office and Published to Cognos Connection.

Environment:

• Event Cluster Process initiates when the Source to Bucket process is completed, in which Event Ids are assigned depending on the Event type like Property Description, Ownership Transfer and Assessment etc., to get the what recent event has occurred on the Particular Property depending on the Event Match.
• Source to Bucket process in which the respective column values from Source will be filled into the respective Column values depending on the Filter Condition and Mapping rules.
• Confidential
• Cognos 8.2/8.3/8.4, Framework Manager, Transformer, Report Studio, Query Studio,Analisys Studio, Event Studio,Metric Manager, Cognos BI Tools, Cognos Go Office, Oracle10g, DB2, Teradata, Toad,Informatica, Data Stage, Erwin 4.5, Microsoft OLAP Services, windows 2003 server, Linux
• Eventually, Bucket to Output Process initiates when the Event Cluster process is completed. The respective Output tables like Property, Name, Lien and Property Sale are updated.

ROLE:

• Installed and Configured Cognos 8BI Suite in multi server environment on Windows and Unix environments.
• Involved in Planning and implementation of Cognos8 BI Suite.
• Created Metadata Modeling by using multiple databases in Cognos 8 BI Modeling.
• Created and Published packages from Cognos 8 BI Modeling.
• Created Complex Reports in Cognos 8BI Report Studio.
• Created Powerplay Reports by using Analysis Studio.
• Scheduled Content Store Backup.
• Created Scheduled Jobs by Scheduling multiple reports in a job.
• Published Powerplay Cubes onto Cognos Connection by using Cognos 8 BI Modeling.
• Integrated Series 7 Security within Cognos 8BI.
• Upgraded Reportnet Reports, Packages and Data Source Connections into Cognos 8 BI.
• Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.
• Created and scheduled different portlets.
• Created Dashboard indicators.
• Involved in architecture and design of the Cognos Report Net 1.1 Application.
• Created Metadata modeling by using Framework Manager.
• Imported metadata from various sources such as Relational Databases, Report Net models, Impromptu Catalogs into the Framework Manager.
• Created OLAP cubes by using Powerplay Transformer.
• Writing JavaScript for some of the reports to overcome the limitation of CRN, not allowing the multiple values for input parameter from the Stored Procedure.
• Created complex reports by using Report Studio.
• Used Query Studio to develop ad hoc reports
• Did Unit Testing for all reports and packages.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance .
• Creating report views with saved prompts and schedule according to the business requirement.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Used SAPBW as backend database.
• Migrated reports from crystal reports to Cognos 8BI
• Personalized Cognos Connection, Specified display options, regional options and personal information.
• Migrated existing Cognos series 7 application to Cognos Report Net 1.1
• Migrated Cognos Reportnet reports into Cognos 8BI.
• Used SDK to validate reports for Cognos Reportnet and Cognos8 SDK.
• Used SDK to create report distribution in remote servers.
• Used SDK to query the content store and print all the report names in folders and subfolders under each package in the public folders, for a particular user, using the Axes and Node Tests
• Deployed reports, packages and folders from DEV to UAT and from UAT to PROD environments.
• Implemented security in Framework Manager packages.
• Integrated Cognos Series 7 Security in Report Net.
• Integrated Cognos Upfront News boxes and News Items in Cognos Connection.

Environment:

Cognos 8.0 BI Suite,Cognos Reportnet 1.1, Framework Manager, Transformer, Metric Manager, Report Studio,Query Studio,Cognos Series 7.3/7.4, Impromptu Administrator,Power Play Transformer, Impromptu Web Reports, Powerplay Enterprise Server, Upfront, Oracle10g, DB2, Teradata, Toad,Informatica, Data Stage, Erwin 4.5, Microsoft OLAP Services, windows 2003 server, Linux.