SUMMARY

• BI Developer with 5 years’ experience in multiple industries, with experience as Database Developer and Business Intelligence developer using various tools like SSMS, SSIS, SSRS, SSAS, Databases MS SQL Server and MS Access.
• Proficient in designing and data modelling, Data Mapping, Table Normalization, Optimization, Tuning.
• Good knowledge in all phases of Software Development Life Cycle (SDLC). Upgrading and Configuring Microsoft SQL Server. Proficient in SQL Server and T - SQL (DDL and DML).
• Generated ETL Packages, Reports/Dashboards applications.
• Worked in agile and waterfall project methodologies from initial development.
• Development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer

TECHNICAL SKILLS

Operating Systems: Windows XP, Vista,7, Windows Server 2003/2008/R2/2012

Database Packages: SQL Server 2005/2008/R2/2012,2016,2017 MS Access

BI Tools: BIDS/SSDT, SSMS, SSIS/SSAS/SSRS, SharePoint, TFS, Power Pivot, Power View, Power BI

Data Modeling: Erwin, MS Visio

SDLC Methodologies: Waterfall Model, Agile, SCRUM

PROFESSIONAL EXPERIENCE

Confidential - Germantown, MD

BI Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for documenting Data Dictionaries and versioning them
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created stored procedures, views, triggers and constrains to implement the database consistency and integrity.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Created data mapping between source and target using different tools like data profiler, ERWIN and Excel sheet.
• Designed ETL packages to migrate data from different data sources such as Oracle, flat files, and XML files into SQL server.
• Used various SSIS tasks such as Condition Split, Derived Column, etc. to scrub, clean and validate data during staging before loading data into the data warehouse.

Tools: and Technologies: MS SQL Server 2014/2012/2008 R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Enterprise Manager, Windows Server 2003/2008/2012/2104 , DTS, Share Point Portal Server, HTML, XML, C#, .Net

Confidential - Bowie, MD

MS SQL/ BI Developer

Responsibilities:

• Created database tables with various constraints including primary key, foreign key, etc.
• Loaded data from flat data files into SQL Server 2008 database tables using bcp, bulk insert, and table export/import, SSIS package
• Power user of SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Assist with documentation of tasks and processes for business and technical teams use of data quality, metadata, ETL tools.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

Tools: and Technologies: MS SQL Server 2014/2012/2008 R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Enterprise Manager, Windows Server 2003/2008/2012/2104 , DTS, Share Point Portal Server, HTML, XML, C#, .NetASP.NET, Visual Studio 2010/2013/2015 , MS Access, Crystal Reports, MS Excel 2007.

Confidential

SQL /BI Developer

Responsibilities:

• Developed Energy Conservation System including design, data model, ETL creation, Star Schema design, Cube Creation, Dimensional Hierarchies design, writing MDX calculations, writing SSRS and Performance Points reports and dashboards.
• Solved T-SQL query performance issues by checking the execution plan and then rewriting the query or adding missing indexes
• Created T-SQL functions, cursors, views, indexes, stored procedures and triggers.
• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Planned, Defined and Designed data based on business requirement and provided documentation.
• Scheduled and maintained packages by daily, weekly, and monthly using SQL Server Agent in SSMS.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Documented all the work and all the process of integration and reporting services for further references
• Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.

Tools: and Technologies: MS SQL Server 2005/2008, Visual Studio 2005, COM/COM+, VC++, C#, MySQL, Windows 2000, Windows XP, T-SQL, VB.NET, ADO.NET, ASP.NET, Visual SourceSafe, XML, MDM, MDX, Crystal Reports, SSAS, SSRS, ERWIN, Brio.