SUMMARY

• Over 7 years of Backend Development experience in MS SQL Server, SSIS and SSRS with various domain such as Finance, Retail and Service, Manufacturing, and Insurance.
• Strong knowledge in T - SQL, MySQL, PL/SQL and DBA experience in MS SQL Server and Oracle.
• Wrote Dynamic SQL Scripts and created Dynamic SSIS Packages.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2014/2012/2008 r2/2008 and 2005, and Business Intelligence tools such as SSIS, and SSRS.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases such as Oracle 10g and 11g, DB2, Sybase.
• Highly proficient in using T-SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Data Integrity, SQL joins and Query Writing.
• Strong experience in designing and developing more than 100+ enterprise reports (SSRS/ Business Objects) using the data from ETL Loads, and various heterogeneous data sources.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008r2,2008 and 2005.
• Experienced in Conceptual, Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS Visio.
• Created Power BI report from different sources which is friendly for both regular and mobile user.
• Strong experience in SQL Server Installation, Capacity Planning, Creating and Implementing Backup and Recovery Strategy, Log Shipping, Replication, Attaching and Detaching the database, and database designing.
• Expert in using tools like MS SQL Profiler, Performance Monitor, Database Engine Tuning advisor, Index Tuning Wizard, and Execution Plan for Query Optimization, resolving Dead Locks, and Long/Slow running queries.
• Experienced in upgrading SQL Server and .
• Scheduled jobs and alerts using SQL Server Agent and troubleshoot any failures or alert problems.
• Maintained positive communications and working relationships at all business levels.
• Excellent experience in working independently as well as in team-oriented environments.

TECHNICAL SKILLS

• MS SQL Server 2012/2008r2/2008/2005
• MS SQL Server 2012/2008R2/2008/2005
• SSRS and SSIS
• Microsoft Access 2010/2007
• MySQL
• PL/SQL
• Dynamic SQL
• Microsoft office
• Report Builder 3.0
• Java
• C++
• MS SQL Profiler
• Query Analyzer
• Enterprise Manager
• Index Tuning Wizard
• Loader and Export/Import
• Erwin 8.0/7.3
• SharePoint
• Microsoft Visio 2010/2007
• Data Modeler
• Third party tool Red Gate and Idera
• Cognos crystal Report
• T-SQL
• P-SQL
• Windows 2012/2008/2003 Advanced Server
• UNIX and Linux environment
• HTML
• PHP
• VBScript
• JavaScript
• XML
• CMD and Batch File.

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn, NY

SQL Developer /BI Developer

RESPONSIBILITIES:

• Create stored procedures and SSIS Packages to collect Accounts data from different sources.
• Interaction with clients while business requirements, design & implementation phases.
• Performed Query optimization for slow stored procedure.
• Used Dynamic SQL for the data retrieval and to insure a flexible process in a constantly changing environment.
• Created stored procedure which well suited for distributed databases and linked server.
• Involved working with data validation logic for all source data and load them in data warehouse using SSIS Package.
• Created different types of reports such as drill down, drill through, parameterize and dash board reports and schedule them according to business requirement using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis and management decision using SSRS.
• Created and published reports on Power BI which works on regular and mobile browser.
• Involved designing a process that stores aggregated value to optimize reporting.
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• Used various sources other than SQL Server for SSIS Package such as Flat File, Excel, Oracle and DB2.
• Used SQL Server agent to schedule and deploy SSIS Packages and Stored procedure.
• Configured and deployed SSIS packages in both Dev and QA environment.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
• Wrote complex T-SQL and PL/SQL queries, stored procedures, views, triggers, functions, table variables, and cursors as per business requirement.
• Involved creating indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.

Environment: MS SQL Server 2012/2008, SSIS 2012/2008, SSRS 2012/2008/2005 , Excel, Oracle 10g, T-SQL, Power BI and C#.

Confidential, Dublin, OH

MS SQL Server Developer / Database Developer

RESPONSIBILITIES:

• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2012 and MS SSRS 2012.
• Created various packages to validate, extract, transform and load data to centralized SQL Server using OLEDB providers from the existing diversified data sources.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices (SSIS).
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Using SSIS, loaded XML data to the Database tables. Generated XML files from Database tables.
• Created drill down, drill through, sub and linked reports using MS SSRS 2012 as well as managed the subscription of the reports.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS) and Crystal Reporting Services.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS) and Crystal Reporting Services.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Creating console applications based on client requirements and specifications to validate the Sample Request Forms.
• Created subscriptions to send email and Fax notifications to the supervisors of the officers when they do not respond to the “To Do List” allocated to them.
• Improve Performance of database by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL Statements using SQL Profiler. Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.

Confidential, Philadelphia, PA

MS SQL Server Developer/BI Developer

RESPONSIBILITIES:

• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Created simple to complex Store Procedure to re-use all the complex queries that I wrote in a specific format with the help of given template.
• Responsible to create various Tables, Views and Functions based on the requirement and wrote complex Join statements for combining data from various Databases and tables in different relational model database server such as Oracle and DB2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Helped in Rebuilding the Indexes at regular intervals for better performance.
• Worked with a Cognos team and helped to create complex by weekly, quarterly and annual report by writing code based on the requirement.
• Involved in configured the report viewing security for various users at various levels using Report Manager.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Produced operational reports in SSRS 2012/2008R2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2.
• Helped in planning out the coding and offered different solutions in initial planning of the project.

Environment: MS SQL Server 2012, 2008r2, SSIS, SSRS, T-SQL, Windows 2008 Server, and Erwin 8.0.

Confidential, Albany, NY

MS SQL Server Developer/SSIS Developer/SSRS Developer

RESPONSIBILITIES:

• Planned, Defined and Designed data based on business requirement using Erwin data modeler and provided documentations for further reference.
• Wrote Dynamic SQL queries for Store Procedure.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Created SSIS package to load data from Flat Files, Excel and transfer packages from SQL Server 2008 to SQL Server 2008r2 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases.
• 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 using SQL Server Agent.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
• Configured the report viewing security for various users at various levels using Report Manager.
• Fine tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Wrote VB.Net and C#.Net scripts in Script task to validate data using SSIS variables and custom code.

Environment: MS SQL Server 2008r2, SSIS, SSRS, T-SQL, Windows 2008 Server, Dynamic SQL, VB.Net, C# and Erwin 8.0.

Confidential, New-York, NY

MS SQL Server Developer/SSIS Developer/SSRS Developer

RESPONSIBILITIES:

• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, T-SQL code and SQL Joins for applications.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Designed SSIS packages to transfer data from various sources like XML files, Excel, MS SQL Server 2008R2/2008 to and from Oracle 10g and 11g.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Analyzed and designed the business rules for Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column that are required by the staging OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Wrote VB.Net and C#.Net scripts in Script task to validate data using SSIS variables and custom code.
• Involved in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports usingSQL ServerReporting Services 2008 and Created ad-hoc reports Using Report Builder.
• Built the SSRS reports from Different Databases like Oracle andSQL Server.Configured and deployed SSRS reports.

Environment: MS SQL Server 2008r2/2008, SSIS, SSRS, Microsoft Performance Point Server 2010, Microsoft Share Point Server, T-SQL, Java, Microsoft Office, Erwin 7.3, VB.Net, C#, and Report Builder 3.0.

Confidential, Chantilly, VA.

SQL Server Developer/BI Developer

RESPONSIBILITIES:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Designed new SSIS packages and deployed them.
• Used SSIS to populate data from various data sources, creating packages for different data loadingoperations for applications.
• Improved Performance Tuning of slow running SSIS Packages by using Merge statement from T-SQL and look up as an alternative of slowly changing dimensions.
• Wrote Stored Procedures, Triggers, cursors and creating indexes.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization, Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Worked on Authoring Reports and managing reporting services.
• Created and deployed various reports using SSRS 2005.
• Developed reports using complex queries and filters as per client requirements.
• Developed and deployed Table, Chart, Matrix reports and Sub-Reports.
• Deployed Cubes on Development Server and Production Server.
• Created parameterized reports in Microsoft reporting services 2005.
• Logical and physical database design using Erwin Tool.
• Performing query plans and making sure each and every query is using appropriate indexes.
• Provided support for in-house and off-shore Development Team.

Environment: SQL Server 2005 Enterprise Edition, UNIX, Sybase Adaptive Server, Enterprise Manager, T-SQL, XMLMS PowerPoint, MS Project and Windows 2003 server