SUMMARY:

• Having 7years of Experience in Data Warehousing and Business Intelligence Applications Design, Development and Maintenance of Integration Services ( SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Expert in Microsoft SQL Server 2008/2012/2014/2016 backend programming, Extensive experience in creating database objects on MS SQL Server 2008/2012/2014/2016/2017.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Programming, Testing and Documentation.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Extensive experience in using different SSIS Transformations e.g. Fuzzy Lookup, Lookup, Derived Columns, Conditional Splits, and Execute SQL Task.
• Experience in SSIS debugging and Error Handling, Precedence Constraints, Break Points, Check Points and Logging.
• Published reports and dashboards to the Power BI service through the Office 365 integration.
• Shared the dashboards among multiple users in the group.
• Extensive knowledge on SSAS Tabular model and DAX studio.
• Adept at defining referenced relationships and calculated members in SSAS and used MDX/DMX and DAX queries.
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SSRS.
• Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
• Expert in uploading SQL Server Reports on to the report manager and organize them in folders and worked with delivering the reports using 'pulled' and 'pushed' methodologies.
• Expertise in ERD modeling Normalization and demoralization concepts.
• Good knowledge about data modeling and worked in dimensional modeling of Data warehouse design concept.

TECHNICAL SKILLS:

SQL Server Tools: SSDT, SSMS, BIDS, Report Builder, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools: Lite Speed, Spotlight, SCOM, SQL secure

ETL & Reporting Tools: SSIS, SSRS, SSAS, Excel 2013, Power View, Power Pivot, PPS, Tableau

Databases: SQL Server 2017/ 2016/2

Programming Languages: SQL,T-SQL,PL/SQL,C,C++,JAVA,C#,VB

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix,MS-DOS

Web technologies: Angular JS,HTML, XML, VBScript, SharePoint 2010,C#,ASP.NET,VB, .NET

Tools: Erwin, VS 2008/2005,Visio,TFS,Visual Source Safe, Sub Version

WORK EXPERIENCE:

Confidential, Atlanta, GA

ETL SSIS Developer

Responsibilities:

• Experience creating SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, 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.
• Performed data cleansing using different transformations within SSIS packages .
• Extracted data using SSIS from OLTP to OLAP systems, identified various data sources and established the connections using SSIS and constructed data source view.
• Implemented error and failure handlings within SSIS packages using event handlers, check points, custom logs to monitor execution.
• Experience in designing and implementing data warehouse and data mart using Microsoft SQL Server 2016/2014 Integration Services, Analysis Services, Reporting Service (SSDT tool)
• Experience with Agile development methodologies.
• Experience in T-SQL programming (DDL, DML) skills like creating Stored Procedures, User Defined Functions, indexes, Views, Tables.
• Experience on design data warehouse tables based on star/snowflake data modeling schema for data reporting and analytics.
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Experience in generating On-demand and Scheduled Reports for business analysis or Management decision using SQL Server Reporting Services.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio.
• Worked on setting up SSRS reports for data driven subscriptions.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions.
• Worked with different types of reports pie chart, bar graph, Semi - pie reports, Table report, matrix report linked reports, click through reports, sub reports and Ad hoc reports.
• Experience in writing complex expressions to calculate, parameterize, group, filter and format the contents of a report for Business users.
• Built different types of reports using Reporting Service (SSRS) for the business requirement.
• Involved in creating new databases, performance tuning, deploying, scheduling and creating reports.
• Configure and maintain Report Manager and Report Server for SSRS.
• Experience in deploying Reports to Report Server and Microsoft Office Share Point Server using SSRS.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: SQL Server 2017 (SSDT) ( SSRS) ( SSIS), FTP, JIRA, WINDOWS 10, VISUAL STUDIO 2017, MS SQL Server 2016, MS Access, Microsoft Team Foundation Server (TFS)

Confidential, Atlanta, GA

SQL/SSIS/SSAS/ POWER BI Developer

Responsibilities:

• Created various database tables and procedures to update and clean the old data.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Implemented various Java/J2EE Design patterns such as Singleton, Business Delegate and Factory based on the business requirement.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts. Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Involved in Tabular Data Warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Created DAX and VB scripts for Excel reporting and calculated members.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Developed Scorecards/Reports for the system using SSRS, Power BI.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created several cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Environment: MS SQL Server 2016/2014/2012 , MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DAX, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Excess, Windows 8, Power BI.

Confidential, Atlanta, GA

SQL/ SSIS/SSRS/SSAS Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Maintained code in TFS through Git-Hub repository and Addressed code review comments in TFS.
• Attended daily scrum meetings and updated the status on User Stories.
• Provided story point estimation for user stories and hours for tasks.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages.
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal.
• Worked in both Waterfall and Agile Methodology.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS.
• Created XML, PDF, EXCEL files using SSRS.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS.
• Used dynamic connection managers using SSIS expressions to load data from different databases into a single DB.
• Developed OLAP cubes using SSAS and calculate the metrics that were revealed in the functional analysis.
• Deploying and troubleshooting the SSIS Packages.
• Developed SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business.
• Create Charts and drill-down chart/reports, Cross-tab report and Sub-Report.
• Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.
• Investigate and optimize reporting system performance by optimizing queries, and using report cache and snapshot.

Environment: MS SQL Server 2012/2008 Business Intelligence Studio ( SSIS, SSRS, SSAS), OLAP, T-SQL, Erwin, MDX, Oracle 10g, XML, MS Excel, Visual Studio 2010/2012.

Confidential, Tampa, FL

SQL/ SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2012/2008 • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2012.
• Expertise in applying correct filters/slicers on the Power BI report based on business need.
• Experience in consulting with IT, Business Users & Business Analysts for building reports and dashboards based their needs.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources (SQL Server, Flat files, and Excel source files) and loaded the data into target tables by performing various kinds of transformations using SSIS.
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Well-versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing Reports from Multi-Dimensional OLAP Cubes.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/Analysis Server (SSAS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created queries for generating drill down reports in SSRS 2012. Formatted the reports using the Global variables, expressions and Functions.
• Created Linked Servers to connect OLE DB data sources and providers.
• Using SSRS for development of reports for Business users from various sources like tables, stored procedures and development of several types of reports.

Environment: Visual Studio 2008, ODBC, Database Engine Tuning Advisor, SQL Server Management Studio, MDX, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, MS SQL Server2012/2008, SSIS, SSRS, Windows 7, Management Studio, Team Foundation Server (TFS), Erwin.