SUMMARY

• Eight+ years of experience in Database Design, Programming, Development and Database systems using Microsoft MSSQL 2012/2008/2005.
• Highly proficient in the use of T - SQL and PL/SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Expert in using tools such as Bulk Copy Process (BCP).
• Experienced in designing and developing SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Experience in Data Conversion, Normalization and Data Modeling, and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin tool.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using SQL Server Reporting Services (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in using tools like MS SQL Server Profiler, Index Tuning Wizard, and Windows Performance for monitoring and tuning SQL Server performance.
• Experience in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Hands-On experience in Big Data related technologies, HDFS, Hive, and Beeline.
• Developed Tableau data visualization using Geographic Map, Pie Charts and Bar Charts.
• Experience in Software Development Life Cycle (SDLC) and implementation of Client/Server and Web-based N-tier applications using .NET, ASP.NET, ADO.NET, and C#.
• Experienced in using Agile methodology (Scrum)
• Experience in using Subversion (SVN), Microsoft Visual SourceSafe and Team Foundation Server for Source Code Controlling.
• Expertise in analyzing and interpreting business requirements and formulating functional specifications.

TECHNICAL SKILLS

Operating Systems: Windows - 95, 98, XP, Vista, 7,8.1, UNIX

Databases: MS SQL Server 2005/2008/2008 R2, Oracle 10g, 11g.

Big Data Technologies: Hive, Beeline, HDFS

SQL Server Tools: SQL Server Management Studio (SSMS), Query Analyzer, SQL Server Profiler, Performance Monitor, Index Tuning Wizard.

ETL Tools: SQL Server Integration Services (SSIS), DTS

BI Tools: SQL Server Analysis Services (SSAS), Tableau

Data Modeling: Erwin, FACT and Dimensions Table Modeling.

Reporting Tools: SQL Server Reporting Services (SSRS)

Languages: SQL, T-SQL, Dynamic SQL, C#\VC#

Web Technologies: .NET, ASP.NET, ADO.NET, Visual Studio 2005/2008/2010 , XML

Source Control Software: Visual Source Safe and Team Foundation Server

Application Software: Microsoft Excel, Visio, Word, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, NYC

Sr. SQL Developer/Analyst

Responsibilities:

• Involved in database designing and created different database objects, such as tables, stored procedures, triggers, functions, and views.
• Created ER diagrams as per the design requirements of the business.
• Worked on Indexes and constraints to optimize the database performance.
• Used joins and sub queries to write complex TSQL code with in stored procedures.
• Merge the tables into one in case of similar data using UNION ALL query using TSQL.
• Used Import Export Wizard in SSMS to read data from Excel or CSV file and extract into the SQL Server Database.
• Created SSIS packages to retrieve data from different business sources, retrieve user data from the Flat files on monthly and weekly basis, file Transfer from one location to the other using FTP task.
• Created complexSSISpackages using appropriate control and data flow elements withSSIS Standards like error handling, logging and working with package config files.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Used Tableau Visualizations like Bar Graphs, Pie-Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Used SVN for versioning and source control of the documents.
• Lead the team members in guiding the business related information and explaining the project.

Environment: SQL Server 2008, TSQL, SSIS, SSRS, Tableau, SVN, MS Excel, Word

Confidential, NJ

SQL Developer

Responsibilities:

• Analyzed, designed, developed, and maintained the application by gathering client requirement and mapping it to the expected result.
• Used SQL Joins, Built-In functions such as char index, substring to create the complex stored procedures.
• Used Dynamic SQL in a Stored Procedure to manipulate the data in multiple tables irrespective of the number of columns.
• Generated Scripts with the data to take the backup of the various database objects.
• Used Import Export Wizard of SQL Server to read the data from the flat file and write to the database table.
• Created SSIS Packages for ETL using Fuzzy Lookup, Condition Split, Term extraction, Aggregate, Slowly Changing Dimension, Execute SQL Task, and Data Flow Task to generate underlying data for the reports and to export cleaned data from OLTP System, Excel Spreadsheets, Text file, and CSV files to SQL Server.
• Generated Drill down, Drill through, parameterized reports using SSRS.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Designed and implemented tables, functions, stored procedures and triggers to implement the business logic as required by the client.
• Used SQL Profiler to trace the activities of stored procedures and performance tuning them thereafter.
• Created views and triggers for the quick access of the data and logging the activities performed on the tables.
• Used Instead of trigger to update data in multiple tables through views.
• Used Merge statement to insert, update, and delete the data in the tables.
• Used Agile Methodology (scrum) during the development of the project. Weekly tasks were assigned.
• Created a template for dynamic grid view with the Insert, Edit, and Delete functionality.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys..
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Tested, debugged, fixed, and reviewed various modules and functions in the application.
• Developed Unit Test Cases for different modules in the application to check the functionality of each component.
• Created technical and understanding document to analyze and ensure the design is in compliance with the client requirement
• Provided production support to help users by giving ad hoc solutions.

Environment: SQL Server 2008 R2, SSIS, SSRS, SSAS, PL/SQL, Visual Studio 2010, .NET Framework 4.0, ASP.NET 4.0, C#, ADO.NET, Agile, TFS.

Confidential, Pennington, NJ

SQL Server Developer

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation and maintenance.
• Create and Maintain database structure and objects, such as Tables, Stored Procedures, User- Defined Functions.
• Used SQL Joins, sub queries, and SQL in-built functions for creating complex Stored Procedure.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values which are used in various components of Data Flow Task.
• Implemented Change Data Capture Functionality using System Variables and system Stored Procedures
• Created tabular, matrix, chart, drilldown reports, parametric, and cascaded reports according to the business requirements.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Worked as a DBA with the Team lead to deploy the packages, creating backups and restoring backups, deploying scripts on the Production server.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Involved created Database Maintenance Plan for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created and Managed OLAP Cubes using SSAS.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
• Perform data partitioning for terabyte size databases with tables consisting of more than 200 million rows.

Environment: SQL Server 2008R2, SQL Server Management Studio, Server Integration Services, SQL Server Reporting Service, SSAS, T-SQL, Microsoft Visual Studio, MS Excel, C#.

Confidential

Program Analyst

Responsibilities:

• Worked on the complete life cycle of the project from design to implementation
• Translated user requirements into functional and technical requirements in coordination with the Sr. Business Analyst
• Executed Store Procedures using ADO.NET.
• Analyzed the business requirement and functional specifications provided by the data specialist
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Migrated few Oracle sources to SQL server development environment.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.
• Used SSIS Variables for storing the values which are used in various components of Data Flow Task.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis
• Documented the complete data warehouse environment, including all dimension and fact tables, the relationship between SSIS packages and the target tables, which packages were valid and in use, the relationship between the jobs and SSIS packages.
• Designed and maintained a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Accountable for making sure reports are scheduled and delivered in a timely manner.
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Created ad Hoc and parameterized various reports using SQL server 2008R2 reporting Services with data from SQL Server and MS Access as data sources
• Created ad hoc SSRS reports in the test environment for data validation
• Produced dynamic Reports from the cube using SSRS 2008R2, and stored procedures.
• Troubleshoot the deployment of reports in the test and production environment using SSRS.
• Cleaned the data and created fact and dimension tables, performed calculations required for the reports using SQL Server 2008R2 environment and accomplished data modeling.
• Maintained files in TFS as per weekly sprints.
• Interacted with the client to understand the business requirement.
• Created and altered Database table structures.
• Created and Modified stored procedures, views, and user defined functions using SQL Server.
• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Designed and developed the Client and Member module including writing, retrieving, editing data using ASP.NET and ADO.NET.
• Fixed the bugs and unit tested the application for periodic reviews.

Environment: Windows 7, SQL Server 2005, 2008, SSIS, SSRS, Visual Studio 2008, .NET Framework 3.5 and 2.0, ADO.NET, VC#.

Confidential

Software Engineer (SQL Developer)

Responsibilities:

• Involved in Installing SQL Server 2005 with latest service pack.
• Extensively worked in creating Database, database objects such as view, table, stored procedure, trigger and function using T-SQL.
• Performance tuning of stored procedure.
• Wrote complex Join queries using T-SQL.
• Created SSIS Packages to integrate the Business Logic and Data Transformations
• Transformed data using SSIS packages, BCP utility and Bulk Insert statement.
• Created and saved SSIS package according to requirements.
• Performance tuning of server and gave suggestion to senior developer.
• Produced and managed index.
• Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
• Monitoring the application and database performance using SQL Server Profiler and Performance Monitor
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Designed Database Maintenance Plans for Database Backups, Re-indexing and Data Integrity Checks
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
• Wrote Windows Admin Scripts to monitor Disk and Tape Backups, Disk Space and Service Status for different servers and generate alerts.
• Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations.
• Designed Triggers to monitor activities on server as well as database and generate alerts and notifications.
• Wrote Stored Procedures, User-Defined Functions, Ad-hoc Scripts and Cursors on Development and Test servers for pre-deployment testing.

Environment: MS SQL Server 2005, Enterprise Manager, Query Analyzer, and System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, T-SQL, Windows 2003/2000 server.

Confidential

Development Executive

Responsibilities:

• Performed validation and quality control checks of SQL programs.
• Wrote T-SQL queries and T-SQL stored procedures.
• Added / Changed Tables, columns, triggers, and T-SQL code.
• Using Indexes, Views, Trigger and Store Procedures for updating and cleaning the existing data and also the new data which was to be added.
• Configured complex SQL queries to meet customer requirements as needed.
• As a DBA managed the backup and recovery of the team.
• Used DBCC utilities to fix data corruption in application databases
• Provided data verification and tuned queries to define the requirements.
• Developed custom reports for contact management information system.
• Scheduled jobs, database backup, and database restore.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Created complex reports using cascading prompts, decode objects etc.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

Environment: SQL Server 2005, Windows XP, Query Analyzer, Enterprise Manager, Erwin, Data Transformation Services (DTS).