SUMMARY

• 7 years of strong experience in teh IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2012/2008/2005 for both OLTP & Data Warehousing Systems applications (SSRS, SSIS, and SSAS).
• Strong team player with excellent problem-solving skills and ability to take new roles, self-starter with excellent communication experience in OLAP, Data marts, Data warehousing, Operations Data Store concepts and ETL technologies.
• Worked extensively on SQL server management studio, SQL server 2014, … and BI tools such as SSIS, SSRS, SSAS SSAS and tabular data modeling including MS solutions like MS EXCEL., DB2, and MS Access Database.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Highly Proficient in T-SQL DDL/DML, perform most of teh SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Very good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Tremendous experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Extremely efficient in writing T-SQL scripts to develop complex Stored Procedures, Triggers, Tables, Views, User Functions and SQL Joins.
• In depth understanding of SQL Server Migration and problem management.
• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Expertise in building complex ETL packages using varied and complex data sources and merging them into a single data model.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations and involved in package configurations and deployment process.
• Worked on creating Jobs, Alerts, SQL Mail Agent, and scheduling Packages.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• An outstanding ability in Designing, Building teh Dimensions, cubes with star and snow flake schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Extensive experience in Optimizing Cubes using SQL Server Analysis Services (SSAS) 2008.
• Actively involved in Processing Cubes, adding KPIs and Calculated Members.
• Advanced extensible reporting skills using SQL Server reporting services(SSRS) Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Strong knowledge in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Very well experienced in managing projects with both waterfall and agile environment.
• Domain expertise in Finance Applications, Health care applications, Global advertising and Retail applications.
• Proficient in gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining.
• Exposure to designing, developing and maintaining web/windows applications based on .Net.
• Exceptional leader with excellent interpersonal skill, communication finesse and Team management skill with strong expertise in analyzing teh requirements and preparing teh specifications document based on teh requirements.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Rational Rose
• Erwin4.x
• Oracle 9i
• TOAD 6.0
• VB6
• .NET
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• Informatica
• R
• HTML
• XML
• C++
• JavaScript
• ODBC
• MS Visio 2003.

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL/MSBI Developer

Responsibilities:

• Gathering teh requirements and writing teh ad-hoc SQL query batches to update teh data and metadata for delta and history loads.
• Worked with complex SQL Stored Procedures, Triggers and packages in very large databases from various servers using SQL Server 2012.
• Working in production support to tune and optimize teh process for better performance.
• Troubleshoot and resolve teh complex issues. Translating complex business requirements into technical solutions.
• Modified teh Stored procedures to log errors by scripting exceptional handling in all stored procedures using SQL Server 2012.
• Provided script to fix errors in database.
• Immensely used teh transactions concept to take care of all teh DML queries dat are executed in teh stored procedures and roll backed teh transactions whenever teh stored procedure is errored out.
• Created complex queries involving Sub-queries and Joins using SQL Server 2012.
• Created new database/tables to put in teh extractedx data and rebuild teh relationship.
• Identify columns for Primary Keys in all teh tables at teh design time and create them.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Created SQL server configurations for SSIS packages and successfully deployed SSIS Packages with defined security.
• Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012.
• Used various SSIS Transformations such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse using SSIS 2014/2012.
• Developed SSIS package and scheduled them to perform ETL and to import and export data from database and performed data validation by using teh transformations, C# and various inbuilt tasks in teh tool.
• Immensely used for loop, For each loop and sequence containers.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports using SSRS 2012.
• Identified teh database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder SSRS2014/2012.
• Defined teh report layout and identified Datasets for teh report generation using SSRS.

Environment: MS SQL server 2014/2012, ASP.NET, BIDS, T-SQL, Oracle, .NET, Visual Studio, MS Server Integration services (SSIS) MS Server Analysis services (SSAS), MS Server Reporting services (SSRS)

Confidential, Philadelphia, PA

SQL Server Developer/SSRS/SSIS

Responsibilities:

• Key role in team of 4 in brining 2008R2 SQL database environment to SQL 2012.
• Extensively worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, ePivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/SQL Server Logging for all SSIS packages.
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services(SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to teh requirement.
• Deployed and configured teh reports in teh Report Server.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, Flat files SQL Server 2008R2 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, Restartability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeed
• Worked on Error Handling.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Performed SQL validation to verify teh data extracts and record counts in teh database tables by writing complex SQL minus queries.
• Tested teh ETL mappings from Source to Target.
• Extensively used SQL Queries to verify and validate teh Database Updates.
• Written test cases for checking teh populated data correctly into fact and dimension tables.
• Created Test Case documents in MS Excel template from teh Test Plan and teh Business Requirements documents.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.
• Designed teh functional and technical documents, report templates and reporting standards for teh developers to work on teh report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2.
• Created cubes and dimensions and measures and calculated measures according to teh business requirements.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Browsing teh cube for analysis and validation of teh data.
• Processing teh cubes and dimensions on a daily basis using teh SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease teh processing time and increase teh performance of teh queries running on front end application using SSAS 2008.
• Deployed SSIS packages and Reports to Production Servers.
• Configuration and Deployment of all reports across various SDLC environments.
• Deployed teh packages to production using XML package configuration.

Environment: SQL Server (SSIS,SSRS,SSAS) 2008R2/2008/2005, DB2, HP Quality center 10.0, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, New York, NY

SQL Server Developer/ SSIS/SSRS Developer

Responsibilities:

• Developed and created logical and physical database architecture using ERWIN.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Successfully implemented indexes on tables for optimum performance.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Developed scripts to migrate data and teh database objects to/from multiple sources.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. Created TEMPeffective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for teh business requirement like column chart, Pie Charts.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Migrated data from different data sources.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Responsible for teh creation and teh maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre calculated measures.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery.
• Held responsibility for database maintenance plans.
• Actively involved in gathering and analyzing stakeholders requirements.
• Created alerts, notifications, and e-mails for system errors.

Confidential, Oaks, PA

SQL Server Developer

Responsibilities:

• Create and maintain clearly written technical, user, and system documentation.
• Developed various T-SQL stored procedures, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, and Views.
• Worked in production support to optimize teh stored procedures and scheduled many jobs using SQL Server.
• Created Indexes for fast retrieval of teh data. Involved in Performance tuning and Query Optimization using execution plan.
• Pivot table are used to provide structured to Reports in proper manner like months etc.
• Implemented error handling in SQL Server 2018 using teh THROW.
• Created SSIS Packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for teh SSAS cubes.
• Created teh SSIS packages and scheduled them using SQL Server Agent.
• Developed ETL packages with different data sources ( SQL Server, Flat Files, Excel source files etc.) and loaded teh data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS-2102.
• Utilized event handling TEMPeffectively to generate audits and logs for teh generated SSIS Packages.
• Performed archiving and achieved automated processing of teh raw data through teh ETL process in SSIS.
• Deployed SSIS Packages rom Dev/Staging/Production using Package Configurations
• Created reports as per user requirement using SQL Server reporting services(SSRS) which delivers enterprise and Web-enabled reports.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports(SSRS) also parameterized reports.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server 2005 Analysis Services (SSAS) and Reporting service (SSRS).

Environment: SSRS 2008, SSIS 2008, T-SQL Microsoft Share point, Microsoft SQL Server 2008, Visual Studio 2005, BIDS, MS Server Analysis services (SSAS), Asp.NET, Execution Plan, MDX, Power Pivot, Query Analyzer, Microsoft Word 2010, Microsoft Excel 2010.

Confidential, Deerfield, IL

MS SQL Server Developer(SSRS)

Responsibilities:

• Created new tables, written stored procedures using T-SQL for Application Developers and some user defined functions.
• Scheduled teh Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
• Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Create Store Procedure using T-SQL to evaluate result for teh reports to implement using Management studio.
• Scheduling & publishing reports using Crystal reports server.
• Export Crystal report in Excel and PDF formats.
• Migration from Crystal Reports to SSRS.
• Generate graphs & Pie Charts using Crystal reports and SSRS show teh revenue of teh business.
• Provide Dynamic Parameter reports for different business criteria.
• Developed different Scripts for teh Data analysts for Verification of reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Used SSAS Cubes as a source for Reporting
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked on SSIS Package, Import/Export for transferring data between SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of teh system.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Pivot table are used to provide structured to Reports in proper manner like months etc.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2012.

Environment: SQL Server 2012, MS Excel, SQL Profiler, ETL, MS SQL Server Reporting Services, SSIS, SSAS, C#

Confidential

SQL Server Developer

Responsibilities:

• Involved in installing and maintaining MS SQL Server 2005.
• Carried out a Developer’s role on MS SQL Server 2005, MS Access Databases (using DTS (Data Transformation Service), T (Transact)-SQL, Stored Procedures and Views).
• Logical and physical database development (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
• Worked on teh Reports, Tables and ETL-Extract Transformation Loading process.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP-Bulk Copy, DTS and Indexes.
• Created Databases and modified teh existing databases.
• Designed and created Database Objects - Tables, Indexes, Views, and Roles.
• Created teh Customized Stored Procedures, Triggers, and Cursors.
• Responsibilities also included transferring of customer, personal financial history
• Loaded information from various ODBC driver files to SQL server database files using DTS.
• Updated and maintained customer information onto client machines.
• Involved in job scheduling using MS SQL server Agent.
• Created and utilized Data Transformation Services Package (DTS) for Data Warehousing.
• Performed Data transfer (Import & Export) using BCP.
• Monitored teh performance of Database Server & Tuning for Better Performance.
• Performed Full Back up, Recovery and Restoration.
• Created Linked Servers to connect OLEDB data sources and providers.
• Optimized teh SQL statements for customer summary reports.