PROFESSIONAL SUMMARY:

• Over 6 years of experience in IT as SQL Server Developer and strong work experience on Business Intelligence tools.
• Experience in analysis, design, implementation & administration of business intelligence solutions with Microsoft SQL server 2012/2016 in development, test, and production environment.
• Expertise in complete Software development life cycle (SDLC) also has strong understanding of Software Quality Assurance Methodology and Agile methodologies.
• Involved in writing various DB objects like user defined functions, views, stored procedures, triggers, and indexes for accomplishing various tasks.
• Analyzed the existing application programs and tuned SQL queries using execution plan, query analyzer, SQL Profiler, and database engine tuning advisor.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Created complex SSIS packages using various transformations and tasks like Sequence Containers, For loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Worked on SSIS performance tuning using error handling, event handling, re - running of failed SSIS packages using checkpoints, Precedence Constraints, Break Points, Logging.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split, and derived column.
• Hands on experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Expert in designing enterprise reports using SQL server reporting services (SSRS) like Tabular, Matrix, Drill down, Drill through, Sub reports and Ad-Hoc reporting. Created multiple value parameters, cascading prompts, dynamics reports.
• Developed cubes, Slowly Changing Dimensions and Hierarchies for analysts and executive Dashboards using Charts, Graphs.
• Designed reports using table filters, single value parameters, multi value parameters, Dynamic, dependent parameters, and cascading parameters.
• Wrote SQL queries and stored procedures to generate data for reports.
• Analyzed Queries and boost the performance necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created complex and sophisticated reports using SSRS for analysis of data at project level
• Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, Normalization/De-normalization.
• Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.
• Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.
• Good working knowledge in database debugging and tuning using the Query Analyzer, SQL Profile.
• Experience in developing reports like Tabular, Matrix, Lists, Charts, and Parameterized reports using SQL Server Reporting Services (SSRS) 2016/2012/2008/2005
• Quick learner who strives for new technical knowledge.
• Team player with good leadership skills.
• Demonstrate professionalism, attention to details, collaborative nature, and a quick learner. Strong communicator exhibited by working closely with users to identify and resolve problems. In addition to working well individually, an effective team player.
• Strong analytical and problem-solving skills, Ability to work to deadlines, Results oriented Flexible, and Adaptable.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Highly motivated and competent individual good communication and analytical skills.

TECHINICAL SKILLS:

RDBMS: MS-SQL Server 2017/2016/2014/2012/2008 R2

ETL: SQL Server Integration Services, T-SQL, Stored procedures

Reporting: SQL Server Reporting Services(SSRS)

Languages: SQL, C, C++, C#, VB.Net, XML

OS: Windows 7, Windows Server 2008,2003, XP

Tools: Visual Studio, BIDS, SSIS, SSRS

Office Tools: MS Word, Power Point, Excel, Visio

Domain Expertise: Mortgage, Banking, HealthCare

Source Control: Team foundation server 2010 (TFS), Visual Source Safe 2005 (VSS)

Data Modeling: Data modeler, Microsoft visual studio 2010,2008

PROFESSIONAL WORK EXPERIENCE:

Confidential, TX

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in writing complex stored procedures, establishing joins to generate the reports.
• Created SSIS packages to validate, extract, transform and load the data to data warehouse databases.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Involved in monitoring and troubleshooting complex packages by using data viewers, grids, debugging and maintenance of ETL packages and its optimization using SQL server best practices.
• Resolved User issues, involved in debugging SQL and updating as needed.
• Responsible for creating all reports such as matrix report, drill down report, drill through report, sub report and chart report etc.
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Investigated data to determine why the reports are showing certain data elements.
• Added Users to reports using report security framework
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Also involved in Production support and scheduling jobs using sql server Agent.

Environment: MS SQL Server Management Studio 2014/2016, SQL Server BIDS 2012/2016, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) 2012/2016, MS SQL server Analysis services, Windows.

Confidential, TX

SQL Server SSIS/SSRS ETL Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Created and maintained database objects (tables, stored procedures, and views).
• Optimized the performance of queries with modification in T-SQL queries, established joins and created indexes.
• Experienced in working with many complex SQL queries using joins and date functions to generate various reports.
• Involved in generating and maintaining SQL scripts.
• Created complex stored procedures for complex reports developed using SSRS 2012
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports
• Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS). Created many complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
• Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snowflake schema.
• Designed and developed SSIS Packages to import and export data from MS Excel, OLTP and Xml files.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Create stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files to SQL server staging tables.
• Designing a data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split and derived column.
• Extensive testing on the performance of the stored procedures.

Environment: MS SQL Server Management Studio 2012, SQL Server BIDS 2012, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) 2012, MS SQL server Analysis services, Windows.

Confidential, IL

SQL Server SSIS/SSRS ETL Developer

Responsibilities:

• Designed ETL packages to load data from different data ware houses and migrated it to text files.
• Used various data flow and control flow items for the ETL.
• Wrote highly complicated and optimized stored procedures which were used for main extraction.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Analyzed the Extracted data is according to the requirement.
• Wrote and discussed Analysis reports with Clients.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Responsible for Configuring, tuning, and optimizing SQL Server 2008.
• Coordinated with DBA in creating and managing tables, indexes, database links and privileges
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor
• Generated parameterized reports, sub reports, tabular reports, drill down reports, Drill through reports using SSRS 2005
• Created reports which retrieve data using stored procedures that accept parameters

Environment: MS SQL Server Management Studio 2008, SQL Server BIDS 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) 2008, MS SQL server Analysis services, Windows.