SUMMARY

• Having 9 years of SQL Server Development experience in SQL Server 2000/2005/2008/2012 with an emphasis on design, development, enhancement, automation, tuning and optimizing databases for high Availability, Performance and Security.
• Experience in using Business Intelligence tools (SSIS,SSAS,SSRS) in MS SQL Server 2008
• Extensive experience with Confidential - SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs.
• Experience in supporting web based, mission critical applications including Logical and Physical Database Design, Development, Performance Tuning and Change Management
• Experience in Performance Tuning and Query Optimization.
• Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in Replication, Clustering, Mirroring and other distributed data issues.
• Experience with SQL Server Security and SQL Server Auditing.
• Created different types of encryptions and decryptions in SQL Server as per the client requirement to secure the data and also use it in flexible ways by a group of users.
• Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SQL Server Integration Services (SSIS), BCP and DTS utility.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experience in Designing and Building the SSAS Cubes, Dimensions and data source views SSAS Data mining Models and Deploying and Processing SSAS objects.
• Experience in migrating DTS packages and reports from SQL server 2000 to SQL server 2005.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports.
• Prepared documentation for the SQL Server 2005 Replication.
• Created backups and restore of database and schedule to run.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
• Created Application sets, Applications, Dimensions, Members and Member Properties as per the requirement.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

• MS SQL Server 2005/2008R2/2012
• SSIS
• SSRS
• SSAS
• OLTP
• OLAP
• MS SQL Server Analyzer
• Transact-SQL(TSQL)
• DTS SQL Developer
• ETL
• MS Visual Studio 2008/2010
• MS SQL Enterprise Manager 2000
• Erwin4x
• Crystal Reports 8.5/9.0/10/X1
• Microsoft Products MS Word
• MS Excel
• MYSQL
• MS Access
• MS Power Point
• MS Visio
• MS SharePoint
• MS Erwin
• Azure
• Powershell
• HTML
• Java Script
• CSS

PROFESSIONAL EXPERIENCE

Confidential, Brookfield, WI

Sr SQL Server Developer

Responsibilities:

• Actively participated in interaction with users, Team lead, DBA’s, technical managers and directors to fully understand the requirements of the system.
• Performed Migration of data to upgrade in newer SQL version.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Data uploaded, manipulated, updated and maintained in Production Database.
• Data cleaned and Data validated in old database to upgrade in new Database.
• Extracted and transformed data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements.
• Wrote complex Confidential -SQL queries for data analyzing, research, unit testing and identifying and resolving bugs.
• Developed Parent - Child packages to load data, ensuring restart ability anytime without having to manually delete partially loaded data from the destination tables.
• Implemented SQL Server Service Broker (SSBS) to keep data in sync between tables across different databases.
• Created database snapshots, restored databases from snapshots in Cert environment. Migrated code, databases from DEV to QA and QA to UAT environment.
• Brilliantly playing with the Triggers.
• Administered, monitored and supported SSIS Packages and ETL process. Wrote support documentation for SSIS packages/SSRS reports and stored procedures.
• Wrote production implementation documents and provided Production support when required.
• Implemented MS SQL Server Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Maintained and updated monthly data of students and employees using and writing query and uploads it in database and forward those data to Team leaders and VIP personalities of each department.

Environment: MS SQL Server 2008R2, Confidential -SQL, SSRS/SSIS, BIDS, MS Office, MS Access, MS Excel.

Confidential, Dallas TX

Sr SQL Server Database Developer

Responsibilities:

• Designed, developed, debugged and tested SSIS packages, SSRS reports and Confidential -SQL Stored Procedures.
• Designed, modified database objects such as tables, views, indexes, Stored Procedures, defaults, user defined data types and functions
• Extracted and transformed data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements.
• Wrote ad-hoc Confidential -SQL queries for data analyzing, research, unit testing and identifying and resolving bugs.
• Implemented performance tuning Confidential -SQL queries, Stored Procedures and SSIS Packages, Peer reviewed Confidential -SQL code/SSIS packages.
• Examined execution plans, created covering indexes and filtered indexes when necessary for Tuning SQL queries.
• Developed Parent - Child packages to load data, ensuring restart ability anytime without having to manually delete partially loaded data from the destination tables.
• Performed unit integration and functional testing of the SSIS packages, Confidential -SQL and Stored procedures.
• Implemented SQL Server Service Broker (SSBS) to keep data in sync between tables across different databases.
• Created database snapshots, restored databases from snapshots in Cert environment. Migrated code, databases from DEV to QA and QA to UAT environment.
• Administered, monitored and supported SSIS Packages and ETL process. Wrote support documentation for SSIS packages/SSRS reports and stored procedures.
• Implemented data mart, facts, dimensions, snowflake schema and OLAP cubes
• Wrote production implementation documents and provided Production support when required.
• Implemented MS SQL Server Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Wrote MDX queries for OLAP cube.

Environment: MS SQL Server 2008/2008R2, Confidential -SQL, SSRS/SSIS, BIDS, MS Office, ERWIN, Pervasive database, SSBS, SSAS, Crystal report, .net, share point, PL SQL. MS Access, .Net, Visual Studio, Share-Point, C#, TFS

Confidential, Madison, WI

Sr SQL Server SSIS Developer

Responsibilities:

• Involved in the Installation and Configuration of SQL SERVER 2008 with latest service packs.
• 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 packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other Confidential -SQL code and SQL joins, Temp tables for applications.
• Used various Data Flow Transformations, like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes using the TF Dimension Merge Slowly Changing Dimension(Task Factory Tool)
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output by TF Error Output Description(Task Factory Tool)
• Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.
• Identifying the mapping issues and discussing them with business analysts in team.
• Handled the database components (Code migration, Change control) for application releases.
• Creates technical specifications, test plans and test data to support ETL processes. Creating and Fixing the Bugs and change requests.
• Involved in business requirement gathering and created functional/technical specification documents and Publishing to SharePoint.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Created SQL scripts for tuning and scheduling.
• Involved in performing data conversions from flat files into a normalized database structure.
• Created a Configuration file, for successful execution of package on any machine and on the server.
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Created Reports on the Performance of the Packages level and deployed the report into SharePoint using SharePoint Destination.
• Identify and map fields to ensure proper data flow to the tables.
• Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s
• Created technical specifications, test plans and test data to support ETL processes.
• Created Bulk Test plans and test cases and executed them in the test Environment and Had hands on Experience on Test manager tool (2010)
• Wrote queries for drill down reports to get the dataset required to build the report.
• Formatted the reports using Global variables and expressions.
• Deployed generated reports onto the Report Server to access it through browser.
• Maintained data integrity by performing validation checks.

Environment: Confidential -SQL, PL/SQL, MS SQL Server 2008 R2/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS),Team foundation server (TFS)2010, Windows XP, Erwin and Visio, Microsoft Office SharePoint Server.

Confidential, Somerset, NJ

SQL Server SSIS Developer

Responsibilities:

• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed Query for generating drill down, drill through, sub reports, URL reports and dashboard reports in SSRS 2008.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008
• Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2008
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2008.
• Extensively worked withSSIStool suite likeConditional Split,Lookup,MulticastandDerived Column.
• Migrated data from MYSQL to SQL server, synchronizing converted data to SQL server.
• Developed several Tables, Stored Procedures, functions and views to load data from the SQL server.
• Working very closely with other developers for their SQL requirements, work with Business Analyst and end users to understand the report requirements.
• Performance Tuning already existing queries to improve the query time for faster reports.
• Following Data Warehousing methodologies and concepts, including Star schemas, snowflakes, dimensional modeling.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Experience in data migration from old databases and different databases to main database
• Experience in using Open Query while getting data from different Databases such as Oracle, SQL Server in same query
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in Implementation of database design and administration of SQL based database.
• Wrote Confidential -SQL procedures to generate scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in Confidential -SQL for various needs of the transformations while loading the data.
• Created Stored Procedures, Triggers and Audit Tables, Views and SQL Joins and other statements for various applications.
• Analyzed and tuned complex Queries, Stored Procedures in SQL Server 2008 for faster execution and developed database structures.

Environment: MS SQL Server 2008R2, SQL server Reporting Services (SSRS) 2008R2, MS SQL Server Integration Services, MS SQL Server Analysis Services, MYSQL, MS Visual Studio 2008/2010.

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements from users and business analysts and created requirement documents.
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks
• Worked on analyzing and Performance tuning queries by looking Confidential the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Expert in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
• Worked on SSRS 2005/2000 to generate about 30+ reports for various user groups and developer groups.
• Created stored procedures to use as the datasets for the Report Design.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports
• Extensively worked on Report coding to behave according to the front end CRM Application.
• Configured Subscriptions and Security for all critical reports.
• Handled the database components (Code migration, Change control) for application releases.
• Creates technical specifications, test plans and test data to support ETL processes
• Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server
• Involved in Database Administration activities like Back up, Security, Migrations in the Development servers

Environment: MS SQL Server 2000/2005, SQL Server 2005 Analysis Services (SSAS), Reporting Services (SSRS 2000/2005, Microsoft Visual Studio 2005, BIDS, Visual SourceSafe, MSOffice, HTML, VBScript, Erwin and Visio.