TECHNICAL SKILLS:

Languages: C C++, C# Java Python, Ruby, Ruby on Rails, TSQL, MySQL, PL/SQL, HTML, D - HTMJavaScript, XML, Java Servlets, Java GUI, Java Applets, LISP, OpenGL, MS Visual Studio 2005/08

Platforms: Mac OS 10.4/10.5 Linux UNIX MS Windows 95/2000/XP, Windows Server 2000/2003

Databases: SQL Server 2000/2005/2008, MySQL 4.1, Oracle 9i

Applications: MS Office 07/ 10(Word, Excel, PowerPoint), Visual Studio.NET, Macromedia Dreamweaver, Macromedia Flash

Database Tools: SSIS, SSRS, SSAS, DTS, SS Management Studio, Query Browser, Query Analyzer, SQL Profiler, Database Tuning Wizard, Index Tuning Wizard

Hardware: CPU Motherboard Storage and Memory Upgrades; networking (LAN) Card installation Custom built computers A/V component installation

PROFESSIONAL EXPERIENCE:

Confidential

SSRS Developer

Responsibilities:

• Advanced experience in developing and deploying reports using SQL Server Reporting Services (SSRS 2005/08).
• Experience in Report Design, Report Model, report configuration and deployment using SSRS.
• Created different types of reports such as Parameterized, Ad hoc, Drilldown, Drillthrough, Linked, Snapshot, Cached, Clickthrough, Subreports with and without using Report Wizard.
• Experience of Designing reports using Report Builder 2.0/3.0 and BIDS 2005 and 2008.
• Excellent skills in implementing ETL Packages using SSIS 2008/ 2005.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in creating master and child packages, package configurations and logging.
• Excellent knowledge of using variables and expressions in packages.
• Experience in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Bulk Insert, BCP).
• Designed Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes
• Experience in designing, creating, processing of cubes using SSAS.
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.
• Excellent hands on experience in creating groups and measures, KPIs.
• Transformed complex business login into Report design while maintaining their information using SQL objects such as Stored Procedures, User Defined Functions, tables, views, complex TSQL and MDX scripts.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using Index Tuning Wizard.
• Scheduled the reports to run on daily, weekly and monthly basis in Sharepoint 2010, Report Manager, also emailing them to director and analysts to be reviewed in excel and pdf.
• Involved in monitoring daily jobs and responsible in handling all the performance related issues.
• Used Heat 9.0 to clear any client’s issue on SSRS reports.
• Used complex Tsql scripts to create CTEs, Stored procedures, views for SSRS Reports.
• Backup and restore of databases to match the need for the running project
• Used SSIS packages to load data from the source to the data warehouse and process the cube.
• Used Ironpython and C#.net to execute SSIS packages, to access the SSIS metadata and to test the SSIS packages.

Confidential

System Analyst

Responsibilities:

• Involved in Data modeling, designing, and building relational databases.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Migrated Databases from SQL Server 2000 to SQL Server 2005 in Production and Test Environments.
• Backup and recovery of production databases and tuning them for better performance using Veritas Netbackup.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Created databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Created Linked Servers between SQL server 2008 and Oracle servers in the environment.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
• Optimized the Disk space for performance using RAID.
• Configured Replication Server, worked on replication server.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Created, Tested, and Implemented SSRS packages for Reporting Services (SSRS 2008) that included paper-based and interactive web-based reports.
• Built adhoc reports, parameterized reports, toggle reports, tabular, cross-tab, freeform, drill-down, drill-through, chart reports, reports with sub reports using SSRS.
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Created OLAP cubes using SSAS and designed complex MDX queries.
• Created SSRS reports using SSAS data
• Performed De fragmentations Techniques of most complex indexes.
• Performed Backup and recovery & Automation of Backups.
• Created and Modified Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Provided support for clients’ network and client-server apps.

Confidential

Lab Consultant

Responsibilities:

• Installed, configured, and troubleshot operating systems, system software, and application software in the computer labs.
• Troubleshot hardware/software problems on lab computers.
• Replaced broken components on problematic-hardware.
• Troubleshot network connections for lab computers if they are not working.
• Constantly monitored for ICMP threats in the network using third party software.
• Managed a computer lab of capacity of 64 computers.
• Helped students with issues in Word, Excel, Power Points, Web Services, Installation
• Provided support for clients’ network and client-server apps.
• Added, edited, deleted and change priority of print jobs.
• Paused and resumed the operations of printers during printer downtime.
• Diagnosed software-based copier/printer problems.
• Diagnosed logon problems with the deposit stations.
• Helped student print on custom paper.

Confidential

Jr.SQL Server DBA

Responsibilities:

• Identified the necessary steps to enhance user response time by checking fragmentation and reindex tables for efficient application access methods.
• Designed and implemented Maintenance plan for consistency checks, backup/restore
• Rebuild Indexes on Various tables.
• Scheduled activities for Maintaining Databases and installed MS SQL Servers 2000.
• Designed DTS package to export SQL Server data to Access Database.
• Set up, configure and administer Snapshot and Transactional Replication on SQL Server 2005.
• Administered Backup and recovery and administered Disk and Database Space.
• Administered the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, granting the privileges to users and groups.
• Assigned users to particular roles and scheduled the job for Database Backup, Transaction Log Backup.
• Ran various DBCC commands like checkdb/checktable, showcontig, showstatistics etc. for checking database/table consistency and system performance.
• Ensured all scheduled administrative jobs are running/completed for Microsoft SQL Servers.
• Involved in installing SQL Clustering for production environments, implementing Log Shipping
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.