SUMMARY

• Over 7 years of professional IT experience in Database design, development, implementation, maintenance, testing and Business Intelligence of MS SQL Server 2014/2012/2008 R2/2005/2000 with various business domains like Financial/Banking, insurance, healthcare and manufacturing.
• Expertise in using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
• Excellent problem solving skills, communication, presentation and interpersonal skills.SQL Server Development
• Experience with SQL Server and T - SQL in implementing and developing Stored Procedures, Triggers, Nested Queries, Constraints, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.
• Experience with T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Excellent skills in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2012/2008R 2/2005/2000..
• Experience in SQL server Performance Tuning, SQL Server Profiler, Client/Server Connectivity, Query optimization, Back-up/Restore and running database consistency checks Using DBCC.
• Proficient in Database Normalization, designing and creating Indexes, planning and implementing server security and authentication, develop Queries and T-SQL Scripts in SSMS using Inner, outer and cross Joins.SSIS (SQL Server Integrating Services)
• Skilled in creating Jobs, Alerts, SQL Mail Agent, Database Mail, Bulk Copy (BCP), Scheduled DTS and SSIS Packages.
• Worked on Data analysis and created packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER.
• Well versed in creating SSIS packages using Active X scripts and with Error Handling
• Experience in using different types of Transformations such as Merge, Union, Conditional Split, Multi-cast, Row/column, Sort, Aggregate, Fuzzy, Look Up Transformations
• Experience in Production Database Support & Troubleshooting for all SSIS packages.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union allSSRS (SQL Server Reporting Services)
• Experienced in writing parameterized queries for generating tabular reports, formatting reports using Global Variables, Expressions, Functions, sorting the data, defining data source and subtotals for the
• Experience in migration of SSRS reports from different versions of SQL Server
• Create different types of reports, Parameter, Cascading parameterized, Drill down, Drill through, sub reports, ad-hoc, graphical, well-formatted, Matrix reports, Chart and Tabular Reports using SSRS.SSAS (SQL Server Analysis services)
• Proficient in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS 2008/2005.
• Good in developing and modifying multi-dimensional cubes and MDX scripts.Data modeling
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool and also worked on star schema, snowflake schema.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2008R2/2005/2000, MS Access 2007/2003/2000 , Oracle

Languages: C,C++, T-SQL, PL/SQL, Java .net

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Profiler,/n software, Univiewer console, Secure-FX,DTS,SSIS,SSRS.

Operating Systems: Windows 2003/2008 Server, Windows 2000/NT/XP/Vista/7, UNIX, Linux and Solaris

Scripting Languages: VBScript, JavaScript

Data Modeling Tools: ERWin 7.2, Visual Studio, SharePoint Server, Microsoft Project Server

PROFESSIONAL EXPERIENCE

Confidential, MA

SQL Server BI Developer

Responsibilities:

• Worked on Multiple projects and currently working on CCAR reporting.
• Created complex stored procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications. Configured and deployed different reports in the Servers using SQL Server Reporting Services.
• Responsible in creating extracts submitted to Federal Government every year.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Created Efficient Stored Procedures, Triggers, and Functions, Indexes, Tables, Views and other T-SQL scripts.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Developed Report Models for building customized Ad hoc reports. Played a Content Manager role on report server.
• Creating and maintaining automated jobs for database backup on a weekly basis based on the percentage used and made sure the backup is current.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL and Stored Procedures.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created complex stored procedures, cursors
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Optimized query performance by creating indexes.
• Responsible for Production Database Support & Troubleshooting for all SSIS packages in all servers
• Moved the static data from various text files to SQL Server database using BCP Import and Export, Bulk Insert.
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• Preparation of project documentation.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future .

Environment: MS SQL Server, SSIS, SSRS, Visual Studio, IIS, Windows Server, Microsoft .NET framework.

Confidential, Essex, CT

SQL Server BI Developer

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the highly efficient system.
• Worked on latest versions of all software’s like Visual Studio 2012 ultimate. Management Studio 2012.
• Monitor and tuned indexes, stored procedures and Server performance using performance monitoring tools for Microsoft SQL Server 2008 R2.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in t-SQL.
• Used SQL Server Reporting Services (SSRS) delivered enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Used Data Conversion, Lookup, Fuzzy Lookup, Derived Columns, and Condition Split, Term Extraction, Aggregate, Pivot Transformation, Merge, Multicast and Union All transformations while extracting data.
• Involved in data analysis and designed dynamic DTS and SSIS packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on various C# codes to break down the scripts that help mapping with the Data Objects.
• Monitored SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Involved in designing front end pages using C#.Net.
• Created fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.
• Used Execution Plan to Optimize and enhance the performance of SQL Queries.
• Moved the static data from various text files to SQL Server 2008 database using BCP Import and Export, Bulk Insert.
• Responsible for helping manage the daily operation of the company, meeting with clients and brokers for brokerage, holding employee meetings, resolve conflicts.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Environment: MS SQL Server R2, SSIS, SSRS, Visual Studio, Erwin 7.2, Windows 2008 Server, Microsoft .NET framework 3.5.

Confidential, Woodbury, NJ

SQL Server Developer/BI Developer

Responsibilities:

• Involve in Business requirement gathering, Technical Design Documents, Data analysis Business use cases and Data mapping.
• Extensively involved in designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.
• Responsible for logical and the physical design of the data mart for the use reporting services.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Transition a legacy data processing system (MS Access and VB.net) to a new platform using SQL and SSIS.
• Developed the Documents for Logging/Error Handling for SSIS Packages.
• Created and Modified the SQL Stored Procedures for validating the integrity of data.
• Provided data verification and tuned queries to define the requirements.
• Configured complex queries to meet the customer requirements as needed.
• Used MS VBA to create word report from Excel data migrated using SSIS.
• Created the Packages in SSIS. Worked with the SSIS for the data integration.
• Data Analysis and migrated data between databases and different servers.
• Created SSIS Packages to get the data from different sources, consolidate and merge into one single source.
• Designed and developed the packages for extracting the required data, transforming it and then exporting the data.
• Created ETL package for data conversion using various transformation tasks.
• Involved in rebuilding indexes as part of the performance tuning exercise.
• Created custom and Ad-hoc reports using SSRS.
• Created reports and added parameters to it so that users can have choice of selecting according to their wish.
• Worked on coding of several stored procedures and maintaining the integrity constraints.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Installed SQL Server Reporting Services (SSRS) and configure the reporting services configuration.
• Developed the Slowly Changing Transformation to maintain the Historical Data.
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Schedule execution of reports in report manager and send them to managers on daily and weekly basis.
• Handled the errors during data moving and Sequencing the task as per requirements.

Environment: MS SQL Server, SSIS, T-SQL, Windows Server, MS Excel, MS Access, Visual Studio 2008.

Confidential

SQL Server/SSRS

Responsibilities:

• Actively participated as a team to gather requirements along with lead, DBA and technical manager.
• Created User Defined Functions, Indexes to generate the distinct data based on the type of input supplied.
• Created SSIS packages to migrate data from heterogeneous data sources like Excel, Access, Flat files and Oracle to SQL Server.
• Implemented stored procedures to overcome transformation conflicts while migrating data from source system.
• Wrote T-SQL queries and stored procedures to perform Data Cleansing to eliminate dirty read.
• Implemented FTP task to download and uploads data files from an FTP server to local server.
• Ensured data changes in the source system by using Slowly Changing Dimension Transformation.
• Configured Send Mail Task to send the mails upon successful deployment of package using STMP.
• Deployed and scheduled packages using SQL Server Agent Job in Management Studio.
• Performed package configuration to maintain environmental variables for packages.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server/BI Reporting Services (SSRS).
• Scheduled reports on a weekly basis to generate the details of weekly calls for various locations for assessing the business for that week.
• Improved Performance of the database by creating clustered and non clustered Indexes.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Rebuilt indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency.
• Exported data from BO reports to excel sheets and MS Access database for data validations.
• Performed installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development,, QA, and production SQL Servers databases.
• Designed & developed data models and performed forward and reverse engineering using data modeling tools like ERWIN.

Environment: SQL Server 2008, T-SQL, Access, Windows 2003 Server, SQL Server Reporting Services (SSRS).

Confidential

MS SQL Server

Responsibilities:

• Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Install, tune, maintain and monitor SQL Server for the Production environment
• Created DTS package to get data from different sources, consolidate and merge into one single source.
• Created variety of reports for business to provide them with critical information about business status.
• Actively involved in Normalization & De-normalization of database.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Involved in System testing.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.

Environment: SQL Server 2005, Access 2005 & Windows 2K platform ADO.NET.