Data Engineer

• Nov 2021 - Present

BI solutions Developer

• Mar 2020 - Nov 2021

Business Intelligence Developer at Cubic Transportation Systems

• Sep 2018 - Mar 2020

IT Analyst

• Jun 2015 - Sep 2018

Cognos BI Analyst Developer (Contractor)

• Mar 2015 - May 2015

* Daily Data warehouse and cube build checks * Development of complex Cognos Report Studio Reports * Resolution of reporting issues as identified by business users * Involved in modifying the Dimensional model in Framework Manager like adding levels, adding hierarchies and publishing the same to the cognos connection. * Have developed new Retail KPI Report and complex trading report covering sales, stock and purchase data sets. * Daily Data warehouse and cube build checks * Development of complex Cognos Report Studio Reports * Resolution of reporting issues as identified by business users * Involved in modifying the Dimensional model in Framework Manager like adding levels, adding hierarchies and publishing the same to the cognos connection. * Have developed new Retail KPI Report and complex trading report covering sales, stock and purchase data sets.

Associate

• Jul 2013 - Nov 2014

• Involved in the development of report studio reports [List, Crosstab, Charts, Drill Through, Master Detail, Cascading Prompts, Conditional Formatting, Group Span] including complex and technically challenging reports.• Worked closely with the Subject Matter Experts [SMEs] of Each Functional area to understand the Reporting Requirements and make changes to the tech specs based on the discussions\ Technical feasibilities.• Developed Framework Manager relational models from the scratch, implemented required joins and published the packages to Cognos connection. • Have implemented Business Labels concept using business translation file to all the Framework Manager Models so that Business labels will appear in the report studio reports.• Have involved in the development of Ad hoc packages for Business users and publishing it to the portal. Business users can create ad hoc queries from these packages in Query Studio. Also provide support to the business users in creating ad hoc queries.• Took ownership of Metric Studio Package and scorecard development. Created around 25 Metrics of type of Manual and Automated Metrics.• Created Metric Designer Package from scratch [Object Extracts, Metric Extracts, Actual, Target, Tolerance Value Calculations] and published the Metric Extracts to the cognos Portal.• Developed FM Package for Metric Scorecards, created Metric Types, Metrics and Scorecards.• Have implemented Security to Cognos FM Packages (Object Security, Data Security and Package Security)• Took ownership of handling all DB related activities like Creation of Report Specific Views, Creation of Synonyms, Granting Privileges to DB Objects, Modifying Oracle PL/SQL Packages, Modifying Oracle functions and Procedures, Schema Comparison using TOAD. Show less

Programmer Analyst

• Dec 2009 - Jun 2013