EDUCATION

Bachelor in Computer Science

WORK EXPERIENCE –

3 Years+
2009 May – Present: Confidential,SSRS Developer, Bossier City, LA, USA

• 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.

2008 Aug – 2009 Apr: Confidential,System Analyst, Irving, TX, USA

• 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.

Languages: C, C++, C#, Java, Python, Ruby, Ruby on Rails, TSQL, MySQL, PL/SQL, HTML, D-HTM,
JavaScript, 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
PROJECTS: Watchdog Anomaly Detection System
Led a team of five in an analysis of a four-gigabyte database of NetQOS to detect anomalies of a net flow as a part of the main project using MYSQL and JDBC
Financial Simulator
Led a team of five in the design and implementation of a financial simulator that calculates the financial