SUMMARY

• 6 plus years of IT experience in Data warehouse development life cycle like gathering requirements, designing, Testing, Implementation and support in various domains.
• Noticeable experience in configuring, managing and troubleshooting SQL server 2005/2008, Reporting and Analysis Services.
• Expert in SQL Server Constraints (Primary Keys, Foreign Key, Default, Unique, Check), writing T - SQL Queries and Dynamic Queries.
• Good experience in dealing RDMS concepts which include Stored Procedures, Constraints, Indexes, Querying, Data Import/Export, Derived Tables, Joins and Triggers.
• Experience in using the MS SQL suite of products like SSRS, SSIS and SSAS on BIDS environment.
• Expertise in building complex reports with SSRS 2005/2008 for analysis of data at enterprise level.
• Noticeable experience in Importing/Exporting data from various data sources like Excel, Oracle and DB2 using SSIS.
• Good experience in designing, deploying and processing OLAP cubes for the analysis of the data using Partitions and Aggregations in SSAS.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS packages.
• Experience in multiple transformation of data with different features like variables, package configurations, event handlers, error logging etc.
• Noticeable experience in parameterized queries for generating Tabular and Sub Reports using temporary variables, expressions and Functions for reports using SSRS 2005/2008.
• Good experience in using tools like performance tuning, SQL profiler for MS SQL server performance.
• Worked in every stage of SDLC (Software Development Life Cycle) like design, development and implementation.
• Good experience in creating Drill-Down, Drill-Through, Cascaded, Pivot, Matrix and Tabular reports based on the requirements of the business.
• Experience in working with visual studio 200/2008/2010.
• Little experience in Application development of web based applications using C#, ASP.NET, ADO.NET, JavaScript and CSS.
• Have good work ethics, quick learning, self-motivation and team player abilities with good communication and technical skills
• Can work in environments with less to no supervision.

TECHNICAL SKILLS

RDMS: Microsoft SQL Server 2000/2005/2008 , MS Access, Oracle 10g/9i

LANGUAGES: SQL,T-SQL, PL-SQL, C#, VB Script, HTML,XML,JAVA SCRIPT,ASP.NET, C, C++

MICROSOFT TECHNOLOGIES: MS Office, Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, Visual Studio

OPERATING SYSTEMS: Win 95/NT/2000/XP/Vista, MS-DOS, UNIX, Windows Server 2003 Enterprise

TOOLS: AND UTILITIES: SSRS, SSIS, SSAS, TFS, Performance point Server, Erwin, SQL Profiler, Database Engine Tuning Advisor, Index Tuning Wizard, SQL Agent, WiX.

VERSION CONTROL TOOLS: Team Foundation Server (TFS)

WEB SERVERS: IIS, Apache

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, Nevada

Sr.SQL BI developer

Responsibilities:

• Involved in all stages of Software Development Life Cycle (SDLC).
• Installed and Configured MS SQL Server R2.
• Involved in creating various database objects which includes Schemas, Stored Procedures, Tables, Views, Joins, User defined functions, Triggers etc.
• Responsible in moving data from MS Access and Excel into SQL Server 2008 using SQL Server Integration Services (SSIS).
• Created Tablix, matrix and Parameterized reports using SQL Server reporting Services (SSRS) and upgrading them.
• Pushes the daily database changes to two servers which are used by application developers and QA.
• Refreshes data on two severs using a Stored Procedures.
• Created many databases for developing, testing the application and for every module of the project.
• Involved in query optimizing techniques for better performance of the application.
• Worked with T-SQL, DDL, DML, DCL scripts and also established relationship between tables using constraints and joins.
• Responsible for designing and testing Stored Procedures and Triggers for maintain huge volumes of data.
• Created and managed clustered Indexes and Non-Clustered Indexes and optimized queries.
• Worked on Team Foundation Server (TFS) for collaborating with the team efficiently and had experience with work item template customization.
• Involved in unit testing and Integration testing.

Environment: SQL Server 2008 R2, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), T-SQL, XML, TFS, C#, VB, MS Excel, MS Access

Confidential, Chicago, Illinois

SQL BI (SSIS, SSRS, SSAS) Developer

Responsibilities:

• Involving in developing complex T-SQL elements like Stored Procedures, Queries and Triggers good execution plan.
• Updating DTS packages to SSIS packages.
• Responsible for generating statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created and Developed databases for every module of the project and provided easy ways to access data by creating required stored procedures for application developers.
• Transferred different data from different sources like oracle to SQL server using SSIS.
• Involved in handling Drill Down, Drill Through and Cascaded reports using SQL Server Reporting Services (SSRS).
• Performed error handling for better performance of reports.
• Responsible for deploying cubes and packages from integration and Analysis services (SSAS) to the local server.
• Responsible for comparing daily schema changes and updating them to the QA server and refreshing data on it

Environment: SQL Server 2008 Enterprise, SSAS, SSRS, SSIS, Management Studio, C#, TFS, IIS, WCF, XML, Oracle

Confidential, Covington, Kentucky

SQL BI Developer

Responsibilities:

• Involved in creating many Database Objects like tables, views and many user defined functions for implementing functionality of the application
• Developed many stored procedures for helping developers for easy access and changes of data.
• Responsible for creating SSAS objects like cubes and dimensions.
• Created many reports for all modules of project using SSRS.
• Established relationship between projects by providing primary key and foreign key constraints.
• Involved in creating ad-hoc reports for many business users using SSRS.
• Had little exposure with code management using TFS.
• Building the databases and deploying the changes to developers and QA server for application development and testing.
• Daily schedule of taking backups for database changes and reversing them back if any build fail occurs.
• Migration of data from MS Access to SQL Server using Integration Services (SSIS).

Environment: SQL Server 2008, T-SQL, SSRS, SSIS, SSAS, TFS, VB, ASP.NET, WPF, XAML, XML

Confidential, Springfield, Illinois

SQL BI Developer

Responsibilities:

• Involved in gathering requirement for data analysis of the application.
• Generating many reports using SSRS.
• Responsible for creating SSIS packages for integration of data from flat files.
• Created tables, functions and views for storing and managing the data.
• Involved in writing queries, joins for performance tuning the databases.
• Created cubes and packages using Integration and Analysis tool.
• Responsible for creating the schemas and maintain them for security.
• Created many reports for cubes and report management using SSRS
• Created many views to some confidential and sensitive tables for providing security to them by hiding important information.
• Involved in installation conversion support.

Environment: SQL Server 2005, SSAS, SSRS, SSIS, T-SQL, C#, ASP.NET, HTML

Confidential

SQL Server Developer

Responsibilities:

• Created and managed databases and schemas as per requirements of the organization.
• Created constraints like primary key, foreign key to implement referential integrity between tables.
• Developed tables, views and Indexes for managing huge amount of data.
• Created stored procedures for reducing the effort of application developers to access of data.
• Developed queries and sub queries for inserting, updating and managing data.
• Created and managed users by providing granting permissions on certain database objects for security of data.
• Responsible for providing support, documents and test plans for data.

Environment: SQL Server 2005, Visual Studio, C#, SQL Profiler

Confidential

SQL Developer

Responsibilities:

• Responsible for gathering requirements, analysis of the database solutions.
• Created and managed databases and database objects like tables, views and other constraints for managing database.
• Developed stored procedures and triggers for managing huge volumes of data.
• Responsible for database backup, recovery and helping support team.
• Developed many scripts to move data from files to tables.
• Involved in all phases of project with development team for improving the speed of the project.
• Responsible for developing sub queries for managing data in tables.
• Responsible for updating and refreshing data in database objects periodically for consistency with application.

Environment: SQL Server 2000, VB, SQL Profiler, HTML, Visual Studio, MS Access 2003, XML, JAVA SCRIPT