SUMMARY

• Specialized SQL/BI Developer with 7+ years of experience in reporting with strong skills in SQL development, SQL Server, data warehousing in domains such as finance, logistics, insurance, and retail.
• 3+ Years of hands on experience as Business Intelligence Analyst creating beautiful and intuitive visualizations, proficient with Power BI, and QlikView.
• Experience in creating SSIS packages, migrating DTS Packages to SSIS, data extraction from various data sources using Flat file, Excel, ADO.NET, ODBC, OLEDB connections
• Extensive experience in creating reports such as drill down reports, drill through reports, grouped reports, linked reports, sub reports, matrix reports and chart reports using SQL Server Reporting Services (SSRS).
• Created report snapshots and caches to improve Performance, Deployment and Scheduling of SSRS.
• Firm grasp in designing and building dashboards and reports from a wide array of static as well as dynamic data sources.
• Designed and developed Power BI graphical and visualization solutions with business requirement.
• Extensive use of Data Analysis Expressions (DAX) functions in creating Power BI dashboards, reports and Tabular Models.
• Embedded Power BI reports on front end portal page and managed user level access using roles.
• Expert in data Extraction, Transformation, and Loading (ETL) using SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
• Efficient with Data Manipulation Language (DML), Data Definition Language (DDL) for creating Tables, Stored Procedures, Views, Indexes, User Defined Functions.
• Created stored procedures, functions and packages for moving the data from staging area to data mart.
• Expert in debugging, logging, error handling and event handling for SSIS Packages.
• Expertise in problem - solving and trouble-shooting capabilities, creating and implementation of Key Performance Indicator (KPI)s as per business requirements.
• Proficient in using SSIS Control Flow tasks, Containers, Data Flow tasks, Transformations, Database administration tasks, Event Handlers, logging.
• Proficient in requirement gathering, Gap Analysis and Root Cause Analysis (RCA).
• Adept in deploying SSIS projects using integration services catalogs and SQL Server Agent and deploying SSRS projects to production servers.
• Experience in Data modeling, Data mining, Dimensional modeling (Star Schema, Snowflake) for data movement, data cleansing and data integrity processes.
• Quick learning capability, delivering solutions as an individual and a good team player.
• Having a zeal for reporting, out of the box thinking competence.
• Good understanding and exposure to Software Development Life Cycle (SDLC) methods like Water and Agile, Process Documentation, Data Organization, System Documentation, and Report Writing.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server, Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2016/2014/2012/2008 ), MS Access, MS Excel, Crystal Reports, Business Objects 4.0

Database: MS SQL Server 2016/2014/2012/2008 R2/2008, MS Access, Oracle 9i/8i

Programming Languages: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML and CSS

Operating Systems: Windows (10/8/7/Vista/XP), Windows 2015/2012/2008 Server

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, MS Azure, Power BI, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE

Sr. MSBI Developer

Confidential, Jeffersonville, IN

Responsibilities:

• Designed SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task etc. to extract data from disparate sources (SQL server, Oracle, Access and Excel) to generate underlying data for the reports.
• Designed, developed, implemented, tested, and supported solutions using SSIS functionality.
• Developed T-SQL query, stored procedures and functions to retrieve data for reporting.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Exported data from SSRS report to several file formats likes PDF and Excel according to the needs of management.
• Enhanced the Reports by updating the embedded Scripts in SSRS to the Stored Procedures Improved the Performance of SSRS reports by optimizing data sets, making use of report caching and snapshots.
• Created dashboard style of layouts using different components of SSRS like List-boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Developed several BI applications using SSIS platform connecting to and integrating data from several databases using an ETL load script and standard expressions for calculated dimensions on charts and tables
• Responsible for all DB work including: Stored Procedures, SQL statements, views, DTS, scheduling DTS packages.
• Extracted information from disparate data sources like excel files, OLEDB, flat files, etc. by using different scripts like add, concatenate, resident, concatenate etc.
• Work with the development team to produce a data model that will support the team to prototype, test, and debug reports to meet business requirements
• Created and executed test plans/scripts to find errors and confirm reports meet specifications
• Provided technical assistance with troubleshooting reports/cubes by responding to inquiries and questions
• Designed and implemented comprehensive Backup and Restore Strategy for point in time recovery and prepared documentation for Disaster Recovery Plan.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Lead offshore meetings and tracking the status by weekly.

Environment: SQL Server 2017, Microsoft Visual studio 2017, Clear Case 7.1, MS SQL Server Integration/Reporting Services (SSIS/SSRS), C#, .Net, Power BI, Eclipse, Jira

MSBI Developer

Confidential | Boston, MA

Responsibilities:

• Designed Recon Dashboard using Lists, Rectangles, Indicators, and Gauges, created page breaks, formatting the report, sorted the report data in SSRS.
• Conducted business process analysis and identify key issues, gaps and needs for an established multi-unit custom application covering Tax users.
• Created logical and physical design of database and database objects to fit new business requirement and implemented new design into SQL server.
• Created SSIS packages with Flat file, Excel connections, SQL stored procedures implementing logic, used derived column transformation for converting data types.
• Used For Each Loop Container to loop through the files and archived using FTP task after data load to stage tables.
• Took advantage of Oracle Antiunity Provider to connect to ISW database, wrote numerous PLSQL queries for loading reconciliation data.
• Created numerous SSIS (ETL) packages involving Control Flow, Containers and Data Flow Tasks, Email alerts.
• Automating the SSIS package execution, Debugging, Error Handling, SQL Stored Procedure and package performance tuning.
• Developed custom reports and deployed them on server using Power BI.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Sending Email notifications in case of failed recon execution and success execution of each recon.
• Involved in DB Admin task like granting and revoking permissions on Master Dashboard table to users.
• Restricted data for users using Row level security and user filters.
• Descriptive and Exploratory data analysis and presented the visuals.
• Developed enterprise level Sales reports and Dashboards using Power Bi Desktop and published to Service.
• Enabled filters, parameters and slicers for dashboards and reports and created and configured Power Bi gateway and given permissions to end users in Power Bi Service.
• Developed Tableau workbooks and dashboards using Tableau Desktop.
• In SSRS created, scheduled delivery and optimized performance of interactive parameterized reports.
• Developed ad-hoc reports using Report Builder, deploying and scheduling the report delivery.
• Involved in Database Objects Migration from Oracle to SQL Server and Database admin tasks by collaborating with IT and operations team.
• Provided technical support and guidance to staff and clients, documenting the reconciliation project.
• Lead offshore meetings and tracking the status by weekly.

Environment: SQL Server 2017, Microsoft Visual studio 2017, Clear Case 7.1, MS SQL Server Integration/Reporting Services (SSIS/SSRS), C#, .Net. Power BI, Cosmos

SQL/BI Developer

Confidential

Responsibilities:

• Designed the database objects to serve business need.
• Created SSIS (ETL) packages with .NET Framework Data Provider connection, involving Control Flow and Data Flow Tasks, wrote SQL stored procedures implementing logic and data cleansing, Event handling.
• Optimized the performance of SSIS package and SQL stored Procedures for better package execution.
• Using SSAS created Data source, Data Source views (Star Schema), Named Calculations, defined relationship between the tables.
• Created Dimensions, attributes, relationship between attributes and hierarchies, measures and measure group.
• Created and processed complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, raised change requests by making changes to the SSAS cube as per the requirement.
• Created Key performance indicators (KPI’s), Partitions, Aggregations serving the business need.
• Connected Live to Sales and GMDSS Cube and published Matrix report with slicers and filters to the Power Bi Service workspace
• Edited the queries by applying custom steps and transformed the data using power query to fit to the business need during the data load.
• Managed the Relationships between the datasets in power bi with cardinality many to 1 and 1 to many and applied cross filter.
• Worked with various R Data manipulation, Data Access and Regression functions and loaded data into power bi cache and created various visualizations using various Graphics functions to plot the data.
• Sorted the data, edited interactions and enabled Drill down & Drill Up functionality in the reports.
• Created App Workspace in Power Bi Service and given access to the Business Users to view the published content.
• Downloaded, Installed the Power Bi Gateway and configured the data sources in the datasets for setting up scheduled refresh.
• Worked closely on training business users on Power Bi Desktop, Power Bi Service and Power Bi Mobile Application.
• Involved in creating Data Mining structures, mining models, defining Data types, content types using Data mining wizard also wrote Data mining expressions.
• Participated in status meetings, updating the project progress and involved in documentation.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Microsoft SQL Server 2017, T-SQL, SSMS, SSIS, SSAS, Microsoft Dynamics CRM, SAP SD, SAP BO (Webi), Data Mining Wizard, MS Excel, Word, Power BI, GIT.

SQL Server Developer

Confidential

Responsibilities:

• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Data Automation Using SSIS to automate data processes for input of information
• Published Power BI reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Rendered and responsible for subscription of reports daily, weekly and monthly using SSRS.
• Involved in migration of reports from Crystal reports to SSRS.
• Worked on tableau desktop version to create some Dashboards.
• Day to day administration of the Team Foundation Server in support of various development teams
• Used TFS for consolidated, integrated location for all work items (e.g. requirements, change requests, defects or tasks).
• Wrote T-SQL Scripts and performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for the transformations.
• Performed data cleansing techniques using look-ups, conditional splits, ranks and partitions.
• Tested SQL Statements using Indexes, stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index-tuning wizard.
• Created SSAS OLAP CUBES and having partition on cubes on yearly bases for good performance, pulled over those data in Excel pivot functionality sheet as per client requirement.

Environment: MS SQL Server 2008/2012 Enterprise Edition, SSIS, SSRS, T-SQL, SSAS, SQL Profiler, Tableau, Power BI.

SQL/ETL Developer

Confidential

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS .
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning .
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, Tableau.

Sr. Implementation Specialist

Confidential

Responsibilities:

• Analyzed and Designed ETL processes.
• Studied the data requirements and the impact analysis on the existing schema.
• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Collaborated with analysts to decide the ETL methods and overall data flow architecture.
• Monitored/reviewed other ETL programmer’s deliverables on a team share basis to ensure that adherence to uniform application development practices are being followed.
• Normalized and De-normalized entities for the Data Warehouse.
• Created the OLAP database from OLTP tables using SSIS.
• Recognized the fact and dimension tables from the OLAP database.
• Created the structure of the model and cube in MS Analysis Services.
• Reviewed Cube with end user and changed the cube and documentation according to their Requirements.
• Performed quantitative analysis on the data sets according to user requirements
• Generated reports out of cubes according to the business needs.
• Created tabular and matrix reports out of the cubes.
• Automated month, weekly and daily-based reports using report manager and using web applications for Credit card statements.
• Prepared end user documentation, Technical documentation, Dimension map, contact list and published into the Production.
• Wrote MDX queries to access data from OLAP cubes in SSAS.

Environment: SQL Server 2008/2005 Enterprise Edition, Performance Point Server, SSAS, SSIS, XMLA, SharePoint, BIDS, SQL Profiler, OTP