SUMMARY

• Around 8 years of experience in MS SQL Server 2008/2005/2000 and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Created Management Reports through SQL Server Reporting Service on demand.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Extensive knowledge in T - SQL queries (DDL and DML).
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Deploy packages to file system and schedule the jobs using SQL Server Agent.
• Good experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Clustering.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Experience in creating ETL mappings in Informatica to load data from different sources to different target databases.
• Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
• Development Projects in SQL Server 2000/2005/2008 and Microsoft.Net.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS

ETL Tools: SSIS (SQL server Integration services), Export & Import (DTS) and Data Stage

Reporting Tools: SSRS (SQL server reporting services),Crystal Reports, Report Builder, SSAS (SQL server Analysis services)

RDBMS: MS SQL SERVER 2008/2005, MS ACCESS, MS EXCEL.

Languages: SQL, T-SQL, PL/SQL, VB.Net.

Software: SQL Toad, Visio

Databases: SQL server 2008/2008 R2/2005/2000, Oracle 9i/10g, MS Access

Operating Systems: Windows2000/XP/2003/2008, MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

SQL Server BI Developer (SSIS)

Responsibilities:

• Involved in the full software development lifecycle
• Gather and analyse business requirements.
• Work with a global engineering team on analysis of business requirements, coding of modifications or new programs, testing.
• Design and implement features and platform components from requirements.
• Execute unit and integrated tests of applications.
• Document the development of code changes and write technical reports.
• Involved in the requirements, design, documentation, development, testing, installation and support of complex data extract, transformation and load (ETL) programs.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQLServer2008R2IntegrationServices (SSIS), SQL Server Reporting Service (SSRS)
• Strong understanding of the SQL Server Integration Services (SSIS) ETL tools, have the ability to take a logical data model and used ETL skills to load the physical layer.
• Understanding of when data should be loaded, how data should be transformed, and optimizing ETL load performance is a critical part of this job. Solid skills with SQL, query optimization are a must for this role to perform.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Worked on C# .Net Application to extract the Files. As a part of support analyst, Analyze and fix the .NET code issues on time.
• Strong problem solving skills, self-motivated, energetic, creative, flexible and able to exercise independent judgment.
• Excellent team player with strong interpersonal, verbal and written communication skills with Positive attitude.
• Maintain applications, infrastructure, and information systems, and perform troubleshooting and debugging tasks
• Provide technical support to customers.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, DTS, C#.net, XML, Windows 2003 Server, IIS5.0, 6.0, 7.0.

Confidential, NY

SQL Server BI Developer

Responsibilities:

• Created detailed design and requirements documents with logic to help team members understand the requirements and design
• Performed design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQLServer2005IntegrationServices (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Deployed SSIS packages and Scheduled Jobs.
• Wrote various queries and stored procedures, and involved in troubleshooting database related issues
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Generated testcases to meet the functionalities deliverables in the project documentation and specifications.
• Ensure database integrity, indexing, segmentation and recovery and update database design over time
• Performed DBA functions, installing, configuring and supporting SQL Server based database systems
• Used Lookup Transformations to get the data from reference data sets
• Scheduling the SSIS packages and Jobs
• Using SSRS delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Created SSIS Packages to migrate slowly changing dimensions
• Used OLAP Processing Tasks for automatic processing of OLAP Databases
• Used Informatica designer to create complex mappings using different transformations
• Used Informatica workflow manager to create workflows, run and monitor mappings.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Developed and executed several optimized queries in SQL.

Environment: SQL Server 2008, DTS, VSS, Informatica, VBScript, XHTML, XML, Windows 2003 Server, IIS5.0, 6.0, 7.0.

Confidential, Dallas, TX

SQL Server BI Developer (SSIS, SSRS)

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse and disability claim systems import data feeds.
• Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Migrate the data from an Access database to SQL Server 2008.
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2005.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2005, MS SQL Server Management Studio, SSIS-2005, SSRS-2005, Report Builder, SSIS-2005, Office, Excel.

Confidential, NY

SQL BI Data warehouse Consultant (SSAS, SSRS)

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Developed Cubes using SQL Analysis Services (SSAS).
• Involved in creating Named calculations and named queries.
• Created Dimensions with the cube wizard and also individually.
• Refreshing the cube to get the latest information updated.
• Deployment of Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Scheduled the DTS package for migration data from old system to MS SQL 2005.
• Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: MS SQL Server 2005/2008, SSRS, SSIS, .NET Framework, C#, ASP.NET, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access Reports

Confidential, New York, NY

SQL Server SSIS/SSRS Developer

Responsibilities:

• Planned, defined and designed data based on the business requirement.
• Worked closely with Business Analysts to produce all required documentation.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Created and maintained databases for Dealers, Vehicle Driver, and Vehicle information.
• Developed complex stored procedures and triggers in T-SQL.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• 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 SSRS to create various ad-hoc, parameterized, drill-down and drill-through reports weekly and monthly showing detailed information of the Vendors information, Titles Information.
• Installed and configured SQL Server 2005 successfully on Windows Server 2003.
• Reviewed and fine tuned stored procedures and triggers before production migration.
• 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, MS Access 2000, Business Intelligence Development Studio 2005, SSIS, MS Excel, Windows Server 2003/2008.

Confidential

SQL Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS.