SUMMARY:

• Certified Microsoft BI developer with 6 years of extensive experience in database design, development and administration with MS SQL Server versions 2017/2014/2012/2008 R2/2005 using SSIS, SSRS, and SSAS at financial, health care, academic, and transportation institutions.
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Strong experience in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience in Project Management and Software Development lifecycle including analysis of business functions and requirements.
• Experience with Business Intelligence Development Studio (BIDS)
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimension tables and Operational Data Store (ODS).
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Proficient in Resolving Complex Issues and Error Handling in SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent and SSIS Packages.
• Good understanding of database and data warehousing concepts.
• Basic understanding in the development of Multi - dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Good understanding of the ETL life cycle and the creation of SSIS Packages
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Development and creation of database objects, T-SQL queries, SSRS reports and SSIS packages to meet business needs of the client
• Using Tableau to design and develop interactive dashboard
• Using PowerBI to design and develop interactive and reliable dashboard.

TECHNICAL SKILLS:

Languages, and Scripting: PL/SQL, T-SQL, Java, C#, HTML, XML, CSS

RDMS: SQL Server 2017/ 2016/ 2014/ 2012/2008/2005/2000, IBM DB2, and MySQL

BI and Data Analytics Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SSAS, Power BI and Tableau

Networking: TCP/IP, LAN, WAN topologies, DNS, DHCP

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, Visual Studio

Data modelling tools: Erwin, Toad, Lucid Chart, Visio, Excel

Operating Systems: Windows, Linux

Cloud Environment: Amazon Web Services (AWS), Azure

Virtualization: VMWare, Virtual Box

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring, MD

MS SQL BI ETL developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes.
• Analyzing SQL agent jobs currently in the dev server and working with DBA to migrate it to Prod server
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Used advanced SSIS tools (Derived Columns, Sort, Conditional Split, Look-up Transformation, Aggregations, Multicasting).
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Performance tuning on existing ETL packages.
• Designed various SSRS reports as requested by the client.
• Rendered reports in different formats like pdf, excel etc. Scheduled to be executed automatically on weekly or monthly basis and managed subscriptions.
• Applied security to reports on item and folder level.
• Utilized triggers, linked servers, dynamic coding and job processing.
• Wrote and maintained system documentation.
• Building and deploying SSIS packages across dev and QA environments
• Using bulk insert statements to load xml files into database tables
• Used SQL 2017 and SSIS 2017 to develop queries and data transformation packages
• Used Tableau to create detailed and filter enabled interactive dashboard
• Monitored SQL Server agent scheduled jobs

Environment: SQL Server 2017, MS Excel, Visual Studio 2017

Confidential, Bethesda, MD

BI ETL Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes.
• Developed stored procedures for the reconciliation of QNXT and WEX data
• Analyzing SQL agent jobs currently in the dev server and working with DBA to migrate it to Prod server
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Used advanced SSIS tools (Derived Columns, Sort, Conditional Split, Look-up Transformation, Aggregations, Multicasting).
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Performance tuning on existing ETL packages.
• Designed various SSRS reports as requested by the client.
• Created and developed Sub-Reports, Drill down reports, Drill through reports and Parameterized reports, Matrix reports using SSRS.
• Created Dashboards, Tabular, Matrix reports, Charts, graphs and Gauges as per customer requirements Using SSRS.
• Rendered reports in different formats like pdf, excel etc. Scheduled to be executed automatically on weekly or monthly basis and managed subscriptions.
• Applied security to reports on item and folder level.
• Utilized triggers, linked servers, dynamic coding and job processing.
• Wrote and maintained system documentation.
• Building and deploying SSIS packages across dev and QA environments
• Using bulk insert statements to load xml files into database tables
• Used SQL 2017 and SSIS 2017 to develop queries and data transformation packages
• Used Tableau to create detailed and filter enabled interactive dashboard

Environment: SQL Server 2016, SQL Server 2015, MS Excel, Visual Studio 2015

Confidential, Seattle WA

BI ETL Developer

Responsibilities:

• Involved in performance tuning, deploying, scheduling and creating reports. This included ETL of data from flat file and excels sources using SSIS, writing T-SQL queries and created various operational drill-through and dynamic reports using SSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses and Data Marts using SSIS and DTS.
• Designed and developed Data Marts Using star schema
• Wrote and maintained system documentation.
• Created SSIS Packages by using advanced tools (Derived Columns, Condition Split, Lookup Transformation, Merge Transformation, Sort Transformation, Aggregations, and Multicasting).
• Rendered reports in different formats to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: SQL Server 2008, SQL Server 2008 R2MS Excel, BIDS.