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 2005/2008.
• Successfully Migrated Data Between Different Heterogeneous Source Such as Flat-File, Excel, Oracle, Sybase, DB2, MS Access Using SQL Server SSIS 2005/2008.
• Expert in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version 2005 to Higher Version 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 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:

• Written T-SQL Queries, Dynamic-queries, sub-queries and Complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Created Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Involved in system analysis & design of the Enterprise data warehouse implementation
• Designed the Functional Requirements and Mapping Technical Specifications on the 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 the Metadata for the Reports using XML Files
• Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Localization for the RDLC Reports and created the 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 used test 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.
• Developed Reports with different styles using Table, Sub Reports and Matrix.

Environment: SQL Server 2008 R2, T-SQL, SSRS, Oracle 11g, Windows 7, 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.
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• 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.
• Migrated of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version (2005/2008) and Troubleshoot Migration Issues.
• Migrated data using DTS Import/ Export for transferring data between different databases like oracle.
• Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
• Handling the errors during data moving and Sequencing the task as per requirements.
• 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 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.
• 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.

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 the data source.
• Created and designed solutions that use the 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.
• Creating tables, relationships, triggers and indexes for enforcing business rules
• Worked closely with the 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 Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005.
• Worked on Hash functions and checksum for loading large amount of data on Target system.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the ETL loadings.
• Configured SQL Mail agent sending Automatic emails when a SSIS Process is failed or succeed.
• 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 the problems.

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, Business Analysis and Design.
• Prepared technical specifications for the 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 the 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.
• Written business and data access components (as separate assemblies) in C# utilizing ADO.NET transaction management.
• Responsible for transferring the 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.
• Created maestro schedules/jobs for automation of ETL load process.
• 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 2008, 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

Role: 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.
• 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 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.
• 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 the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for identifying KPIs in SSAS 2005.
• Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery.

Environment: SQL Server 2005 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 2005 Server.

Confidential

Role: SQL Server DBA/Developer

Responsibilities:

• Installed and maintained MS SQL Server 2005.
• Worked as a developer on databases like MS SQL Server 2005, 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 2005.
• 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 2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2005 Server.