SUMMARY

• BI Solution Architect and BI Practice Lead / Manager
• Over Fifteen years of IT experience in software design, development, testing and maintenance
• Ten plus years in Data Warehousing, Data Modeling, ETL, Business Intelligence (BI), Decision Support Systems (DSS) and Customer OLAP application development in Windows and Unix
• Worked in a Data Warehouse and Business Intelligence Projects for the Fortune 500 clients as an efficient team member with the teams of Informatica (ETL), Business Objects, Cognos and ReportNet
• Leading and Managing BI projects
• Cognos and Brain Bench Certifications
• Expertise in Cognos (Framework Manager modeling, PowerPlay Transformer modeling and administration)
• Design and Analyze Business and Technical Models
• Providing End to End BI solution for effective decision making
• Design and build the Data Warehouse, Data marts and the Metadata Management solutions
• Reporting solution migration
• Architecture, Development and Administration of Cognos applications
• Administration of Access Manager to implement Security among Cognos applications
• Installation and Configuration of Cognos products for building Multidimensional Cubes and ReportNet reports
• Migration and upgrading Cognos products
• Design and create appropriate Impromptu catalogs, PowerPlay Transformer models, PowerPlay cubes and Framework Manager models.
• Excellent database and reporting skills
• Advanced query writing and trouble shooting
• Provided extensive End User Training and Support
• Manage and deliver BI projects

TECHNICAL SKILLS

OLAP Tools: Cognos 10.x and 8.x (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Dynamic Cubes, Go Office and TM1), ReportNet 1.1 (Framework Manager, Cognos Connection, Report Studio and Query Studio,), Cognos 7.3/7.1, EP Series 7.0 / 6.0 (Impromptu, PowerPlay, Access Manager, Architect, NoticeCast, Impromptu Web Reports, Cognos Query, Upfront, Visualizer and Metrics Manager), Business Objects 5.1 (Designer, Business Objects and Supervisor,) and Oracle BI EE 10.3.2.3 (Analytics, Answers, Dashboards, Administration Tool and BI Publisher)

ETL Tools: Informatica 4.x/5.0/5.1, IBM MDM

Query Tools: ShowCase STRATEGY 4.0

Databases: SQL Server 2005/6.0/7.0 , Oracle 7.x/8i/9i, DB2, Sybase, MS Access, Teradata

Languages: C, C++, COBOL, Pascal, SQL* Plus, Java, PL/SQL and T - SQL

Operating Systems: UNIX (Sun Solaris, AIX,), Windows 95/98/2000/2003/ NT, MS DOS

Project Methodologies: SDLC, Agile, SCRUM

Concepts: Data Warehousing, ETL, BI, MDM and Big Data

PROFESSIONAL EXPERIENCE

Confidential, NC

Cognos Expert

Responsibilities:

• Requirements gathering and analysis
• Developed complex reports and dashboards
• Developed Map reports
• Analysis and inspection of the technical solution provided
• Contribute to the brain storming sessions over requirements and solutions
• Closely worked with the ETL and Business Teams.
• Supporting the client side development team with the report development

Environment: Cognos 10.2, Talend, My SQL and Windows

Confidential, CT

BI Solution Architect

Responsibilities:

• Managing the Cognos L2 and L3 support teams in the areas of application and administration
• Providing expert architectural solutions
• Coordinating the client and TechM project teams
• Analysis and inspection of the technical solution provided
• Performing root cause analysis
• Validating the documentation
• Delegation of technical assignments
• Team mentoring and support

Environment: Cognos 10.1.2 BI and TM1, Informatica9.5, Spotfire, Oracle 11G and Windows

Confidential

BI Solution Architect/SMTE

Responsibilities:

• Leading Cognos and DataStage Teams
• Providing expert architectural solutions
• Successfully lead the Cognos upgrade project from versions 7 and 8 to 10.
• Coordinating the client and MSat project teams
• Analysis and inspection of the technical solution provided
• Hands on developing FM models, Transformer Models and Dashboards
• Design and develop POCs for Cognos 10 Active Reports and Dynamic Cubes
• Contribute to the brain storming sessions over data model design, performance tuning and project technical implementation
• Validating the documentation
• Delegation of technical assignments
• Team mentoring and support

Environment: Cognos 10.1.1/8.41/7.4/7.3 , DataStage Oracle 10G and Windows

Confidential

BI Solution Architect

Responsibilities:

• Requirements gathering and analysis and suggesting appropriate solutions
• Coordinating the client and MSat project teams
• Designed and developed various types of Cognos 8 Framework Manager Models and cube models.
• Contribute to the brain storming sessions over data model design, performance tuning and project technical implementation
• Created database and business views in the FM models
• Validating the documentation
• Delegation of technical assignments
• Team mentoring and support

Environment: Cognos 8.41, Oracle 10G and UNIX

Confidential

BI Technical Lead

Responsibilities:

• Requirements gathering and analysis and suggested multiple solutions
• Designed and developed various types of Cognos 8 Framework Manager Models and cube models.
• Contribute to the brain storming sessions over data model design, performance tuning and project technical implementation
• Created database and business views in the FM models
• Applied appropriate query subjects, namespaces, folders, joins, cardinalities, and short cuts in the FM model according to the reporting requirements
• Created multi-dimensional PowerPlay Transformer models to create cubes
• Published FM packages and PowerPlay cubes on to the Cognos connection
• Developed report using Report Studio, Analysis Studio and Query Studio
• Scheduled report runs and to email the results to the users on Cognos Connection
• Implemented various levels of security to the data and Cognos components
• Wrote SQL queries useful for data quality and performance tuning
• Created Project plans, estimated modules
• Identified, assessed, prioritized and highlighted risks
• Managed ETL and Cognos teams
• Delegated and monitored various technical tasks
• Acted as the bridge between the ETL and Cognos teams
• Provided the technical knowledge and guidance to the team
• Performed code and quality reviews
• Built reusable components
• Worked with the top level management
• Reviewed functional specification documentation, technical specification documentation and user documentation

Environment: Cognos 8.41, Cognos 8.2, Cognos 7.2 and Cognos 7.4, Oracle 10G and Sun Solaris

Confidential, CA

Cognos Expert

Responsibilities:

• Requirements gathering and analysis
• Designed and developed various types of Cognos 8 Framework Manager Models and cube models.
• Contribute to the brain storming sessions over data model design, performance tuning and project technical implementation
• Created database and business views in the FM models
• Applied appropriate query subjects, namespaces, folders, joins, cardinalities, and short cuts in the FM model according to the reporting requirements
• Created multi-dimensional PowerPlay Transformer models to create cubes
• Published FM packages and PowerPlay cubes on to the Cognos connection
• Developed report using Report Studio, Analysis Studio and Query Studio
• Developed complex reports such as drill-thru, OLAP, interactive, chart and multi-queried reports
• Implemented various levels of security to the data and Cognos components
• Provided optimized solutions with appropriate report logic and data base table/view changes
• Migrated reports and packages from development to production environment
• Upgraded FM models and Report Studio reports from Cognos 8.2 to Cognos8.41
• Upgraded Transformer Models from Cognos 7.2 to Cognos 7.4
• Implemented audit logging and audit reporting to monitor report usage and run-times to improve the performance
• Authored functional specification documentation, technical specification documentation and user documentation

Environment: Cognos 8.41, Cognos 8.2, Cognos 7.2 and Cognos 7.4, Oracle 10G and Sun Solaris

Confidential, DC

Cognos Upgrade Expert

Responsibilities:

• Upgrading Impromptu reports to Report Studio reports
• Implemented advanced options that are available in the latest version to increase the report usability
• Developed reports using Report Studio
• Created complex reports with heavy formatting, Page Sets and drill-through
• Bursting reports
• Provided optimized solutions with appropriate report logic
• Providing technical guidance to the team members
• Authored functional specification documentation, technical specification documentation and user documentation

Environment: Cognos 8.4, Impromptu 7.3, Oracle RAC and Windows

Confidential, IL

Sr. Cognos Solution Architect/ Delivery Management

Responsibilities:

• Gathering report requirements from the users
• Converting requirements into functional and technical documents
• Responsible for delivering reporting solutions to the client
• Assigning and monitoring off-shore team work load
• Designed and developed Framework Manager Models
• Contributing in brain storming sessions for data model design, performance tuning and project technical implementation
• Created database, business and calculation views in the FM models
• Defined dimensions, levels and measures in the PowerPlay Transformer to create multi-dimensional cubes
• Applied appropriate query subjects, namespaces, folders, joins, cardinalities, and short cuts in the FM model according to the reporting requirements
• Developed reports using Report Studio and Analysis Studio
• Scheduling reports to distribute report outputs
• Developed complex reports such as trend in time analysis.
• Writing SQL to create and update database tables
• Provided optimized solutions with appropriate report logic and data base table/view changes
• Providing technical guidance to the team members
• Authored functional specification documentation, technical specification documentation and user documentation

Environment: Cognos 8.2, MS SQL Server 2005 and Windows

Confidential, CA

Cognos Data Modeler/Developer

Responsibilities:

• Gathering report requirements from the users
• Designed and developed Cognos 8.3 Framework Manager Models such as relational and dimensionally modeled relational (DMR)
• Contributing in brain storming sessions for data model design, performance tuning and project technical implementation
• Created database, business and dimension views in the FM models and publishes packages
• Applied appropriate query subjects, namespaces, folders, joins, cardinalities, and short cuts in the FM model according to the reporting requirements
• Developed report using Report Studio
• Developed complex reports to build reports that displays planned vs actual P&L accounts in user selected currencies at user selected currency rates
• Developed variance reports compare P&L numbers between various forecast scenarios and actuals by CBL, territory and formats
• Provided optimized solutions with appropriate report logic and data base table/view changes
• Migrated reports and packages from development to production environment
• Providing technical and functional guidance to the team members
• Authored functional specification documentation, technical specification documentation and user documentation

Environment: Cognos 8.3, DB2, SAP BW and Windows

Confidential, SC

Cognos Implementer / Cognos Architect

Responsibilities:

• Installation and configuration of Cognos 8.3 on IBM AIX
• Designed and developed various types of Cognos 8.3 Framework Manager Models such as relational and dimensionally modeled relational (DMR)
• Contributing in brain storming sessions for data model design, performance tuning and project technical implementation Created database, business and dimension views in the FM models
• Applied appropriate query subjects, namespaces, folders, joins, cardinalities, and short cuts in the FM model according to the reporting requirements
• Developed report using Report Studio and Analysis Studio
• Implemented various levels of security to the data and Cognos components
• Provided report access to various users with appropriate permissions by defining appropriate user groups and user roles in Cognos Connection
• Organized folder and reports on the Cognos portal into Development, Quality Analysis, User Acceptance and Migration areas
• Provided optimized solutions with appropriate report logic and data base table/view changes
• Migrated reports and packages from development to production environment
• Migrated sales reports from SAS reports to Cognos
• Presented BI team with the Cognos work flow sessions
• Conducted user and BI team Cognos training sessions
• Authored functional specification documentation, technical specification documentation and user documentation

Environment: Cognos 8.3, SAS, Oracle 10.3, IBM AIX and Windows

Confidential, SC

Cognos Architect/Administrator/ Lead

Responsibilities:

• Requirements gathering and analysis
• Designed and developed various types of Cognos 8 Framework Manager Models such as relational, dimensionally modeled relational (DMR) and cube models.
• Contributing in brain storming and SCRUM sessions for data model design, performance tuning and project technical implementation Created database and business views in the FM models
• Applied appropriate query subjects, namespaces, folders, joins, cardinalities, and short cuts in the FM model according to the reporting requirements
• Created multi-dimensional PowerPlay Transformer models to create cubes with external rollup measures.
• Published FM packages and PowerPlay cubes on to the Cognos connection
• Developed report using Report Studio, Analysis Studio and Query Studio
• Developed complex reports such as drill-thru, OLAP, interactive, chart and multi-queried reports
• Bursting reports
• Developed Mill Operations Report PowerPoint presentation using Cognos Go Office Connection
• Scheduled report runs and to email the results to the users on Cognos Connection
• Implemented various levels of security to the data and Cognos components
• Provided report access to various users with appropriate permissions by defining appropriate user groups and user roles in Cognos Connection and user groups in Access Manager.
• Organized folder and reports on the Cognos portal into Development, Quality Analysis, User Acceptance and Migration areas
• Provided optimized solutions with appropriate report logic and data base table/view changes
• Migrated reports and packages from development to production environment
• Migrated Cognos Content Store from SQL Server to Oracle
• Migrated BusinessObjects Universes and reports to Cognos
• Recreated reports in SAS FMS to Cognos
• Designed data model for the FMS project
• Created D-Lists, D-Cubes and D-Links using Cognos Analyst
• Generated GL by gathering data from various sources
• Created Income statements, Expense sheets, Summarized Overheads and other adjustments
• Integrated Planning and BI to distribute D-Cubes and reports
• Maintained Financial models, processes, validations, metrics and controls
• Worked with Excel Add-In for Analyst and Contributor
• Presented BI team with the Cognos work flow sessions
• Involved in QA and UAT phases
• Wrote SQL queries useful for testing
• Successfully installed and configured Cognos 8.3 on the test server
• Conducted user and BI team Cognos training sessions
• Authored functional specification documentation, technical specification documentation and user documentation

Environment: Cognos 8.3/Cognos8.2, Cognos Planning 8.1, Cognos Go Office Connection, Business Objects 5.1, SAS FMS, SQL Server 2005, Oracle 10.2, JDE, 3C and Windows 2000/2003

Confidential, WI

Cognos Architect

Responsibilities:

• Analyzed existing Crystal reports
• Designed and developed Cognos 8 Framework Manager models
• Created database and business views in the FM models
• Applied appropriate query subjects, namespaces, folders, joins, cardinalities, and short cuts in the FM model according to the reporting requirements
• Published FM packages on to the Cognos connection
• Documented and converted reports from Crystal Reports to Report Studio
• Created prompts, filter and calculations in the reports
• Provided data mapping documents templates for Report Studio reports and PowerPlay Transformer models

Environment: Cognos 8.1, Crystal Reports 10, Oracle 9i, Windows NT/2000/2003 and Linux

Confidential, GA

BI Practice and Project Manager

Responsibilities:

• Analyze the project requirements for bidding
• Contributing the technical aspects of the project proposals
• Providing BI solutions in the Cognos, Business Objects and OBI EE environments
• Project Resource Management
• Conducting seminars and knowledge improvement sessions
• Preparing Proof Of Concepts for clients
• Extending BI expertise to the onsite resources

Confidential, CA

Cognos Architect/Administrator/Developer

Responsibilities:

• Successfully Installed Cognos 7.0 and Cognos 7.1 software
• Automated Installation of Cognos client software on user computers
• Upgraded Cognos components from Cognos 6.0 to Cognos 7.0 then to Cognos7.1. I have upgraded the components such as Impromptu catalogs, Impromptu reports, Transformer models, PowerPlay cubes and Authentication
• Upgraded PowerPlay Enterprise Server
• Successfully installed and configured Cognos ReportNet
• Migrated Cognos Impromptu catalogs/reports to Cognos ReportNet
• Gathered Requirements specifications from the users
• Created Models and Packages using Framework Manager
• Created business views in the Framework Manager Model
• Created appropriate joins, calculations and filters in Framework Manager
• Fixed ambiguity relationships in the Framework Manager model
• Created reports using Impromptu, PowerPlay, Report Studio and Query Studio
• Created master/detail and parent/child reports using Report Studio
• Scheduled report runs and to email the results to the users on Cognos Connection
• Updated/ modified various existing Transformer models and PowerPlay cubes
• Built cubes such as PowerPlay cubes and PowerPlay reports
• Implemented multiple drill down paths, drill thru, user class views, dimension views, exceptional highlighting, subsets and cube security in PowerPlay
• Published PowerPlay cubes on to the Upfront and Cognos Connection using PowerPlay Enterprise Server
• Wrote macros to automate PowerPlay report building and scheduled them using Scheduler
• Installed and Configured Cognos 8
• Migrated Framework Manager models from ReportNet to Cognos 8
• Worked on Multi-dimensional modeling in the Cognos 8 Framework Manager
• Created variance reports using Analysis Studio and Report Studio in Cognos 8
• Created email alerts and report alerts in the Event Studio
• Built reports using ShowCase STRATEGY and MS Excel
• Development, administration and security on MS SQL Server
• Managed security to the Cognos solutions using Access Manager
• Designed appropriate schemas, created database tables, stored procedures and jobs
• Automated database jobs
• Provided technical, functional and usage documents
• Provided user training

Environment: Cognos 8.0/ReportNet 1.1/7.3/7.1/7.0/6.0 (PowerPlay6.61), MS Access, MS Excel, ShowCase STRATEGY 4.0, i2, JDE, MS SQL Server 2000, Oracle and Windows NT/2000/2003

Confidential, CA

Cognos Administrator/Architect

Responsibilities:

• Created an Architect model to provide common meaning and uniform naming conventions to the business entities
• Create appropriate Architect packages for creating Impromptu catalogs and to publish on to the Upfront as Cognos Query wizard
• Created PowerPlay cubes used for OLAP and for visualizations
• Used Visualizer to create visualizations
• Provided ad-hoc querying environment to the web users using Cognos Query
• Published IWR reports, cubes and visualizations to the Upfront
• Created drill-thru Impromptu reports
• Implemented drill-thru from PowerPlay cubes and visualizations to Impromptu and IWR reports
• Managed security using Access Manager by creating appropriate user classes and data source sign-ons

Environment: Cognos 7.1, Oracle 8.1, Sun Solaris 8 and Windows NT