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.