Teja Tarigopula Email & Phone Number

Alpharetta, Ga, Us

Alpharetta, Ga, Us

Remote

Managed multiple deliverables of stakeholder engagements in Agile and Waterfall modes. Scrum Master for cross-functional analytics and reporting team. Implemented Power BI, Paginated Reports, Cognos Analytics, Planning Analytics tools to scale to new data visualization and reporting needs of end users. Managed Predictive modelling projects to continuously improve existing scoring models and rollout new Propensity models in Auto ML. Requirement analysis, Technical Design reviews, controls and balances, certification process.Information Management representative for Business Intelligence Vision-COE and Cognos-COE. Worked with stakeholders to layout future vision on Analytics and Reporting. Worked with Data Governance team to implement standard KPIs, business naming conventions, standard business calculations. Worked with Architects to identify and implement infrastructure for analytics initiatives. Created monthly scorecards, PowerPoint, dashboards for higher management. Participated in recurring resource planning efforts, costs and heat maps for multiple parallel deliverables.Incident Management, Root cause analysis, timely remediation of production failures. Implemented best practices, data balancing processes to proactively reduce incidents and improve confidence in the quality of data. Managed periodic upgrade of multiple systems including Statistica, Informatica, Undraleu. NPS, SQL Server. Coached Agile teams in story writing, sprint planning, capacity planning. On boarded and mentored new resources in the team.

Warren, Nj

(Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight/Workspace, Business Insight Advanced/ Workspace Advanced, Active Reports, Cognos Portal), DQM, Transformer, Cognos Connection, TOAD, TOAD Data Modeler 5.0, Informatica 9.6/9.1 (PowerCenter Designer, Repository Manager, Workflow Monitor, Workflow Manager) , JavaScript, MS Office 2003, Oracle 11G, PL/SQL, TOAD, Kronos, Windows 7.• Responsibilities: Design and develop reports using Report Studio, Analysis Studio, Query Studio for Kronos Timekeeping system and Staffing requirements for Point of Sales across North America.• Created metadata models/projects using Framework manager. Updated existing Transformer Cubes.• Managed user and data security using Active Directory using Cognos Connection. Resolved daily Production issue. Created User Roles and Groups in cognos. Assigned capabilities to user groups. Deployed packages between environments.• Performed Unit Testing, User Acceptance Testing on exisiting and new reports. Trained business users to effectively use Cognos functionality.• Analyzed and documented requirements for new Smart Dashboard.• Created Data Model, sample data, tables and views for Smart Dashboard using TOAD Data Modeler. • Created Mappings using PowerCenter Designer to create Lookups, Transformation, Fact and Dimension tables. Monitored Worflows in Workflow Monitor.• Analyzed and tuned PL/ SQL queries for Cognos, Informatica and Webservices.

Princeton, Nj

• Platform: Cognos 10.2.1.1/10.1.1 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight/Workspace, Business Insight Advanced, Active Reports, Cognos Portal), DQM, Transformer, Cognos Connection, JavaScript, MS Office 2003, Oracle 11G, TOAD, Windows XP Professional, UNIX.• Responsibilities: Created complex lists, graphs and burst reports in Report Studio and Analysis studio. Published monthly Transformer Cubes. Created Developed dashboards using Report Studio, Business Insight, Business Insight Advanced.• Tune, debug and designed framework manager projects.• Support day-to-day technical queries and ad-hoc report requests from Business Users.• Work with database team to design datamarts and views to support reporting requirements.• Gathered, analyzed and documented business requirements.• Successfully conducted unit testing and unit testing of reports using SQL.• Prioritized work efforts and managed project delivery timelines for offshore team. Shared daily status reports with the onshore team.• Implemented JavaScript in reports to enhance the front end user interaction with reports.• Created Cognos datasources. Implemented Cognos package, report, folder and row level security.• Implemented and documented report requirement templates and Cognos best practices for the team.• Trained users in Query Studio and report studio.

Hartford, Connecticut Area

• Platform: Cognos 8.4/10.1.1 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Impromptu 7.4, MS Office 2003, Teradata SQL Assist, Windows XP Professional.• Responsibilities: Cognos onsite lead for migrating Cognos 7.4 applications to Cognos 8.4. Onsite liaison between client and offshore team. • Migrating and Upgrading Impromptu 7.4 catalogs and reports to 8.4. Resolved Framework manager issues and reporting issues.• Maintained security for packages and created Cognos portal pages.• Gather Business Requirements for File Review projects for Claims team. Act as a Cognos BI SME between File Review business users and Cognos developers for creating Business Intelligence reports in Cognos.• Created a new report specifications template to gather functional and non-functional requirements for Cognos reports.• Conducted user sign-off sessions. Maintained all documentation on Sharepoint portal. Conducted Unit Testing, User Acceptance Testing of framework manager packages, reports. Created and updated defect logs. Notified the management of the defects and the users of defect resolution

Greater New York City Area

• Platform: Cognos 8.2,8.3(Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio, Metrics Manager, Cognos Connection, Cognos Configuration, Cognos Analysis for EXCEL), Windows XP Professional.• Responsibilities: Designed framework manager package and report studio reports with lists and crosstabs.• Conducted unit testing and user acceptance testing. Successfully deployed reports from development environment to testing and production.• Created training material for credit risk and operational risk management courses.• Mentoring fellow consultants in getting started with Cognos.

 Provided Level II Production Support for all datacenters (American, Europe, and Far East Asia) for Alcon Global IT Services. Monitored daily load of production data to warehouse (SQL Server 2000), extraction of data to various databases and file systems, daily build of Cognos and Essbase cubes for finance and Sales through ControlM jobs. Read and logged issues to track the errors in various data centers apart from the Quality Checks /Cognos Integrity Reports.  Help Desk trouble ticket resolution. Managed and updated notes in Magic and Status documents for timely resolution of incidents for Users and Business Analysts. Prepared Change Control Requests with strict adherence to Alcon’s SOP and SLA’s. Provided technical support to resolve issues in Cognos reports (Report Studio, Query Studio, Analysis Studio and Power Play Cubes). Analyzed SQL code performance optimization and for problem resolution for ControlM jobs. Evaluate and ensure data integrity from new system enhancements. Communication updates to supervisor, business analysts and fellow analysts. Prepared Quick References and Documentation for incident resolutions for IBI Support tasks. Converted Impromptu 6.3 reports to Cognos 8.2 Report Studio reports for Clinical Trial Management Systems (CTMS) in FortWorth, TX. With the help of SQL queries in Impromptu Catalog and Impromptu reports provided by the Business Analyst in TX, I created Framework Manager Model and published package in Cognos. Created reports using this package and completed Unit Testing for the reports.  Participated in technical discussions with FortWorth Team to gather all business requirements for CTMS project. Demonstrated the report functioning to users in FortWorth through WebEx and Conference call. Set up report and package security in Cognos for CTMS users in American Data Center.

 Created and published DMR and relational packages using Framework Manager. Authored reports in Report Studio and Analysis Studio for Auto, Property and Finance teams. Gathered and documented user requirements, maintained project plan.  Involved in identifying the data inputs from various source systems depending upon the business requirement. Created source to target mapping documents from Data Warehouse to SQL Server. Created complicated and detailed reports, graphs, unions, joins, conditional formatting and cascading prompts in report studio. Created portal pages for individual teams and agents.  Created Analysis studio reports to capture policy level information for property team. Created Tree prompts and drill-through reports from Analysis to report studio reports. Deployed packages and conducted user acceptance testing. Scheduled and emailed reports. Setup datasources in Cognos Connection and restricted access. Provided front-end access to SQL server using Access Project forms for users. Managed and created Cognos groups. Administered security for packages, reports, portal pages. Created SSIS package to pull in data from Teradata to be uploaded to SQL Server. Introduced users to use CAFE 8.3 as a probable solution for effectively using DMR models with Microsoft EXCEL. Created user documentation to train users to use report studio and analysis studio reports. Created best practices guide for maintaining Cognos reports. Mentored junior developers at the client end. After the implementation phase, conducted knowledge transfer sessions and demos to handover production support for various applications to offshore team in Chennai.

 Developed 10 complicated Dashboard style insurance reports containing multiple crosstabs, lists and charts in Cognos 8 Report studio. Formatted reports to be downloaded in Cognos Office Connection, to create a user friendly interface. Used joins and unions in report studio to perform user-specific calculations. Performed user acceptance testing using SQL Server 2000, DB2, MS Access. Created conditional formatting and multiple prompts, debugged reports and improved report presentation. Created drill-through reports from Cognos 7.3 PowerPlay Web to Report Studio. Created tables, test data in SQL Server 2000 to create sample reports to be used for scoping future projects. Modified existing reports to accommodate user-requested enhancements for reports in production and improved presentation on both DB2 and SQL Server 2000. Improved report performance and tuned reports against large DB2 database. Documented existing PowerPlay cubes, Impromptu reports and catalogs.

San Francisco Bay Area

• Platform: Cognos 8.1, ReportNet 1.1 Cognos Series 7.3(Report Studio, Query Studio, Event Studio, Framework Manager, Cognos Connection, Cognos Configuration), Cognos Office Connection, Cognos Go! Search), Oracle 9i, Windows XP Professional, SQL Navigator 4.1c1. I was responsible for creating financial reports and migrating ReportNet reports to Cognos 8 reports.• Responsibilities: Created new reports using Cognos 8, Report Studio and upgraded and replaced existing EXCEL reports.• Created documentation for report specification for all new and old reports. Created report templates to standardize reporting across various departments in Wells Fargo.• Migrated reports from ReportNet to Cognos 8. • Created Framework Manager model and published packages for finance team.• Created complex financial reports such as Trend report, Sales, Forecast reports etc., using single and multiple lists, crosstabs, charts and prompts.• Performed testing, scheduling and tuning of reports. Assisted fellow developers in debugging and improving report performance.• Created Portal Pages in Cognos Connection.• Participated in meetings with different departments to understand end-user requirements.• Managed package and report security. Administered Users, Groups, Roles and Distribution lists in both Cognos 8 and ReportNet.• Created Cognos Technology Team website using Microsoft FrontPage 2003 for Cognos team in Wells Fargo.• Authored user guides to educate users on how to use Cognos reports, email reports, schedule reports etc. Conducted user demonstrations to create report views.

Chicago, Il

• Platform: : ReportNet 1.1, Cognos Series 7.3(Report Studio, Query Studio, Scheduler, Framework Manager, Cognos Configuration), PowerPlay, PPES, Transformer, Access Manager, DB2, SQL Server 2000, Windows XP Professional, Lotus Notes, Acqua Data Studio 4.5.• Description: BCBS of IL is the largest and most experienced health insurance company in the state, providing more than 6.5 million members with comprehensive and affordable health plans.• Responsibilities: Created ReportNet reports to replace the current Siebel reporting in place.• Tuned and managed the current existing ReportNet reports to improve the performance of the reports.• Managed Framework Manager Model and published packages.• Conducted and participated in meetings involving end-users, project leads and team leads to better understand the reporting requirements.• Conducted demos and training sessions to train users in using Cognos Connection and ReportNet.• Demonstrated report functionality to the management.• Created complex reports, templates, prompts, filters.• Created Dashboard reports, Departmental reports, Activity reports, Service Request reports and Performance reports.• Performed User Acceptance Testing and troubleshooting.• Authored Cognos Supplementary User guide to train the users to manage the reports in Public Folders, My folders and Scheduling reports.• Built Multidimensional Cubes using PowerPlay Transformer.• Created PowerPlay reports in Excel by connecting to cubes through Excel and performed advanced calculations and formatting on the reports.• Administered changes to PowerPlay Cubes, to generate intuitive reports for better analysis.• Optimized the cube performance by reducing appropriate measures and dimensions in the cube.

Ridgefield, Ct

• Platform: ReportNet 1.0, Cognos Series 7.3(Cognos Connection, Scheduler, Framework Manager), Oracle 8i, Windows XP Professional• Team: 3• Responsibilities: Created and managed reports in Zero-footprint environment using ReportNet.• Participated in discussions with senior management to better understand the business requirements.• Created a series of templates, drill-through reports, reports with individual prompts and filters and sectioned reports.• Created Drill-through reports, Master-detail Reports, Repeater reports, Business Mix Reports in ReportNet.• Created Scorecard, Service Level reports, Electronic Data Completeness reports, Inventory Level reports and Demand Variability reports.• Authored 850 Detail Reports, 852 Detail reports, 856 Detail reports.• Conducted user demonstrations and authored user guide to train the users to navigate and display the final ReportNet reports.