Sr Developer & Analyst

Aakash Namboodri

**** ******* ****

Dublin, Ohio US 43017

Cell: 614-***-****

******.*********@*****.***

OBJECTIVE

To obtain the challenging position of business intelligence analyst and assist the organization in planning, organizing and decision making activities

WORK EXPERIENCE

Narayan Infinity, Rajasthan India

Business Intelligence Analyst 05/2007 - 06/2008

• Assisted company managers in making informed and sound business decisions to sustain or improve the competitive positioning of the organization.

• Analyzed the company financial/business data to receive facts and statistics and provide true picture of performance and industry standing.

• Created views consisting of computed columns to facilitate easy user Interface.

• Analyzed the organization’s strengths and weaknesses in order to enhance the future performance

• Formulated the process of reports to improve the business intelligence of the organization.

• Collected historical and current business data to establish operational trends in the company.

• Utilized statistical tools to forecast the outcome of implementing certain business strategies based on historical data.

• Collaborated closely with organization staff for optimal data

Pacer International Inc., Dublin, OH US

Business Intelligence Analyst (Junior Developer) 08/2011 – Present

• Collect performance data from previous financial quarters to determine the patterns and trends in organization's operations and performances

• Created stored procedures for commonly used complex queries involving join and union of multiple tables.

• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.

• Created Reports in SSRS with different type properties like filters, Interactive sorting, parameterized/drilldown, cross-tab reports &summary reports.

• Designed and developed SSIS packages to extract data from various data sources such as excel spreadsheet and flat files into SQL server 2008

• Created Datasets in T-SQL, Stored Procedures for SSRS

• Analyze the effectiveness of the current systems and procedures applied in the organization towards achieving the long term and short-term goals

• Helping Design Dimensional Modeling using SSIS packages for End –User. Created Hierarchies in Dimensional Modeling

• Assist the organization in planning and decision-making activities by considering the availability of resources, potentials risks, competition levels, etc.

EDUCATION

Western Michigan University 2009 - 2011

Master’s Degree in Electrical Engineering and Engineering Management

University of Rajasthan 2003 -2007

Bachelor’s degree in Electronics and Communication Engineering

SKILLS

• Extensive knowledge of data warehouse methodologies and data modeling

• Ability to work in all stages of System Development Life Cycle (SDLC).

• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases

• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.

• Strong ability to analyze user requirements

• Proficient in building front-end BI applications according to specifications

• In – depth knowledge of relational database structures, theories, principles and practices

• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms.

• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.

• Proficient in using MS Windows, UNIX ,Visual Studio and ETL tools

• Ability to understand organization’s goals and objectives

REFERENCES

References available upon request

Contact this candidate