SUMMARY

• 7 Years of Professional Experience as a SQL Server Developer (SSRS, SSIS, and SSAS) using MS SQL Server 2000/2005/2008.
• Hands on Experience in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2008/2005/2000.
• Experience in Software Development Life Cycle (SDLC) Processes Including Analysis, Design, Development, Testing and Implementation.
• Good Experience in Exposure to Writing SQL/Transact - SQL (DDL, DML and DCL), Developing, Creating New Database and Database Objects Such as Tables, Views, Indexes, Complex Stored Procedures, Function (UDF), Cursors, E/R Diagrams, Normalization, Triggers, Locking Issues, Constraints, Security, SQL joins and Query Writing, DTS (i.e. Import and Export), BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent, SQL Server profiler using SQLSERVER 2000/2005/2008.
• Have Good Experience in Migrating From SQL Server 2000 to SQL Server 2005. And Successfully Migrated Data Between Different Heterogeneous Source Such as Flat-File, Excel, Oracle, Sybase, DB2, MS Access Using SQL Server SSIS 2000/2005/2008.
• Expert in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version (2005/2008) and Troubleshoot Migration Issues.
• Expert in Deploying and Configuring Packages, Error Handling and Batch Logging Check Points and Troubleshoot Reporting Services Using SSRS.
• Experience in Generating On-Demand And Scheduled Reports For Business Analysis Or Management Decision Using SQL Server Reporting Services.
• Proficiency in Creating Different Types of Reports such as Cross-Tab, Drill-Down, Cascading Reports, Detail, Summary Reports Including Line and Pie Charts, OLAP, OLTP, Sub Reports, Matrix Reports, Parameterized Reports, Trend Analysis Reports and Sub-Reports According to Business Requirements Using SSRS
• Experience in Generating Reports for OLTP and OLAP databases.
• Expert in Created, Designed and Processed a Multi-Dimensional Analysis (Configured Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star and Snow Flake schema) using SQL Server 2005/2008 Analysis Services (SSAS).
• Strong Knowledge of Data Ware Housing Concepts, Including Star Schemas, Snowflake Schemas and Dimensional Modeling.
• Effectively Manages Time Spent On Multiple Projects To Meet Deadlines.

TECHNICAL SKILLS

Languages: C, C++, JavaScript, ASP, ASP.NET VB, C#.NET, JAVA, SQL, T-SQL, PL/SQL, MDX.

SQL Server Tools & Packages: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Configuration Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL.DTS, SSIS, SSRS, SSAS, Erwin Data modeler

Databases: SQL Server 2000/2005/2008/2008 R2, MS Access 97/2003/2005/2008, Oracle 11g/9i, DB2

Methodologies: Data Modeling, Star Schema, Snowflake schema.

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front page.

Operating Systems: Windows Server 2000/2003/2008/2008 R2, Windows NT & XP.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Developed tables, Views, Stored Procedures, Cursors and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Experience in creating Clustered Indexes and Non-Clustered Indexes.
• Worked on extracting, transforming and loading (ETL) data using SSIS Import/Export Wizard.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created ad-hoc reports in Query-studio with incorporated filters, sorting etc and presented them at the client side to note the changes they may need.
• Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users.
• Excellent Hands on Experience with Scheduling and the Deployment of the Reports and Uploading Files to a Report Server Catalog from the Report Manger.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent
• Configured packages event logs.
• Identified and resolved the query performance using SQL Profiler
• Migrated of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version (2005/2008) and Troubleshoot Migration Issues.

Environment: MS SQL Server 2008, MS SSAS, SSIS, SSRS, Crystal reports,, T-SQL, Oracle, PL/SQL, MS Access, DTS, FTP,SQL Profiler, VB.Net, MS Excel, ASP.Net.

Confidential, Secaucus, New Jersey

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Extensively used T-SQL to manipulate and architect to produce results for users.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Created SSIS process design architecting the flow of data from various sources to target databases.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Data Migrations using DTS Import/ Export for transferring data between different databases like oracle.
• Migrated data from SAS environment to SQL Server 2008 R2 via SQL Server Integrated Services (SSIS) Applied conversion and transformation procedures according to business requirements.
• Experienced in report generation using XML, Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet.
• Involved in Scrum Methodologies and Sprint Reviews.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts, usage of tablix (new feature of SSRS 2008), use of filtering conditions.
• Expert in modifying SSRS RDL (XML) which is the primary role of SSRS gateway.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

Environment: MS SQL Server 2008, MS SSAS, SSIS, SSRS, Crystal reports,, T-SQL, Oracle, PL/SQL, MS Access, DTS, FTP,SQL Profiler, VB.Net, MS Excel, ASP.Net.

Confidential, Tallahassee, FL

SQL Server SSRS/SSAS/ Oracle SQL

Responsibilities:

• Expert in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2008/2005 using Oracle 11g as the data source.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex).
• Excellent hands on experience in creating groups and measures, KPIs.
• Expert in using SSRS gateway service calls to and from SSRS reports.
• Expert in modifying SSRS RDL (XML) which is the primary role of SSRS gateway.
• Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS 2008.
• Proficient in Using Tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005.
• Expert in comfortable mentoring others in my team for complex SSRS reports.
• Data Transformation Activities using DTS Import/ Export for transferring data between different databases like oracle. Design new DTS packages as per needs, Resolve the problems.
• Migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services (SSIS) Applied conversion and transformation procedures according to business requirements.

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008, SSIS, MS Visual Studio 2008, Oracle SQL Developer.

Confidential, Los Angeles, CA

MS SQL Server DBA/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in logical & physical development of the database using Erwin.
• Developed complex T-SQL code for data retrieval.
• Designed and implemented of Stored Procedures and Triggers for automating tasks.
• Responsible for transferring the data from different servers using DTS packages.
• Experience in Performance Tuning in SSIS packages By Using Row Transformations, Block and Unblock Transformations.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports, Parameterized Reports using SSRS.
• Created reports usingSSRSfrom OLTP and OLAP data sources and deployed on report server.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Expert in using SSRS gateway service calls to and from SSRS reports.
• Created Packages that Transfers Databases from One SQL Server instance to Another Instance.
• Design and Implementation of Data Mart for reporting purposes.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for identifying KPIs in SSAS 2008.
• Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery.

Environment: SQL Server 2000 Enterprise Edition, MS Access, SharePoint Server, DTS, Query Analyzer, PL/SQL, MS reporting Services, SQL Profiler, Erwin, ETL, DTS, T-SQL, BCP, SSIS, SSRS, SSAS, Windows 2000 Server.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Installed and maintained MS SQL Server 2000.
• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Developed complex T-SQL code for the application.
• Used BCP in and out, Bulk Insert and DTS as tool for migration of data to and from SQL Server 2000.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked with DTS packages and MS OLAP Services.
• Used Guide wire for converting legacy data into its Claim Center and Policy Center applications.
• Maintained the consistency of the client’s Database using DBCC.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Involved in analyzed and designed disaster recovery / replication strategies with business managers to meet the business requirements.

Environment: MS SQL Server 2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements
• Used T-SQL to create various queries
• Created new tables, wrote stored procedures and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Performed tuning of SQL queries and stored procedures using SQL Profiler.

Environment: Microsoft SQL Server 2000, Windows XP, VB Script, DTS, Visual Studio 2000.