SUMMARY

• Have 9 years of working experience in Microsoft SQL Server suite of products like SSIS, SSRS and T - SQL of MS SQL server 2005/ 2008/ 2012/2014/2016 .
• Experienced in migration of Data from one SQL Server Database to another SQL Server Database using import export function and experience in developing, deploying packages and extracting data using SSIS of MS SQL from OLTP to OLAP.
• Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Mastery in extracting and transforming transactional information using BCP (Bulk Copy Program) and SSIS Packages from SQL Server.
• Expertise in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expert in Microsoft Business Intelligence Studio 2010/2008 (SSIS/SSRS/SSAS).
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Generated sub reports, conditional, drill down reports, drill through reports and parameterized reports using SSRS
• A quick learner, skilled and experienced using several programming languages good time management, effective interpersonal communication, and efficient problem resolution.
• Expert in interacting with clients, business analysts anddevelopers. Extremely dedicated and hardworking, strong team player with an ability to take new roles.

TECHNICAL SKILLS

Microsoft Tools: Visio, Excel, Word, PowerPoint, Visual Studio

Languages/Standards: SQL

RDBMS: MS SQL Server 2008/ 2012/2014/2016

Process Methodology: Agile/Scrum, Waterfall

SQL Server Tools: SQL Profiler, Query Execution Plan, Index and Database Tuning Advisor, SSIS, SSRS

Windows: Windows Server 2012R2/2012/2008R2/2008

ETL Tools: SSIS, Informatica

PROFESSIONAL EXPERIENCE

Confidential, WARREN NJ

SQL ETL BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Develop and recommend operational processes and/or process improvements in support of clients.
• Developed Subject Areas forMDMusing SQL Business Intelligence
• Created SSIS package to load data from XML Files and SQL Server 2012 by 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.
• UsedADO.NetEntity Framework to connect, retrieve and manipulated data with database operation by implementing Data Access Layer. Data access layer implemented usingADO.NETwith Database.
• 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.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.

Confidential, New York City, NY

SQL Server/ SSRS/SSIS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Developed various T-SQLobjects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures.
• Developed, monitored and deployedSSISpackages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks usingSSIS.
• CreatedSSISpackage to Export and Import data fromSQLServer to Access, Text and Excel files and ConfiguredSQLmail agent for sending automatic mails.
• Configured Connection Manager files forSSISpackages to dynamically execute on Quality Analysis server and Production server.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits usingSSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQLstatements usingSQLprofiler

Confidential, Ethiopia

SQL Server/ SSRS/SSIS Developer

Responsibilities:

• Expert in building Data Integration, Workflow solutions, and ETL solutions for data warehouse using SQLServer Integration Services (SSIS).
• Developed, deployed and monitored SSIS packages. Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB source, Flat files and excel Spreadsheet to SQL server 2012.
• Worked with large databases, troubleshoot issues and documented the causes,
• Create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, different constraints and functions.
• Create SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and stored procedure.
• Generated reports using SQL Server Reporting Services (SSRS 2008/2012) in Microsoft Visual Studio and complex SQL queries and stored procedures.
• Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Functions, Constraints, Indexes, Triggers, Cursors.
• Designed Data Warehouse Database for both Star and Snow Flake Schema.
• Created and Designed Data Source and Data Source Views Using SQL Server 2008/2012 Analysis Services. Created and Configured Cubes using SQL Server 2012 Analysis Services. Configured Dimensions, Measures and Measure Groups using SQL Server 2008/2012 Analysis Services.