Consultant, Associate Consultant, Sr. Software Engineer

Project #3
|Project Name|OCCM-MDM |
|Environment |Cognos 11/TM1 10.2/ Oracle 10g|
|Duration |NOV' 2015- JUL'2017|
|Role |Cognos Report Developer |

Description:

One Call Care Management is the market-leading provider of medical cost-containment solutions to US
workers' compensation payors. On behalf of payors, the Company coordinates care for injured workers
by actively managing the delivery and scheduling of specialty healthcare services and products
through proprietary networks of contracted providers. OCCM is part of the Apax partners since 2013.
Global Logic works with OCCM to architect, establish, execute and sustain the performance & test
automation initiative across all product lines.
A platform to establish centralized master data representation of business entities across systems.
Global Logic is designing and building out a sales database to maintain branch and HQ relationships
for all business units.

Responsibilities:
* Involved in understanding Requirement Specifications.
* Design, develop, and implement Cognos TM1 10.2 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.
* Maintenance of TM1 users, roles, and security.
* Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
* 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.
* Used TM1 rules editor to create and edit rule to create various calculations.
* Import the data from ODBC and Text files using TM1 Turbo integrator.
* Migration and updation of reports from Cognos 10 version to Cognos 11.
* Creating Dynamic Cubes using Cognos Cube Designer and apply security to the Cubes.
* Created standard and Ad hoc reports using Cognos Query Studio and Report Studio.
* Developed List, cross tab, drill through, master-detail, chart and complex reports which involved
Multiple Prompts, multi-query, Burst Reports against database using templates.
* Customized data by adding prompts and filters.
* Implemented Framework manager security for Data access, Object level access and Package access.
* Deployment of Reports in different environment from Development to UAT and from UAT to
Production.

* Involved in several walk-through and interacted with the Quality team for any changes or
enhancements to be made in reports.

Project #4
|Project Name |ERICSSON, INDIA |
|Environment |Cognos 10.2/TM1/ Oracle 10g|
|Duration |SEP' 2014- AUG'2015 |
|Role |Cognos Report Developer |
Description:
Ericsson has been awarded a contract by Reliance Communications (RCOM), to manage RCOM's networks
across the northern and western regions of India. The complexity of the network increases with the
number of platforms and applications, often comprising of offerings from a multitude of vendors and
technologies. Ericsson plans to drive modernization of the tools, processes and best practices that
are applied across the business resulting in operational efficiencies by managing cost through
consolidation. As a consequence, Tivoli Netcool Performance Manager has been selected as the
strategic platform to support the current and future processes of network performance.
Responsibilities:
* Involved in understanding Requirement Specifications.
* Design, develop, and implement Cognos TM1 and Cognos BI solutions for financial planning and
budgeting projects using Turbo Integrator (TI) and complex business rules.
* Extensively used TI for loading data into Dimensions and Cubes, added new dimensions and cubes to
existing environment.
* Developed TM1 application to gather and consolidate data in support of the footnotes in the annual
report.
* Manage TM1 data through TM1 Reports (Active Form & Slice).

* Created and arranged different TM1 rule statements and performed complex calculations for cubes.
* Design models using framework Manager and deployed packages to the Cognos connection.
* Lot of Research and Development is involved while developing the Model and Reports.
* Created standard and Ad hoc reports using Report Studio and Query Studio.
* Created Cubes using Transformer and applying security to the cubes.
* Developed List, cross tab, and complex reports which involved Multiple Prompts, multi-query,
Scheduling and Burst Reports against database using templates.
* Customized data by adding prompts and filters.

* Creation of users and assign Groups for that users to provide Report level security

* Deployment of Reports in different environment from Development to UAT and from UAT to
Production.

* Created different types of reports as per the end user requirements mentioned in report
specifications by using templates.

* Involved in several walk-throughs and interacted with the Quality team for any changes or
enhancements to be made in reports.

Project #5
|Project Name| HDFC ERGO GENERAL INSURANCE |
|Environment |Cognos 8.4/ Oracle 10g|
|Duration |MAY' 2013- SEP'2014 |
|Role |Report Developer |
Description:

HDFCERGO is one of the world's leading investment banks, with deep client relationships and product
capabilities. HDFCERGO develops the most complete and innovative financial solutions in the industry
to meet the needs of our clients in dynamic industries and markets. Whether it's raising capital to
meet growth objectives or identifying strategic business partners, HDFCERGO offers the most complete
M&A advisory, capital markets, restructuring, risk and research platform.
Used Cognos 8 business Intelligence, the Projects main focus was to analyze and forecast financial
transactions of bank with the commercial services they provide and identify most profitable sales
channel, spot and leverage trends in customer satisfaction and support Business Executives to take
quick decisions.

Responsibilities:
* Developed Active Reports, List, cross tab, drill through, master-detail, chart and complex reports
which involved Multiple Prompts, multi-query, Burst Reports against database using templates.
* Design models using Framework Manager and deployed packages to the Cognos connection.
* Created cubes using Transformer.
* Involved in creating Dimension Hierarchy in Framework Manager Model.
* Implemented Framework manager security for Data access, Object level access and Package access.
* Lot of Research and Development is involved while developing the Model and Reports
* Worked with Business Units to define Business strategy and create a centralized reporting
capability for users to perform analytical, and ad-hoc reporting for business applications and
provide accurate information available to Decision Makers.
* Used Cognos Connection for organizing, security, scheduling and distributing reports.
* Customized Cognos Connection with appropriate reports and security measures.
* Involved in several walk-throughs and interacted with the Quality team for any changes or
enhancements to be made in reports..

Project #6
|Project Name |ICICI BANK |
|Environment |Tableau / Oracle 10g/ Win XP |
|Duration |JUN' 2011- APR'2013 |
|Role |Report Developer |

Description:
This project is mainly focused towards transforming the process of generation and circulation of
multiple advices, reports and other forms. These forms (AOF, LC/BG, Payment Advices, TDS, Wealth
Management, and GPC) are a part of the existing banking operations and are circulated to the users
or branches.

Responsibilities:

* Involved in creating database objects like tables, views, procedures, triggers
and functions using T-SQL to provide definition, structure and to maintain data
Efficiently.
* Building, publishing customized interactive reports and dashboards, reports scheduling
using Tableau server.
* Created action filters, parameters and calculated sets for preparing dashboards
And worksheets in Tableau.
* Restricted data for particular users using Row level security and user filters.
* Developed Tableau visualizations and dashboards using Tableau Desktop.
* Developed Tableau workbooks from multiple data sources using data blending.
* Provided 24/7 production support for Tableau users.
* Involved in several walk-through and interacted with the quality team for any
Changes or enhancements to be made in reports.

Project #7
|Project Name|YES BANK |
|Environment |Tableau / Oracle 10g/ Win XP |
|Duration |DEC' 2010- MAY 2011 |
|Role |Report Developer |
Description:
Project Deals about E-statement Generations current formats are Multi cash, MT940, consolidated
and other formats as per the client specifications. Click-fin fetches the records from remote BI
database for data population, Client customers receives E-statement based on registered frequency
(Daily,Weekly,Monthly,Quarterly) and Statement formats. Scheduler take cares for generation as
client used to setup scheduler in between off business hours. Scheduler generates statements and
broadcast statements over internet using SMTP servers.
Responsibilities:
* Understanding functional and technical Requirement Specifications.
* Deep experience with the design and development of Tableau visualization server.
* Experience with creation of users,groups,projects,workbooks and the appropriate permission sets
of Tableau server logons.
* Preparing Dashboard using calculation,parameters in Tableau.
* Used Sets,Bins,Parameters,Aggregate Function and Filters.
* Use Measure name and Measure value fields to create visualization with
Multiple measure and dimension.
* Develop, organize, manage and maintain graph, table, slide and documents

Project #8
|Project Name|BIRCH |
|Client |BIRCH (USA) |
|Environment | Crystal Report 8.5/ SQL SERVER/ Win XP |
|Duration |JAN' 2010- NOV'2010 |
|Role |Report Developer |

Description:
This is a telecom project. Customer info documents received from customers and submitted through
various branches and other sales teams. The application is developed using .NET. Reporting part of
application was developed using SQL Server and Crystal Report.

Responsibilities:

* Studied Report Requirement Specifications and developed reports as per the End user
requirements.
* Optimize various SQL queries to make the reports run faster.
* Developed professional reports with different conditional styles and layouts as per the
requirements mentioned in report specification.
* Modify the existing reports by adding new logic and deleting existing logic as the line of
Business changes periodically.
* Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
* Use prompts, alerts, drill down analysis as per the end user requirements.
* Create nested, conditional subgroups and formatting features in reports.
* Create Sub reports called from the main report to implement the business logic.
* Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
* Migrate reports from Development to Production.
* Provide on call support after reports are deployed to production.

Project #9
|Project Name|Multi plan Web Tool and Application |
|Client |Multi plan |
|Environment |Crystal Report/ SQL SERVER/ Win XP |
|Duration |FEB' 2008- DEC'2009 |
|Role |Crystal Report Developer |

Description:

The Multi plan Application does the outbound process. In Outbound process it executes new Master
file and Details file; during the process based on the business rules the flat file information are
uploaded into the database. Then the uploaded data are retrieved for call purpose. Multiplan Web
Tool has used for agent calling purpose. It automatically record has been pulled from the server to
application. All kind of reports are provided for audit purpose. Before uploading the file,
internally it checks based on business rule, if the data is not good then it will write on separate
file and automatically send back to client through the outlook object.

Responsibilities:
* Analyze business requirements, gather additional requirements as
needed, meet and coordinate tasks with business users.
* Create complex reports using Crystal report 8.5/9.
* Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph
Reports by using Chart expert of Crystal Reports.
* Expert in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary
Reports, Drill-down, Dynamic grouping, graphical, aging reports).
* Expert in writing complex formula at the summary level and group level to implement the
business logic.
* Created reports with drill down option, Parameter fields, formulae, and heavy formatting.
* Designed and developed the reports as per the user's requirements.
* Involved in Optimization to increase performance of reports.
* Involved in the UAT process along with business users.

Project #10
|Project Name|STARTEC |
|Client |STARTEC |
|Environment |ASP.NET/ SQL SERVER 2000/ Win XP |
|Duration |OCT' 2006- DEC'2007 |
|Role |SQL Developer |

Responsibilities:
* Created reports using SQL Server.
* Used DTS to transfer files from Excel data sheets to SQL server database.
Took part in data normalization process along with senior data base analyst.
Creation, manipulation and supporting the SQL Server Database.
Designed and optimized indexes, views, stored procedures and functions using T-SQL.
Writing database triggers, procedures, and packages for applications.
Performed Database Normalization.
Handling database objects with Enterprise Manager and Query Analyzer.
* Development and implementation of backup and recovery strategies.
* Optimized the performance of queries with modifications in T-SQL queries.