SUMMARY

• Around 7 plus years of experience in Database Development of MS SQL Servers 2000/2005/2008, in Production, QA, and Development environments.
• Extensive experience in MS SQL Server 2008 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services
• Very good understanding of SQL Server Architecture design.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions.
• Experience in Creating SSIS and DTS package development and implementation for different tasks.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expert in creating SQL Server Reports using SSRS 2005 in designing stylish report layout parameterized, performance, Chart Reports, ad - hoc reports.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Experience in report writing according to the business requirement in SSRS.
• Very strong experience in ad-hoc reports, Tabular and Charts reports in SSRS.
• Experienced in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts
• Familiar with OLAP cubes and fact table, star and snowflake schemas
• Using Data Mining Wizard and Designer to Design, Manipulate models.
• Strong experience in design and construction of data marts, data views and data mining.
• Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Experience in backup and disaster recovery procedures.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Used Microsoft Source Safe for version control and configuration management.
• Strong communication skills and ability to work in a team and individually.

TECHNICAL SKILLS

Platforms: Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/Vista, Linux, UNIX

Languages: C, C++, T-SQL, PL/SQL, VB, C#.NET, ADO.NET, JAVA

RDBMS: Microsoft SQL Server 2000/2005, MS Access, Oracle 10g

IDE: Microsoft Visual Studio 2003/2005

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, Export & Import (DTS), SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Web Technologies: HTML, JavaScript, PHP, ASP.NET, ColdFusion

Other Tools: ERwin, MS Visual SourceSafe, VERITAS Backup Exec 10, MS Office suite, MS Visio, SPSS

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

SQL Server Developer

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Involved in Report writing according to business requirment using SSRS and Crystal Reports.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Worked on .Net data access layer and ADO.Net and developed various clauses to connect to database with the front end pages.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configure the report server and generated the report models for user interactions.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Developed unit test plans for SSIS packages.
• Involved in migrating data from MS SQL server 2005 database to MS SQL server 2008 database.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Hands on experience in SSAS (SQL Server Analysis Service) with MDX.
• Created calculated measures and dimension members using Multi Dimensional Expressions (MDX).
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS)
• Created MDX queries to extract data from the data mart.
• Involved in building an extensive OLAP data warehouse on SQL Analysis services (Cubes, stars schema)
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2008.
• Generated Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using stored procedures that accept parameters.
• Responsible for monitoring and tuning SSRS Report Performance.
• Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Fine tuned the complex database stored procedures and increase performance up to 5%.
• Taking weekly database backup and schedules job using SQL Agent.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

Environment: MS SQL Server 2005/2008, Management Studio, ETL, DTS, Erwin, Oracle 10g, Notification Services, Crystal Reports, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSAS, SSIS, SSRS, community server, Erwin.

Confidential

SQL Server BI/SSAS Developer

Responsibilities:

• Provided recommendations and guidelines for development of ETL, Analytical & Decision Support system based on SQL Database Warehousing using presentations, demos and meetings.
• Involved in Logical and physical design of the data warehouse and ODS in SQL Server 2008 using Star Schema.
• Responsible for Data mapping document: Source/Transformation/Destination.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Loading data from various sources like Excel, flat files to SQL Server database Using SSIS Packages.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Involved in taking backups of SSAS database and restoring them when needed.
• Worked on SQL Server Analysis Service and participated in creation of Dimensions, Cubes and Partitions on Cubes, Develop KPIs and Calculations for various Measures.
• Helped in creating new component in SSIS called Partition Tasks that creates partitions for the Cubes and drops partitions based on some criteria.
• Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS which involves nightly maintenance.
• Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers, Execute SQL Task and lot more using SSIS.
• Designed dynamic reports on the newly developed ERM Model for financial data users using SSRS.
• Involved in Performance tuning the SQL Server Queries used in SSRS Report and also used Report Snapshots for better performance.
• Worked with SSRS module to request data from output tables, design of report templates, use of bar and pie charts, drill-down and drill-through reports, use of parameters, global variables and functions to generate final reports.
• Created user groups in Report Manager for limited access to the end users in SSRS.
• Developed Ad Hoc Report Model for specific users is SSRS.
• In SSAS, created cubes on top of the data warehouse for reporting purpose and wrote MDX.
• Created calculated measures in a cube by using MDX scripting and worked on slowly changing dimensions.
• Created multiple Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements with various security standard.
• Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSRS, SSIS, T-SQL, SSRS, Windows Server 2008, Oracle 10g..

Confidential (Houston, TX)

SQL Server Developer Contract

Responsibilities:

• Installed and Configured SQL server 2005 on windows 2003 advance server system.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user .
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and DHTML.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Involved in Report writing according to business requirement using SSRS and Crystal Reports.
• Used the Report Manager to Create folder structures, modify data sources, Controlling access to Report Services resources
• Optimized query performance by creating indexes.
• Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Provided support to the application developers on the application databases.
• Configured and Deployed different reports in the Servers using SQL Server 2005 Reporting Services.

Environment: MS SQL Server 2005, Enterprise Manager, Management Studio, Integration Services, Reporting Services, SSRS, T-SQL, DB2, Windows 2003, Tuning Advisor, ETL, SQL Profiler, SQL Server Agent, Data ware Housing, BCP, and Visual Basic 6.0.

Confidential (Framingham, MA)

SQL Server Developer (SSIS/SSRS/ASP.Net) Contract

Responsibilities:

• Designed and developed several Reports using SSRS (SQL 2005 reporting services) according to business requirements.
• Creating complex SQL Queries to partition and aggregate the data based on cookie and session ids of millions of visitors.
• Creation of temporary tables, efficient index mechanisms and optimizing joins to match the performance expectations of the system.
• Multiple stored procedures with transaction processing for different modules.
• Creation of tables, mapping of page ids to the product line categories and the sources of information.
• Creation of SSIS packages to request a dump of weekly page views from Staples databases to our databases.
• I worked on authenticating users and providing on-demand reports using server-side scripting with ASP.Net (VB Script). It involved connecting to database, calling queries and stored procedures, displaying forms and tables and implementing means for navigation to different reports.
• Identified the data source and defined them to build the data source views.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta loads.
• Created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
• Designed and created drill down reports in SSRS 2005.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically on weekly or monthly bases using SSRS 2005.
• SSRS module to request data from output tables, design of report templates, use of bar and pie charts, drill-down and drill-through reports, use of parameters, global variables and functions to generate final reports.
• Designed ad-hoc reports using Report Model and configured using Report Manager.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Windows XP

Confidential

SQL Server/Application Developer Contract

Responsibilities:

• Involved in Data modeling to develop the database design using Erwin 4.0
• Involved in requirement gathering, analysis, design, development, change management, deployment and user .
• Actively involved in Normalization & De-normalization of database.
• Designed DDL and DML for MS SQL Server 2000.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and involved in performance tuning of T SQL queries and stored Procedures.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Configuring, tuning, and optimizing SQL Server 2000.
• Developed complex financial reports using Crystal reports.

Environment: SQL Server 2000/7.0, T-SQL, Stored Procedures, Windows XP, Crystal Reports 9, ASP.NET 1.1, IIS3.0.

Confidential

Software Engineer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user .
• Perform quality assurance and testing of SQL server environment.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Provide database coding to support business application with T-sql.
• Participated and trained in designing of website using .net application for clients.
• Supported developer team and DBA in Configuring replication, tuning, and optimizing SQL Server 2000.

Environment: SQL Server 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, T-SQL, BCP, Replication.