Summary:

Business intelligence professional with over 9 years of experience and Certified in Business Intelligence, OLAP and Data warehousing. He has worked in the capacity of a Developer as well as Data Modeler in the full suite of Cognos Products, such as various Studios in Cognos Suite, Framework Manager, ReportNet, Power Play Transformer, Impromptu and IWR. He has also been officially trained and certified in Cognos 8 Report Authoring and TM1 Developer. He has worked on multiple projects in an onshore-offshore model team setting across the SDLC of the project. Amiya's sound database and analytical skills and an advanced degree have given him an opportunity to bring some challenging projects to successful fruition.Some of Amiya's responsibilities have included Developer, Team Lead, Solution Architect, Project Management, Business Analysis, Designing of the Meta-data, System Architecture, Report Authoring, Upgrading, Documentation, End-User training, working on project proposals, estimations, proof of concepts, etc. His clients include retail and insurance industries.

Reporting and Dash Boarding Tools:

OLAP Tools:

Databases:

Languages:

Operating Systems:

Data Modeling Tools:

Scheduling Tools:

Analytical Tools:

Quality Control/Testing:

Confidential

Solution Architect/Onsite-Offshore Coordinator

Main objective of this project is to combine to different source system into one and generate Cognos reports out of the new source system that provides a holistic view of data. This application helped business users get a better view of available data than the existing system that was providing only a partial information. Another objective of this application was to ensure all the reports are executed only in few seconds.The application is designed to extract data from two different systems called WM and WR using the SSIS ETL tool and the data is loaded into SQL Server database. Cognos is used as a front-end reporting tool to create model and package, which in turn used as a source for Cognos reports. Cognos packages are also used for various ad-hoc reporting for various decision-makings.

Roles and Responsibilities:

• Organizing multiple requirement gathering sessions with business to understand the areas of improvement in the existing system.
• Architect the solution approach and create appropriate design and review the same with the review board
• Review documentation of technical specs and technical designs.
• Design and development of the SSIS Package and Framework Manager model along with the offshore team and review the same.
• Ensure the SSIS jobs are scheduled and trigger on a regular basis.
• Ensure the package is designed to support both canned reporting and ad-hoc reporting.
• Coordinating the change controls and enhancements to offshore team appropriately
• Doing peer review of each and every deliverables to ensure greater quality of the deliverables.
• Doing Pre-UAT of the SSIS package and each and every report

Environment: SQL Server 2005, Cognos 8/10x, SSIS

Solution Architect/Onsite-Offshore Coordinator

Confidential in my current application area I have been involved in several Proof of Concepts, prototypes, processes, enhancements, automations, optimizations, etc. I have always tried to enhance the quality of the service/deliverables by providing something extra to facilitate better functionality and to add additional value to the deliverables.Have been involved in various prototypes using SAP BO Xcelsius, Cognos, VBA, etc. Have done several Cognos reporting query performance tuning. Have also been engaged in multiple process monitoring and process optimization to ensure efficient and effective process execution.

Roles and Responsibilities:

• Requirements and Analysis: Understanding the requirements from the clients
• Interacting with the client on various forums to discuss the status of the service calls
• Come up with design approaches and propose the same to client manager and other stake holders
• To ensure of quality deliverable
• Peer review and feedback
• Development and Implementation

Environment: SQL Server 2000/2005/2012, Cognos 8.x/10.x, Framework Manager 2010/2012, XCelsius, Teradata 12/13, SAS, Shell Script, TM1

Onsite-Offshore Coordinator

Main objective of this project is to provide a wrapper around the black box of SAS codes. Existing project was to provide inputs to the SAS codes manually and process the same and manually send the output to the requestors. The wrapper was designed to help with accepting inputs from users and process the same and provide the outputs directly to the user mailbox. This helped avoiding lots of manual intervention.Claim Analytics project is a web application that is intended for the business users to submit their request and get the result in the mailbox. This application accepts inputs from users anywhere in US and stores the inputs in SQL Server database. We have used SAS to connect to SQL Server to fetch the inputs and process them in SAS and provide the result output as an attachment. We have used crontab to keep looking for new requests and trigger the execution on a regular interval.

Roles and Responsibilities:

• Understanding existing business model and customer requirements.
• Provide the easiest and quickest solution
• Set up meeting between the business users and offshore developers if and when needed.
• Developed the Shell Script codes to connect between the crontab jobs and SAS scripts
• Involved in modifying the existing SAS jobs to connect to SQL Server and fetch business user inputs and to distribute the result output.
• Have extended the same solution for multiple lines of products.
• Created a operational dashboard using Cognos to see current status of the jobs that are in queue or in execution mode. This helped business users keep track of how much time it may take to complete their request.
• Designing technical specification document for all the modules.
• Worked on multiple enhancements to fine-tune the application and to add additional features and functionalities.

Environment: .Net, SQL Server, Shell Script, SAS, Cognos 8

Solution Architect/Onsite-Offshore Coordinator

Loss Trend Tool is mainly a reporting tool that generates reports with various statistical trends based on various parameters selected by users. This is be used by mainly the actuarial, pricing, reserving, product management business executives in personal insurance area in Travelers to generate and view various professional and ad-hoc reports to gain a better understanding of the losses and claims in last 5 years and that helps them to decide on the future policy pricing rates.Main objective of the project is to replace the existing manual excel reporting due to its lack of reliability, portability, and its limitation of handling limited data.In this project SSIS has been used to extract data from Teradata database and loaded the same into SQL Server database after doing certain transformation based on business requirements. Then Cognos Framework Manager is used to create a relational model and a package from SQL Server database and the packages are published in to Cognos content store, which in turn is being used as a source for reporting in COGNOS Report Studio/ Query Studio. There are various predefined professional reports with tabular data and charts have been created and are regularly used by business executives by providing several sets of parameters. Several reports are also scheduled and run automatically on a monthly and by-monthly basis and the reports are delivered to a designated shared path and also delivered to email box.

Role and Responsibilities:

• Involved in Understanding existing Business Models and Customer requirements by participating in the Requirement Gathering and Designing Phase meetings with users.
• Understanding the requirement and documenting them and sharing the same with the whole team.
• Work closely with business executives and offshore team to ensure the requirements are understood very clearly and the same is passed onto offshore team for development work.
• Design and documentation of multiple documents like Technical Requirement specification, mapping document, etc and getting a sign off on the document and sharing the same with offshore team for development.
• Designed and developed complex Framework Manager Model with several business logics.
• Designed and developed various complex reports showing multiple trend values and charts.
• Worked extensively in SQL Server 2005 to create various queries with several joins and used the queries in the Cognos reports.
• Worked on various report level complex joins.
• To ensure the report is delivered with high quality and zero defects.
• Involved in multiple enhancements to implement new logics and features to existing reports and to add many new reports.
• Production Deployment of Cognos Package and the reports and their maintenance.

Environment: SQL Server 2005, Cognos 8.0

Offshore Team Member

National program business unit belongs to the commercial P C business of travelers. They have about 30 programs. The National Programs business unit offers products to commercial insured, underwritten on a program basis. This business segment is dedicated to developing tailored program approaches for insured's with similar risk characteristics, typically utilizing a single distribution source.National Programs MI also known as NPMI is used by National Programs business executives to create and view various professional and ad-hoc reports with losses and claims data, to gain a better understanding of the financial status of the company, which in turn helps them to make better decisions with respect to claims handling, policy pricing and other operational expenses for coming years. It helped them to take further decisions to enhance their business.SSIS jobs were developed to extract the data from Mainframe system and do certain data processing to clean and filter unnecessary data. Load the data into the SQL Server database system. Models are created from SQL Server database and packages are published to COGNOS Content Store, which in turn is being used as a source for reporting in COGNOS Report Studio and Query Studio.

Role and Responsibilities:

• Requirement Analysis, Design and Development of the Model and Packages in Cognos Framework Manager.
• Created model using Framework Manager based on business requirements have used several complex business logics to implement the business rules.
• Have created several complex list and crosstab reports along with graphs and charts.
• Leading offshore team of 3
• Have designed and developed various Reports in COGNOS Report Studio/Query Studio.
• To ensure the requirement is understood to the maximum from onshore and it is shared with the team members.
• To ensure flawless report development as per the requirement and delivery of the same on or before the deadline.
• Taking care of other quality and process related activities for the project.
• Have also been involved with other estimation and/or POC related activities.

Environment: Cognos 8, SQL Server 2000.

Offshore Team Member

This project is developed with the objective to have a consolidated clean and consistent Data warehouse for Sales, Product, Manufacturing, and Distribution divisions of the company with historical business trends using historical data. This package facilitates Stock Management, Market Research, Advertising and promotion strategy building for the products. By this system SDMI can estimate the Current Demand, and provides information to Marketing Managers that helps them to make better decisions about pricing, advertising and other vital marketing matters. The other objective is to provide flexibility to perform multi-variant analysis in Sales Distribution area.

Roles and Responsibilities:

• Analyzing the existing reporting approach and creating detail design document.
• Designing and developing the model accordingly as per the technical specification.
• Creating the Package in Framework Manager and publishing the same.
• Creating various types of prompts.
• Creating various Kinds of reports like list, cross tab in Report Studio.
• Created Prompts, Filters calculations to customize the data.
• Developed various complex reports using drill through and master detail capabilities of Cognos.
• Extensively used conditional blocks conditional formatting conditional texts different parameter prompts and static choices for the graphs
• Scheduling and Distributing Reports using Event Studio
• Creating technical documents.

Environment: SQL Server 2000, Cognos 8 BI Suite