SUMMARY:

• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Over 7 years of extensive experience in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008.
• Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies.
• Proficient in creating different types of reports such as drill down, sub reports, parameterized reports and formatting them using SSRS.
• Experienced in creating MDX Cubes and dimensions using star and snowflakes schema(SSAS)
• Extensively using various SSIS Objects such as Dataflow Components, Control Flow Elements,
• Extensively involved in using SSIS tools like Import and Export Wizard for developing the
• Involved in creating complex stored procedures, triggers, functions, indexes, tables, views and other T - SQL code and SQL joins for applications.
• Efficient in upgrading and migration from MS SQL Server 2005 to MS SQL Server 2008.
• Experience in Creating an SSIS Package for data importing and cleansing. Extracted cleaned and validated.
• Good at understanding database design, referential integrity constraints, OLAP, OLTP, Cubed Data and normalizations.
• Extensive use of Query Analyzer for performance tuning.
• Proficiency in the use of T-SQL for developing stored procedures, triggers, tables, user functions, views, indexes, SQL optimization and joins and query writing.
• Worked closely with management and users on database solutions.
• Experience with Manual/Automation Testing using tools; Quality Center (Test Director) and Quick test pro (QTP).

TECHNICAL SKILLS:

• SQL Server 2008/2005,T-SQL
• SQL SERVER INTEGRATION SERVICES(2008/2005)
• SQL SERVER ANALYSIS SERVICES(2008/2005)
• SQL SERVER REPORTING SERVICES(2008/2005)
• SQL Server management Studio2008/2005
• Business Intelligence, Microsoft Visual studio (2008/2005).

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. MS SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Migrated Databases from SQL Server . Determine the technical approach of Migration used when migrating from SQL Server .
• Migrating data from various sources into the SQL Server 2008 using ETL (Extract, Transform, Load) tool SQL Server Integration Services (SSIS).
• Working extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP
• Extensively using various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Extensively involving in using SSIS tools like Import and Export Wizard for developing the packages.
• Involving in writing T-SQL stored procedures, views, triggers
• Writing SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Creating tables, views, users, logins, indexes (indices), check constraints and business rules using T-SQL and maintained databases.
• Extensively involved in Preparing Detailed Technical Documents from the Functional Specifications.
• Governing and maintaining performance and analysis of the customers billing information in the form of reports using SSRS.
• Developing several stored procedures to handle large amount of data manipulation.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Using SQL Profiler for debugging issue, performance tuning whenever necessary.
• Performing data mapping and transferred data from staging tables to database tables using SSIS transformations.

Environment: Windows XP, MS SQL Server 2008, MS SQL Server Reporting Services 2008,MS SQL Server Integration Services 2008, Excel, Acrobat Reader.

Confidential, Gainesville, FL

Sr.MS SQL Server Developer/ SQL BI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Developed the reports using business intelligence development studio (BIDS) and SQL Server reporting services (SSRS) based on the business logic by implementing efficient stored procedures.
• Performed Extraction, Transformation and Loading (ETL) using SSIS.
• Designed Fact tables, Dimension tables and scheduled data transfer from real time database to data warehouse and databases
• Designed SSIS packages to migrate the data from different sources to destination data warehouse.
• Extensively worked on Query Optimization and Performance Tuning of databases.
• Deployed SQL Code and Reports (SQL 2005 Reporting Services) To QA\Dev\Prod.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Used Report manager to deploy reports, schedule reports, and created groups and users. Used role based Security to control access to folders, reports and resources Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access, created and managed new security accounts.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2005/2000, SSIS, SSAS, SSRS, Oracle, Management Studio, Enterprise Manager, Mirroring, Replication, WINDOWS 2003, Excel Macro 2003

Confidential, Iselin, NJ

SQL Server Developer

Responsibilities:

• Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Involved in designing ETL solutions to migrate data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2005, T-SQL, .Net, ADO.Net, ASP.NET, MS SQL Server 2005/2000, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HTML, CSS Windows XP Pro, Windows Performance monitor.

Confidential

BI/SQL Developer (SQL/SSIS)

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Designed new SSIS packages and deployed them.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Writing Stored Procedures, Triggers, cursors and creating indexes.
• Fixing Bugs and Automating jobs.
• Testing and loading the data on Development and Production.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Performing query plans and making sure each and every query is using appropriate indexes.
• Provided support for in-house and off-shore Development Team.

Environment: SQL Server 2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL, ERWIN 4.0, XML, MS PowerPoint, MS Project & Windows 2003 server.

Confidential, Cleveland, OH

BI/SQL Developer (SQL/SSIS/SSAS)

Responsibilities:

• Converted all existing DTS packages of MS SQL by adding SSIS task using the different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Manager.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Developed stored procedures and triggers in T-SQL.
• Planned, defined and designed data based on the business requirement.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Fine-tuned database objects and server to ensure efficient data retrieval.
• Assisted the front end application developers with their queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005/2000, MS Access 2000, MS SQL Analysis Services 2005, MS Excel, Visual Studio 2005, Windows Server 2003, Toad, ERWIN