sivaselvan karuppusamy

business requirement and data modeler and data analyst

About

Data Modeler / Analyst / BI at Citi Group

Country

united states

City

new york

Industry

information technology and services

Skill

data analysis, data modeling, requirements analysis, business intelligence, oracle, sdlc, data warehousing, software project management, business analysis, pl/sql, requirements gathering, business process

Experience

technical consultant

capgemini

2005-3 - 2007-3 · 2 yrs 1 mo

technical lead

hcl technologies

2007-3 - 2011-10 · 4 yrs 8 mos

* Translating business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources. * Developed Dashboard Reports, Standard Reports, Charts and Drill through Reports, Master-detail/conditional formatting reports using Report Studio and Query Studio. * Created Multidimensional models and CUBES in Cognos transformer using Framework Manager. * Transition developed reports and dashboards to the Operations & Support team. * Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users. * Created Oracle PL/SQL Stored Procedures, Functions to be used by Framework Manager Packages and Report Studio reports. * Responsible for SQL tuning and optimization using Analyze/DBMS_STATS, hints and Explain Plan. * Responsible for performing code reviews, unit testing, and documentation of the interfaces.