SUMMARY

• Business Intelligence professional with 7+ years of experience in Data Modeling, Database Design, Data Warehousing, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Highly proficient in generating complex Transact SQL (T-SQL)queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc., for developing and debugging complex stored procedures, triggers, user-defined functions, user profiles, relational database models, Common table expressions (CTEs) and data integrity, SQL joins and query writing.
• Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading. Also multi-dimensional schema concepts (Star Schema and Snowflake Schema).
• Expert in Database Normalization,De-Normalization,Optimization and Tuning, Data Import/Export, Trouble shooting and Database Objects authorization.
• Proven ability in Performance Tuning, Query Optimization and running Database using indexes.
• Worked on administration tasks such as SQL Server Replication, data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations.
• Developed Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) with various control flow, data flowtasks and stored procedures for work order validation process.
• Skilled in developing reports from SQL Server Analysis Services(SSAS) Cubes and OLAP Data source using SQL Server reporting Services (SSRS).
• Extensive experience indesigning and generating reports using SQL Server Reporting Services (SSRS) and Excel Pivot table which make use of multiple value selection in parameters pick list, matrix, dynamic reports and other features of reporting service.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Experience in developing Charts and other visualization using Tableau.
• Experienced in creating Jobs, Alertsand SQL Mail Agent.
• Organized professional with excellent communication and coordination skills, Documentation Skills, Team problem solving ability, analytical and programming skills in high speed, quality conscious, Multitasked environment.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2000/2005/2008/2012/2014, MS ACCESS

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development Studio, Visual Studio, Configuration Manager, SQL Server Profiler, SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, FACT& Dimensions tables, Talend Enterprise Data Integration,Import/ export wizard, Bulk Insert, BCP.

BI Tools: SSIS, SSAS, SSRS, Crystal Reports, Tableau

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook.

Languages: T-SQL, MS SQL, MDX, C#, VB, HTML, XML, Python

O/S: MS Windows NT/2003/XP/ME/95/98, Windows 7, Windows 8.

PROFESSIONAL EXPERIENCE

Confidential, OH

SQL Server /ETL/Talend Developer

Responsibilities:

• Worked in the Insurance/Financial department as a SQL developer to perform data transformations and develop reports for the end users.
• Worked with Auto Insurance & Property insurance business analyst team and co-workers to identify the requirements and to refine or review data.
• Worked intimately with the requirements of Business Analysts and data modelers to design the reports according to the business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Used C#.Net, Ado.Net and ASP.Net for writing code to make availability of packages in server at scheduled times.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Created configuration files to deploy the SSIS packages across all environments.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAS cubes.
• Created SSRS reports from SQL Server Analysis Services (SSAS) cubes by implementing MDX scripts for querying the data from OLAP cubes.
• Built SSIS packages with EXCEL and FLAT file source to extract data into the SQL server.
• Developed and maintained tables, queries, stored procedures and views to support business needs and reporting requirements.
• Provided support to maintain the existing reports, software issue investigation, defect analysis and provided timely corrective actions.
• Created, analyzed and deployed OLAP cubes with SSAS.
• Created ETL jobs with Talend open studioto migrate data from EXCEL and CSV files to SQL Server database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
• Designed, created and distributed reports in multiple formats such as Excel, CSV using SQL Server Reporting Services (SSRS).
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports using SQL Server Reporting Services (SSRS).
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0.
• Created complex Stored Procedures for data retrieval.
• Ensured the security of data within the database and client side with the help of the data masking technique in Talend Open Studio.
• Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created various Daily and Monthly reports showing detailed and summary information.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Added and updated the reports on the Team Foundation Server.

Confidential, Harrisburg, PA

SQL Server /Talend/Data Warehouse Developer

Responsibilities:

• Analyzed and interacted with the requirements of business users to build reporting solutions such as relational database reports, OLAP reporting, dashboards, and scorecards.
• Designed and developed SSIS packages, store procedures,Schema Databasediagrams,User Defined Functions (UDF),configuration files, table structures, views, variablesby implementing best practices to maintain optimal performance.
• Built SSIS packages with EXCEL and FLAT file source with validations to capture any kind of errors in the source.
• Designed, developed and deployed end-to-end Data Integration solution using Data Integration process with Talend Integration Suite.
• Used different components in Talend like tmap, tmssqlinput, tmssqloutput, tfiledelimited, tfileoutputdelimited, tmssqloutputbulkexec, tunique.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components for de-duplication of data.
• Designed, created and distributed reports in multiple formats such as Excel, CSV using SQL Server Reporting Services (SSRS).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubesto store data to OLAP databases.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008/2012 that maintained data. Involved in the complete data warehouse development life cycle.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Created Talend mappings for initial load and daily updates and also involved in the ETL migration jobs from Talend to SQL Server database.
• Prepared dashboards and worksheets in Tableau by creating action filters, parameters and calculated sets.
• Provided support for Tableau developed objects and understand tool administration.
• Created Fact and Dimension tables to extract, transform and load data from various sources into Data Warehouse.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Using transformations like Derived Column, Conditional Split, Aggregate, Row Count, Lookup, sort and Data Conversion to load data into Data Warehouse.
• Creating Report subscriptions to store the reports at shared locations at schedule time.
• Generating sub report, drill down, drill through, Parameterized, Cascade parameters, Report Expressions and custom code.
• Gather requirements and design of data warehouse and data mart entities.
• Involved with the client interaction for functional and Technical clarifications and solutions.
• Involved in resolving the Production issues and deployment Process with DBA's while deploying to different environments.
• Preparing Technical design documents (TDD), Code Review, Promotional and Deployment Process Documents.

Environment: Microsoft SQL Server 2014, MS SQL Server 2014, MS SQL Server Reporting Services 2014, MS SQL Server Integration Services 2014, DTS, C#, SQL Profiler, MS Office.

Confidential, Chantilly, VA

SQL server Developer SSIS/SSRS

Responsibilities:

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel.
• Migrated data between different heterogeneous sources such as Flat file, Excelusing SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Deployed and maintained Applications/systems/databases/stored procedures development on FACETS.
• Updated and migrated the data into to and from the FACETS application database.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed differentSSIS packages on test and production servers and different SSRS reports onto Microsoft Office SharePoint Server (MOSS)also uploaded them to Microsoft Performance Point Server.
• Wrote Shell Scripts for Data loading and DDL Scripts
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Written complicated store procedures to handle premium billing and process claims using FACETS system.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Involved in providing ETL support for the production server.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents, code reviewand preparing unit test cases.

Environment: SQL Server 2012 Enterprise Edition, BIDS, SSIS, SSRS, T-SQL, MOSS 2013, MDX, ETL, Oracle 9i, Performance Point Server 2013, Erwin 7.2.

Confidential, Mount Laurel, New Jersey

SQLServer Developer SSIS/SSRS

Responsibilities:

• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Created Store Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.
• Involved in performance tuning of T-SQL Queries and focused on index tuning, query optimization and partitioning.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Imported and Exported data from text files and excel spread sheets into SQL Server database using SSIS package.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
• Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Running Data Scans on Production/ QA Environments as per the requests from SYSOPS.
• Aware of working with different ticketing workflow systems like JIRA and SRS.
• Documented the development work.
• Responsible for identifying and defining Data Source and Data Source views.

Environment: MS SQL Server 2012 Enterprise Edition, MS SQL Analysis Services 2012,MS SQL Reporting Services 2012, MS Access, MS SQL SSIS/SSRS 2012, Windows XP Professional, Relational DBMS, data warehousing.

Confidential, Chicago, IL

MS SQL Server / SSIS/SSRS Developer

Responsibilities:

• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• VB .Net and other .NET languages likeC# is used for Script task. Script task is primarily to control the flow of SSIS package.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Scheduled Backups and performed Restore operations for system test data.

Environment: SQL Server 2008 R2 (Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Crystal Reports 8.0, XML.

Confidential

SQL Server Developer

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Migrated data using ETL Tool in SSIS.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Used various transformation components in the data flow task to implement business logic to merge data from different sources.
• Reviewed and developed data models and database designs with development teams
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2005.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, and usage based optimization, besides providing security by providing perspectives.

Environment: MS SQL Server 2008 R2, SSRS, SSIS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Created different Data sources and Datasets for the reports.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 2008, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.