SUMMARY

• 7 Years of Professional Experience as a SQLServer Developer (SSRS, SSIS, and SSAS) using MS SQLServer 2000/2005/2008.
• Hands on Experience in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQLServer 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, ComplexStored 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 SQLServer Agent,SQLServer profiler using SQLSERVER 2000/2005/2008.
• Has Good Experience in Migrating From SQLServer 2000to SQLServer 2005. AndSuccessfully Migrated Data Between Different Heterogeneous Source Such as Flat-File, Excel, Oracle, Sybase, DB2, MS AccessUsing SQLServer 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 andTroubleshoot 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 SQLServer2005/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, Urbandale, IA

SQL Server Developer/SSRS Developer

Responsibilities:

• WrittenT-SQL Queries, Dynamic-queries, sub-queries and Complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• CreatedIndex, Views, Complex Stored Procedures, Triggers, Cursors andappropriate User defined functions to implement teh business logic.
• Involved in system analysis & design of teh Enterprise data warehouse implementation
• Designed teh Functional Requirements and Mapping Technical Specifications on teh basis of Functional Requirements.
• Involved in Creating Period reports: shift or daily report, weekly, monthly and annual reports, till and employee reports.
• Developed Reports with different styles using Table, Sub Reports and Matrix.
• Developed RDLC Reports and Passing teh Metadata for teh Reports using XML Files
• Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Localization for teh RDLC Reports and created teh Descriptor files for sort by options.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Prepared and usedtest data & test cases to verify accuracy and completeness of ETL, report process.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS).
• Generated various reporting services RDL’S using SSRS for Financial DW reports.
• Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Created Period reports: shift or daily report, weekly, monthly and annual reports, till and employee reports.
• Developed Reports with different styles using Table, Sub Reports and Matrix.

Environment: SQL Server 2008, T-SQL, SSRS, SQL Server 2008 R2, SSRS, Windows 7, Crystal reports, Oracle, PL/SQL, MS Access, FTP,SQL Profiler, 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 teh flow of business and called various stored procedures from DTS to make teh flow of DTS effective.
• Created SSIS process design architecting teh flow of data from various sources to target databases.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Migrated data 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.
• Modified SSRS RDL (XML) which is teh primary role of SSRS gateway.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Involved 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.
• 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, Tallahassee, FL

SQL Server SSRS/SSAS/ Oracle SQL

Responsibilities:

• Written 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 teh data source.
• Created and designed solutions dat use teh SSRS gateway to interface between SSRS and a web front end (ideally flex).
• Involved in creating groups and measures, KPIs.
• Worked on using SSRS gateway service calls to and from SSRS reports.
• Modified SSRS RDL (XML) which is teh primary role of SSRS gateway.
• Worked closely with teh business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS 2008.
• 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.
• Used Tools like Bulk Copy (BCP) and DataTransformation Services (DTS) and SSIS with MS SQL Server 2000/2005.
• Mentored others in my team for complex SSRS reports.
• Involved in Data Transformation Activities using DTS Import/ Export for transferring data between different databases like oracle. Design new DTS packages as per needs, Resolve teh 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, Tampa,FL

SQL SSIS Developer/SSRS Developer

Responsibilities:

• Responsible for Requirements gathering, BusinessAnalysis and Design.
• Prepared technical specifications for teh development of SSIS (ETL) packages to load data into various target tables and defining ETL standards.
• Created logical and physical data models using Erwin.
• Extracted Data using SSIS from Oracle, flat files, Excel and XML files performed transformations and loaded teh data in to SQL Server Data warehouse for E-File Payment application.
• Implemented SSIS with SQL Server stored procedures for data manipulations.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings.
• Writenbusiness and data access components (as separate assemblies) in C# utilizing ADO.NET transaction management.
• Responsible for transferring teh data using SSIS packages from OLTP to OLAP.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type I and type II changes.
• Worked on SSIS, for removing duplicate records with data standardization.
• Created mappings for conditional split, merge, merge join, export column, import column, audit and SCD transformations.
• Created Data Conversion package which converts columns to different types and adds columns to datasets.
• Worked on Hash functions and checksum for loading large amount of data on Target system.
• Created procedures to drop and recreate teh indexes in teh target Data warehouse before and after teh ETL loadings.
• Created maestro schedules/jobs for automation of ETL load process.
• Configured SQL Mail agent sending Automatic emails when a SSIS Process is failed or succeed.
• Prepared and using test data & test cases to verify accuracy and completeness of ETL process.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS).
• Generated various reporting services RDL’S using SSRS for Financial DW reports.
• Used SSRS to create customized reports and ad hoc reports.
• Create reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
• Created Period reports: shift or daily report, weekly, monthly and annual reports, till and employee reports.
• Developed Reports with different styles using Table, Sub Reports and Matrix.

Environment: SQL Server 2005, SSIS, SSRS, C#. Net, ASP.NET (2.0), T-SQL, Sybase12.0, Windows XP, ERWIN 4.0, Oracle 10g, Microsoft Source safe, Unix

Confidential, Los Angeles, CA.

MS SQL Server DBA/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in logical & physical development of teh 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 teh data from different servers using DTS packages.
• Experienced 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 teh subscription reports with teh subscription report wizard.
• Expert in using SSRS gateway service calls to and from SSRS reports.
• Created Packages dat Transfers Databases from One SQL Server instance to Another Instance.
• Involved in 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 teh 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 teh Stored Procedures and Triggers to be used in production.
• Developed complex T-SQL code for teh 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 teh 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 teh consistency of teh 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 teh business requirements.

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