SUMMARY

• Over 7+ years of IT experience as a SQL BI developer that includes migration of data and reports using SQL server 2012/2008R2/2008 and Visual studio 2013/ 2010.
• Proficient with Azure database migration, BLOB storage including disaster recovery.
• Hands on experience working in different industry domain including logistic and shipping, Insurance and health care, Federal client .
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2008/2008R2/2012/2016 with expertise on data normalization.
• Conversant with all phases of the Software Development Life Cycle (SDLC) specially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Proficient in MS SQL Server Always Encrypted utilization; Dynamic Data Masking utilization; JSON Support;
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
• Good working knowledge on languages: C, C#, T-SQL, PL/SQL, JavaScript, Perl, Cosmos.
• Skilled in technical analysis, requirements documentation, project management, customer service, client relationships, mitigation planning, risk management, workflow redesign, data analysis and migration, best practice implementation and cost benefit analysis.
• Highly experienced in report migrations to SSRS, developing Dashboards, Power BI integration and Power BI dashboards.
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

Database: MS SQL Server 2016, 2012, 2008R2, 2008, MS-Access.

SQL Server Tools: SSIS, SSRS, SSAS, SQL Server Management Studio, DTS, SQL Server Business Intelligence Studio.

Source Control: TFS, Tortoise SVN.

Reporting Tools: Power BI, SSRS (SQL Server Reporting Services), Tableau, Crystal Reports.

ETL Tools: SSIS (SQL Server Integration Services)

Operating System: Windows 8.1/ 8/7/Vista/XP/ NT/2000, DOS, Windows Server 2003/2007.

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL BI Developer

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS).
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages. Preparing Dashboards using calculations, parameters in Tableau.
• Performed Provider analysis and gave useful Insights about deposit details from the Power BI dashboards. Created report schedules on Tableau server.
• Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Used Microsoft Power BI to create interactive reports and Dashboards.
• Experienced in Data visualization and Data analyzation using Power BI.
• Installed On premise data gateway and scheduled daily data refresh in Power BI.
• Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model using Report Builder.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), Tableau, SVN (source control), Informatica, Windows 2012 Server.

Confidential - Wellesley MA

SQL/ BI Developer

Responsibilities:

• Used Azure Portal for setting up Disaster Recovery.
• Created and managed Blob storage for automatic backup of databases.
• Geo Replicated databases for security.
• Managed daily Schema changes from Dev to UAT reflection.
• Used SQL Server Analysis Services (SSAS) 2008.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008.
• Created complex reports using Gathered requirements from the business users, created technical specification documents.
• Work with XML / JSON (O-data feeds) data and parse them as data elements into SQL server tables to achieve real time data processing.
• Created/modified SQL Joins, subqueries, and other T-SQL implement business rules.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
• Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server 2008.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.

Environment: MS Azure SQL, MS SQL Server, T-SQL, SSRS, SSIS, XML, Json, SQL server 2008/2012/2014 Enterprise Edition, SSRS, SSIS, SSAS, Power BI, MS Excel.

Confidential, Baltimore MD

SQL/ BI Developer

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Migrate reports from Dev to Production.
• Provide on call support after reports are deployed to production.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD and SMO.

Environment: SQL Server 2008 R2, SSIS, SSRS, SSAS, OLAP, OLTP Performance Point Server, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, C#, MS Excel, Windows 2000 Server, T-SQL.

Confidential, El Segundo - CA

SQL Developer

Responsibilities:

• Assist with the integration of a corporate merger by designing couple reports showing system usage to help client understand its reporting system. Inventoried and compared hundreds of reports from both companies that are merging.
• Found the matching reports and gave advice for the creation of new reports to meet both companies' business needs. Led new reporting system development.
• Build the reporting portal for marketing and sales team in CRM. This business intelligence portal includes dashboards and linked detail reports that provide all key information in one place.
• Build the POWER BI Reporting system for client from scratch, which included setting up the Power BI structure, writing stored procedures to get data as reporting source, data modeling, visualization designation and reports, as well as, dashboard developing and publishing.
• Extensive experience in Microsoft T-SQL/PL-SQL statements (DDL and DML) including features like Temporary Tables, Ranking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
• Be responsible for requirements gathering, analysis, design, implementation, validation and maintenance of ad-hoc and automated reports focused on understanding product usage and core business operations.
• Work closely with executive management, product, finance, customer success, and other business functions to understand requirements and provide insightful dashboards, reports, data visualizations, and metrics.
• Construct dashboards and reports to provide key insights and metrics, using a variety of reporting tools (e.g., Power BI, Excel, Tableau, etc.) depending on the needs of the project.

Environment: MS SQL Server 2008, Integration Services (SSIS), Reporting Services (SSRS), T-SQL, HTML, XML, Power BI, Excel.

Confidential, Virginia Beach, VA

SQL BI Developer

Responsibilities:

• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Perform unit testing at various levels of the ETL.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSRS).
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in Report writing according to business requirement using SSRS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2005, MS Access, DBMS, SSRS, SSIS, T-SQL, ASP.NET, C# .NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL.