Manager Developer
Resume:
*******@*******.***
Satish Kokle
Cognos Certified
Over Twelve years of IT experience in software analysis, design and development of
which Eight years have been in Various tools of Cognos.
Experience as Tech Lead roles in projects and achieved the goals on time.
Experience in installing Cognos 8.4 Framework Manager, Developing reports in Report
Studio & Query Studio. Implement Event Studio.Created Dashboard in Metrics Studio.
Trained in Cognos 8 Analysis Studio, Metric Studio Cognos 8 Datamanager.
Area of expertise encompasses Database designing, ETL phases of Data Warehousing.
Created Business User type reports and Dashboard using Cognos ReportNet.
Experience in OLAP tools like Cognos Impromptu, PowerPlay and Business Objects.
Extensive experience with administration & maintenance of Cognos Tools Area of
expertise encompasses Database designing, ETL phases of Data Warehousing.
Experience in various kinds of reports (list report, grouped list report, summary report,
crosstab report, mailing report, form report, freestyle report).
Experienced with working with users, collecting information and requirement from users,
Analyzing, plan and create Reports.
Involved in connecting to corporate database, to setting up effective catalogs, joins,
folders, filters; ensuring that adequate security procedures.
Strong working experience on Informatica PowerCenter/ PowerMart for Extraction,
Transformation and Loading of data from multiple sources into Data Warehouse.
Worked on different transformations using transformation developer
Working knowledge of the Star Schema and Snow Flake Schema Design strategies.
Experienced in Dimensional Data Modeling using Erwin.
SKILLS
Languages SQL*plus, PL/SQL, Visual Basic5, 6, C and C++, Sun Solaris Administration
ETL Cognos Decision Stream, Informatica Power Center 6.2/6.1/5.1. /4.7/3.8
COGNOS Cognos 8.4, Query Studio, Report Studio,Metrics Studio, Event Studio, Analysis
Studio, Cognos Viewer, Cognos Office Connection, Cognos 8 Framework
manager, Cognos 8 Data Manager, Cognos BI, Cognos Impromptu 7.0/6.0,
Cognos Transformer6.5/7.6, Cognos Powerplay 6.5/7.6, Cognos Decision Stream,
Impromptu Web Reports (IWR), Cognos Query, Cognos Scheduler 6.0, Cognos
Visualizer, Cognos Metrics Manager 2.0, Cognos ReportNet, Business Objects
Databases Oracle 9i/8i/8/7.x, MS Access, SQL server, Teradata, SQL server, SSRS.
GUI/Tools Toad, DB Artisan, ERWIN, PL/SQL, SQL*Plus, Excel, Golden32 and PLSQL
Developer.
CERTIFICATIONS
• COGNOS ReportNet Product User
• COGNOS ReportNet Product Professional- Report Track
• COGNOS ReportNet Product Professional – Metadata Modeling
• COGNOS ReportNet Product Professional – Server Administration
• OCP in ORACLE 8i Architecture and Administration
• OCP in ORACLE 8i Performance Tuning
• MCP in Visual Basic Desktop Application
EDUCATION
• Bachelors in Engineering Four year’s degree, Pune University, India
• Diploma in Oracle, C, C++, Sun Solaris System Administration, Window NT
EXPERIENCE
01/10 – Till Present Team Lead - Cognos Analyst/Developer, Kronos Chelmsford MA
Lead a team of 4 people. Planned the approach to the project, assigned work to team member, discuss all
the issues and solve them with priority one by one .Finished project with 8 working days to spare. This
involved Supporting Migration of Cubes from Cognos Series7 to Cognos 8.4 environment. Debugging
and redesigning the cubes and reports moved to the new Cognos 8.4 version. Migrating the reports from
Repotnet to Cognos 8.4 And the same time supporting the production environment.. helping Team
members with the issues while building cubes and trouble shooting the issues with the migrated reports.
• Serving as the portal/dashboard designer utilizing Cognos 8.4, managing new operational/finance
report requests, leading creation of an internal ad-hoc reporting area to promote the concept of
“self-service” reporting, serving as the BI Analytic technical resource, serving as Internal reporting
expert.
• Develop standard reporting Templates, perform gap analysis for new and conversion
reports as well as working closely with architects and data modelers to address data gaps.
• Created Dashboard in Go Dashboard by reusing the dashboard Objects /Reports.
• Help Team to troubleshoot issues in creation of cubes and Migration of reports.
Environment: Cognos 8.4 Report Studio, Query Studio, GO Dashboard, Cognos DataManager,
Connection, Framework Manager 8.4, Powerplay, DataManager, Oracle 10g, SQl Developer.
10/08 – 12/09 Senior Cognos Analyst/Developer, Johnson & Johnson, Jacksonville FL
Working on ETL and Vibes reporting Project. Design and develop reports on Vibes Non Confirm
database.
Studied and understand the Non-Confirm system the data entered on Lims and Vibes system. Familiar
with events which leads to non-confirm status. Familiar with FPR, FOQ statuses, Scrap and Sterilization.
Part of the team on the reporting for Jacksonville and Ireland.
• Created Reports as we are still in the process of getting the database built.
• Involved in gathering requirement and doing analysis on it to lay out the foundation for reporting.
• Analyze the data source namely ETQ, Lims, Vibes and Staged Database.
• Actively working with the team on providing valuable information to designing the database.
• Recommended Tables and some columns in the tables being created in database and being
populated using Cognos Data Manager.
• Created Sophisticated Dashboards and Template for reporting purpose in Report Studio.
• Implemented bursting of reports, Cascading Prompts, Text Box Prompts, Dynamic Sorting
Prompts.
• Created Dashboard in Go! Dashboard.
• Supported and provided valuable tips while creating Powercubes.
• Used OLAP Data source for reporting purpose, commonly known as MDX queries.
• Provided support and fixed reports already in production.
• Created reports with drill down capability, Control charts and reports in Analysis Studio as
required by the users.
• Work on the validation and user acceptance of the reports based on the data.
• Perform Upgrade from Cognos 8.3 to Cognos 8.4.
Environment: Cognos 8.4, Cognos 8.3 Report Studio, Query Studio, Go Dashboard, Cognos
DataManager, Framework Manager, Powerplay, DataManager, Oracle 10g, Oracle 9, 8, TOAD 9.1 .
01/08 – 09/08 Senior ReportNet Analyst/Developer, CHASE, Dallas TX
Worked in conversion of reports from Access and Excel report into Cognos Environment.
The report were in 3 phases first phase was for SubPrime, second was in Prime and the third phase in
HE(Home Equity). During the Prime Conversion. In total 500 + reports were converted.
Designed and developed the reports with enhancement and changes to the original reports .
Implemented changes to the reports based on the feed back from the SME.
The conversion had to sync between the older database system and at the same time implement the
changes in accordance with the new database system DRI . Eventually the older database system had to
be Phased out, so all the changes had to be based on the new database system. But the new database
system was concurrently developed, which made the task much more challenging.
Met the deadline for the different stages of the conversion.
Suggested valuable suggestions in conversion process of the reports.
Verified data integrity on Toad, for all the Reports.
Environment: Cognos 8.2 Report Studio, Query Studio, Cognos Connection, Framework Manager,
Access Manager, Oracle 9i, TOAD 9.0, SQL Server, Access, Excel and Access.
05/06 – 01/08 Tech Lead ReportNet Analyst/Developer/Administrator, Compucom, Dallas TX
Worked as a Team Lead of a team of 8 of which 5 were offshore . This involved taking status every
morning and assign work based on the progress.Worked as a Reportnet Analyst /Developer for Finance
Reporting. Created P&L reports, AP reports, AR reports and a number of other reports for other
departments. Setup security for different levels of users, Designed model in Framework Manager, and
created some very sophisticated and complex reports.
•Created Financial Profit and Loss reports which incorporated multiple conditional block, prompts and
conditinal highlighting.
•Performed ETL jobs to create table based which reports have been created.
•Imparted valuable analysis to the team regarding Reporting and helped other team members to
understand the comcepts of reporting.
•Created cubes in powerplay based my ETL work.
•Setup security for different types of users.
•Took care of day to day updates to the etl and the reports as required by the users.
•Gathered Information directly from the users for the reports.
•Analyzed data on PLSQL developer.
•Taught users to use Powerplay cubes and customised views ofr them to look at.
•Automated process in etl using Control M jobs.
•Created Dashboard in Metrics Studio Based KPI.
•Successfully installed Powerplay and Reportnet Framework manager on Citrix server.
•Created templates in Cognos for standardisation of the report formats.
•implemented security filters,setup Different Levels of users, setup data access for the databases from
Cognos Connection
•Helped Install Cognos8 on server and configure it. Helped offshore teams to get access setup on Cognos
connection, which I Installed on Citrix server.
•Used security table in the database to implement the security. For each users so as to enable to get
theuser specific data in the user specific report.
Environment: Cognos 1.1 MR2 Report Studio, Query Studio, Metrics Studio, Cognos Viewer, Cognos
Connection, Framework Manager, Access Manager, Impromptu 7.0,SSRS, Oracle 9i,Orcale 8, PLSQL
Developer, SQL Server, Excel, Access, Brio, WOW, Citrix.
03/06 – 05/06 ReportNet Analyst/Developer/Administrator, BCBS Richardson, Dallas, TX
Worked for marketing department. Created Reports on the RDS project which mainly deals with
health plans for Retired people. Trained 16 people in the group in Cognos 8 Report Studio,
Query Studio, Event Studio and also gave an introduction of the tools Analysis Studio and Metric
Studio.
• Analyzed the extracted data and tables to create Model in Framework Manager.
• Installed Framework Manager and Created Model and Package in Framework manager.
• For testing of the data in the report used QueryMan (Teradata query tool) and Cognos
Office connection and Query Studio.
• Did modeling in Visio
•Analyze the report requirement and create the layout and the various components of the
report
•Created highly customized reports in Cognos 8 Report Studio and some of the Ad-hoc
reports in Query Studio.
Environment: Cognos 8 Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos
Office Connection, Cognos Viewer, Cognos Connection, Framework Manager, Datamanager,
Impromptu 7.0, Oracle 9i, Teradata, SQL Server, Excel and Access, Visio and Erwin4.0 .
05/05 – 03/06 Tech-Lead ReportNet -Analyst /Dev/Administrator, Wake Forest University,
NC
Worked for Advancement Department to analyze and create datamart, before creating reports
based on this datamart. The requirement included Gathering information and requirement from
the user and pay attention to minute detail, creating report similar to the old report with added
information to be displayed on the report. And various new reports. Performed various tasks
• Gather requirement and information from users
• Analyze the requirement and design the datamart accordingly
• Analyze the report requirement and create the layout and the various components of the
report
• Created highly customized reports in Report Studio
• Created Dynamic sorting and multiple level sorting
• Created reports with multiple prompts, up to 48 prompts in a report
• Created reports solely based on Tabular SQL supported by functions.
• Changed reports as specified by users. on the reports which were already in production
• Created multi page reports with rank sorting, multiple level sorting, created summarized
Reports using simple list reports
• Created some of the most Complex reports involving multiple tables, views, Calculated
columns, Filters, cascading prompts, Dynamic grouping, CLOB
• Created model in Framework manager, set up cardinality and calculated columns, filters.
• Maintained reports in production, development and testing environment. Took backup of
all the production reports after any changes were made on the request of the user.
Environment: Cognos BI, Report Net (1.1), Report Studio, Query Studio, Cognos Decision
Stream (6.5), Cognos Powerplay, Cognos Impromptu 6.5, Oracle 9I, SCT Banner, SQL Server,
PL/SQL Developer and Excel
09/04 – 04/05 ReportNet - Admin /Dev/Administrator, Ansell Healthcare, AL.
This is a company, which is related to healthcare business. Have setups in Europe, Asia,
Australia, Canada and US. The requirement was to create reports for various users all over the
world and the USA. Worked on Framework manager to implement Security and creating
packages. Created about 49 reports.
• Created reports for various users spanning all over Europe, Asia and US. Most of the
reports were created in Report studio meanwhile taking care of the currency conversion
for different countries.
• Help implement standard unit of measure.
• Recreated some of the old reports in Impromptu into ReportNet.
• Created reports for profit and loss and net sales
• Created groups and roles to implement security
• Designed and setup Framework manager
• Setup security filters in Framework manager.
• Set up three Packages for different type of reporting.
• Setup security in report studio and query studio.
• Created bursting of reports which a part of implementing security at report level.
• Two data sources were used to bring data into the metadata creation.
• Creating Models using the two data sources .
• Mainly dealt with maintenance of the builds in Decision stream, creating builds and the
corresponding job streams to take care of the process, as it had are done at different time
of the day as data comes from different part of the world at different time.
• Created Fact build, dimension builds, jobstreams, for new processes for the data
warehouse using Decision Stream.
• Done maintenance work on Dataware house using Decision Stream.
• Populated test database while Extracting data from data warehouse using Decision
Stream.
• Created a small data mart in Oracle and populated this datamart using Decision Stream.
• Created Morning Report for Europe.
• Done a full life cycle of MLE project. Which is mainly dealing with forecasting and created
reports on the forecasting comparing any Demand to any Forecast.
• Created and maintained two Power Cubes for inventory and sales.
Environment: Cognos BI(6.0), Report Net(1.1), Cognos Decision Stream(6.5), Cognos
Impromptu 6.5, AS 400, IBM 6000 series, Oracle 9i, Lotus Notes 6.5, Golden32 5.7 Benthic
software.
03/04 – 08/04 Cognos Developer, J.C. Whitney, Chicago, IL
The project requirement is to provide various clients to have a look at individual reports to identify
the performance with the company. Allows re-buyers in the company see the performance of the
vendors and attend the orders, which would have been lagging behind. The reports had to be
developed for six different departments - Financial, Inventory Management, Call Center,
Merchandising Category, Logistics and Distribution center.
Analyzed the requirements and created Models, connecting various data sources, reports,
sub queries, creating users, scheduler and joins using Framework manager.
Designed and Analyzed the requirement for this project which has database as AS400,
SQL server and data warehouse as data source
Used various kinds of Filters, List reports, Cross tab and sub queries. Used Visio for
creation of logical E-R Diagram before creating the Catalog
Created a dashboard for merchandising department to have a display of all the aspects of
the merchandising report, which is roughly a combination of eight reports and few extra
fields.
Environment: Cognos BI (6.0), Impromptu, Report Net (1.2), Power Play, AS 400, Excel, MS
SQL Server, Visio, Erwin, Ms-Access
8/03 – 03/04 Cognos Developer, Sprint, Overland Park, KS
worked on the various projects at Sprint, most prominent of them being WFO, which keeps track
of all the employees in all the work areas. Specially the mobile personnel. Keeping track of the
performance of each individual. Did lot of PowerPlay reports, impromptu reports.
Generated reports as per the requirements using Cognos Impromptu.
Developed & generated scripts for building the database structure (tables & synonyms)
using Informatica-ETL tool in the Oracle database.
Used Multidimensional analysis for Data Retrieval using PowerPlay structure
Created Power Play cubes using Transformer.
Defined conditions, calculations and prompts in the catalog
Different department users used the PowerPlay environment that is customized for each
user depending on the requirements
Enabled users to access the distributed HTML reports through local network
intranet/internet, and via email
Environment: Cognos Impromptu 6.0/7.0, Cognos PowerPlay6.5/7.6, Cognos Decision Stream,
Cognos Transformer6.5/7.6, Oracle 8.0, MS Excel, MS Access, Windows NT 4.0/2000
10/02 – 07/03 Cognos Developer, SSA Global, Chicago
In order to quickly identify customer needs and better target services to its huge subscribers, we
implemented a business intelligence system using Decision Stream. With PowerCenter a large
amount of customer-related data from diverse sources is consolidated, including customer billing,
ordering, support and service usage. Then decision support system/analysis on this data is done
using various Cognos Tools to understand which customers stay the longest with the service and
why, and to gauge the effectiveness of promotional activities. The results have been improved
customer-retention efforts and more focused effective customer promotions.
Environment: Cognos Impromptu 6.0/7.0, Cognos PowerPlay6.5/7.6, Cognos Decision
Stream, Cognos Transformer6.5/7.6, Oracle 8.0, MS Excel, MS Access, Windows NT
4.0/2000
10/01 – 9/02 Cognos/Informatica Developer, Citibank, New York, NY
Involved in the design and development of a data warehouse environment based application for
studying various segments of the customer base and for regular reporting. This data warehouse
was developed to generate an ongoing activity based measure of profitability from various
accounting sources. The project was intended to extract, transform and load data into Oracle
database from the sources flat files, MS- Access. SQL SERVER using SQL Loader.
Environment: Oracle 8.x, PL/SQL, Informatica PowerCenter5.0, Cognos Impromptu6.0, Cognos
PowerPlay, Cognos Transformer, Cognos Decision Stream, SQL * Loader, Windows NT,
Business Objects 5.1, Business Miner4.1, Erwin
08/00 – 10/01 Cognos/Informatica Developer Ranbaxy's Pharmaceutical Inc., NJ
Ranbaxy Pharmacy developed a data warehouse using Informatica PowerCenter to transform the
data that is extracted from various source systems and to load dimension and fact tables. Oracle
was used as the target database.
Environment: Informatica PowerCenter1.5/4.5, Cognos Impromptu, Cognos PowerPlay, Cognos
Transformer, Erwin, Shell Scripts, SQL*Loader, Business Objects 5.0,Oracle 7.x/8.0, Windows
NT.
07/99 – 03/00 DBA/Analyst, Object InfoTech, India
Weighted Average Rate
This project was for the finance department of Indian oil. The largest company supplying oil and
gas to the whole of India this is a company, which has a monopoly of supplying oil and natural gas
to all the various parts of India. The finance dept of the west zone H.Q needed to generate reports
for various departments in the finance department itself. The company demanded a complete
documentation of the project. They wanted to have a good communication between the different
locations in the western section so that they could save the precious time in getting the data from
the various locations and let every person requiring the data in the concerned department access
at the same time.
Environment: Oracle 8i, V.B., Window NT, SQL Server, FoxPro, Lotus, Excel
Contact this candidate