About Me
B.tech graduate with 8 years of experience in data warehouse technologies like IBM Cognos Analytics and IBM Cognos Planning Analytics. I have good experience in creating data warehouse models, writing SQL queries and writing Macros for Excel.
... Show MoreSkills
Data & Analytics
Database
Programming Language
Web Development
Portfolio Projects
Company
Panasonic for North America
Role
Software Architect
Contribute
Gathering the requirements and converting them into model and develop the dashboard and reports.
Description
- Understanding user specification requirements and convert them into business logic.
- Creating dimensions and cubes structures in the model.
- Applying business rules and TI processes to cubes.
- Creating PAX/Perspective reports.
- Creating dashboards in workspace.
- Automating the dimension load processes using chores.
- Adding user groups and security to the model.
- Server management.
- Performing System Integration test, Unit test on modules.
- Preparing user requirement specification document.
Skills
CognosTools
SQL DeveloperCompany
Omnitracs BI Carve out
Role
Software Architect
Description
- Involved in design and development of Complex reports using Report Studio.
- Analyzing the data along with ETL team to know where the data elements come from & what data is required for the report development.
- Having stand-up calls with the user almost on daily basis to support the report requests.
- Built list and crosstab reports, which have complex business logics by developing queries (native SQL) and firing them onto Cognos report studio.
- Calculations, conditions, filter etc... are developed at the query level only.
- Used advanced concepts of report studio like conditional formatting, master – detail relationships.
- Involved in designing detail filters, summary filters, grouping and associations, Calculations and develop the report with client specific guidelines for report development.
- To understand the functional requirements provided by the report users and Worked on bug fixes & enhancements in Cognos BI.
- Deployment of Cognos BI packages & reports to QA & PROD environments.
Skills
CognosTools
SQL DeveloperCompany
Trade Automation 15
Role
Software Architect
Contribute
Cognos Developer
Description
- Gathered reports requirements with Business Users and converted them into project documentation.
- Installed Cognos Framework Manager in an interim environment as a proof of concept.
- Designed, developed and maintained catalogs according to the business requirements.
- Developed Project Files, Models and packages according to the business specifications using Framework Manager.
- Developing reports for new migrated environment Trade Automation ’15.
- Performing unit test on reports.
- Creating prompts, parameters and filters to reports.
- Performing performance test on reports.
- Trouble shooting of Production issues.
- Applying drill through definitions on reports.
- Involved in designing and creating the Model and Packages in Framework Manager.
- Preparing technical documents.
Skills
CognosTools
SQL DeveloperCompany
Operational Reporting and Business Intelligence Tool (ORBIT)
Role
Backend Developer
Contribute
Cognos Developer
Description
- Designing reports for various business segments like Customer Installation, OptumHealth care solutions using packages.
- Involved in designing and creating the Model and Packages in Framework Manager.
- Creating report templates for various product types.
- Requesting to publish new package to Tier III.
- Creating report query, report groups, sorts, custom sorts, subtotals, Query Processing, Filters, prompts, calculations and preparing output formats.
- Maintaining report folders and version of reports.
- Developing on-demand and self-service reports.
- Customizing existing reports according to business requirements.
- Involved in creating cubes using IBM Cognos Transformer.
- Creating views to cube.
- Created Ad-Hoc reports using Query Studio.
- Scheduling reports.
- Performing unit and performance testing on reports.
- Writing queries, validating data and formatting reports.
- Preparing technical documents.
Skills
CognosTools
SQL DeveloperCompany
Ika Claim System Production Support and Maintenance
Role
Backend Developer
Description
- Involved in writing the queries to retrieve the date from schema objects to produce the RTP reports.
- Analyze, translate and define business requirements into technical solution
- Data Modeling and Data Analysis
- Design and Publish packages to Cognos portal using Framework Manager
- Involved in design and development of Complex reports using Report Studio.
- Creation of reports like cross tab reports, Charts, Drill Through reports.
- Assignment of developed code for review and incorporating the review comments.
- Deploying the code from Development environment to test environment and from there to PROD
- Fixing the defects raised by Users.
- Provide developer support to Quality Assurance and User Acceptance Testing teams till the code moves to production.
Tools
SQL Developer