SUMMARY

• Over 9 years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Retailers, Insurance, Pharmaceuticals, Banking, data visualization using Tableau .
• Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
• Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced.
• Configured and optimized Cognos BI environment, which includes relational, and OLAP layers, and data migration components; working in collaboration with the data warehouse environment and team.
• Experience in optimizing QlikView and QlikSense applications to improve the performance.
• Proficient in troubleshooting and fixing the QlikView and QlikSense dashboard issues.
• Conversant with all phase of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions (CTEs, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Experience in using Change Data Capture for track DML Operation on Database level.
• Strong in creating table Partition for better performance for Database and creating Partition Function and Partition Scheme.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.
• Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Sybase databases.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Strong in optimizing MOLAP cubes by partitioning them, designing aggregations and implementing hierarchies. Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX) and Data Analysis Expressions (DAX).
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Strong experience in logical and physical database design and development using Erwin and SQL server enterprise manager. Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.
• Good understanding of SAP SD tables and their join conditions, SAP SD document flow and processes.
• Having knowledge of Design and implement database solutions in Azure SQL Data Warehouse

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000 SQL Server Integration Services (SSIS 2005/2008/2010/20012 )
• SQL Server Reporting Services (SSRS 2005/2008/2010/20012 )SQL Server Analysis Services (SSAS 20052008//2010/20012 )
• PowerBI, QlikView, QlikSense Data Transformation Services (DTS)MS Visual Studio 2008/2005Microsoft Products: MS Word
• MS Excel, VSS, MS Power Point, MS Access 2007/2003ERWIN 4.0/4.1/4.2/7.2 , Microsoft Visio 10.0/11.0, C#, VB.NET, MS office 2007/2003, Windows 2003/2000.

PROFESSIONAL EXPERIENCE

MS SQL Server SSIS/SSRS Developer

Confidential

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Agile methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Involved in designing, developing, testing, publishing, maintaining, and supporting QlikView & QlikSense applications.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created C# Script for Control Flow and Check File existence using Script task in SSIS.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Involved in Production support with Deployment of the SSIS Packages (From Developer - Test - Production) and schedule SSIS packages using SQL Server Agent Job.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Installed and configured Master Data Services (MDS) and Data Quality Services (DQS).
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Tools: & Technologies: SQL Server 2012/2008R2/2008, Server Integration Services 2008, SQL server Reporting Service 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, C#

MS SQL Server Developer SSIS

Confidential

Responsibilities:

• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams.
• Performed Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access)
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Used PowerQuery to acquire data and PowerBI desktop for designing rich visuals
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Wrote C# script in Script task of control flow.
• Experienced in Error handling and debugging coding issues and troubleshoot production problems.
• Experienced in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor.
• Well-versed in usage of SSIS Control Flow items (for Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• Developed SSIS package for implementing Slowly Changing Dimension. Fact Load and Dimension Load. Incremental Load.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Involved in configuring and creating SSIS solutions for ETL and Business Intelligence Process for data integration and migration services.
• Experienced in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Tools: & Technologies: SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server, SQL Profiler, Index Tuning Wizard, C#, Erwin 7.2.