SUMMARY

• A skilled software professional as SQL Server/BI Developerwith7years of experience in design & coding of database, and applications of MSSQL Server 2008/2005/2000.
• Work experience in the field of Data Warehousing and Business Intelligence applications as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services.
• In - depth knowledge of Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables and maintaining ACID properties.
• Extensive working experience in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) and in-depth knowledge of maintaining entity relationship between them.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Common Table Expression (CTE).
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, indexes, joins, constraints (keys) with their integrity, functions, stored procedures.
• Well experienced in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008, DTS in SQL Server 2000.
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, Send mail task, For loop container, For each loop container, Sequence container) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge, Multi cast, Derived column, Character map, Union all, Sort, Row count, OLEDB command).
• Experience in creating SSIS packages with Error handling, and for Logging, by using Event Handler, Breakpoints.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2005/2008 using data from a variety of sources.
• Experienced in generating on-demand (ad-hoc reports) for business analysis or management decision using SQL Server Reporting Services and Report Builder.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008.
• Experience in Creation of Dimension tables, Fact tables, Measures, Cubes and deployment of cubes onSSAS.
• Experience in creating the MDX queries to access cubes and dimensions (SSAS).
• Efficient in creating various cube objects KPI’s, Aggregations, perspectives and calculated members.
• Possesses excellent skills in Data Modeling using Star and Snowflake Schemas.
• Performance oriented in developing and extending cubes, dimensions and data source views, data mining models and deploying and processing SSAS objects.
• Experienced in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SQL Server Integration services (SSIS) packages for Data Management applications.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Hands on experience in installing, configuring, managing, upgrading and migrating, and monitoring and troubleshooting SQL Server 2000/2005/2008 .

PROFESSIONAL EXPERIENCE

Operating systems: Windows Vista/XP/2000/NT, Server 2003,Server 2008

Databases: MS SQL Server 2008/2005/2000/7.0, MYSQL, Oracle, MS Office Access 97/2000/2003

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS), Informatica

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio

Reporting Tools: Visual Studio, Report Builder2.0, Report Builder 3.0

Data Modeling Tools: Erwin, Red gate, Light speed

Languages: T-SQL, C, C++,Visual Studio2005/2003,XML,HTML,ASP.NET

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL SERVER DEVELOPER/BI DEVELOPER

Responsibilities:

• Optimized the performance of database by creating various clustered, non-clustered indexes and indexed views for querying data faster.
• Creating the complex stored procedures, joins, User defined functions to meet the business rules.
• Normalized and De-normalized the tables and maintained Referential Integrity by using Triggers, Primary and Foreign Keys.
• Created Physical and Logical design of Database using primary key, foreign key and maintained ACID properties.
• Developed incremental loading using MERGE statement in SQL server 2008.
• Extracted the data from OLEDB, Flat Files, Excel Files transformed and Loaded into SQL server using SSIS.
• Worked on various tasks and transformations likeExecute Sql Task, File system task, Send mail task, Sequence container, Merge, Multi cast, Derived column, Character map, Union all, Row count, OLEDB command while loading the data into Destination.
• Developed, deployed and monitored SSIS Packages.
• Used SQL server reporting services (SSRS) to create complex reports that draw content from a variety of data sources and deployed them to server.
• Designed and developed parameterized reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created complicated reports like parameter based reports, graphical reports, well-formatted reports, chart and tabular using filters and expressions in SSRS.
• Scheduled Reports to run Hourly, Daily, Monthly according to end user requirements.
• Generated on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services (SSRS).
• Created many stored procedures / functions in Reporting Services directly to generate reports on the fly.
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Created OLAP Measures and Cubes using SSAS.
• Supported in creating KPI, calculation members and measure groups, and MDX queries.
• Deployed Packages from Development to Production Server.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Windows 2003, MS Access, Report builder3.0, EXCEL,SQL Server Profiler.

Confidential, Fort Worth, TX

MS SQL Server Developer - SSIS/SSRS/SSAS

Responsibilities:

• Created and developed tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created complex stored Procedures, triggers, cursors, and other SQL joins and statements for applications.
• Created clustered/ non clustered Indexes and maintained FILL FACTOR for fast and efficient reporting process.
• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Designed SSIS packages with Error Handling and email notifications.
• Involved in Data Integration by identifying the information needs within and across functional areas worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
• Implemented Incremental loads and Data split using different kind of transformations like Row count, Sort, Merge, Fuzzy lookup, Multicast using SSIS.
• Transformed data from one server to other servers using tools likeBulk Copy Program (BCP)andSSIS.
• Proficiently created drill down reports, linked reports, drill through reports and sub reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Responsible for identifying and defining data source and data source views.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence.

Environment: - MS SQL Server 2000/2005/2008, SSIS/SSAS/SSRS, MS Access, Windows NT, Windows XP/ 2003/2000/98, MS SQL, ERWIN 7.0X, SQL Profiler, SQL Query Analyzer, T-SQL, MS SQL Server Integration Services 2008/2005, DTS, ASP.NET, MS Office.

Confidential, NewJersy

SQL BI Developer (SSRS/SSAS)

Responsibilities:

• Developed T-SQL Queries, stored procedures and triggers to facilitate consistent data entry into the database.
• Created indexes for better performance and tested the data with complex queries, joins, sub queries and temp tables.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Constraints.
• Used SQL server reporting services (SSRS) to create complex reports that draw content from a variety of data sources and deployed them to server.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.
• Designed and developed Matrix and Tabular reports with Top N, Cascaded, Parameterized, and drill down, drill through reports using SSRS.
• Created stored procedures and functions in Reporting Services to generate reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also e-mail them to Manager to review in Excel Sheet.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Creating an OLAP cube by using the Cube and Dimension Wizards.
• Designed the Data source views, cubes and dimensions with snowflake schema using SSAS.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS.
• Involved in writing MDX Scripts for the OLAP Cubes.
• Enhanced and deployed the SSIS packages from development server to production server.
• Created drilldown reports, Parameterized reports, Ad-Hoc reports in SSRS from multiple data sources including SSAS cubes.

Environment: SQL Server 2008/2005, Enterprise Edition, SSAS, SSIS, SSRS, T-SQL, MS Office 2003/2007, Share point Server 2007 (MOSS), T-SQL .

Confidential, Plano, TX

SQL Developer

Responsibilities:

• Designed and developed database objects like tables, stored procedures, triggers, rules, defaults, user defined data types and functions for this project.
• Wrote complex SQL queries, stored procedures, and views.
• Created and updated clustered and non-clustered indexes to keep up the SQL Server performance.
• Implemented T-SQL features like Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text file and CSV files.
• Developed SSIS packages with transformations like Derived column, conditional split, Lookup, Execute SQL task by using control flow and data flow wizards.
• Applied various Data flow and Control flow transformations to meet the business needs.
• Generated reports in SQL Server Reporting Services (SSRS) using table control, matrix control for cross tab reports.
• Developed Tabular, Drilldown, Parameterized, Charts, Sub-Reports using SSRS.
• Defined Report Layouts for the report design as per the need.
• Designed and deployed Reports with Drop down menu option and Linked reports and created Sub Reports, Parameterized and as well.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Created SSAS cubes and defined the dimensions.
• Extensively worked on Dimensions and Measures using SSAS.

Environment: Windows server 2003, MS SQL Server 2005, SSIS, SSRS, VBScript, Erwin, Visual Source Safe.

Confidential

SQL Developer

Responsibilities:

• Active member of the team designing the OLTP and data warehouse relational data models
• Embedded complex queries and procedures in DTS Packages based on business requirements.
• Optimized poorly performing queries and procedures for optimal performance.
• Implemented data integrity by implementing constraints and triggers.
• Replaced sub queries with inner and outer join statements for improving query performance.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Involved in the Analysis and creation of Staging DB and defined various facts and Dimensions in the data.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Involved in performing Extraction, Transformation and Loading using DTS.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/Data Migration with SQL server DTS.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary
• Involved in developing a database system prototype for front end application for testing purposes
• Used PHP in backend of company’s web portal for reporting purpose

Environment: MS SQL Server 2000, DTS, Flat Files, SQL Server Agent, Enterprise Manager, Query Analyzer