SUMMARY

• 8+ years of gross experience with major experience in MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query and Power Map)/ Performance Point (on SharePoint), 2+ years of overall experience on Tableau Reports, dashboards, scorecards and strong background in SQL Server 2014/2012/2008R2/2008/2005, stored procedure development and triggers.
• 8+ years of ETL experience in SQL SERVER INTEGRATION SERVICES (SSIS).
• 2+ Years of ETL experience in INFORMATICA Tool (Designer, Workflow manager, Workflow monitor, Repository Manager).
• Extensively worked with clients of Insurance, Healthcare, Financial environments with primary skills on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite to understand business requirements, recommended technical solutions and documented functional requirements.
• Hands on experience in installing, managing, configuring, upgrading, migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2008.
• Experience in data modeling using Kimball methodology.
• Expertise in SQL Server Integration Services (SSIS) ETL, SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2012/2008R2/2008.
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses by Using Informatica Power Center 10.2.0/9.6.
• Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and data flow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
• Created different types of reports such as Conditional, Drill-down, Summary and Sub reports, and formatted them and Performed unit testing at various levels.
• Defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, partition and aggregation using SQL Server Analysis Services.
• Experience in migration of SSRS reports from SQL 2005 to SQL 2008.
• Good experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services ( SSRS) in Business Intelligence Development Studio (BIDS).
• Developed Dashboard Reports using SQL Server Reporting Services, Report Model using Report Builder.
• Rendered reports in CSV, PDF, XML and delivered reports by file share and Email according to schedule.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server.
• Extensive experience in Designing and Developing data warehouse and its component tools for data storage.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports
• Good at using shared and global variables across crystal reports.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database tables.
• Expert in creating Subqueries and Joins for complex queries involving multiple tables and Exception handlers.
• Expert in creating Stored Procedures, Triggers, Views to assist efficient data manipulation and data consistency.
• Experience in designing Database Models using MS Visio and ER-Win
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Databases: MS-SQL Server 2016/ 2014/2012/2008 R2/2008/2005, MongoDB

Languages: T-SQL, HTML, XML, C, Python, C#, PL-SQL

ETL Tools: SQL Server Integration Services (SSIS), DTS, Informatica

Reporting Tools: SQL Server Reporting Services (SSRS), PowerBI, Tableau

SQL Server Tools: SQL Server Management Studio, Business Intelligence Development studio, SQL Profiler, Query Analyzer.

Operating System: Windows 8.1/8/7/vista/XP/2003.

PROFESSIONAL EXPERIENCE

Confidential

Apps Systems Engineer

Responsibilities:

• Being an Application system engineer, I have to be involved in various phases of the software development from designing and writing code, Automated Unit Testing using Red Gate to configuring and deploying of the fully functional application which is used by stakeholders.
• Requirements gathering and analysis, time estimates, preparing design documentation, design reviews, backlog refinement with PO’s, development, testing and deployment of application enhancements, project planning.
• Coordinating with Team leads and architects for technical roadblocks and early resolution.
• Document detail description of stakeholders needs to develop functional and technical specification.
• Developing ETL solutions using SSIS .
• Developing .NET API’S to post and consume data from heterogeneous systems.
• Deploying, Configuring, troubleshooting and maintaining SQL Server Jobs and SSIS Packages.
• Conducting and Coordinating design validation sessions across the team.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints .
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task .
• Imported data from XML Source with dynamic xml files.
• Used TF XML Destination and TF XML Output Destination to create the xml files based on the XSD’s provided with group names .
• Designed SSIS packages to Extract Data from different sources like Flat Files, Excel Files, SQL Server and Transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed SSIS packages using For Each loop in Control Flow to process all excel files within the folder, File System Task to move files into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.
• Following SDLC (Software Development Life Cycle) and Test- Driven Development (TDD)
• Based on the new requests from Stakeholders accommodate the changes into the current ETL process and present transformed data on the reporting server.
• Experience in injecting data from AWS S3-Raw Bucket and loaded into HBASE and Hive by using Informatica BDM IDQ.
• Experience in injecting data from S3-Raw after refining loaded into S3-Refine Bucket in the form of Slices and by using copy Command loaded into Redshift Database.
• By using Informatica BDM refined the data with the scope of delta processing and for the cleansing of the data from S3 Raw to S3 Refine.
• Developing and Deploying SSRS Reports in Reporting Server for Analytical Purpose.
• Creating Visual Dashboards using Tableau.
• Maintaining and managing code from all the development technologies using TFS version control
• Participating in code reviews and code releases using TFS.
• Writing complex SQL Scripts to provide solutions for complex business requirements.
• Tuning the existing application by modifying the existing code base to make it perform better with enhanced features.
• Provide Technical consultation, perform analysis, Design, Programming and supporting the applications and Programs.

Environment: MS SQL Server 2014/2016, SSRS, SSIS, Visual Studio 2015/2017, BIDS, SSDT, MS Office 2017, TFS GIT, SQL Job Agent, Agile Scrum Environment, Oracle, Tableau, MongoDB, Teradata, Microsoft Azure, AWS, INFORMATICA 10.2.0/9.6.

Confidential

SQL BI Developer

Responsibilities:

• Created Archiving model for the current system which has complex data structure.
• Performed Archiving Tasks by creating a new database and moving transactional data to new database to improve the production import and processing performance on SQL SERVER 2012.
• Worked on performance tuning in complex stored procedures that process huge amounts of data.
• Implemented error handling in the existing stored procedures.
• Migrated data from Heterogeneous data sources ( Excel, Flat File and CSV file, X12 EDI files, Oracle ) to SQL server database using ETL -- SQL server integration services (SSIS ) and INFORMATICA.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints .
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task .
• Imported data from XML Source with dynamic xml files.
• Used TF XML Destination and TF XML Output Destination to create the xml files based on the XSD’s provided with group names .
• Created MongoDB database for saving unstructured EDI files(820,835,834) converting files to JSON format.
• Created Web API’s to load data from JSON files to SQL SERVER.
• Created SSRS Reports ( Parameterized, Linked, Drilldown, Drill through ) for reconciliation purpose
• Worked on creating Parameterized reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Performed daily tasks including backup and restore by using SQL server tools.
• Deployed and Generated SSRS reports using the Reporting Services and Report Manager.
• Used Subversion (SVN) and as the SCM tool.
• Used CNR Testing Utility (CTU) for deployment in QA and Production environments.
• Worked on FishEye/Crucible for Code reviews.
• Used TIDAL Enterprise for Scheduling jobs.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used DMVs to identify bottlenecks and resolved them.

Environment: MS SQL Server 2008R2/2012/2014, SSRS, SSIS, SQL profiler, Windows Server 2012/2008, Visual Studio 2010, BIDS, SSDT, MS Office 2013, MondoDB, Visual Studio 2017, SVN, Confluence, CTU, TIDAL, FishEye Crucible, Agile Scrum Environment, PL-SQL.