SUMMARY

• Over 9 years of strong IT experience as a MS SQL Server Developer 2008/2005/2000 in various Industry verticals like Finance, Insurance, Pharmacy, Law, Cosmetics and Education.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2008 R2/2005/2000, Business Intelligence in SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server enterprises manager.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for SQL Server/Oracle/Sybase databases.
• Expert in creating MOLAP Warehouse on SQL 2005 Server Analysis Services and created multiple cubes with dimensions and facts.
• Excellent experience in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
• Highly experienced in optimizing MOLAP Cubes by partitioning them, Designing Aggregations, Implementing Hierarchies and Calculated Members.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS 2005/2008and Created Calculate member in MOLAP cube in SSAS 2005/2008.
• Strong experience in designing and developing more than 100+ enterprise reports(SSRS/Business Objects) using the data from ETL, SSAS Cubes and various heterogeneous Data Sources.
• Highly experienced in writing Parameterized Queries for generating Tabular Reports, Formatting Report Layout, Sub Reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Expert in using Visual Studio 2008/2005/2000 to generateclient side reports, tabular reports, matrix reports, drill down reports, parameterized reports, ad-hoc reports, and stylish reports usingSQL ServerReporting Services (SSRS).
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

• MS SQL Server 2008/2008R2/2005/2000
• MS SSRS
• SSAS and SSIS 2005/2008
• DTS
• Erwin Designer 2000
• DB2 SQL syntax
• MS-Access 2000
• VB 6.0
• Developer 2000
• ERWIN 4.0/4.1/4.2
• Oracle 9i
• T-SQL
• PL/SQL
• ASP.NET
• VB.Net
• XML
• VB Script
• Visual Studio 2005/2008
• Crystal Reports
• ODBC
• MS Office
• Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE

Confidential, DE

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created new Stored Procedures, Functions and Triggers using T-SQL to migrate the data from various tables as well as various databases
• Created complex views by joining more than 20 tables from different SQL instances using Linked Server
• Involved in migration of data from main frame server to SQL Server database using Target Adapter.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables with star schema and snow flake schema for analysis purposes using SQL Server Analysis Services (SSAS) 2008/2005.
• OptimizedMOLAP Cubes by partitioning them, Designing Aggregations, Implementing Hierarchies and Calculated Members.
• Implemented Key Performance Indicator (KPI) Objects in SSAS 2005 and Created Calculate member in MOLAP cube in SSAS 2008/2005.
• Created reports for students’ higher education enrollment statistics to provide number and percentage of students enrollment by their sub groups (like race, gender, special ed. Etc.) using SSRS from the OLAP cube.
• Created various reports (like matrix, tabular, chart, and list) with drill down, drill through, parameterized reports using SSRS and deployed them to the server.
• Established security and roles on the reports for various users.
• Published the reports on the web and scheduled the reports in different formats (Email, Public folder etc.)
• Documented the Stored Procedures, User Defined Functions (UDF) and MDX queries for future references and maintenance.
• Created new data mart for the university based on their requirements. Then created .txt files from tables’ data records using SSIS 2008.
• Encrypted .txt files for the security stand point and transferred them using FTP site to the client.
• Created reports that included formatting options such as Grouping, Sorting, Parameter prompts.
• Created a stored procedure to automate the execution of all the stored procedures and to schedule the jobs.
• Created reports using COGNOS BI with an ability to drill down into details

Confidential, Berkley Heights, NJ

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Have performed the team supervision (Team Lead) in the absence of project manager more than two times and had completed the task successfully.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency using SQL Server 2005/2008 R2
• Documented the Stored Procedures and User Defined Functions (UDF) for future references and maintenance.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Warehouse. Developed, deployed and monitored SSIS Packages
• Creating SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package.
• Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.
• Create OLAP cubes with SSAS based on multidimensional database with star schema or snow flake schema
• Extensive experience using Data Mining tools in Microsoft Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created several MDX queries according to business requirements.
• Created MDX script for representing Cube Calculation using SSAS.
• Responsible for General Database Administration and Performance tuning.

Confidential, Newark, NJ

Sr. SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created Stored Procedures, Functions and Triggers using T-SQL to migrate the data.
• Created SSIS packages to clean the incoming data including address and to find out if the address is valid or not.
• Performed data analysis and designed source to destination mapping.
• Involved in migration of data from main frame server to SQL Server database using Target Adapter.
• Used try-catch block to handle the errors globally and to store all the errors in a table to handle them later and to continue the flow of execution.
• Designed and developed Matrix and Tabular reports with Drill Down, Drill Through, Parameterized, Sub Reports and Drop down menu option using SSRS 2005 and 2008.
• Developed reports with Charts and Multiple Datasets using Reporting Services (SSRS).
• Created reports that included formatting options such as Grouping, Sorting, Parameter prompts.
• Created a stored procedure to automate the execution of all the stored procedures and to schedule the jobs.
• Used web services to use the service provided by many applications to clean and verify the incoming addresses.
• Installed SQL Server, applied service packs and hot fixes.
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta load.
• Created a Log tables to capture the SSIS events and used it to Perform Debugging of packages.
• Created and scheduled a SSIS package to run our stored procedures to create the output report tables and regenerate reports automatically
• Performed tasks like Backup, Restore, Data Profiling using SQL Server 2008R2 tools like SQL Server Management Studio, SQL Server Profiler and SQL Server agent.
• Created .Net windows application to display all the data from different tables in grid view based on the search.
• Used Merge Join extensively to load the data from production database to operational database and to perform basic de duplication.

Confidential, Atlanta, GA

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Created/modified SQL Joins, sub-queries, and other T-SQL and SQL code to implement business rules.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
• Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server 2008.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2008.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008.
• Involved in setting up and implementation of the 2008 reporting server.
• Created complex reports using SSRS 2008 from the OLAP cubes for end user analysis.
• Migrated reports from MS SQL Server Reporting Services 2000 to 2008.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.
• Ran and tested required queries and reports before publishing.
• Published the reports and scheduled the reports in different formats (Email, Public folder etc).
• Scheduled the reports on capacity levels of different servers to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Scheduled tasks to run every day to update changes in the base tables.
• Added/modified Users, Groups, folders and rights.

Confidential, Addison, TX

MS SQL Server Developer / BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL, DML) statements using dynamically generated SQL.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2005.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2005.
• Generated daily, weekly and monthly reports using SSRS 2005.
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Developed MDX for cube calculations and KPIs.
• Implemented the calculations to aggregate physical measures using management studio.
• Defined Referenced relationships with the measure groups and fact tables.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instances of Analysis Services.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used SQL Profiler to identify and repair database lockups, deadlocks, and other issues.

Confidential, New York, NY

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
• Installed MS SQL Server 2005 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server 2005.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005).
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2005.
• Involved in setting up and implementation of the 20085reporting server.
• Created complex reports using SSRS 2005 from the OLAP cubes for end user analysis.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2005 using data from a variety of sources.
• Ran and tested required queries and reports before publishing.
• Published the reports and scheduled the reports in different formats (Email,Public,folder)
• Scheduled the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.
• Created a number of complex formulas to find the capacity levels of different servers.
• Scheduled tasks to run every day to update changes in the base tables.

Confidential, Irving, TX

MS SQL Server Developer

Responsibilities:

• Worked with MS SQL Server 2000, MS Access Databases using DTS, T-SQL, Stored Procedures and Views.
• Logical and physical database development using Erwin, Normalization, and Enterprise Manager. Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Created and automated regular Jobs such as Daily/Weekly Report Generations using crystal reports.
• Developed complex T-SQL code for the application.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Migration of the data from text files to SQL Server database using BCP and DTS packages for the processing of different policies.

Confidential

MS SQL Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases 2000.
• 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.
• Managed rollback segments, and table spaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.