Thrilok Pokanati

Email : ac8032@r.postjobfree.com Mobile: 832-***-****

PROFESSIONAL PROFILE

Over 14 years of extensive hands on experience in installing and developing OLTP/OLAP/Data Warehousing and BI Tools.

Experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.

Expert in ETL-Extraction Transformation Loading, Operational Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Over 10 Years of Experience with the BI lifecycle components including Source Data Analysis, Data Marts, Data Mining.

Over 10 Years of Experience on Cognos Suite (Cognos 11, 10.1, 10.2.2, Reportnet, Framework Manager, Analysis Studio).

Over 10 Years of Experience with the BI lifecycle components including Source Data Analysis, Data Marts, Data Mining.

Designed, developed and supported production environments using Cognos Analytics 11, 10.2, 10.1, 8, Report Net.

Administered and Supported BI tools to provide self service reporting solutions and capabilities to end users.

Over 3 years of Experience with Tableau Analytics and hands on experience on Tableau Desktop versions and Tableau Server.

Good Experience with other BI Tools (Power BI, QlikView, Business Objects, SSAS, SSRS).

Expertise with Multiple Relational Databases Oracle, DB2, MS SQL server, MS Access Databases

Strong Exposure to Transact-SQL, PL/SQL, Oracle9i/8i and SQL Server 2017/12/08/05 databases

Lead the collaboration with Business/IT stakeholders. Successfully Delivered projects with Hands on experience in SDLC processes and methodologies in Business Intelligence domain demonstrating influential leadership, project management capabilities.

Technical leader who knows how to determine priorities and complete project deliverables within tight timeframes.

Proficient in agile environment, acting as a scrum master for two different sprint teams and responsible for smooth delivery of sprint goals.

Ability to work under tight deadlines and rapidly changing priorities and handle multiple projects simultaneously with a limited timeframe release cycle.

Expertise in managing and leading projects, with strong focus on communication, process and constant improvements.

PROFESSIONAL CERTIFICATIONS

Certified IBM Cognos BI Author (8, 10 and 11 Version)

Certified IBM Cognos Administrator (10 and 11 Version)

Certified Cognos professional

TECHNICAL SUMMARY

Operating System

Windows 10/07/2000/NT/XP/7, MS DOS and UNIX (AIX, Solaris)

Software/Tools

Cognos Analytics 11.0.10, 10.2, 10.1.1, 8.4, 8.3, 8.2 and 8.1.2, ReportNet1.1, Cognos7, Cognos Transformer and Imprompt7.2, SSRS, Power Play, Web Sphere Process Server and Tableau 10,9,8, Power BI, Business Objects, SSRS, QlikView

Languages

C, C++, SQL, SQL*Loader, PL/SQL, Java, JSP, .Net

Web Technologies:

Cognos Enterprise Server, IIS web server, Apache web server

RDBMS

MS Access, MS SQL Server 2017/2012/2008, Oracle 7.x/8.x/8i/9i/10g

ETL

SSIS, Data Stage, Alteryx, Informatica Power Mart 5.1/ 4.7, Power Centre

EMPLOYMENT SUMMARY

Boston Public School, Boston, MA, USA

DeVry University, Chicago, IL, USA

Blue Cross Blue Shields. Chicago, IL, USA

IBM, Bangalore, India

PROFESSIONAL EXPERIENCE

Client – Project – Location

Boston Public Schools, Boston, MA.

Role

Sr. BI Consultant

Duration

June 2015 –Till Date

Environment

Cognos BI (11.0.10, 10.2.2), Framework Manager 11, 10.2.2, Cognos Connection, Report Studio, Query Studio, Tableau Desktop 10.0.4, 9.1, Cognos SDK, Microsoft Excel, IIS Web Server, SQL server 2012/17,SSIS

Project Details & Responsibilities:

Design, develop and maintain Stored Procedures which updates the Analytical Tables/Views in databases.

Made efficient use of the BPS Organizational Process Assets such as documentation, process, and templates.

Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Responsible for Data Modelling, Architecture, Production support and migration to SQL Server 2017

Lead the creation of informative and interactive data visualizations in BI Tools.

Lead the Data warehousing Team and met the deadlines for every Project.

Developed Star schema and Snowflake schema models in framework manager for Ed-Fi Data Warehouse.

Design, develop, maintain and support complex reports including interactive reports, Active Reports and Tableau dashboards.

Support and maintain Models and Reports on Student/Staff Attendance, GPA, MCAS, Batch Assignments, English Language Learners and Transportation.

Implementing Row level security and efficiently customizing it in IBM Cognos.

Performing best practices to fine tune reports and models for better performance and load-balancing on application server.

Worked on creating Student Data Modules, Attendance Data Sets using Cognos Analytics.

Performing unit testing of the Stored Procedures, Models and Reports and check for data accuracy.

Troubleshoot issues with reports and application server and provide solutions in a timely fashion.

Implementing Tableau Dashboard Reports for Student Performance Metrics and Staff Attendance for Schools, Central Office and City of Boston Mayor’s Dashboard.

Developed Tableau data visualization using Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Customized BPS Login Page as per Business Requirements.

Upgrading and Migrating Models and Reports and Dashboards from Cognos 10.1 to Cognos 10.2.2 to Cognos 11.0.10.

Created Audit tables and developed Audit Reports to analyze the Report Usage.

Support and assist users with access issues and report enhancements for existing Dashboards.

Client – Project – Location

Boston Public Schools, Boston, MA

Role

BI Consultant

Duration

July 2013 –June 2015

Environment

Cognos BI (10.1, 10.2.2), Framework Manager 10.1, 10.2.2, Cognos Connection, Report Studio, Query Studio, Cognos SDK, Microsoft Excel, IIS Web Server, SQL server 2012/08

Project Details & Responsibilities:

Installed and Configured Cognos Server (8.4, 10), Framework Manager, Power Play Server and Transformer.

Involved in design, development and implementation phases of the Data Warehouse.

Worked closely with different BPS Units to gather the reporting needs and develop reports.

Worked on migration of Data Warehouse Reports and Models from version 8.4 to 10.

Administered and maintained Data Warehouse portal which includes managing user access to reports and other contents in Data Warehouse.

Used JavaScript for certain validations to overcome the limitations in Cognos report studio.

Created security groups by role and assigned to reports and package based on the level of access.

Imported source tables from different databases and created Framework Manager Models based on area of reporting like Attendance, MCAS, Cohorts and Student Reports etc.

Performed unit testing of reports in SQL Server Management Studio express to verify data for accuracy and Created Tables, joins, views and stored Procedures in SQL Server 2008 database and Worked with views and stored procedures in the database to increase performance and creates job to import data.

Implemented Security with LDAP and Group level security in Cognos Connection Portal.

Handling training sessions and demonstration of Cognos tools to End-users.

Handled deployment of packages in different environment, support and transition activities.

Used Framework Manager in building the dimensionally modeled relational (DMR) and relational Models using different data sources.

Client – Project – Location

Boston Public Schools, Boston, MA

Role

Cognos Developer/Administrator

Duration

April 2009 –June 2013

Environment

Cognos BI (8.4, 8.3), Framework Manager 8.4, 8.3, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Cognos SDK, Event Studio, Cognos Transformer, Power Play Server, Microsoft Excel, IIS Web Server, SQL server 2005/08 and .net frame work 4.0

Project Details & Responsibilities:

Assigned to a key position in the Data Warehouse group of the OIIT team to develop and maintain a BI solution using Cognos suite of products.

Worked with DBA to analyze the data and metadata including primary keys, indexes and foreign keys, also understanding the relationships and cardinality between the tables.

Installed and Configured Cognos Server (8.4, 8.3), Framework Manager, Power Play Server and Transformer.

Involved in design, development and implementation phases of the Data Warehouse.

Worked closely with different BPS Units to gather the reporting needs and develop reports.

Worked on migration of Data Warehouse from version 8.3 to 8.4.

Administered and maintained Data Warehouse portal which includes managing user access to reports and other contents in Data Warehouse.

Created security groups by role and assigned to reports and package based on the level of access.

Imported source tables from different databases and created Framework Manager Models based on area of reporting like Attendance, MCAS, Cohorts and Student Reports etc.

Implemented filters, calculations, prompts, conditions, and created various reports using Report Studio.

Used Framework Manager in building the dimensionally modeled relational (DMR) and relational Models using different data sources.

Created reports which include dynamic prompts, conditional styles, dynamic sorting and interactive behavior.

Created complex reports using conditional formatting and cascading prompts multi list reports, static choice prompts, Drill Through and HTML items.

Using Cognos SDK (BI Bus API) integrated different applications (.NET) with Cognos.

Fine-tuned performance of the reports by using summary data and creating drill through reports to reduce overhead on the server and enable ease of use.

Created Power Play Cubes for Student data using Power Play Transformer and used cubes as data source for reports in Analysis Studio.

Documented reports in technical design documents which include data elements used in the report, filters, report design, and sample outputs.

Customized Data Warehouse login screen to add updates of releases and provide information on Data Warehouse.

Configured Data Warehouse portal to use “cognosisapi.dll” extension for better scalability and performance.

Scheduled reports for users to be delivered to their email.

Client – Project – Location

DeVry University, Chicago, IL

Role

Cognos Developer/Administrator

Duration

June 2008 to March 2009

Environment

Cognos BI(8.3, 8), Framework Manager 8.1.2, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos SDK, Cognos Transformer. Power Play 7.x, Microsoft Excel, IIS Web Server, DB2, Oracle 9i.

Project Details & Responsibilities:

Involved in gathering Business Requirements and prepared the requirements specification document.

Built Framework Manager Model and established the cardinalities to suit the business needs and provided security to those models.

Involved in regularly meeting with the data warehousing team on discussing about the changes in the schemas and Setup Security using Access Manager Administration.

Involved in data warehousing Methodologies and architecture.

Setup Security using Access Manager Administration.

Involved in implementing entire Architecture based on design and performed load testing and unit testing.

Created Dimensional Models by using Impromptu Query Definition (IQD) in Power play Transformer.

Worked extensively with Power Play Enterprise Server and the Upfront in publishing the OLAP Cubes (MDX) and Dimensional Maps, Transformer Models, Power-Cubes.

Expertise with creating page breaks and Created complex reports using conditional formatting and cascading prompts multi list reports, static choice prompts and HTML items.

Extensively worked on performance tuning for existing reports in Report Studio and Testing and improving Report Performance and performing Query optimization.

Client – Project – Location

Blue Cross Blue Shields, Chicago, IL

Role

Cognos Developer/Administrator

Duration

Jan2007 to May 2008

Environment

Cognos (8.1, 8), Framework Manager 8.1.2, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Content Manger, Apache web server, SQL Server2000, SAP BO XI 3.0, Windows server 2000/NT.

Project Details & Responsibilities:

Involved in Strategic Planning for Cognos Framework Models.

Involved in Reports Migration From SAP BO to Cognos.

Built Models and published Packages utilizing Framework Manager.

Created database connections for different data sources.

Created Reports (Simple & Complex) using Query Studio and Report Studio for training purpose.

Created security models using Framework manager.

Created, organized and formatted reports, folders and other contents on Cognos Connection portal.

Created DMR models using Framework manager.

Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Cross tab, and Nested Cross tab) Reports and represented data graphically by Charts utilizing Query Studio. Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production) with complex formatting utilizing Report Studio.

Created Burst Reports using Report Studio.

Create Run, and Schedule Reports and Jobs using Cognos Connection.

Used SQL*Loader to load the input data into the database tables.

Client – Project –Location

IBM, Bangalore, India

Role

Cognos Developer

Duration

May 2005 to Dec 2006

Environment

Cognos Report Net, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Transformer 7.x, Power Play 7.x, Impromptu, Microsoft Excel, DB2 UDB 7, Apache web server

Project Details & Responsibilities:

Applying Security and User Authentication to the various User Groups using Access manager.

Creating database connections for different data sources.

Modeling the data from Physical to Logical model according to business requirements.

Involved in data warehousing Methodologies and architecture.

Involved in implementing entire Architecture based on design and performed load testing and unit testing and UAT testing.

Involved in architect the Cognos BI environment to support the volume of report generation with accepted levels of response times.

Deploying the packages (exporting and importing the packages) using the Deployment functionality under Cognos Connection Portal.

Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Cross tab, and Nested Cross tab) Reports and represented data graphically by Charts utilizing Query Studio.

Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production, Business, Ranking) with complex formatting utilizing Report Studio.

Secured Models are created using Framework Manager.

Monitored the Cube performance and modified the structure to enhance Performance.

Produce Queries and Reports in Multiple Languages. Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages

Developed Standard Reports, Variance reports, Charts, Time reports Drill through Reports, Master Detail Reports and Bursting Reports using Report Studio and Query Studio.

Create Run and Schedule Reports and Jobs using Cognos Connection.

Migrated reports from Cognos 7 series (power play and impromptu) to Cognos Report Net 1.1.

Contact this candidate