We provide IT Staff Augmentation Services!

Bi Developer Resume

Germantown, MD

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.

Hire Now