SUMMARY

• 6+ Years of IT Experience in designing, developing, enhancing and maintaining large data sets processed through the MS BI stack (SSIS and SSRS) of Microsoft SQL Server 2012/2008R2.
• Experience in various facets of Information Technology Industry.
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2012/2008
• In - depth knowledge ofPL/SQL,SSIS, SSRS, Reporting and Analytics.
• Extensive experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
• Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions.
• Extensive experience in data warehousing, data analysis and data mining which includes MSBI development & deployment of SSIS & SSRS
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in designing reports using SSRS, Report Builder and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters, and matrix dynamics reports.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Good ETL skills and knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance.
• Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
• Good understanding ofMicrosoft ReportingService(SSRS)with Report authoring, Report management, Report delivery andReport security.
• Created many Drill Through, Drill Down, Parameterized reports using SSRS 2005/2008
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Involved in DBA activities such as backups, restores, replication etc.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box
• Involved in all the stages of Software Development Life Cycle including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.
• Strong debugging skills and the ability to solve complex problems.
• Good team player with strong analytical skills.

TECHNICAL SKILLS

Relational Databases: SQL Server 2008/2012R2.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS,SSAS, ETL, SQL Query Editor

Languages: T-SQL, PL/SQL, XML, SQL.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential, Buffalo NY

Senior SSIS/SQL server developer

Responsibilities:

• Responsible for designing of initial package, keeping in view implementing appropriate SSIS controls.
• Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into EDW.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data.
• Involved in the ETL phase of the project. Development of mappings according to the ETL specifications for the staging area data load & warehouse data load using SQL Server Integration Services & SQL Server 2012.
• Developed the reports in the form of Matrix, Table, cascading reports and Charts Using SQL Server 2005 Reporting Services.
• Generated the Reports Weekly, Monthly and quarterly basis as per the player's requirements.
• Generated the reports by using the Report server project.
• Building and generating reports with the help of Report Builder in the Report manager.
• As per the client requirements, rendering the Reports in the form PDF, .CSV and EXCEL formats.

Environment: MS SQL Server 2008/2012R2, MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL server Analysis services (SSAS)

Confidential, Weehawken, New Jersey

Senior SSIS/SQL server developer

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008 R2/2012.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Performed operations like validation and error handling after Extracting data into SQL Server.
• Used different control flow tasks such as Sequence Container, For Each Loop (File Enumerator, ADO Enumerator), For Loop, Execute SQL Task, Execute Process task, Script task and FTP task.
• Implemented different transformations like Look up, Dynamic Lookup through variable, conditional split, derived columns, multicast, union all, sort, merge, pivot transformation.
• Expertise with various control flow tasks like Data Flow Task, File System Task, Script Task, Execute SQL Task, Execute Package Task, Send Mail Task etc.
• Created jobs in Production using SQL Server Agent for executing various packages which run according to schedule and send notifications upon completion
• Experience with SSIS performance tuning using counters, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.Net in SSIS.
• Designed various SSRS reports using different reporting features such as group by, drilldowns, drill through etc. Created SQL server Reports using SSRS.
• Used various types of report layout options like charts (bars, lines, pie etc.), images, sub-reports, and hyperlinks to make them more attractive and understandable.

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS), MS Visio.

Confidential, NY

SSIS/SQL server developer

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse
• Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.
• Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.

Environment: SQL Server 2008/2012R2, T-SQL, SSIS, SSRS,SSAS, MS SQL Profiler, SQL Query Analyzer.

Confidential, New Jersey NJ

SSIS/SQL server developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, OLEDB and Access to SQL Server.
• Used various SSIS tasks such as Conditional Split, Merge Join, Data conversion, OLE DB Command, Derived Column on the data retrieved, performed Data Validation Checks during Staging, Used Data Flow task, Execute package task, Execute SQL Task, in SSIS for transformation of data.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various users using SQL mail agent.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files, Oracle and Access database, DB2 into SQL server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created sub-reports, drill down reports, parameterized reports, Drill-through, to get monthly client account details and profits using SSRS.

Environment: SQL Server 2008/2012R2, T-SQL, SSIS, SSRS, SSAS, PowerPoint, Excel

Confidential

SSIS/SQL server developer

Responsibilities:

• Developed Use Cases, High Level Design and Detailed Design documents.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects
• Developed several database objects such as tables, triggers, procedures, views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers. Created and scheduled jobs and alerts.
• Assisted the Application team in data modelling and T- SQL coding.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Developed & executed several optimized queries.
• Created packages using SSIS for moving data from MS Access to SQL Server.
• Extensively working in data Extraction, Transformation and Loading from source to target system using SQL Server 2008 Integration Services.
• Analyzing the Existing System and Understanding the business requirement.
• Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2008 Integration services.
• Created Transformations and Mappings using Data Flow Tasks.
• Created Event Handlers for the Packages Using Event Handler Tab.
• Extensively used Derive Column, Row Count, Data Conversion, Conditional Split and Aggregate.
• Created reports Using SQL server reporting services.

Environment: SQL Server 2008, SSIS, SSRS, Windows NT, EXCEL, Access