SUMMARY

• Around 7 years of experience in designing, developing, and implementation of business requirements with Microsoft SQL Server 2008 R 2/2008/2005/2000 in OLTP and OLAP environment.
• Experience in installation, configuration, Performance tuning, optimization, backup and recovery in SQL Server 2008 R 2/2008/2005/2000 .
• Experience in Upgrading of SQL Server 2005 databases to SQL Server 2008.
• Strong experience in data modeling using Erwin Data Modeler and Microsoft Visio.
• In - depth knowledge of Transact-SQL (DDL, DML).
• Expertise in creating indexes, stored procedures, user defined functions, views, cursors, derived tables, common table expressions (CTEs) and triggers.
• Advance Knowledge in RDBMS concepts, Conceptual/logical/physical data models, and Dimensional/Star/Snow Flake schemas.
• Hands on experience on SQL Server Integration Services (SSIS), SQL Server Analysis Server (SSAS), SQL Server Reporting Services (SSRS).
• Experience in building Data Integration, Workflow Solutions, Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services.
• Expertise in Importing/Exporting Data from various data sources like Excel, Oracle, DB2, My SQL, MS SQL and Flat file using SQL Server Integration Services.
• Excellent knowledge of using variables and expressions in SQL Server Integration Services packages.
• Experience in data migration from different database platforms.
• Experience in developing reports using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Drill Through, Parameterized, cascading and Ad hoc Reports.
• Experience in configuration of report server and report manager, scheduling Reports, give permissions to different level of users in SQL Server Reporting Services.
• Experience in designing, building and deploying multidimensional cubes using SQL Server Analysis Services.
• Experience in Creating Data Source and Data Source Views, Dimensions, Measures, Partitions, KPI’s and MDX (Multi - Dimensional Expressions) Queries using SQL Server Analysis Services.
• Extensively worked on designing and developing multiple enterprise reports using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Ability and willingness to learn new technology and deliver results in a timely manner.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 7/Vista/XP/2000/98/95, Linux

RDBMS: MS SQL Server 2008 R 2/2008/2005/2000 , Oracle 9i/10g, My SQL

IDE & BI Tools: SQL Server Business Intelligence Development Studio (BIDS), MS Visual Studio 2010/2008/2005

ETL Tools: SQL Server Integration Services (SSIS2008/2005), Data Transformation Services (DTS)

Reporting Tools: SQL Server Reporting Services (SSRS2008/2005), Crystal Reports

Languages: T-SQL,PL/SQL,C, C#, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential - CA

SQL Server BI/DW Developer

Responsibilities:

• Involved in gathering business requirements from business users to develop various reports and cubes.
• Created functional requirement specifications and supporting documents for business systems as per the SOX standards.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting.
• Utilized multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created stored procedures, Sub-Queries, CTE’s, Views, Triggers, User defined functions and etc.
• Designed and developed extensive Logging and Error handling in SSIS for optimal monitoring of data flow.
• Migrated data from SAS and SQL Server 2005 to SQL Server 2008 using SSIS.
• Used Script Component to generate the Surrogate key values in Dimensional Tables.
• Designed and developed OLAP cubes and wrote MDX queries to create calculated members in the cube
• Designed and developed Hierarchies in Dimensional Modeling.
• Created Perspectives of the cube to simplify the process of browsing for the end users.
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Developed Drill down, Drill through, Cascading, Parametric reports in SSRS 2008.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Used Report Builder to do Ad-hoc Reporting.
• Developed an automated report subscription process using SSRS.
• Published reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports

Environment: Business Intelligence Development Studio, MS Visual Studio 2008,, MDX, SSIS, SSRS, SSAS, MS-Visio, MS-Access, Windows XP, SQL Server 2008 R 2/2008/2005.

Confidential, Charlotte, NC

ETL/SSIS Developer

Responsibilities:

• Involved in gathering business requirements and building logical and physical data models.
• Created high level design of the ETL process.
• Created three step ETL process to get the files from the server and load the data into database.
• Designed and Developed SSIS Packages to Extract and Transform the data from Heterogeneous Source systems and eventually load into EDW.
• Created complex Stored Procedures to validate and process the incoming data.
• Generated Validation Reports to notify the client with the invalid data received.
• Written Power shell scripts to purge files.
• Understanding of existing SSIS 2005 packages and redesigning them into SSIS 2008 packages and facilitate batch processing.
• Designed deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files.
• Scheduled execution of ETL Packages using SQL Server Agent.
• Created Work Items using Team foundation server.
• Creating detail design documentation of the packages and creating release notes for each installs.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Scheduled the SSRS reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Created Ad Hoc reports by building models in Report Builder using Model Designer and Report Builder.

Environment: MS SQL Server 2008/2005, Business Intelligence Development Studio, Team Foundation Server, T-SQL, Performance Point, VBScript, XML, Windows XP, Excel.

Confidential, IL

Sr. Microsoft BI Developer

Responsibilities:

• Installed and administered Microsoft SQL Server 2008, SQL Server Integration Services 2008 and SQL Server Reporting Services2008.
• Actively worked as part of a team for gathering and analyzing Business Requirements.
• Designed and Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Created SSIS Packages to load the data in to the data mart on daily basis and involved in production support.
• Deployed the packages (both the methods File system & SQL Server system) to different environments.
• Created SSAS OLAP Cubes, where the cubes are used to automate the current manual process of Reports.
• Administered OLAP and reporting Services environment.
• Involved in writing MDX queries and worked on creating calculated measures that fits business logic.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Dashboards, KPI’s, Score Cards and Reports.
• Designed and developed Drill Down, Drill through, linked and sub reports using SSRS 2008.

Environment: SQL Server 2008/2005, T-SQL, Windows XP, MS Visual Studio 2008/2005, SQL Server Integration Services, Erwin, SQL Server Reporting services, SQL Server Analysis services

Confidential, Atlanta, GA

Microsoft BI Developer

Responsibilities:

• Created functional requirement specifications and supporting documents for business systems.
• Created logical and physical database design, data structures and maintained by using SQL functions like Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Involved in database design process and data modeling process for Billing Method using Erwin.
• Worked with providing data to OLTP systems and pulling data from OLTP systems using SSIS.
• Created Data-driven Packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL Server 2008/2005, Oracle, .CSV, Excel and Text file from Client servers and through FTP
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Created reports using SSRS from various sources like SQL Server 2008/2005and Cubes from Analysis Services
• Designed various Cubes as per the requirements for various clients using SSAS.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel spreadsheet.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.
• Involved in optimization of queries, improving the performance and Maintaining the database consistency with DBCC at regular intervals

Environment: SQL Server 2008/2005 Enterprise Edition, Windows XP, Enterprise Manager, Business Intelligence Development Studio, T-SQL, MS Access 2007, MS Excel 2007.

Confidential, CA

SQL Server Developer

Responsibilities:

• Prepared and updated the Functional Specification Document.
• Responsible for re-designing database models for its applications.
• Responsible for creation & maintenance of database, table spaces, users, tables, indexes, stored procedures, roles.
• Tuning Queries and Database performance using tools like SQL PROFILER.
• Responsible for scheduling and managing jobs on MS SQL Server.
• Responsible for designing and writing DSS queries and reports.
• Supported the project in areas of data quality, standardization, data definition, modeling, metadata repository management functions and replication.
• Load, transform and extract data from different sources such as production database, flat files, excel files into staging database for cleanup using SSIS.
• Loaded Data from staging database to the OLAP database.
• Defined measures and various dimensions to analyze the measures of the cube.
• Designed and developed reports using SQLServer Analysis Services and Reporting services.
• Developed Web Forms using ASP.NET and Code behind using VB.NET.

Environment: SQL Server 2005, Business Intelligence Development Studio, ASP.NET, VB.NET, C#, XML, Visual Source Safe, Active Reports 2.0, Windows Server 2003.

Confidential

Jr. Database Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2000.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Defined relationship between tables and enforcing entity referential integrity using Primary Key constraint
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables and eliminating table scans and implementing index seeks

Environment: SQL Server 2005/2000, Windows XP, SQL Profiler, SQL Query Analyzer, Business Intelligence Development Studio, T-SQL.

Confidential

SQL Developer/ Analyst

Responsibilities:

• Converted logical databases into the physical models.
• Involved in creating the DTS packages by using SQL Server 2000.
• Involved in creating tables and designed different constraints, enabling and disabling the constraints.
• Defined functions as per the requirement.
• Design and development of Interfaces and connected to Database using SQL Server.
• Created database objects like tables, views, stored procedures and Triggers.
• Created and maintain database environments development, Test and Production; and synchronizing all database environments.
• Designing and building databases for applications across all company business functions.
• Involved Unit testing and creating the test cases.
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.
• Created views for the users according to their roles.
• Helped the front end application developers with their queries.
• Performing frequent maintenance, scheduling backups and restoration of Database.

Environment: Microsoft SQL Server 2000, DTS, SQL Server 7.0, MS Access, VB 6.0, HTML, ASP and PL/SQL.