Data Sales

Iraidasan Murugesan

Mobile: 602-***-**** Email: *********@*****.***

Objective: To continue my career with an organization that will utilize my Technical & Management skills to benefit mutual growth and success.

Skill Synopsis

7+ years of Industry experience in Relational Database Design, Query Optimization and solid understanding of Data Modeling, Data Integration, Evaluating Data Sources and strong understanding of Data Warehouse, T-SQL, ETL, and Client/Server applications

Proficient with SSIS & SSRS (SQL Server Integration Service & Reporting Services), Expertize with all MS office (Outlook, Word, Excel, PowerPoint, MS Project, Visio) applications and Experienced in UI Designing & Scripting using XHTML, HTML5, Advanced CSS, Java Script, and ASP.NET

Complete knowledge of Excel functions and macro, MS Access, SQL and Minitab programs

Self learned .Net Framework, C#, ASP.NET, ADO.NET.

Highly Involved in all the phases of SDLC process - Analysis, Design, Development, Test, implementation and Documentation

Excellent knowledge in project documentation which includes specification documents, data mapping and data analysis and status report to all project stakeholders

Excellent communicator, leverage technical, business to communicate effectively with client executives and their respective teams

Analytical problem-solver, able to anticipate issues and streamline operations, resolves concerns and improves efficiency

Personal Info

Work Authorization : H4-EAD (No sponsorship required to renew)

Communication Address:

6445, S Maple Ave, Apt # 1054

Tempe - 85283, Arizona

Mobile: 602-***-****

Email: *********@*****.***

Work Experience

Infosys Technologies 07 Feb 2012 - 29 Apr 2013

Location: Chennai, India

Designation: Process Specialist

Role Summary

SQL BI Developer

Perform requirement, design, coding, configuration, unit testing, debugging, and documenting application programs. Identify key areas of automation and provide Solution design and technical assistance focusing on key technologies in SQL Server. Responsible for ensuring successful implementation of projects

Co-ordinate with onsite for requirement gathering, implementation of projects and its status updates.

Responsible to estimate the new requirements or enhancements in existing projects.

Responsible for requirement gathering and creating requirement and technical document.

Create Stored Procedures, Functions and Triggers to meet client requirements.

Interact with client on daily basis for status reporting purposes.

Testing multiple content controls that are created and incorporated in to TFS for Source control

Troubleshoot performance issues and fine-tuning queries and stored procedures.

Leverage Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and create various dynamic reports using SSRS and Reports.

Developed various Charts (bar, line, pie charts etc) and Graphs like by using Excel Chart

Awards and Recognition

Individual Exceptional performance of the month of September 2012

HCL Technologies 5 May 2008 – 23 Jan 2012

Location: Chennai, India

Designation: Senior Data Analyst

Role Summary

Senior SQL ETL Developer

Sales Order Project combines subsets of data from systems containing Sales Orders information and stage it in to a format that can be easily integrated by the business users. The BI solution will provide a consolidated view of the captured Sales Order Information, sub reports based on client needs. Provide sales report, inventory quantity and value in each country, where available.

Determine the technical specifications of customers by actively listening to what their system needs

Extract sales data from various sources such as flat files, SQL, Excel and stage in the business user requested format

Manage and planning the development of design and procedures for metrics reports

Develop new reports and delegate tasks to team members

As a senior programmer to analyze user specifications for workability, completeness and adherence the business flow

Investigate and conduct study on forecasts, demand for products (Forecasting Tool) using Minitab.

Provide improvement strategies and operation to the team. Perform the market analysis to efficiently achieve objectives, increasing sales by 24% with the help of Minitab. (Successfully completed Yellow Belt Project)

Proposed solutions to improve system efficiencies, leading to a 15% reduction in operating costs with the help of Minitab (Best project award winning in Quality Green Belt Project competition)

Awards and Recognition

Successfully completed the Quality Yellow and Green Belt live Projects and won the project award in Year 2010

Won the special prize award for Best Productivity tool in “Celebrating Excellence 2010”

Best performer Award for the month of Jan 2009

Syven Global Services 06 Mar 2007 - 16 Jan 2008

Location: New Delhi, India

Designation: Analyst

Role Summary

SQL Developer

Design and development of a comprehensive and flexible Business Intelligence solution with interactive dashboards and custom analytics based on data from global banks.

Develop & Modify SQL queries using Microsoft SQL Server Management Studio.

Create Store Procedure & ad-hoc queries for user reports.

Fine tune the queries to improve the performance.

DTS packages to transform data from various data sources.

Import MS Access data to MS SQL server with various formats.

Office tiger (RR Donnelly) 1 Mar 2006 – 2 Mar 2007

Location: Chennai, India

Designation: Document Specialist

Role Summary

MIS

Develop automated reports that have to be sent to the client on a daily basis. Mentor the Daily productivity of the team by automated Dashboards of around 60 agents and provide solutions for improving the productivity.

Create, modify and maintain MS Access Database to automate reports and data analysis.

Create Macro-enabled workbook in MS Excel that reduced user error and time spent completing the job efficiently in the team members report

Organize & formatted data reports in Excel. Assisted the staff with their Excel reports.

Create Excel templates to be used for specific purpose or as per requirement & Export and import data to and from database into Excel sheet

Teaching Experience 1998 - 2006

Seven Years (1998-2006) Computer Programming Assistant experience in Arasan Ganesan Polytechnic College, Sivakasi.

One Year(1997-1998) DTP operator experience in Gandhigram Rural University Dindigul,

And One year (1996-1997) Computer Instructor experience in GIST Computers, Dindigul.

Academic Credentials

Bachelor of Commerce (B.Com) (1992-1995) - Madurai Kamaraj University, India

Post Graduate Diploma in Computer Applications (PGDCA) (2001- 2002) specialization in VB, RDBMS, and Internet & Java - Alagappa University, Karaikudi, India

Contact this candidate