Cognos Developer Resume

SUMMARY

2+ years of experience in data analytics tools, data warehousing concepts, SQL server management studio and testing.
Worked closely with stakeholders to gather functional requirements and developed cognos reports.
Implemented Framework manager models and published packages into server.
Expertise in designing, development, unit testing and validating reporting solutions against relational and dimensional databases.
Created analytical reports using advanced excel features and Tableau.
Earned over 50 salesforce badges, 25000 points for admin level modules/trails.
Specialties: Analytical/critical thinking, time management, individual and team skills, data analytics, scripting experience, SQL queries.

TECHNICAL SKILLS

Languages: C, C++, Java, PL/SQL, HTML, Matlab, Simulink, Keil.

Databases: SQL server2008/2012, oracle11/10g, TOAD, DB2.

Software/Tools: MS Office (EXCEL, POWERPOINT, OUTLOOK, WORD), MS Visio, Informatica power center 9.5, Tableau 9.X/8.X, Cognos 10.X/11.

Statistical Modelling: SAS, Python.

Academic Level Expertise: Networking Protocols, computer architecture, operating systems, software engineering.

PROFESSIONAL EXPERIENCE

Cognos Developer

Confidential

Responsibilities:

Involved in life cycle management for migrating reports from Hyperion to Cognos 10.
Developed and published packages in Framework Manager by connecting and testing the data source, creating database, presentation layers and defining appropriate relationships between query subjects.
Created complex reports like list, cross tab, charts, drill - through reports, master-detail reports, cascading reports.
Developed dashboards involving complex calculations and filters to bring in company information together.
Involved in OLAP/OLTP system study, data analysis, E-R modelling and created models based on star and snow-flake schema.
Executed SQL, Oracle and DB2 scripts and functions for data profiling, report validat ion and troubleshooting report performance.

Data Analyst

Confidential

Responsibilities:

Involved extensively in decision making related to data analyzing, data collection, data security, design and methodologies.
Built analytical reports with advanced excel features like and prepared summaries to accompany the charts prepared.
Maintained data integrity during data extraction, manipulation, analysis and storage.
Created PL/SQL Script, stored procedures to troubleshoot data and maintain proper data extraction.
Merged Data Sets altered and analyzed data as per requirement using SAS.
Built SQL scripting, indexes and queries for data analysis and extraction.

Test Engineer

Confidential

Responsibilities:

Monitored the test vehicles and tracked the issues to take corrective actions.
Conducted inspections as per requirements.
Tested internal signals of the Control Deck of the Armored vehicles using Matlab.