SUMMARY

• SQL server/BI Developer wif over 7 Years of IT Experience in Database and Business Intelligence Technologies wif expertise in SQL Server Database, ETL and Report development using SQL Server 2008/2012/2014/2016, SSRS, SSIS, Tableau and Power BI.
• Experienced in client requirement analysis, logical and physical design (using Erwin, normalization and SQL Server Management Studio), development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintain business applications.
• Expertise in developing reports and dashboards using Microsoft Power BI
• Experience in creating Tiles and Content Packs in Power BI service.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column, optimizing queries wif indexes.
• Performed data migration using import/export, BULK INSERT and BCP between heterogeneous systems and SQL Server Created Alerts and Scheduled SSIS Packages.
• Skilled in creating Cross - Tab, Drill-down and Sub-Report,cascading,parametrized using RDL in SSRS Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
• Good noledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SSAS.
• Hands on experience creating Tableau dashboards and visualizations
• Excellent noledge of all the phases of Software Development Life Cycle (SDLC).
• Good Understanding wif AGILE methodologies like Scrum, Extreme Programming (XP) and Unified Process (USDP).
• Strong Experience in Database Development using SQL Server, Skilled in writing T-SQL scripts and designing databases
• Extensive noledge of SQL reporting, business intelligence and analytics
• Expert in designing and optimizing ETL solutions using SSIS
• Expertise in working wif power BI Service and Power BI Desktop.
• Experience in working wif creating conditional formatting, Filters, calculated columns and measures in Power BI .
• Skilled in testing the reports and performing code review
• Critical thinker and problem-solving skills
• Team player wif good time-management skills, great interpersonal and communication skills

TECHNICAL SKILLS

DBMS: SQL Server 2008/2012/2

Language: T-SQL, HTML, C#.

DataBase Tools: SSMS,Query Analyzer,Database Engine Tuining Advisor(DTA)

Data Modeling Tools: LucidChart, Draw.io, Erwin

Business Intelligence Tools: SSRS, SSIS, SSAS, Visual Studio 2017/2013/2012

Data Visualization Tools: Power BI,Tableau

Cloud Tool: Azure Data Factory

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

SQL and BI/ETL Developer

Responsibilities:

• Analyze business requirements and built conceptual, logical, and physical data models that describe all the data and relationships between the data.
• Evaluated the data structures in the source and enhanced the existing logical and physical database design to fit new business requirement, and implemented new design into SQL Server.
• Developed relational databases and multidimensional OLAP data warehouses.
• Create T-SQL Stored Procedures, User Defined Functions, Indexes, Views, Constraints, Triggers and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs.
• Optimized SQL queries and stored procedure using SQL Profiler and Index Tuining Wizard.
• Create queries to provide ad hoc reports, analysis, and datasets based on business needs.
• Designed ETL packages dealing wif different data sources (SQLServer, Flat Files, and XMLs etc.) and load the data into target data sources by performing different kinds of transformations usingSQLServer Integration Services (SSIS).
• Worked on different types of Power BI visualizations like Charts, Bubbles Maps, Tree Map, KPI, GAUGE, SLICERS etc.
• Experience of viewing dashboards in Power BI Mobile version.
• Good experience on generating reports like Bar Chart, Column Chart and Water fall chart, Sub report and Navigation reports using Power BI .
• Built and deploy SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion
• Worked on updating and maintaining customer information using Slowly Changing Dimension for address and last name changes using SSIS.
• Worked on SSIS logging, Error Handling and Package configurations.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Involved in testing, bug fixing and documentation for the project. successful completion of scheduled Jobs.
• Worked on Azure, has created pipelines in Azure Data Facotory to move data from on premises to cloud.

Confidential, Germantown, MD

SQL and BI/ETL Developer

Responsibilities:

• Created complex stored procedures and functions to support efficient data manipulation
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Built and deployed SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships
• Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using SSIS.
• Perform data analysis, including data profiling, to obtain a good understanding of data availability, relationships and nuances for consideration of BI solution design.
• Performed intermediate queries using SQL, including Inner/Outer/Left Joins and Union/Intersect.
• Pulled data from existing customer databases using views built in SQL Server, Excel and csv flat files.
• Created Complex ETL Packages usingSSISto extract data from staging tables to partitioned tables wif incremental load using Visual Studio.
• Worked on SSIS logging, Error Handling and Package configurations.
• Ensured processes and project plans implemented and used by the end user customers.
• Worked on SSIS logging, Error Handling and Package configurations.
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.
• Designed snowflake and star schemas for customer summaries.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Created many complex ad hoc reports like Tabular report, parameter report, drill through, and drill down reports in SSRS.
• Involved in performing Audits and recovery operations of SSAS objects

Confidential, Washington, DC

SQL Developer

Responsibilities:

• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task
• Performed Data Modeling and Developed logical and physical model using Erwin and implementing them to SQL server. Designed database, tables and views structure for the application.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Created and modified existing stored procedures, triggers, views, indexes.
• Design Change Data Capture (CDC) to capture insert, update, delete activities applied to SQL server tables, and to make the details of the change available in an easily.
• Creating table indexes and constraints to ensure data integrity and enhance query processing.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel etc.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Extensively used SSRS to design and subscribe Drill Down, Drill Through, Matrix, Cascading parameterized reports to present the billing detail and sale performance of departments and shared them in SharePoint.
• Designed reports subscription schedule for managers.
• Standardized reporting formats and statistical analysis methodologies

Confidential 

SQL and ETL Developer

Responsibilities:

• Attending daily scrum meetings and gather requirements and work user stories.
• Participated in the complete requirement analysis in all phases of development.
• Involved in design, coding and testing phases of software development and database related activities.
• Keep the project manager informed of the task accomplishment, issues and status.
• Provide on-call support to production system to resolve any issues.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Performance tuning of the SSIS packages and SQL Queries.
• Involving deploying and scheduling SSIS package using Control-M (Third Party Tool)
• Data warehouse development, and ETL development best practices maintaining optimal load performance.
• Created system for capturing, reporting, and correcting error data.