SUMMARY:

• Highly qualified IT Professional with 9+ years of end to end business solutions in Database developer/ administrator and designing, Experience in ETL/BI developing & implementing Microsoft BI using SQL Queries.
• Hands on experience in database management techniques including backup/restore, import/export, and script generation.
• Expertise in using SQL to create and manage database items, such as tables, views, functions, stored procedures, indexes, and partition of tables.
• Expertise in creating and scheduling complex SSIS packages for transferring data from multiple sources into SQL Server, Access and Excel by using SSIS and DTS of SQL Server.
• Coding of Database objects like Triggers, Procedures, Functions and Views.
• Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages also in backup and disaster recovery procedures.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Extensive experience in SSIS Package Configuration, Development, Deployment and Support of SSIS.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), MS Excel spreadsheets.
• Experience in TFS (Team Foundation Server).
• Experience in create the batch files.
• Experience in .NET application development using C# and VB languages.
• Experience in sql server analysis services(SSAS)
• Creating and scheduling SQL jobs.
• Hands on experience in MS SQL Installation, maintenance and optimization.
• Excellent analytical, problem identification and solving skills.

TECHNICAL SKILLS:

BI and ETL: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Reporting Tool: Sql server reporting services(SSRS)

Databases: SQL Server 2005/2008/2008 R2/2012

Database Utilities: SQL Jobs creating and scheduling

Operating System: Windows XP/Vista/7/8/, Linux, Windows 2003/2008 Server

Application Packages: MSOffice

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer (SSIS/SSRS/.Net)

Responsibilities:

• Involved in requirement gathering, System design and functionality demonstration for the end users approval.
• Input data is Voluminous and inconsistent.
• Developed around 50 processes for various HSBC finance operations
• Most of these activities are manual, there is a higher risk of errors and if detected, there are subsequent rework efforts.
• PEC(period end closure) currently have around 3000 sub processes with potential to grow additional 2000 sub processes moving from onshore to GFC.
• Generated various Monthly, Quarterly, Bi - Yearly, Yearly reports by different type of reports using SSRS.
• Designed and developed SQL Server Reporting Services (SSRS) SQL Server 2005/2008/2010.
• Involved in Report writing according to business requirement using SSRS Reports.
• Creating SSIS Packages using different type’s task and with Error Handling.
• Fine-tuned the complex database stored procedures to increase performance.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Expert in writing stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language
• Performance Optimization of Microsoft SQL Server stored procedures.
• Developed and deployed SSIS packages, configuration files and schedules job to run the packages to generate data in CSV files Maintained TFS Source Control server for versioning the Database Objects and production releases
• Experience in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created SSIS packages and daily jobs which send the customer data from production server to other servers (E-com) on daily basis.
• Prepared daily and weekly status reports and collaborated with other team members.

Environment: MS SQL Server 2012/2008R2, Management Studio (SSMS), ETL, DTS, Data Modeling, ETL and Database, TFS, Source Control, Data ware Housing,C#.Net, T-SQL, SQL Profiler, Windows 2003 Advanced Server, SSIS, SSRS 2005/2008/2010.

MS SQL Server/BI Developer

Responsibilities:

• Actively participating in daily calls with Client and Client Team
• Modified the existing stored procedures to get the new functionality depending on the client requirement. Created many tables.
• Created SSIS Packages using various Transformations.
• Used various Data Flow Transformations, like Derived Column, Data Conversion, conditional splits, Multicast and Copy Column while developing the packages.
• Developing of SSIS packages, which retrieve data from various sources like OLEDB, Excel, Flat files and used data transformation.
• Implementing the logging, checkpoints.
• Creating Unit test cases and Implemented unit test results.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Responsible for 24X7 Production support for critical process.
• Involved in high priority tickets based on user request.
• Generated matrix reports, drill down, drill through, sub reports, multi parameterized reports.
• Utilized different SSIS information stream changes, for example, Data Conversion, Conditional Split, Derived Column, and Lookup which were utilized for Data Scrubbing and Data Validation Checks amid arranging, before stacking the information into Data Warehouse.
• Made and adjusted Stored Procedures, Functions, and Indexes.
• Setup of report server and report chief planning for SQL Server Reporting Services (SSRS).
• Expertise in generating reports using MS Reporting Services 2012.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in writing VB scripts for user defines functions in SSRS.
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server Catalog from the report manger.

Environment: MS SQL Server 2012/2008R2, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2012/2008, Microsoft Office, Team Foundation Server (TFS).

Business Intelligence, ETL/SSRS Developer

Responsibilities:

• Actively participating in daily calls with Client and Client Team.
• Developing of SSIS packages, which retrieve data from various sources like OLEDB, Excel, Flat files and used data transformation.
• Working on various work flows like Data flow Task, Script Task, Execute SQL Task, Containers and File System Task.
• Creating Packages on SSIS by using Different Transformations like Derived Column, Lookup, Sort and OLEDB command to Load Data into Destination.
• Implementing the logging, Breakpoints.
• Created Unit test cases and Implemented unit test results.
• Designed and implemented stored procedures and triggers for automating tasks.
• Loading data from various sources to SQL Server database using SSIS package.
• Writing SQL statements which includes joins and functions.
• Implemented complicated transactions for the existing tables.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Worked with SQL System Defined Functions and User Defined Functions.
• Created batch file to run the SSIS packages.
• Used SSIS to build high performance data integration solutions, including Extraction, Transformation and Load (ETL) packages and scheduled the SSIS packages and jobs.

Environment: SQL Server 2008R2, T-SQL, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows 7, Team Foundation Server (TFS).

ETL Developer

Responsibilities:

• Creating requirements, functional and release documentation of Project and ERs.
• Extensively used Joins, sub-queries and CTEs for complex queries involving multiple tables from different databases.
• Written Stored Procedures and Triggers to enforce data and referential integrity.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created SSIS Packages using various Transformations.
• Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
• Developed various operational Drill-through and Drill-down custom reports using .Net framework within SSRS.
• Created source and destination connection for Excel, Flat Files and OLEDB.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.

Environment: SQL Server 2008R2, T-SQL, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows 7, Team Foundation Server (TFS).

ETL Developer

Responsibilities:

• Created tables, views, stored procedures, functions, CTEs and indexes in support of various databases and ETL applications
• Implemented Left, Right, Inner, Outer, Cross Joins and Self Joins
• Created packages in SSIS with error handling.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Developed backup and restore scripts for SQL Server 2008.
• Created checkpoints and configuration files in SSIS packages.
• Providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Developed various operational Drill-through and Drill-down custom reports using within SSRS.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS).
• Deployed the generated reports directly on the client’s workstation
• Used Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages
• ETL Package Jobs Scheduled to run daily during Night Hours in data warehouse
• SQL Email configuration done to send Email Alert from production to inform Job Status of data ware house

Environment: SQL Server 2008R2, T-SQL, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows 7, Team Foundation Server (TFS).

Software Engineer

Responsibilities:

• 3-tier architecture
• Building Business Layer and Data access layer.
• Implemented the project using ASP.NET, C#, and back-end database as Microsoft SQL Server
• Involved in the analysis, design and development of the project.
• Created database tables.
• Created Stored Procedures, Tables, Views and other T-SQL code and SQL joins for applications.
• Deployed the SSIS packages in Development and Testing environments.
• Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Created checkpoints and configuration files in SSIS packages.
• Implemented debugging of packages using Breakpoints, Event Handlers and Loggings.
• UsedSSRS 2005/2008 to build various kinds of reports based on requirements. Developed Drill-through, Drill-down reports.
• Scheduling the SSIS packages and Jobs.
• Collaborated TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in the organization

Environment: SQL Server 2008R2, T-SQL, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows 7, Team Foundation Server (TFS),.Net, C#, ASP.NET