SUMMARY:

• Twelve years of IT experience with expertise in Design, Development and Implementation of Data Warehouses & Business intelligence with ETL & OLAP Tools using Cognos suite of products, SQL Server, DB2, Taradata and Oracle 11g/10g/9i/8i.
• Cognos TM1,Qlik View for Banking, Pharmacy, Health Care, Construction and Telecommunication domains
• Experience in IBM Cognos Tools like Cognos administration, report development, transformer cubes along with certification in Cognos Administrator and Report Studio, and expertise in Cognos TM1 like TM1 Architect, TM1 Executive Viewer,TM1 cubes, rules and turbo integrator
• Extensive Knowledge in Dimensional Data modeling, Star Schema modeling, Snow - Flake modeling, Fact and Dimension tables.
• Ability to analyze source systems and business requirements, identify and document business rules, design data architecture.
• Physical and logical data modeling using Erwin data modeling tool.
• Worked on Different tools in Cognos FM, Power Play, Life Cycle manger,DQM, DQA, CognosTM1, Congos EP, Access Manger.
• Worked on Different reporting tools in Cognos Report Studio, Query Studio,Analysis Studio, Active Reports, Business Insight, Business Insight Advance, Event Studio
• Handling complete range of BI capabilities: reporting, analysis, score carding and dashboards  
• Expertise in creation of Drill-through and drill-down reports using Cognos report studio
• Experience in performance tuning of cubes, framework manager, Oracle SQL queries and store procedures.
• Performed Cognos administration work .
• Installed and Configured Cognos BI 10.1, 8.x in multi-server Windows and Unix platforms
• Expertise in migration and upgrade of Cognos 8.4 to 10.1.1 objects  
• Involved in Data Extraction from ERP, Siebel, Filenet using Cognos decision stream Experience in data collection and requirement gathering from users, customers and stakeholders and document the expectations and metrics information.
• Experience in Data Analysis, Data Migration, Cleansing, Transformation, manipulation, chart creation, visual representation, Import and Export through various ETL tools. 
• Used Cognos Reports objects like Listboxe, Text Objects, Slider, Buttons, and Charts (Bar, Line, Scatter, and Straight/Pivot table) for dashboard development.
• Developed customized file storage monitoring dashboard that shows space trends of different user developed dashboards deployed on shared server.
• Involved in deployment of Frame Work Manger models for creating the Models and published to create reports.
• Involved in Building Cubes using Transformer and models using Frame Work
• Certified Cognos BI Administration and Cognos Development
• Expertise on Cognos TM1 Components such as Turbo Integrator and Performance Modeller
• Provide overall leadership and direction to internal Project Team leads for solution delivery of BI Tools like Cognos, Cognos TM1 and Qlik View and Data Warehousing, Maintained good working relations with all key teams of organization.
• Have been working with various data sources such as Oracle, SQL Server, ODBC and Flat Files as sources. Also sound knowledge working with Cubes and dimensional tables for Cognos dashboard.
• Experience in Installations, Security, Configurations, Design, Implementation and Support for various customers using business intelligence and data warehousing tools and technologies.

TECHNICAL SKILLS:

Operating Systems:  Windows 2003/2008/2012 Server, Windows XP/8.

Languages:  HTML, Jscript, Unix

Databases/ETL:  Microsoft SQL Server 2005, 2008 and 2012, SSIS

Tools and Utilities:  Query Analyzer, SQL Server Management Studio, Cognos Series 7,Report studio8.x to cognos 10.x, Framework Manager,Tranformer Model, 8.0, 8.3, 9.1,Cognos TM1 Turbo integrator, Performance Modellers, Qlik View

Business Software:  Microsoft Office 2003 and 2007/2010 - Access, Excel, Outlook, Power Point, Word.

Education and Certifications:  Bachelors of Engineering, Computer Sciences - JNTU University, INDIA. Year 2004.

Cognos:  IBM Cognos 10 BI Author

Cognos Administration:  Cognos Administration

PROFESSIONAL EXPERIENCE: 

Confidential, North Chicago, IL

Responsibilities:

• Used data blending techniques in transforming data from different disparate data sources (Salesforce, MySQL, and SQL Server) and add additional filters at transformation layer and load data.
• Involved in creating Tree Map, Heat maps, background maps, calculated fields, mapping and hierarchies.
• Designed and developed Cognos BI environment to support high concurrency  
• Worked with Business Analysts, end users and internal systems resources to translate business requirements into technical specifications  
• Handled complete range of BI capabilities such as reporting, analysis, score carding, dashboards and business event management
• Responsible for all technical design deliverables
• Enhanced existing Cognos development processes
• Collaborated with peer business intelligence and data warehouse architects on reporting solution designs
• Provided technical support for Cognos applications including report analysis, development, maintenance, and report migration.  
• Developed and maintained framework manager models and implemented proper securities and publishing packages.  
• Designed and implemented a robust security architecture which will include both row level security and object security
• Developed complex reports using the Report Studio and Query studio
• Prepared power point and excel report based on Cognos GO Office
• Developed IQDS, reports using SQL queries
• Implemented FM level security based on the user roles and region level security in cubes
• Created batch script to update and publish cognos power play cubes daily
• Installed, Configured and upgraded Cognos BI versions 10.x, 8.4 in multi-server Windows and UNIX platform
• Configured Cognos security which included backups, configuration, performance and roles
• Build and automated cube build process using Batch file and Cognos Scheduler
• Performed deployments and coordinated QA and PROD releases with DBAs and Cognos Admin team
• Performed Production support to CDW, IPA, FTE, HR Dash Board, CCU, and CVM.
• Provided training, support and guidance to use best practices for Adhoc query users and report authors
• Prepare worksheets with the necessary tables and create filters and graphs using show me functionality after mining the database tables.
• Involved in development of File Storage dashboard in analysing all the dashboards deployed on Shared Server and highlight the .tde, .tbwx files with highest storage space and reach out to respective developers for performance improvement and deletion of non usage of workbooks.
• Promoted different dashboards deployed on QA server to PROD server based on user requests and created schedules and permissions on these dashboards and distributed to authorized users.
• Measures include no. of hits, time intervals, and count of online channels, time spent and other core metrics for data visualization.
• Promoted different dashboards deployed on QA server to PROD server based on user requests and created tasks and triggers on these dashboards and distributed them to authorized users.
• Provided Support for several Qlikview applications by analyzing presentation layer, gather understanding of the data model and also resolved by identifying the issues.
• Involved in troubleshooting of failed tasks using document logs and reach out to respective dashboard owners for any specific errors related to dashboard failures.
• Regular monitoring of QA and PROD servers for any hung tasks or long running tasks and abort tasks running more than estimated time.
• Written technical documentation for the application developed, file structure information and data model structure and core KPIs implemented in the application for future references.
• Implemented Agile Framework in handling complex projects and worked towards successful completion of the project with more accuracy of the results by meeting all the technical requirements of the business.

Confidential, Chicago, IL

Responsibilities:

• Design and Implementing the Metadata model using the Framework Manger
• Creating the reports using the Report Studio
• Working on SQL server database for validations and sql scripts.
• Involved in Deploying reports and packages from Development to Production environment.
• Involved in creating worksheets, Parameterized sets, feature rich dashboards and stories for user interaction.
• Creating the Cube using Cognos 10.x Power play Transforme
• Creating the reports using the Report Studio and Business Insight Advance
• Prod support and enhancement for existing project in Cognos 10.x
• Prod support and Bug fixes for existing projects in Cognos 8.4
• Working on SQL server database for validations and sql scripts
• Using the SSIS as ETL tool.
• Build and automated cube build process using Batch file and Cognos Scheduler
• Involved in Deploying reports, cubes and packages from Development to Production environment
• Maintained the packages and reports in development, test and production environment.
• Involved in creating user permissions using set filters in workbook for user level access to specific data.
• Analyzing data on Health Care information using Dimensional Modelling techniques.
• Involved in incremental load process to update data extracts on requirement basis in order to maintain the consistency.
• Extracted information from disparate data sources like Excel, flat files, SQL Server tables using data blending technique and link the data sources based on common key pairs between them.
• Involved in database and schema development and dimensional modelling of facts and dimension tables in providing analysed information in the form of reports locally and to different stake holders.
• Worked and developed Meaningful Use, EP and EH measures and involved in understanding the complexity of the requirements and developed the measure to meet the standards.
• Involved in writing T-SQL scripts, views and stored procedures in SQL server 2008 environment for viewing and analysing complex data.
• Involved in understanding measure breakdown and collecting requirements from the clinical research team and written stored procedures and views and functions accordingly for dashboard development.
• Implemented Agile Framework in handling complex projects and worked towards successful completion of the project with more accuracy of the results by meeting all the clinical requirements.

Confidential

Responsibilities:

• Onsite to Dubai to Freeze Dashboard requirements and a solution fix for the existing dashboards in the Cognos Reporting
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Design and Implementing the Metadata model using the Framework Manger.
• Prod support and enhancement for existing project in Cognos 10.x
• Prod support and Bug fixes for existing projects in Cognos 8.4
• Working on SQL server database for validations and sql scripts
• Worked closely with the Data Architecture team and provide technical design recommendations on the data mart structures which support analytical applications.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Perform ad-hoc analysis that helps in understanding business and performance trends. Interpret the results and weave insightful stories to stakeholders.
• Develop multiple prototypes, mock ups and conceptualization of ideas that bring simplicity and context to complex design challenges.
• Design and develop Business Intelligence solutions using multidimensional cubes MOLAP and Tabular Models.
• Work with the business to develop a formal business glossary, defining metrics and KPI’s.
• Extensive experience in creating Dashboards using Calculations, Parameters.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed effective and interactive Dashboards using Filters, Parameters and Actions.
• Maintaining Server activities, User activity, and customized Views on Server Analysis.
• Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive reports.
• Developed Attributes, Facts, Metrics, Prompts and Hierarchies as per Specifications for developing reports.
• Created dashboards and reports with best practices for ad-Hoc Reporting.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Experience in documentation such as Test Cases, Mapping document, Traceability Matrix etc.

Confidential

Responsibilities:

• Onsite to UK at BARCLAYS to Understand the Application architecture and the data flow of the Application
• Interact with users frequently through on call for Business users clarifications on the tickets.
• Handled the tickets based on the priorities raised by the users
• Enhancing the reports if users requires any Changes in the existing reports through Standard internal process
• Deployment of packages and reports from one environment to other.
• Scheduling the business Reports based on the inputs provided by the end users
• Giving access to the users based on the roles.
• Worked on Installation/ Configuration of highly scalable Cognos TM1.
• Created and Deployed the TM1 application to Web.
• Participated in designing the solution for TM1 Application.
• Integrated Cognos TM1 with Cognos 8 BI.
• Added Business Rules to Cubes.
• Involved in importing data using processing worksheets in TM1.
• Performed Admin tasks like Creating Users and assigning them Permissions.
• Process the Turbo Integrator by manipulating cubes, views, dimensions, elements, and other TM1 objects while importing data.
• Created Cubes, Dimensions in TM1 and replicating cubes between servers.
• Used SKIPCHECK and FEEDER statements to avoid Zero value cells and to improve the performance and to feed the values.
• Worked on controlling the cubes based on security and performance.

Environment: Cognos TM1,Cognos Turbo Integrator, Cognos8 Report Studio, Cognos 8 Framework Manager.

Confidential 

Responsibilities:

• Analysing the business requirements and understanding the data flow which is coming from multiple data sources
• Identifying the Relationships between Dimensions and facts according to the Business needs to avoid the loops.
• Providing the data securities in FM using Macros
• Created Frame Work Manager Models based on multiple data sources
• Created List, Cross-tab and Chart reports using multiple queries in a single report
• Created Drill-through Reports based on requirements to get the detail information of particular field in other report.
• Created calculated columns to focus on summarized data.
• Created finance(i.e. Accounts, Sales order, GL balance etc) cubes, Dimensions in TM1
• Worked on replicating cubes and cube views between servers.
• Involved to replace cubes between servers and to share across the organizations.
• Worked with advanced calculations by creating Business Rules that perform calculations, such as average price, currency conversions, and price/earnings ratios in TM1.
• Worked with turbo integrator to import the data and manipulate the data to cube.
• Worked with Query Language to manipulate the data using TOAD and SQL server from different data sources and cube views.
• Worked on Authentication and authorization by creating the TM1 Users and User groups.
• 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.
• Worked with TM1 control objects to secure the TM1 data based on different users and user groups.
• Created Dimensions, Cubes, View’s and Applications and applied Business rules to Cubes in TM1.
• Worked on controlling the TM1 cubes based on security and performance.
• Created Chores to schedule the TM1 Turbo Integrator processors.
• Trained the Users and User group on TM1 finance cubes and TM1 objects.

Environment: Cognos TM1, Turbo Integrator, Cognos 10.2, Frame work Manger, Microsoft SQL Server 2008.

Confidential

Responsibilities:

• Responding to a change in the client\'s IT direction, promptly prepared for construction of the planning and forecasting tool, developed a global enterprise-wide application using Cognos TM1.
• 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.
• Perform budgeting and forecasting modelling using TM1.
• 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.
• Used Replication to copy the Cubes from one server to other server.
• 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.
• Provided the What If Analysis facility to users to get desired output by changing parameters.
• Reviewed Business Requirement Document (BRD) for Completeness, Gather and analyze financial planning, budgeting and reporting requirements.
• Monitor CRM data ensuring quality of data is maintained.
• Performed Unit Testing and User Acceptance Testing

Environment: Cognos TM1, Turbo Integrator, Cognos Framework manager, Transformer Models, Microsoft SQL Server 2000/2005.

Confidential 

Responsibilities:

• Designed Frame work Models and provided relationships among the dimensions and facts according to the business requirements
• Created IQD’s from FM Model.
• Creation of Power Play Transformer Models based on FM
• Developed Cross tab reports based on the existing multi-dimensional package on the Report Studio.
• Created Metric types, Qualifiers, Groups, Group types, Metrics in Metric Designer
• Creation of Metrics in Metric Studio
• Created Dashboards Using Metric Studio

Environment: Cognos 8.2 Report Studio, Power play, FM, Metric Designer, Metric Studio, Oracle9i.

Confidential 

Responsibilities:

• Onsite to Belgium to get the Application KT
• We used to interact everyday with users through on call to resolve the tickets
• Performing network separations for the applications.
• Deploying updated reports and packages
• Scheduling Reports as per the Business needs
• Analysis of reports and catalogs
• Creation of new data sources
• Publishing of the reports in Impromptu Upfront
• Disaster Recoveries
• Providing access to the end users based on the Roles
• Creation of Metrics in Metric Studio
• Created Dashboards Using Metric Studio

Environment: Cognos Impromptu, Report Studio, Cognos FM, Oracle.

Confidential 

Responsibilities:

• Onsite to Belgium to get the Application KT
• Created Catalogues Using Impromptu Cognos EP7.0
• Created Impromptu Reports based on the Catalogues developed
• Publishing the Impromptu Reports in upfront
• Scheduling the Impromptu Reports based on user requirements.

Environment: Cognos Impromptu, Report Net, Cognos FM, Oracle.