SUMMARY

• Around 9 years work experience in IT industry in different sectors which includes Retail Energy Services providers, Banking Management System, Property and Casualty Insurance and Financial Services.
• Strong experience in MS SQL Server 2008/ 2012/2014/2016 database, MySQL with Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services, ETL tools, JAVA and hands on experience in Data warehouse
• Strong database programming experience using SQL, T - SQL, in constructing tables, views, Stored Procedures, Indexes, relational database models and ETL techniques.
• Experience in writing & reviewing SQL queries in SQL along with Performance Tuning for SSIS & SQL Query Optimization and Performance Tuning.
• Experience in using global variables, expressions and system functions for the reports.
• Expert in handling parameterized reports in SSRS also involved in variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Generated multiple Enterprise Reports using SSRS from SQL Server Database(OLTP) and SQL Server Analysis Services(OLAP) and included various reporting features such as group by, sub-reports etc
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and also integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Experience in developing SSIS packages for Incremental Loading using Lookup and Slowly Changing Dimension Transformation
• Knowledge in using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task etc
• Experience in Performance Tuning in SSIS Packages by using Row Transformations, Block and Unblock Transformations
• Experience in creating Jobs, Alerts, SQL Mail Agent and schedule DTS Packages.
• Good knowledge in OLAP tools, building complex cubes for business analysis using SQL Server Analysis Services (SSAS)
• Knowledge in the SSAS storage, partitions, aggregations, calculations of queries using MDX
• Knowledge in extracting and loading data into SQL Azure and build SQL DataMart and Data Warehouses.
• Knowledge in migrating data from on-premises data servers on to Microsoft Azure cloud platform utilizing Azure data factory
• In-depth understanding of all stages of software development life cycle (SDLC) and involved in different SDLC models like Agile, Waterfall.
• Maintain positive communications and working relationships at all business levels.
• Team player and self-starter with ability to work independently or as a part of team and capable of picking up new skills quickly.

TECHNICAL SKILLS

SQL Server Tools: SSMS,SSIS,SSAS,SSRS(2005,2008,2012,2014,2016)

Databases: SQL Server 2005,2008,2012,2014, 2016,MySQL, and Oracle

Programming Languages: C, T-SQL, Java, C#.net, VB.net

Application Development: HTML, XML, CSS

IT Processes: Software Development Life Cycle (SDLC)

Cloud Computing: Microsoft Azure

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Sr. SQL Developer

Responsibilities:

• Developed SSIS package for transferring the data between several sources of data from external systems including SQL Server, Oracle, csv files, Flat Files.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Multi Cast, column conversion, Script Components.
• Used Checkpoints to implement the restart ability of the packages in SSIS
• Implemented Error Handling using global variables and logging of the errors into database
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in deployment and maintenance of SSIS Packages.
• Developed SSIS Packages for Incremental Loading using Lookup and Slowly Changing Dimension Transformations.
• Worked with different Control Flow elements like For loop Container, For each Loop Container etc
• Creating the ETL design specifications for the project by interacting with the Stake Holders and Customers, taking their inputs in prioritizing the areas of improvement and acted upon it.
• Worked extensively on performance tuning and query optimization
• Managed, created and altered Databases, Tables, Views, Indexes and Constraints using T-SQL.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, User-defined functions and Cursors.
• Created Triggers for auditing purpose.
• Developed several reports with multi-level drill downs and used several Charts to represent the data in the reports using SQL Server Reporting Services (SSRS).
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created several report subscriptions to deliver reports to the end users via email.
• Generated Reports using Global Variables, Expressions and Functions for the Reports using SSRS 2012.
• Designed and Created Bar Graphs and Pie Charts based on Accounting and Usage Data.
• Involved in the SSAS storage, partitions, aggregations, calculations of queries using MDX and generating reports using MDX and SQL.

Environment: SQL Server 2012/2014/2016 , T-SQL, VB.net, SQL Server Data Tools, SQL Server Integration Services, SQL Server Reporting services, SQL Server Analysis Services, SQL Profiler

Confidential, Iowa Falls, Iowa

SSIS / SSRS Developer

Responsibilities:

• Build SSIS Master and child packages for initial load of data and incremental loads of data.
• Worked on creating SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Generated reports using Global Variables, Expressions and Functions based on the requirements using SSRS.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports as per client’s requirements using SSRS.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Tested the reports and fixed bugs in the stored procedures.
• Scheduling the SSIS jobs and packages.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Created SSIS packages to integrate data coming from Text files and Excel files.
• Worked on SSIS for transferring data from Heterogeneous database to SQL Server
• Created highly complex SSIS packages using various Data transformations like Fuzzy Look Up, Fuzzy Grouping, Multicast etc
• Involved in Deployment of SSIS packages across various environments
• Worked with SSIS variables, scripting, event-handlers, package configurations

Environment: SQL Server 2008/2008R2/2012, SQL Server Integration Services, SQL Server Reporting services, Windows Server 2008, SSDT, SQL Server Agent

Confidential, Wooster, Ohio

SQL Server / SSIS / SSRS Developer

Responsibilities:

• Continuously interacted with end user to gather business requirements.
• Generated different types of Reports like Tabular, Matrix and Charts.
• Created stored procedures and user-defined functions for different Reports.
• Deployed and configured the reports in the Report Server.
• Created Subscription of Reports in different formats like PDF, excel etc to be executed automatically on weekly or monthly basis.
• Created complex correlated sub queries to generate reports.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Generated reports by passing parameters through URL Developed reports using SQL Server Reporting Services.
• Performed data mapping the report columns with the database tables and columns. Documenting the data mapping and relationships between tables.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
• Created complex SSIS Packages using proper control and data flow elements with error handling
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel spreadsheets and vice-versa
• Worked with various Dataflow tasks like Aggregate, ODE command, Conditional Split etc while designing SSIS packages
• Responsible for scheduling Jobs, Alerting and maintaining SSIS packages

Environment: SQL Server 2008/2008R2, SQL Server Reporting Services, SQL Server Integration Services (SSIS), Windows Server 2008, T-SQL, Business Intelligence Development Studio (BIDS), SQL Server Agent.

Confidential

SQL Developer

Responsibilities:

• Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Followed and maintained standards and best practices in database development
• Involved in Database Management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL analyzer and SQL enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Wrote database Triggers in T-SQL to check the referential integrity of the database
• Performed data conversions from flat files into a normalized database structure
• Worked on DTS Package, DTS import/export for transferring data from Heterogeneous Database to SQL Server
• Involved in the performance tuning of the database and T-SQL queries
• Going through client requirement and coming up with database design and application architecture
• Created Clustered and Non-Clustered Indexes for improved performance
• Provided assistance to development teams on Tuning data, Indexes and queries
• Actively participated in the gathering of User Requirement and System Specification

Environment: MS SQL 2000/2005, Windows 2000/XP, SQL Query Analyzer and Enterprise Manager, MS Access 2000 & Windows NT platform.