SUMMARY:

• 7 years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2012/2008 in various domains like Financial, HealthCare, and Telecommunications sector.
• Experience in Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Excellent SQL, T-SQL Development Skills to write Complex Queries involving Multiple Tables & to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views.
• Experience in writing complex SQL queries involving Inner and Outer joins, Temp Tables, Global Temp Tables.
• Proven ability in Performance Tuning (SQL Query/Stored Procedure Tuning), Query Optimization, troubleshooting.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents (BRD) and plans for creating interactive dashboards.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions, for various fact calculations for efficient data visualization in Power BI.
• Comfortable in working with filters/calculated columns/measures/relationships and transformations of Query Editor section.
• Published/shared the reports by creating Content Pack/Sharing the pbix file.
• Utilized Power BI (Power Pivot/View) and DAX functions to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Extensive experience in T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data Warehousing.
• Adept at creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools.
• Experience in Creation, Configuration, Development, and Deployment on various servers of Reports using SSRS.
• Deployed the packages on staging and production. Monitored jobs and supported Azure Data Lake production environment.
• Have good understanding in Dimensional Data Modeling and Cube Development, designing of STAR, SNOWFLAKE Schemas, Partition, Aggregation and Optimization using SSAS

TECHNICAL SKILLS:

MS: SQL Server 2016/2014/2012/2008 , T-SQL, Oracle, Postgres, Snowflake

ETL: SQL Server Integration Services (SSIS), T-SQL using Stored Procedures, Informatica.

BI Tools: POWER BI, SSRS / SSIS, Visual Studio 2008/2013

Version Control Tools: SVN, Git

Languages: C++, PL/SQL, JAVA, SQL, Python.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

SQL/POWER BI DEVELOPER

Responsibilities:

• Involved in SDLC of the project from requirements gathering phase to technical design, development and testing phase.
• Worked extensively in writing and debugging complex stored procedures, views, and defined the constraints on the table columns to prevent data redundancy.
• Created Power Bi Reports in Power BI Desktop with various sources of data Like Excel, Sql server and CSV files as per the User Requirements.
• Designed different types of Visualizations like column chart and pie chart and KPI s and used slicers to filter the data by the user.
• Extensively used the DAX queries to build the Data Model in the backend to create calculated columns and Measures.
• Working with Power BI Service for creating Dashboards and sharing them to business users to monitor the business.
• Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.
• Worked extensively on SSIS packages to implement the data load strategy.
• Involved in designing, developing and testing ETL strategy to populate the data from various source systems feeds using SSIS.
• Created 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.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2016.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

Environment: Power BI Desktop MS SQL Server 2016/2008, DTS, Power BI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, ETL, Red Gate SQL Source Control.

Confidential, Tampa-FL

Sr. SQL/Power BI Developer

Responsibilities:

• Connected to multiple different sources of data and combine them into a data model and build visuals, reports, and shared with other people in the organization.
• Clean and transform data using the built-in Query Editor. To make changes to the data, such as changing a data type, removing columns, or combining data from multiple sources.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS (move two points up).
• Configured the Row-level security (RLS) with Power BI to restrict data access for users.
• Used Refresh Now and Schedule Refresh functionalities to get the updated data from original dataset.
• Created reports and applied filters on the data.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

Environment: Power Bi Desktop, MS SQL Integration Services 2008, SSMS, MS SQL Server 2012, Visual Studio 2013, MS Excel, Informatica.

Confidential

SQL / BI Developer

Responsibilities:

• Created new databases and required tables as per the requirement.
• Created T-SQL queries, stored procedure for faster retrieval of data and to display specific information.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views.
• Designed ETL packages for integrating data from heterogeneous sources like Excel, CSV, Flat file and Text Format data and applied various data transformation like conditional split, look up, derived column, slowly changing dimensions.
• Used check point, Break point and Logging in SSIS to debug and optimize package while developing them.
• Used Event Handlers to run the Send mail task in the background upon failure of SSIS package.
• Evaluated database performance and maintenance duties such as Backup, Restoration are performed by scheduling jobs using SQL Server Job Agent.
• Provided daily support to the client/technical teams for system wide tasks such as monitoring, alerting, testing, bug fixing/problem resolution & documentation.
• Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.
• Troubleshooted reports issues, ETL job failures, optimized query performances.
• Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.
• Used Event handlers to capture the run time error messages by using send mail tasks in the background upon success or failure of a package in SSIS, carried out scheduling and administering of SSIS packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in error handling, creating package configuration and log details using SSIS logging.
• Developed, designed and deployed Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio (BIDS) as per client requirements.
• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio BIDS) as per the client requirements.

Environment: MS SQL Server 2008 (SSMS), MS SQL Server 2012 (SSMS), MS SQL Integration Services, MS Word, Visual Studio 2008, MS Excel.

Confidential

Informatica Developer

Responsibilities:

• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio BIDS) as per the client requirements.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformations, Informatica Repository Manager.
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Involved in developing the mappings by using various transformations like source qualifier, sorter, aggregator, router, filter, lookup, expression etc.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Involved in preparing the Mapping design documents.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Involved in preparing the Unit Test Cases for various mappings and workflows.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Developed workflows by using various tasks like command task, session, decision task and e-mail task.
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs.

Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.