Sirisha Chouturi
Dallas,TX
Summary
Business Intelligence professional skilled in ETL Workflows, data bases, data warehousing tools, data modelling, data visualization, designing packages, developing reports, creating insights using visualization tools for data analysis in order to drive successful business solutions. Around 10 years of experience in Information Technology and a wide range of progressive experience in providing product specifications, requirement gathering, designing, analysis, development, coding, testing, documentation and implementation of the client, server applications. Verifying the quality of the data, removing the corrupted data, performing analysis to determine the meaning of the data and prepare reports based on analysis and presenting insights to management. Excellent understanding of business operations and analytics tools for effective analyses of data. Identifying efficiencies and problem areas within data streams while communicating needs for the projects, play a key role in analyzing problems, and drive remediation. Seeking to leverage skills and experience to guide business decisions.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Sr. Cognos Developer
Mercedes Benz Financial Services
05.2021 - Current
- Mercedes Benz Financial Services Applications project focus is initiated by designing, development and maintenance of new cognos analytics BI reports across all MBFS environments
- Generated reports and information for supported departments (Alliance Business Center, HQ, all brands, all countries)
- Development of COGNOS reports for supported departments accurately and within estimated development times and according to the approved scope specifications
- Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through reports with conditional prompts, blocks, render variables related to lease maturities, credit dispute, fleet services, and lease portfolios in management environment
- Validate the generated cognos reports in access database and test the data
- Created daily, weekly, or monthly reports according to delivery schedule
- Reports are accurate and within scheduled due dates
- Adding new conditional prompts to the existing report, test the data and work with stakeholders for approval
- Adding a new cognos conditional prompt, new data items to the report level to identify the segregated data related to various business areas
- Adding a new dimension to the existing dimensions of a cognos cube and publish the cube for reporting purpose
- Generated cognos analytics report views for each region, department, and services for management and operations environments
- Schedule jobs for the cognos analytics repots, report views
- For supported departments, utilization of Cognos analytics, Access, SQL, Excel to develop new reports, update existing reports, and provide ad hoc support within the BICC environment
- Worked with the assigned business analyst to identify data availability and development issues with the report project prior to scope creation
- Assess prepared scope statement and provide estimated effort estimation of effort (in hours)
- Updated scope statement as necessary during report development
- Worked with IT to publish reports to the COGNOS environment
- Resolved production issues for existing reports
- Utilize COGNOS 10.1.1 components, Power play, Access, SQL , EXCEL, to trouble shoot, modify or enhance existing production reports
- Designed, developed, tested and maintained Tableau functional reports based on user requirements
- Designed and deployed graphic visualizations with drill down and drop down menu option and parameters using Tableau
- Worked extensively in creating graphs by using measures and dimensions data from various databases by using data blending concept
- Converted existing Cognos reports to tableau dashboards
- Developed Tableau data visualization using crosstabs, Heat Maps, Box and Whisker Charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
- Worked extensively with advance analysis actios, calculations,parameters,background images,maps,trend lines and table calculations
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
- Created Custom Hierarchies to meet Business requirement in Tableau
- Provided production support to Tableau users
- Utilized Tableau server to publish and share the reports with business users
- Responsible for creating calculated fields, combine field,bins,sets and hierarchies using Tableau desktop
- Created a dual axis bar chart with multiple measures
- Implemented data blending to blend related data from different data sources
- Executed and tested required queries and data before publishing Tableau Dashboard
- Environment: IBM Cognos Analytics 11.1 R4 (Report Studio, Query Studio, Analysis Studio, cognos workspace, cognos workspace Advanced, Frame Work Manager, Transformer ), Tableau Desktop Version: 2020.3.1, Tableau Server Version: 2020.3.1 (20203.20.0918.1727) 64-bit Windows , SQL Server 2012, SQL Workbench/J, Jira, Share Point, Windows Server 2012 R2
Sr. Cognos BI Developer
Alcon Laboratories
12.2018 - 04.2021
- Alcon Comm BI Applications Assessment project is initiated by designing, development and maintenance of new cognos BI reports across all Alcon environments
- Since Alcon moved out to be an independent company from Novartis, BI applications ( ETL, BI, Database, upstream and downstream dependencies) were analyzed as part of the spinoff program
- Worked with developers, Analysts in preparing detailed plan for the execution of transferring BI applications like Cognos, Tableau, Business Objects from Novartis to Alcon infrastructure as part of the spinoff
- Gathering requirements from stakeholders, analysing and converting the BRD's into technical documents, designing, developing, testing, maintaining and managing Cognos framework manager packages, data modules in cognos analytics, cognos transformer cubes, cognos BI reports, tableau worksheets and dashboards reports
- Extensive experience on structuring metadata by building three layer approach models using cognos framework manager, created folders based on the business functions and deployed packages to the cognos server environments
- Implemented framework manager security for row level access and package access based on the product, region and location level
- Performed burst of reports against the regions, locations and products for delivering by email, appropriate outputs to the concerned managers and supervisors in cognos connection
- Designed and developed list, cross tab, chart, map reports with various functionalities like drill through capabilities, master-detail, cascading prompts, render variables, conditional blocks, conditional formatting, burst reports and complex cognos analystics reports, which involved multiple multi-queries in a report studio against framework manager models and cognos analytics data modules
- Performance tuning by analyzing and comparing the turn around times between SQL and cognos
- Created several different types of ad-hoc (simple list, grouped list, section heading, crosstab, and nested crosstab) reports and represented data graphically by charts using query studio
- Created dashboards using cognos workspace which allows cognos content and external sources to build sophisticated interactive workspaces that provides insight and facilitate collaborative decision making
- Managing Cognos administration environment by creating the data sources in cognos connection for Dev, UAT and Prod environments, customizing cognos connection with appropriate reports, security measures and maintain folder stuctures for active packages and reports
- Daily, weekly, monthly and quarterly monitoring of the scheduled reports, jobs and tasks in cognos connection and Implemented security with LDAP and group level security in cognos connection portal
- Created visualizations in Tableau using dual axis, box plots, bullet graphs, tree maps, heat maps, bubble charts, waterfall charts to assist business users in problems solving
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements
- Worked extensively to create graphs by using measures and dimensions data from various databases by using data blending concepts in Tableau reports
- Worked with action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau desktop
- Developed Tableau data visualizations using cross tabs, heat maps, scatter plots, geographic maps, pie charts, bar charts and density charts
- Organized dashboards in Tableau to analyze the revenue, expense over various attributes of Product, Product Type, time and location dimension
- Moving models, reports from development to QA and then production servers
- Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions
- Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom
- Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau
- Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations in Tableau reports
- Use Trend Lines, Reference Lines and statistical techniques to describe the data in Tableau
- Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions in tableau reports
- Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel
- Extensively used Agile methodology as the organization standard to implement the data models and to complete tasks on sprint basis
- Worked on JIRA to log defects and track resolution till the closing of defect after retesting
- Coordinated with Alcon/Novartis teams and work with onsite & offshore team by sharing the functional and SME knowledge
- Gathered all the necessary information from the current teams who support the BI apps (ETL, BI, Database, Upstream and Downstream dependencies) as a part of spinoff program
- Documented the required details for each application as part of migration program
- Coordinated with development team tasks, deliverables and working on high priority issues
- Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
- Transferred technical knowledge specific to cognos tools and the existing data model to other team members
- Scheduled daily,weekly,monthly meetings to share the status updates to team, client periodically
- Environment: IBM Cognos Analytics 11.0 (Report Studio, Query Studio, Analysis Studio, cognos workspace, cognos workspace Advanced, Frame Work Manager, Transformer ), ,Tableau 10.3, SQL Server 2012, Oracle 11g V 11.2, Oracle SQL Developer V17.2.0.188, Jira, SAP Business Objects XI 3.1, Share Point, Windows Server 2012 R2
Sr. Cognos BI Developer
Pioneer Natural Resources Inc.
09.2016 - 12.2018
- Infor Enterprise Asset Management Reporting project kicked off initially by gathering requirements from stakeholders, developing and maintaining cognos10.2 packages, reports and integrate the cognos reports to Infor EAM and defects raised by the users were taken and then fixed based on the priority
- Build prototype solutions based on initial business requirements
- Created models using database layer, presentation layer and business layer by defining appropriate relationship between query subjects in framework manager
- Designing DMR models with relational data using framework manager and deployed packages to the report servers
- Implemented framework manager security for data access, object level access and package access
- Developed, maintained and managed work order maintenance reports, store activity reports, inventory aging reports, Inventory by warehouse reports, on hand inventory reports in cognos report studio using different functionalities like drill through, master-detail, chart , render variables, conditional formatting, complex reports which involved multiple prompts and multiple queries
- Designed OLAP reports using most of the report studio features (conditional formatting/page layout, sections, page breaks, sorting, summaries, grouping, drill down, drill up)
- Created, refreshed and supported cognos transformer models and cubes to support timely transaction operations to support multi-dimensionality of the reports
- Optimized cubes by selecting appropriate methods, which include partitioning, time-based partitioning, cube groups and incremental updates.Tuned transformer models for faster cube builds and access times
- Created various dashboard reports for different business areas based on cognos transformer cubes and cognos framework manager DMR models to present critical company data in a single report
- Extensively worked on performance tuning of reports in report sudio, testing and improve report performance and performing query optimization
- Widely used oracle for trouble shooting and testing the data level errors and cross-checking values by using SQL queries
- Schedule and distribute cognos reports on regular basis through schedule management in Cognos Connection
- Created Tableau dashboards with quick filters, parameters and sets to handle views more efficiently
- Published Tableau workbooks by creating user filters so that only appropriate teams can view it
- Analyzed the source data and handled efficiently by modifying the data types for Tableau
- Worked on solving performance and limit queries to the workbooks that when it connects to live database by using a data extract option in Tableau
- Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, geographical maps
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
- Publishing customized interactive reports and dashboards, report scheduling using Tableau server
- Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the revenue, expense and margins as currency values in Tableau
- Modeled the dashboards with appropriate filters for comprehensive analysis by Asset, Resource Type, and Inspector roles, timestamps and location
- Blending data from multiple databases into one report by selecting primary key's from each database for data validation
- Combined multiple dashboards to a single story to enhance the visual appeal of the tableau report
- Deployed tableau reports and published them on the tableau server
- Created tableau reports, dashboards using various databases
- Administer users, user groups and scheduled instances for reports in Tableau
- Provide status on issues and progress of key business projects
- Continuously improve technical skills through training, seminars, webinars, self- directed Research and investigation
- Review application code to ensure standards are being followed
- Regularly check the status of the issues in service now application and work closely with other developers to resolve issues as well
- Experience with unit testing methodologies, tools and agile methodology
- Excellent team player with problem-solving and trouble-shooting capabilities
- Environment: IBM Cognos 10.2.1 (Framework Manager, Transformer, Report Studio, Analysis Studio, Query Studio), Tableau 8.3, Infor EAM 11.0, Oracle 11g V 11.2, Oracle SQL Developer V17.2.0.188, Service Now, JBOSS 5.1, and Windows Server 2012 R2
Sr. Cognos BI Developer
American Airlines Inc.
09.2013 - 07.2016
- Dependability Reporting project kicked off initially by complete cycle of project plan, design, install ,configure of all the suites of cognos10.2 BI products, gathering requirements from business users, convert BRD's to technical documents, design, develop, maintain and manage cognos10.2 reports and integrate the cognos reports to portal (IBM Web portal)
- Worked on defects raised by the users and testers and then fixed based on the priority and also maintain the cognos standards in American Airlines
- As a developer and administrator involved in the complete cycle of project plan, design, install, develop and test, production cutover, end user training and post production maintenance of the system
- Upgraded IBM cognos 8.4 environment to IBM cognos 10.2 and deploying and testing all the reports
- Followed step by step approach of upgrade process for all the Dev, Test and Production environments
- Setting up of the backups of all environments with backup and restoring of content store databases, backups of cognos configurations, deployment of public folders
- Migration of the cognos 8.4 content store to new environment
- Installed all the components of cognos 10.2 suite of products in dev environment with application and gateway on a single server and content manager in another server
- Tested the report,cube performances, security, batch process, report schedules in the new cognos 10.2 environment
- Setting up the security of cognos suite of products query studio to general users, report studio report authoring to power users, report studio professional authoring to report writers based on user roles
- Setting up the security to cognos FM packages, folders and reports in cognos connection by granting up read, write, execute and traverse permissions based on user requirements
- Participated in requirements gathering process to bridge gap between user needs and tool functionalities
- Monitoring and troubleshooting of servers with performance issues
- Deployment of models, packages, folders, reports, cubes, data sources from development environment to production environment
- Worked on the framework manger to develop efficient data models like flight operations, schedules and ground handling for both domestic and international operations
- Created various IQD packages in framework manager and from this IQD integrated to power play transformer to create various models and cubes
- Generated Drill through Reports like flight operations reports, fllight departures reports, delayed operations reports, ground handling reports
- Created list reports, cross-tab reports, chart reports, repeaters, drill-thru and master detail query reports using report studio
- Scheduled and distributed cognos 10.2 reports, jobs using schedule management in cognos 10.2 connection
- Worked on test planning, test case design, test script generation and design documents walk throughs
- Based on use cases test plan and test cases were developed and maintained in quality center
- Worked extensively with advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics and table calculations
- Hands on building groups, hierarchies, sets to create detail level summary reports and dashboard using KPI's in tableau desktop
- Strong tableau dashboard design experience and passionate practitioner of effective data visualization
- Familiarity with best practices around visualization and design
- Provide production support to tableau users and wrote custom SQL to support business requirements
- Scheduled daily,weekly,monthly meetings to share the status updates to team, client periodically
- Submitted issues in jira on regular basis, checking the status of the issue and work closely with dvelopers to resolve
- Extensively used agile methodology as the organization standard to implement the data models,reports and to complete tasks on sprint basis
- Trained users with new user interfaces and technologies involved in cognos 10.2, Tableau
- Environment: Cognos 10.2 (Report Studio, Analysis Studio, Query Studio, Business Insight Advanced, Framework Manager, Transformer), Cognos 8.4 products, Jira, Tableau 8.0, SQL Server 2008, Teradata 14.10.0.02, Windows XP
Cognos Developer
International Monetary Fund/ TCS
01.2012 - 09.2013
- Financial and accountability reporting project kicked off initially by gathering requirements from business users, design, develop, maintain and manage cognos10.1 reports and integrate the cognos reports to portal (IBM Web portal)
- Worked on defects raised by the users and testers and then fixed based on the priority and also maintain the cognos standards in IMF
- Design the metadata modeling in cognos8.4 framework manager model into various layers like database layer, business layer and presentation layer publish packages and deploy them in cognos connection
- Created parameter maps, calculations and relationships in framework manager packages
- Implemented cognos framework manager security for data access, object level access and package access
- Created list reports, dashboard reports, cross-tab reports, chart reports, drill-thru and master detail query reports in report studio
- Customized cognos connection with appropriate reports and security measures and scheduled reports using cognos connection
- Designed models, multiple cube views using cognos power play transformer
- Developed cognos power play reports like variance reports, exception reports
- Trained professional authors to write complex reports using report studio and trained power users to use query studio for ad-hoc reporting
- Compared and analyzed data in ad hoc analysis and query studio reports (using filters, summaries, prompts) Structured, lateral thinking in order to provide multiple options and recommend the best suited option
- Assisted project manager in preparing time estimates,priorities and justification for assigned tasks
- Worked to solve service requests from TGS department
- Consistently managed server environments as administrator
- Worked to create cognos insight reports to executives and demonstrated the business value of those reports
- Environment: IBM Cognos 8.4 (Report Studio, Analysis Studio, Query Studio, Business Insight Advanced, Framework Manager, Transformer), Cognos Insight, Info sphere 8.5, Service Request System, Web sphere, Oracle 10g, Windows XP.
Cognos Developer
LVMH P&C/ Cognizant
01.2010 - 12.2011
- Louis Vuitton and Moet Hennessy Perfumes and Cosmetics sales project kicked off initially by design, develop, maintain and manage cognos8.4 reports and integrate the cognos reports to portal
- Worked on defects raised by the users and testers and then fixed based on the priority and also maintain the cognos standards in LVMH P&C
- Developed and published packages in framework manager connecting and testing the data source, created database, business and presentation layer (DMR) models, defining appropriate relationship between query subjects and fact tables
- Created changes in the existing models of cognos framework manager and published packages for reporting activity
- Created relational and multidimensional models using star schema model in frame work manager with calculations,filters and securities for models, publish packagesand deploy packages to the cognos connection portal
- Worked with sales data and validate the existing reports against SQL Server 2008 database
- Developed the list reports, chart, graphs, cross tab, dashboard reports, master detail and drill through reports using report studio and analysis studio
- Created views for summary detail reports, created jobs, and scheduled reports, jobs in cognos connection
- Working experience with different date functions like YTD, QTD and MTD in report studio Moved projects from development to QA and then to production servers
- Customized report studio reports using HTML and java Scripts
- Test and validate the report output against the database to verify performance of the reports
- Worked to improve performance tuning and troubleshooting of reports, created templates and modify the existing templates
- Executed scripts to refresh the cubes on a daily and weekly basis
- Administered database and cognos security, backups, tuning, configuration, and performance
- Created user, group access roles for cognos reports and packages
- Responsible for solving problems as administrator and created reports in query studio for user access
- Responsible for scheduling meetings with team members and clients
- Organized status meetings with manager to give updates about reports and cubes
- Trained the end users to effectively use the ad-hoc reporting tools to build and customize reports
- Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio,), SQL Server 2008, IIS, Windows XP, Linux
Education
Master's in Electrical Engineering -
NorthWestern Polytechnic University
Fremont, CaliforniaBachelor's in Electronics & Communications Engineering -
Acharya Nagarjuna University, India
Skills
- Programming Languages - SQL, PL/SQL, Python 30
- Scripting Languages - Unix/Linux Scripting, Perl
- Web Technologies - HTML, CSS
- Operating Systems - Windows 7/VISTA/NT/XP/ME/2000/95/98, LINUX/UNIX,Mac
- Methodologies - SDLC, Agile (Scrum Approach)
- ETL Tool - Informatica Power Center 861/81/71
- Databases - oracle 11g, MS-SQL Server 2005/2008/2012,Teradata, MS-Excel
- BI Visualization&Reporting Tools - Tableau 202031,Cognos Analystics 111 R4
- Web Servers - IIS, Tomcat and Apache
- Data Modelling Tool - ER Studio 910
- LDAP Servers - Active Directory
- Project Management Tools - Jira
- Service Tracking Tool - Service Now
- Requirement Gathering
- Analytical and process oriented
- Ability to grasp new concepts quickly and efficiently
Certification
IBM Cognos BI Author Certificate, 2012
Locations
Dallas, TX
Personal Information
- Title: Sr. Cognos Developer
- Visa Status: H1B and 2024
Timeline
Sr. Cognos Developer
Mercedes Benz Financial Services
05.2021 - Current
Sr. Cognos BI Developer
Alcon Laboratories
12.2018 - 04.2021
Sr. Cognos BI Developer
Pioneer Natural Resources Inc.
09.2016 - 12.2018
Sr. Cognos BI Developer
American Airlines Inc.
09.2013 - 07.2016
Cognos Developer
International Monetary Fund/ TCS
01.2012 - 09.2013
Cognos Developer
LVMH P&C/ Cognizant
01.2010 - 12.2011
Master's in Electrical Engineering -
NorthWestern Polytechnic University
Bachelor's in Electronics & Communications Engineering -
Acharya Nagarjuna University, India