SUMMARY:

• Extensive experience in Database Administration and Analysis.
• Excellent knowledge an work experience in RDBMS concepts
• Strong experience in with utilizing SQL for data retrieval
• Good experience in SQL Server Analysis Services (SSAS) using Microsoft Visual Studio 2008
• Extensive experience in OLAP/OLTP concepts / Logical Models / Physical Models
• Good experience in Managing of Database Backup, Restoration and Recovery
• Understanding of star and snow flake schema design
• Convert data received into compatible formats
• Good experience in Master Data management project
• Proficient with MS Access / MS Excel / MS Word / MS PowerPoint
• Expert in documentation skills, knowledge of technical documentation and functional documentation
• Good experience in SQL Server Integration Services ( SSIS) using Microsoft Visual Studio 2008
• Good knowledge of Data warehousing concepts
• Good knowledge in data reporting
• Extensive experience in designing and implementing different types of Replication Models like Snapshot, Merge, and Transactional
• Good experience in product and business and operating support
• Excellent written, communication and interpersonal skills
• Excellent experience in T - SQL Programming language
• Excellent experience in SQL Server Reporting Service (SSRS) using Microsoft Visual Studio 2008
• Good experience in Excel Reports, Charts, Pivot tables
• Can take responsibility and work well with a team

TECHNICAL SKILLS:

RDMS and technologies: MS SQL Server / 2008 / MS Access, Oracle 9i

Language: T-SQL

OLAP Tools: Informatica SSRS / SSIS / SSAS Microsoft Visual Studio 2008

ETL Tools: SSIS

Modeling Tools: Erwin, Toad

Other Tools: Toad, Microsoft Word 2003, Microsoft Excel 2003, MS PowerPoint

Operating Systems: Windows XP/Windows vista/ Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Bensenville, IL

SQL Server Data Analyst

Responsibilities:

• Created Database, create tables, created views, created triggers, Indexes
• Write T-SQL programming queries, Triggers, Store procedures.
• Data Cleansing and mining from raw data, ETL from data sources Excel/ Access.
• Performed data query, extraction, completion and reporting task.
• Maintained files and documentations for future .
• Trained new trainee on MS Access/Excel and documented it.
• MDM system Assist the organization in performing data compiling, mining an analysis required to
• Created ETL packages using SSIS in Microsoft Visual Studio 2008
• Wrote process and documentation in MS Access/ Excel.
• Created reports in SQL Server reporting Services(SSRS) using Microsoft Visual Studio 2008
• Assisted the manager in the analysis of the collected data and interpreting them
• Created reports, forms, database, and tables for data management using MS Access.
• Created OLAP Cubes in SQL Server Analysis Services(SSAS) using Microsoft Visual Studio 2008

Confidential, IL

SQL Server Data Analyst

Responsibilities:

• Created and implemented database design solutions in collaboration with the programming team
• Created database, tables, view, stored procedures, triggers, and indexes.
• Created reports in SQL Server Reporting Services (SSRS) using Microsoft Visual Studio 2008
• Created Tabular / Matrix Reports in SSRS 2008 using Microsoft Visual Studio 2008
• Migrated MS Access database to SQL Server 2008 database.
• Created reports / Charts / Pivot tables in Excel
• Created OLAP Cubes in SQL Server Analysis Service (SSAS) using Microsoft Visual Studio 2008
• Created SSIS packages in SQL Server Integration Services using Microsoft Visual Studio 2008S
• Created tables, reports, charts, in MS Access
• Perform Database Backup and Restores

Confidential, IL

SQL Server Data Analyst

Responsibilities:

• Created Databases, Tables, Triggers, Store procedures, Indexes
• Created DTS Packages to extract, transform and Load ( ETL) from Source and Destination
• Data cleansing and mining from raw data, ETL from data sources Excel / Access
• Tuned the SQL queries using SQL profiler
• Designed and developed cubes using SQL Server Analysis Services(SSAS) using Microsoft Visual Studio 2008
• Created Pivot tables, Reports, Charts in Excel
• Created Databases, queries, reports, tables, charts in MS Access
• Build and maintain SQL Scripts, Indexes, and complex queries for Data Analysis and extraction
• Maintain Tune, Update Databases using DBCC commands in SQL Server
• Created publications in SQL Server using Snapshot Replication, Merge Replication, Transactional Replication
• Created SSIS Packages in SQL Server Integration Services using Microsoft Visual Studio 2008
• Developed DTS Packages to using Import / Export Wizard in SQL Server
• Created reports in SQL Server reporting Services( SSRS) using Microsoft Visual Studio 2008

Confidential, Lombard, IL

SQL Server Data Analyst

Responsibilities:

• Created Databases, Tables, Indexes, Triggers, Store procedures
• Manipulating, cleansing and processing data using Excel, Access, SQL
• Developed and manage reports using SQL Server Reporting Service (SSRS) using Microsoft Visual Studio 2005
• Created SSIS packages in SQL Server Integration Service using Microsoft Visual Studio 2008
• Write T-SQL programming queries, Triggers, Views, Store procedures
• Created Databases, queries reports, forms, tables, charts in MS Access
• Created queries, sorting, filtering and created a calculated field in MS Access
• Build and maintain SQL scripts, indexes, and complex queries for Data analysis and extraction.