SUMMARY

• Over 7 Years of experience as SQL Developer in MS SQL Server 2008/2005/2000 Development environment in Financial, Insurance & Telecom industries.
• Experience in MS - SSIS, SSAS, SSRS, OLTP, OLAP and Data Migration, Flat file using DTS, SSIS and other ETL Tools.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS and BCP.
• Experience in creating Test cases document (Uploaded to share point) for ETL and tested ETL packages and involved for integration testing, UAT testing, regression testing, System testing.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, linked reports, Snapshot, Cached, Ad hoc reports using SSRS.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008/2005 Analysis Services.
• Experience in SQL Server Analysis Services (SSAS) in SQL Server 2008/2005.
• Expertise in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• In-depth knowledge of T-SQL (DDL, DML and DCL) queries, Stored Procedures, User Defined Functions (UDF's), CTE’s, Database Triggers and Exception Handlers.
• Excellent in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Broad experience in Query Optimization and performance tuning of stored procedures, Functions etc.
• Experience in installation, up gradation and configuration for various version of MS SQL Servers.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Expert in activities including Updating Statistics, Re-building and Re-organizing Indexes.
• Experience in Microsoft .NET technologies in using Visual Studio.NET, C#.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Experience in working with a SQL Server 2008 Facets.
• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.

TECHNICAL SKILLS

Operating Systems: Windows 7/vista/XP/2003/2000/NT4.0, Macintosh.

RDBMS: MS SQL Server 2008/2005/2000 , MS Access 2007/2003.

Languages: T-SQL, MDX, C, VB.NET, C# (.NET).

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligence Development Studio (BIDS), SSISCrystal Reports9.0, Visual SourceSafe6.0.

Designing Tools: MS Visual Studio and MS Visio.

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS).

Application Packages: MS Office 10/07/03

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

SQL Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Created objects like table, complex stored procedure, view, UDF, Cursor, DML and DDL Trigger based on the requirement using T-SQL programming.
• Being part of Point Solutions group, involved in extensive troubleshooting of the existing SQL code and stored procedures.
• Experience in tasks involving collaborative effort and working with Cold fusion developers.
• Involved in the database design to support the role-based access to Nucleus pages.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Updated the already existed stored procedures and created new stored procedures based on the new requirements.
• Applying Query optimization techniques & tuning the query by creating indexes to improve the Query & System performance.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Responsible for Testing and Debugging the Stored Procedure, SQL Scripts, SSIS package and Reports.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, SQL 2005)
• Used For-Each Loop Container, Sequence Container, VB Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business requirement.
• Provided Dynamic Configuration, Custom Package Logging, Error Handling, and Notification to SSIS template package.
• Created and managed versions of manifests and the deployment of the code to all the environments.
• Created multiple reports using SSRS in Drill mode using tables, financial tables, crosses tabs and charts.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Worked in on site/ off shore environment; coordinated my activities by proactively communicating with my counterparts in the off shore team and working closely with my manager.
• Created unit test cases and worked with the QA team in designing the test cases and testing of the migrated code.

Environment: MS SQL Server 2005/2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual studio(C#, ASP.NET), ColdFusion, SQL Server Analysis Services (SSAS), SQL Server CE client, MS Access, Windows XP.

Confidential, Westchester, IL

SQL BI Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed various T-SQL stored procedures, triggers, views, and adding/altering tables for data extraction, data load and transformations.
• Developed SQL Queries to fetch complex data from different tables in remote databases by using joins, database links and formatted the results into reports and kept logs.
• Dynamically supported business users for given requirements and developed the reports accordingly.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created checkpoints and configuration files in SSIS packages, Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Generated various reports with drilldowns, calculated members and dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created data sources, connection strings and defined the datasets for generating the report.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Migrated Crystal reports to SSRS reports.

Environment: MS SQL Server 2005/2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual studio(C#, ASP.NET), SQL Server Analysis Services (SSAS), SQL Server CE client, MS Excel, MS Access, Crystal Reports, Windows XP.

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

• Administration of Clustered MS SQL 2000/2005 servers in 24 x 7 Windows data center environment.
• Installation and configuration of SQL Server 2000/2005 components all editions.
• Knowledge on security expressions.
• SQL Server 2005 experience with Schema design, Replication, Partitioning, Query optimization, Disaster recovery, Service Broker.
• Designing and testing of Backups and Recovery strategies in 2000/2005.
• Managing SQL databases from, Created Mirroring for Production Databases Security, fine tuning of SQL queries, troubleshooting.
• Created transactional and merge replication on different servers. Log Shipping for hot standby computers.
• Designing and managing SQL Loader and Worked close with Oracle DB and Team.
• Developing SQL stored procedures, views and triggers.
• Designing, testing and implementing of DTS/SSIS packages and synchronizing with Oracle database. Responsible to releases from development to test to production environments.

Environment: Windows 2000 (Advanced Server) and Enterprise Server 2003, MS SQL Server 2000/2005

Confidential, San Francisco, CA

SQL BI Developer

Responsibilities:

• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Importing the data from different departments using SSIS to create reports.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created Perspectives of the cube to simplify the process of browsing for the end users.
• Used MDX to create calculated members in the cube.
• Expertise in solving errors occurs in report generating.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Migration of an MS Access application to SQL Server 2005.

Environment: MS SQL Server 2005, Windows 2003, SSIS, SSRS, SQL Server Management Studio, BIDS, MSIIS, MDX, MS Access 2003,VB.NET, C# VISUAL STUDIO, SQL Profiler.

Confidential, Torrance, CA

SQL BI Developer

Responsibilities:

• Analyzed specifications provided by the client.
• Monitored the data warehouse system to maintain periodic data.
• Developed SQL queries to Insert, Update and Delete data in Database.
• Used Temporary tables, Table variablesandCommon Table Expressions (CTE)depending on the requirement.
• Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules usingT-SQL.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Worked onPerformance tuning,query optimizationandexecution planof queries for better performance.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Flat file, Excel, Oracle.
• Implemented the concepts ofIncremental Data Load, Slowly Changing Dimensionsfor updating and maintaining the history of the records.
• Conducted and automated theETLoperations toExtractdata from multiple data sources, transforminconsistent and missing data to consistent and reliable data, and finallyloadit into theMulti-dimensional data warehouse.
• Extensively used SSIS forTransformations, Aggregations and Lookups.
• Defined Relationships betweenDimensions and Measure Groupslike Fact Relationship,Many-to-Many Relationship, and Dimension Granularity within a Measure Group.
• Designed and DevelopedKPIs, Aggregations and Cube Partitions.
• Generated Named calculations and named queries.
• Deployment of Cubes to the production server.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.

Environment: SQL Server 2005, SSIS, SSAS, SSRS, Windows Server 2003, C#, MS Access 2003, SQL Profiler.

Confidential

SQL Developer

Responsibilities:

• Defined Check constraints, Business Rules, Indexes, and Views.
• Migration of data from text files to SQL Server 2000 using BCP and DTS packages.
• Wrote DTS packages to move data between production, staging and QA environment.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Fine- tuned Procedures, Functions and Triggers for optimum performance.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering
• SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: Windows 2000, MS SQL Server 2000, TSQL, MS access, VB script

Confidential

Software Programmer

Responsibilities:

• I was involved in designing, developing, coding, debugging and testing application.
• I developed all the help screens in this application. The help files were in the form of html and java script applications designed using Dream weaver.
• I developed the database, created tables, joins in Ms-access. I was involved in testing this application.
• Trained the Top Level Officials in learning Office related computer skills.
• Manually tested the forms and database for functionality
• Coding Front and Back end and control screens
• Coding server side scripts Unit testing.
• Write database connecting code and SQL queries to communicate with MS-Access database to access the user details and update the database with the new user requirements.
• Responsible for maintenance of database on server. Backup & Restore of database
• Involved in manual testing at different stages of the project

Environment: C#, SQL Server 2000, Visual Basic 6.0 and Windows NT