PROFESSIONAL SUMMARY:

• Around 6+ years of total professional experience as a MS SQL BI Developer, ETL Developer in various industrial domains like Insurance, Finance, Banking and Health Care.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting inSQLServer wif expertise on data normalization.
• Conversant wif all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Good noledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Strong noledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.
• Good understanding in Database and Data warehousing concepts (OLTP & OLAP).
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced inSQLServerReporting Services (SSRS),SQLServerIntegration Services (SSIS), Data Transformation Services (DTS) andSQLServerAnalysis Services (SSAS).
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MSSQLServerSQLtools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.
• Used VB scripts in the script task in SSIS packages.
• Developed dashboards and key Performance Indicators (KPI) wifSQLServerReporting Services (SSRS) and PowerBI.
• Worked on PowerBIand prepared dashboards using Tableau to make it more attractive.
• Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.
• Highly noledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Scheduled & distributed reports in multiple formats usingSQLServerReporting Services (SSRS) in Business Intelligence Development Studio.
• Expertise inSQLServerAnalysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Organized, self-motivated and punctual wif excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, wif ability to take new roles in minimum time and little training.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Unix

Languages: C, Python 2.7, UML, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL, R programming and Java EE.

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), SAP BI 7.4

Database: MS SQL Server 2012/2008, Oracle 10g/9i/8i, MYSQL, IBM DB2 7.1/8.0 and MongoDB

Reporting Tools: SSRS 2012/2008, Crystal Reports XI/X/9/8, Power BI, Excel, Qlikview and Tableau

Web Services: SOAP 1.2 and REST 2.0

Web Technologies: HTML, XML, JavaScript, Angular JS, PHP, Shell Scripting, jQuery

Methodologies: Agile, waterfall and Scrum.

Tools: Eclipse 4.2, SAS, UML Rational Rose, Visio, MS Word, MS Excel, MS Access and MS Project

Web/Application Servers: IBM Web Sphere 6.1, JBoss 3.2.x, Apache Tomcat 6.0, Microsoft IIS 6.0

Cloud Environments: Azure, AWS and Google Cloud.

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralizedSQLServerdatabases usingSQLServerIntegration Services (SSIS) to overcome transformation constraints.
• Converted Data Transformation Services (DTS) application toSQLServerIntegrated Services (SSIS) as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using ofSQLServerIntegration Services (SSIS). Created Pivot tables using Power Pivot and power Query.
• Worked wif various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse.
• Different data flow and control flow tasks in Business intelligence studios using SSIS.
• Debugged SSIS Packages using Data Viewers and Breakpoints. Used various transformations like derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created Cubes wif Star schema in SSAS and developed SSRS reports based on the cubes.
• Used T-SQLinSQLServer2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages. Preparing Dashboards using calculations, parameters in Tableau.
• Performed Provider analysis and gave useful Insights about deposit details from the PowerBIdashboards. Created report schedules on Tableauserver.
• Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports usingSQLReporting Services (SSRS) for customized and ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model using Report Builder.
• Experience in creating Parameterized reports and Linked reports wif thorough noledge of report serving architecture (Table, chart and matrix report). Created drill down and drill up in worksheets in tableau.
• Designed SSIS Packages to extract, transform, load (ETL) existing data intoSQLServerfrom different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Used Performance Monitor andSQLProfiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting of performance issues which were associated wif Tableau reports.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS wif MSSQLServer.
• Experienced in working wif agile methodology.
• Used Microsoft PowerBIPower Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Worked on PowerBIand prepared dashboards using Tableau to make it more attractive.
• Experienced in Data visualization and Data analyzation using PowerBI.
• Installed On premise data gateway and scheduled daily data refresh in PowerBI.
• Created Calculated Columns and Measures in PowerBIand Excel depending on the requirement using DAX queries.

Environment: MSSQLServer2016/2014,SQLServerIntegration Services (SSIS),SQLServer Reporting Services (SSRS), Business Intelligence Development Studio (BIDS),SQLServerAnalysis Services (SSAS), SVN (source control), Tableau, Informatica, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0/VB.net, VB Script and Windows 2012Server.

Confidential

SQL BI (SSIS, SSAS, SSRS) Developer

Responsibilities:

• Conducted DB management, Performance measurement and Performance tuning for new databases by usingSQLProfiler, Data Engine Tuning Advisor and Index Tuning Wizard.
• Designed Star Schema (identification of facts, measures and dimensions) and Snowflake Schema.
• Development and Creation of Complex Stored Procedures, Triggers and Functions.
• Fine-tuning Stored Procedures to improve the performance by removing the unnecessary cursors.
• Usage of Active Directory to identity management design for providing strong authentication and authorization for internal and external websites.
• Management of T-SQL Views, Cursors, Index statistics, Tables and query optimization using execution plan for tuning the database.
• Implemented different types of constraints on the tables.
• Usage of Try, Catch and error for exception handling.
• Development of physical and logical data modeling tools such as Erwin and ER/Studio.
• Generation of periodic reports based on statistical analysis of data usingSQLServerReporting Services (SSRS).
• Creation of Cross Tab Reports, Drill-down, Drill-through and Sub-Reports using RDL.
• Used PowerBIPower Pivot to develop data analysis prototype, and used Power View, Power Map and Power Pivot to visualize reports.
• Used Microsoft PowerBIPower Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Managed up gradation of DTS packages to SSIS packages.
• Used the SSIS Import/Export, migrate the Heterogeneous Databases such as Access database, Oracle and flat files toSQLserver2014.
• Worked in developing Tabular model for Dashboard and Generating the power view Reports.
• ConfiguredSQLmail agent for sending automatic emails when a SSIS package is failed or succeed.
• Developed multi-dimensional objects (cubes, Dimensions) using SSAS.
• Expert in creating Star schema cubes using SSAS.
• Involved in analyzing, designing, building & testing of OLAP cubes wif SSAS 2014.
• Responsible for maintaining cubes using SSAS and populate cubes wif data.
• Involved in development of ASP.NET/ C# /SQLServerWeb Applications.
• Installed and ConfiguredSQLServerActive/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Configured replication servers and transactional replication between production & standbyserverfor disaster recovery.
• Actively participated in interacted wif users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: SQLserver 2008/2012/2014 Enterprise Edition, SSRS, SSIS, SSAS, PowerBI, .NET Framework, C#, ASP.NET, ADO.NET, Oracle 11g/10g, Visio, MS IIS, XML, MS Excel, Access and Visual Source safe.

Confidential

SQL BI Developer

Responsibilities:

• Extracted data from various sources likeSQLServer2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, wif strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Developed free-form reports using reports using MS-SSRS tool for consulting multiple reports into single report delivered in .pdf format to the power users.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Worked on SSIS (DTS, DTSX) packages for Data Integration Services. Used SSIS to produce a Data Mart for reporting.
• Extensively used System variables and created User-Defined variables for SSIS packages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and developed them onserverusingSQLServerReporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Created reports using stored procedure and experience in building reports on Analysis Services cubes (SSAS).
• Worked wif Report Builder 2.0, Report Models and Ad Hoc reports and worked wif Tableau desktop, Tableauserverand Tableau reader in various versions of Tableau.
• Managing the ReportServercontents wif Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQLServer2012/2008 R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS. SSAS, OLAP, XML, SharePoint, Agile, Visual Studio 2010, .Net Framework 3.5, Window 8

Confidential

SQL BI Developer

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MSSQL Serverby using DTS and SSIS services.
• Created packages in SSIS wif error handling.
• Worked wif different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, ExecuteSQLTask, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors usingSQLServerIntegration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share PointServerwif SSRS and deploying SSRS reports on to Share PointServer.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Provide on call support after reports are deployed to production.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Generate reports wif parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Worked wif development teams in the design of physical databases and in modification.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, and Hierarchies.
• Experience in writing T-SQLscripts, dynamicSQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQLServer2008 Enterprise Edition,SQL, Enterprise manager, Crystal Reports, UML, VB.NET, MS PowerPoint, MS Project, Oracle.

Confidential

SQL BI Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQLin Development and Production environment for SQLServer.
• CreatedSQLscripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked closely wif developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Involved in performance tuning and monitoring of both T-SQLand PL/SQLblocks.
• Wrote T-SQLprocedures to generate DML scripts dat modified database objects dynamically based on user inputs.
• Involved in performance tuning using indexing (Cluster Index, NonCluster index) tables.
• Performance tuning ofSQLqueries and stored procedures usingSQLProfiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Involved in regression testing, evaluating the response times, and resolving the connection pooling issues.

Environment: SQLServer2008, T-SQL, PL/SQL, TOAD, Forms 6i and reports 6i.