PROFESSIONAL SUMMARY

• Over5 years of ITexperience in Data warehousing, Business Intelligence BI applications and various segments of Software Development Life Cycle SDLC usingMS SQL Server 2008/2005 DTS/SQL Server Integration, Reporting Analysis Services.
• Extensive SQL Development experience in Banking,Insurance, telecommunications domains with a strong understanding of data analytics.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP OLAP.
• Experience in Interacting with Business users to analyze the business process and transforming
• requirements to solutions by designing, documenting and rolling out the deliverables.
• Involved in Database Design, Data modeling, Development, Implementation in
• SQL Server 2005/2008.
• Extensive experience in using T-SQL DML, DDL in SQL Server 2008/2005.
• Expertise in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Skilled in Business Intelligence tools like SQL Server 2008 Integration Services SSIS , Reporting Services SSRS and Analysis Services SSAS .
• Analyzed, designed and developed data collection strategies, tools and procedures for ongoing data requirements.
• Expertise in handling multiple business units and support stakeholders as per the business needs.
• Experience in working with SharePoint Performance Point 2007 Servers.
• Hands on experience in dimensional data modeling, Physical and Logical data modeling.
• Excellent understanding of relational databases and client/server applications.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skills.

TECHNICAL SKILLS

• Databases: SQL Server 2005/2008, Oracle, MS Access.
• Programming Languages:C, C , T-SQL, PL/SQL
• Web Technologies: HTML,XML.
• Operating Systems: Windows 98/2000/2003/XP/NT/Vista
• IDE BI Tools: SQL Server BI Development Studio BIDS , SharePoint, Performance Point Server, MS Visual Studio2008.

WORK EXPERIENCE:

Report Developer

Confidential

• Was responsible for analysis of reporting needs of all lines of business and designing of reports for local channel management.
• Created production dashboards and analysis reports for managers, and leadership teams throughout Channel Management and the Sales and Service Information SSI team.
• Interfaced with business users to prepare Business Process and Software System requirements and provided developers with test scripts.
• Designed and created operational reporting for field operations team to view daily/weekly/monthly quota vs. actual for store P L and personal goals.
• Examined and evaluated the purpose and content of business reports to develop new or to improve current reporting.
• Established business relationships with external partners and customers to provide reporting and analysis for Retail team including VPs, Directors and Managers.
• Gathered requirements and generated reports using SSRS, Excel Pivot for the diverse group of users.
• Generated ad-hoc SQL Query reports for the Commission,marketing and customer care departments to track the performance of stores in different regions.

Environment: SQL Server 2008, Oracle, Teradata, MS- Excel, Windows Server 2008, Microsoft Visual Studio, MS Visio, MS Integration, Analysis and Reporting Services.

Confidential

Business Intelligence Developer Certificate Program

• Developed Custom Reports, Tabular Reports, Matrix Reports and Distributed Reports in multiple formats using SSRS 2008.
• Designed and developed different data mining models such as decision trees, clustering, regression, and time series to perform predictive analysis using SQL Server 2008 data mining tools.
• Built interactive Dashboards for displaying various KPIs such as ROA, Growth in customer base, Gross Profit margin defined in SSAS cube.
• Created and configured Data Source Data Source Views, Dimensions, Cubes, Measures, Partitions, and KPI's using SSAS 2008.
• Developed ETL packages using heterogeneous data sources SQL Server, Oracle, Flat Files, Excel source files, XML files etc. and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Designed logical dimensional models to illustrate the data warehouse for multiple business domains such as Health care, Retail, Financial and Educational institutions.
• Manipulated advanced Online Analytical Processing OLAP objects to satisfy requirements.
• Applied Multi-Dimensional MDX queries against an OLAP cube.
• Developed scorecards with executive summary dashboards using MS Office Performance Point Server 2007 Dashboard Designer that displays performance monitoring measures for sales, sales trends for a fictitious Bicycle Company deriving data from a SQL Server 2008 OLAP data source and deployed them to SharePoint sites. .
• Enhanced the functionality in database and data ware housing concepts OLAP, OLTP Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008 SSAS .
• Monitored the database activity to identify and resolve the performance issues using SQL Server Profiler.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Transformation of OLTP data to the Data Warehouse using SSIS and T-SQL

Environment: SQL Server 2008, Oracle, MS Access, Excel, Windows Server 2008, Microsoft Visual Studio, MS Visio, MS Integration, Analysis and Reporting Services, Management Studio.

Confidential

Database Analyst

Responsibilities:

• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Monitor failed and long running MS SQL Server jobs.
• Data conversions and data loads from various databases and file structures.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Written several stored procedures and Triggers as per the client requirements.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using TSQL in SQL Server 2005.Troubleshooted and minimized production down issues.
• Built ad-hoc queries from SQL Server databases based on customer requirements.
• Organized monthly and annual reports to ensure balance statements are accurate.
• Assisted the manager in the analysis of the collected data and interpreting them.
• Verified accuracy of data analysis and coordinated with the branch office.
• Responsible for logical and physical design of SQL Server databases.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Designed and implemented stylish report layouts.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Administered MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.

Environment:

SQL Server 2005, Transact-SQL, Enterprise Manager, Query Analyzer, DTS Designer, SQL Profiler, Index Tuning Wizard ,MS-Access,MS-Excel.

Confidential

Business Analyst Intern

• Used Excel to create charts and graphs to analyze business income and expenditures.
• Assisted managers in reviewing monthly financial statements.