PROFESSIONAL SUMMARY:

• Over 8 years of IT working experience in SQL Server database development and data warehouse development performed in various enterprise environment.
• Experience in Analysis, Design, Development, Testing and Implementation of Business applications and Client/Server applications.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Have excellent skills in Data Warehouse: Relational and Multi-Dimensional databases: Data Migration: System & Data Integration, Reporting: Analysis and Software Development and Data Management.
• Experienced in developing implementing: documenting: monitoring and maintain the data warehouse extracts: transformations and ETL process in various industries like Financial: Health Care: Retail etc.
• Extensive professional experience in design: development: implementation and support of mission-critical Business Intelligence (BI) applications.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Good in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in working on version control systems like Subversion, and GIT.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Extensive experience in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts, Drill Down, Cascading, Parameterized, Sub reports.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Extensively worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

TECHNICAL SKILLS:

Databases: SQL Server (2008 R2/2016), Oracle 8i/9i, Oracle 10g/9i DB2, Postgre MS Access, NoSQL Databases (HBase), Teradata.

Database Tools: MS SQL Server (2008 R2/2012, 2016), MS-Access, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS), Firebird.

Development Skills: T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI, Tableau, Microsoft Azure

Languages: VB.net, C#, SQL, PL/SQL, HTML

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

Reporting Packages: SQL Server Reporting Services, MS Excel.

Tools/ Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall

PROFESSIONAL EXPERIENCE:

SSIS/SSRS /POWER BI Developer

Confidential, New York

Responsibilities:

• Installed SQL Server 2012 on Development and Production Servers, Setting up databases, users, roles and permissions.
• Involved in gathering the user requirements.
• Developed reports using Microsoft Power BI (Desktop, Service, Mobile)
• Developed SSIS Packages for integrating data using OLEDB connection from heterogeneous sources.
• Used multiple transformations provided by SSIS such as Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge and union all, etc.
• Performed error handling in SSIS using Event Handling and logging.
• Developed calculated columns and measures using DAX in Power BI
• Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non-blocking, semi blocking components over blocking components, dropping and rebuilding the indexes during the SSIS package run.
• Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
• Created data visualizations using various visual objects and Published reports and dashboards to the Power BI service through the Office 365 integration.
• Implemented row level security by restricting the users for the data access.
• Created Content packs that package up a dashboard, report, and dataset to send to specified team.
• Incorporated Power Pivot/View to create analytical reports/dashboards from tabular and multidimensional models.
• Developed dashboards with Power BI which display key KPIs for business analysis and decision making.
• Developed SQL queries for data migration and Reporting Services. (SSRS)
• Visualized data using Power BI, implemented SSIS business intelligence life cycle such as SSIS package configuration ( XML Configuration, SQL Server, Environment variable, Parent Package Variable), Deployment, Scheduling packages in Development, Test, Production environments.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Troubleshoot problems using SQL Profiler.
• Experience in writing T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins for Data Integrity and normalization.
• Hands-on experience working with issues relating Transactional replication.
• Used system monitor to find bottlenecks in CPU, disk I/O and memory devices and improved the performance.
• Worked with business owners and analysts to define and implement new requirements for a more scalable and stable data processing application.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Worked on SSRS to generate hierarchical reports, drill down and drill through reports and tested using Management Studio in SQL server 2012/2014.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS)
• Provided visual/graphic analysis based on data content.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using SSRS and deployed them in Native mode.
• Monitor database performance and analyze issues, primarily with Microsoft SQL Server 2012/2014.
• Customized columns and tables utilizing Named calculations and Named queries in SSAS.

Environment: Microsoft SQL Server 2012/2014, Power BI (Power Query, Power Pivot), Power BI Dashboard, T-SQL, Agile Methodology, SQL Server Integration Services 2012(SSIS), SQL Reporting Services 2012 (SSRS), Microsoft Azure, MYSQL Workbench, SQL Server Analysis services 2012 (SSAS), Crystals Reports 2011, Microsoft Excel 2016.

SQL Server BI Developer /Power BI

Confidential, Beaverton, Oregon

Responsibilities:

• Created SSIS package to load data from Flat Files and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS -2012.
• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
• Created reports to retrieve data using stored procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring and Tuning Report performance.
• Modified numerous reports/stored procedures that were not performing properly (slow response time, inconsistent results, poor format of the actual report).
• Converted query-based crystal Reports to query/stored procedure based SSRS Reports.
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/ SQL Developer and SQL * plus.
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented stored procedures and Triggers for automating tasks.

Environment: MS SQL Server 2012/2008, SSIS, T-SQL, PL/SQL, SSRS, BIDS, Win 2008 Advanced Server, VSS, SQL Profiler, Database Engine Tuning Advisor, DTS, VB script, Erwin v7.3.

MS SQL Developer/ MSBI Developer

Confidential, San Francisco, CA

Responsibilities:

• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each member, zone, and region and nationally to gauge system performance using the Tableau.
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.
• Created series of signboard and dashboard reports, built for a new process being built in Horizon.
• Created & maintained data sources in Cognos connection and used Framework manager’s best practices to create models, publish packages, designed several reports using Cognos Report Studio on EDW environment.
• Created complex data Views manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Validated the reports before publishing reports to server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created Sets, Groups and Data Bins as per user requirements. Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Developed Custom SQL scripts to view required claim data in developed dashboards
• Optimized SQL scripts to improve the efficiency on the database.
• Involved in performance tuning for tableau Dashboards.
• Define / Develop SQL queries, Stored Procedures, and data mining as necessary in collaboration with the Database developer and BI Team as needed
• Developed transformation logic and designed various Complex Mappings using the Designer
• Extensively used SQL to analyze the data.

Environment: Microsoft SQL Server 2012/2014, Periscope Dashboards, PL/SQL, Agile Methodology, SQL Server Integration Services 2012(SSIS), Cognos.8.X, Tableau Desktop 8.X, 7.X, Tableau server / Administrator, Informatica Power Center 9.1, SQL, Microsoft Azure.

SQL Server Developer/SSIS

Confidential

Responsibilities:

• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each member, zone, and region and nationally to gauge system performance using the Tableau.
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.
• Created series of signboard and dashboard reports, built for a new process being built in Horizon.
• Created & maintained data sources in Cognos connection and used Framework manager’s best practices to create models, publish packages, designed several reports using Cognos Report Studio on EDW environment.
• Created complex data Views manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Validated the reports before publishing reports to server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Developed Custom SQL scripts to view required claim data in developed dashboards
• Optimized SQL scripts to improve the efficiency on the database.
• Involved in performance tuning for tableau Dashboards.
• Define / Develop SQL queries, Stored Procedures, and data mining as necessary in collaboration with the Database developer and BI Team as needed
• Developed transformation logic and designed various Complex Mappings using the Designer
• Extensively used SQL to analyze the data.

Environment: SQLServer 2008R2, SSIS, Power shell,SQLProfiler, Database Engine Tuning Advisor, DTS, VB script, MS Access, T-SQL.

MS SQL Server Developer

Confidential

Responsibilities:

• Effectively interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling .
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilt Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery .
• Worked on Documentation using MS word.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.

Environment: Windows 2000 Server SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.