SUMMARY

• Over 6 years of IT experience in Designing, Developing and Implementation of Integration, Analysis and Reporting projects using SQL Server, SSIS, Power BI and Tableau.
• Strong Analytical and problem - solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Involved in all phases of Software Development Life Cycle using Agile Methodology.
• Expertise in using Microsoft BI suite: SQL Server Integration Services (SSIS).
• Good Programming knowledge on SQL, C#, Python, R Script and VBA.
• Good working knowledge on Cloud Technologies Azure, AWS.
• Good knowledge on Relational Database Management System (RDBMS), OLTP and OLAP concepts, Data Migration, Data Analysis.
• Expert in developing Confidential -SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Hands on implementing ETL process using SQL Server Integration Services (SSIS).
• Expert in creating Stored Procedures, Functions, Tables, Views, Scripts, Indexes, Triggers, SQL Jobs and Transaction Analysis.
• Excellent in High Level Design of ETL Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Knowledge in working with SSAS in creating Data cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Designed and developed ETL packages (SSIS) with variables, parameters, and expressions and scheduling SSIS packages in SQL agent to load data to data warehouse or OLTP database using error handling, logging and deploying methodologies.
• Strong experience in creating tables, writing complex SQL Queries using functions, stored procedures, cursors, Indexes, joins, triggers, views in T-SQL for optimum performance.
• Experience in checking data quality using SQL/Integration Services, identifying errors and error patterns, and suggesting some data cleansing mechanisms.
• Experience in debug, maintenance of ETL packages and ETL optimization using SQL Server best practices.
• Experience in OLTP/OLAP system study, Analysis and modelling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modelling.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), POWER BI, Tableau, Business Objects, EXCEL services.
• Good knowledge on SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports and Crystal Reports with thorough knowledge of report service architecture. (Table, chart and matrix report) using SSRS.
• Strong Knowledge in using Reporting service to deliver output according to client requirements, Dashboards, scorecards, Graphical Reports.

TECHNICAL SKILLS

BI Tools: SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Service (SSIS), SQL Server Analytical Services (SSAS).

Databases: SQL Server 2008/2008R2/2012,2014,2016, Oracle 11g, 10g

Designing Tools: Visio, Microsoft Power Point

Reporting Tools: Excel, SQL Server Reporting Services, Power BI, Tableau, SAS, Business Objects

Languages: C++, SQL, Confidential -SQL, PL/SQL, C#, Python, VBA, R Script

PROFESSIONAL EXPERIENCE

Confidential, Mt Laurel Township, NJ

SQL Developer/ Report Developer

Responsibilities:

• Wrote and optimized SQL stored procedures related to SSIS package or used in building SSRS reports.
• Daily meeting environment was based on SCRUM/ Agile application development environment.
• Loaded files with different data structures (Flat, CSV, Excel) to database using SSIS tools.
• Involved in data validation documents, created data profiling documents and SOP documents and data mapping document.
• Worked with project lead and users to understand business processes, gathered and documented project requirements and translated them into functional and non-functional specifications for BI reports and applications.
• Involved in performance tuning, index tuning, analysis and optimization of queries and packages.
• Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc.
• Invoked in SQL Server Migration with DBA team, reset parameters in SQL Server jobs and wrote Migration document.
• Wrote SQL Server queries and created SSIS data flow tasks to control data quality such as remove duplicates data, change null values, change data format and change data types.
• Migrated PL/SQL query into SQL SERVER query and created stored procedure for the process.
• Using T-SQL on SQL SERVER 2016 to store data and maintained database efficiently.
• Used SSIS to create ETL packages to validate, Extract, Transform and Load data into Data Warehouse and Data Marts.
• Worked in Extract, Transform and Load (ETL) process framework development using T-SQL programming, scripts, stored procedures, views.
• Involved in implementation of data viewers, SSIS logging, error handling of the packages.
• Get involved in create different data tasks in SSIS packages such as Merge join, look up, merge, union all, multicast, conditional split and control flow tasks such as container, bulk insert, expression task.
• Developed SSIS packages using different types of error handling for various events.
• Using #C in SSIS package to read files, extract zipped files and rename delete files.
• Familiar with FISERV, LKWD and WEB application data and service data.
• Involved in migrating the present SSIS packages in 2014 to SQL Server 2016 environment.
• Used Try catch and @@error for exceptional handling.

Environment: MS SQL Server 2016, Visual Studio 2015, SQL Server Integration Services, MS Excel, MS Access, XML, SSRS

Confidential, NY

SQL Developer/ Report Developer

Responsibilities:

• Work with users, product management and business analysts to understand client requirements and help reach data deliverables.
• Design, develop and deploy Business Intelligence solutions using SSIS.
• Work on the file import framework process for the various flat files structures to get data imported into our database.
• Create databases and schema objects including tables, indexes and applied constraints and written functions, stored procedures and triggers.
• Work on data issues, performance and production problems to find root cause to maintain data and databases correctly.
• Making use of Joins, Procedures, cursors, triggers and extracting data from different tables or Reporting.
• Work on setting up folders and environments for Package creation.
• Created ETL Projects using SSIS 2014 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
• Create SSIS package to pull data from different sources consolidate and merge into one single source.
• Create SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developing and deploying packages by creating new packages or modifying and using existing packages.
• Developed SSIS packages that fetches files from FTP, did transformation on those data base on business need before loaded to destination.
• Schedule jobs accordingly and implement logging functionality in order to get the execution time and start time and end time of the packages.
• Performed Confidential -SQL tuning, Performance Tuning, optimization of queries for reports that took longer execution time using SQL Query.
• Develop complex Stored Procedures and views to generate various Drill-through, Drill Down reports, parameterized reports and linked reports using SSRS.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Experienced in creating multiple kinds of reports in Power BI and present it using Story Points.
• Experience in writing reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power Query, Power View, Power BI.
• Created visualization reports and dashboards using Power BI desktop and published them to the Power BI Service.

Environment: SQL Server 2016/2014/2012 , Visual Studio 2012/2013/2015 , Oracle 11g, 10g, ASP.NET, C#.net, SSIS, SSAS, Confidential -SQL, SSRS, Power BI.

Confidential, Storrs, CT

BI/Report Developer

Responsibilities:

• Worked with Business Analysts and various business units to identify existing report items suitable for Tableau solution and new reporting requirements.
• Conducted reverse engineering on reports that have limited documentations.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups under SCRUM/ Agile Environment.
• Built SSIS ETL packages for processing fact and dimension tables with transforms and slowly changing dimensions to ensure the database platforms are configured, hardened and maintained to capture record changes.
• Designed and built up high performance ETL packages to migrate and manipulate data from Oracle, MS Excel and SQL Server by using SSIS.
• Used various SSIS transformations such as conditional split, derived column for data scrubbing, including data Validation, checks during staging before loading the data into the data warehouse.
• Communicated with all lines of business and management, proactively identified cross functional or technical issues to improve application stability.
• Used SQL Server Reporting services for creating, editing and scheduling various reports
• Created and maintained database objects, created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications.
• Created various reports using SQL Reporting Services.
• Developed complex reports, which are migrated from different reporting tools.
• Created and wrote database objects such as tables, indexes, views, procedures, functions, triggers, SQL code with proper grants to all the users and roles.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting
• SQL performance tuning by modifying SQL or adding/changing indexes.

Environment: MS SQL Server Management System 2012/2014, MS Office 2010, Visual Studio 2014, SQL Server Integration Services (SSIS), Tableau 8/9, SSRS

Confidential

BI/ Report Developer

Responsibilities:

• Gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Designed and built high performance ETL packages to perform filtering operations, to import data from multiple sources.
• Built ETL packages for processing fact and dimension tables to transform slowly changing dimensions to capture record changes and ensure data quality and data consistency.
• Extensively used SSIS components such as Pivot Transformation, Fuzzy Lookup, Derived Columns, Aggregations, Sort, Merge, Joins, Count, Condition Split, Data conversion.
• Deployed SSIS packages to SQL Server and used SQL Server Agent to schedule them to run daily, weekly and monthly as per the requirements and create complex data analysis queries to troubleshoot issues reported by users and support them by automating tasks with reliable SQL queries.
• Created polished and compelling Tableau Dashboards, Reports, Data visualizations and Stories by extracting data from different data sources for executive level usage and for various business functionalities.
• Blended data from multiple sources, used Custom SQL queries in Tableau to join tables and views and created calculated fields, sets, mapping and hierarchies in worksheets for data analysis.
• Developed worksheets and interactive dashboards using various data visualizations like line graphs, histograms, heat maps, Tree maps, Bullet graphs, Box and plot charts, and drill down, drill through reports.
• Used Level of Detail (LOD) expressions and Tableau advanced Analytics features
• Develop storytelling dashboards in Tableau and publish them on Tableau Server allowing business users understand data and constructed quick filter for on demand needed information.
• Implemented data refreshes on Tableau Server for daily, weekly and monthly increments based on business requirements to ensure that the views and dashboards are up to date.

Environment: SQL Server 2012, T-SQL, Tableau 8.x, Tableau Server 8.x, SSAS, SSIS, OLAP, MS Excel, MS Visio.

Confidential

BI/ Report Developer

Responsibilities:

• Developed Stored Procedures, Functions, Indexed Views and DML Triggers to facilitate ETL processes using T-SQL in SSMS.
• Developed ETL packages in SSIS to ensure data quality and data consistency using lookup, Execute SQL Task, Sequence Container, Breakpoint and Checkpoint.
• Included Execute SQL Task in the template to call pre-coded Stored Procedures, integrated Audit Transformation in data flow, and set event handler OnPostExecute, OnPreExecute and OnError events.
• Filtered packages belonging to multiple categories in SQL Server Configuration Table according to naming convention in Configuration Filter.
• Prepared ETL Log Reports and ETL Audit Reports in SQL Server Reporting Services (SSRS) for project manager to check run status of ETL packages such as ETL name, data flow type, start time, finish time, status and error message.
• Wrote documents to show the flow of different processes.
• Wrote data validation document, data mapping documents, data migration documents and stored-procedure flow documents.

Environment: SQL Server 2008 R2, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio