Bi Developer Resume
Mclean, VA
SUMMARY
- Overall 8 years of experience in IT Industry as Microsoft SQL Server Database Developer / BI Engineer
- Extensive knowledge in data warehousing, data mart, data visualizing, data analysis, report and dashboard development in Tableau
- Excellent knowledge in creating databases, objects, stored procedures, Triggers, security, Bulk Loading of Data
- Experience in writing scripts in VB script, Python, R script, T - SQL, constructing tables, joins, user functions, views, indexes, triggers, synonyms and user profiles
- Proficient working with MS SQL Server and MS BI Suite (SSIS, SSAS, SSRS), Data Visualization, Data warehouse and data mining techniques
- Exposure working with Database installation, configuration, monitoring, patching, cloning, backup and recovery
- Strong expertise in ETL (Extracting, Transforming and Loading) development using SSIS for migration of data between legacy systems, ERP to SQL Server 2000/2005/2008
- Diversified experience in implementation Business objects report management with in Finance, Health Pharmaceutical, Energy and Insurance sectors
- Involved in all the phases of the project life cycle with Scrum and Agile methodologies
TECHNICAL SKILLS
Business Intelligence: MS BI Suite (SSIS, SSAS, SSRS), Power BI, Informatica, Teradata, Tableau, Report Builder
Scripting: Python, VB Script, R Script, Perl, JavaScript(Angular)
ERP: Oracle EBS and JDE
Software Development Life Cycles: Waterfall, Agile, Scrum, XP, Lean and Kanban
Concepts: Relational Database Management System (RDBMS), Data Analysis, Reporting, and Dashboard creation
Database: MS SQL Server 2000/20, MS Access 1997/2000/2007 , MySQL, Oracle
Programming: ANSI SQL, T-SQL, Oracle PL/SQL, PostgreSQL, Java, C#, HTML, CSS, XML
Data Modelling: Erwin, MS Visio; Development Tools SSDT, SSMS
Project Management Tools: SharePoint, MS Project, JIRA, Confluence, CA Technologies (aka Rally)
Source Control: Team Foundation Server (TFS), GIT, SVN, Jenkins
Cloud: Microsoft Azure Services (PaaS and IaaS), Azure Storages (BLOB, Tables, Queues), Azure Data Factory
PROFESSIONAL EXPERIENCE
BI Developer
Confidential, McLean, VA
Responsibilities:
- Involved in project planning meeting with Project Manager, Business Analyst and Team members to analyze the business requirements and outlined the proposed solutions.
- Participated in daily stand-up meetings and estimated work product backlogs
- Created analytical reports and dashboards utilizing Tableau.
- Created logical and physical data models using the Erwin data modeler tool.
- Extracted data from internal data warehouse system to SSRS, created ad-hoc reports
- Developed various operational Drill-through and Drill-down reports using SSRS
- Developed different kind of SSRS reports such a Sub Reports, Charts, Matrix reports.
- Used Reporting service (SSRS) to publish data to the end user via HTML, PDF, Excel, and CSV formats
- Responsible for identifying sources, creating a staging database, and data warehouse dimensional modeling.
- Implemented normalization and de-normalization of existing tables wherever needed for faster query processing.
- Working on analyzing Hadoop clusters using Big Data Analytic tools including Map Reduce, Pig and Hive.
- Created frameworks for processing data pipelines through Spark
- Written SQL, VB Scripts to perform data validation post data load process.
- Performed data analysis as well using R scripts and Python
- Implemented SQL queries into stored procedures utilizing execution plan and indexes for better performance.
- Identified types of slowly changing dimensions required for the data mart.
- Maintained data integrity by creating various integrity constraints.
- Managed ETL for extraction, transformation, and loading of data to the destination database.
- Developed mappings utilizing SSIS to transform data from multiple sources: Excel, Flat File, and SQL Server OLTP.
- Implemented SSIS packages with loggings and event handlers for error handling.
- Worked on implementing transactions for billing details and checkpoints in the packages for optimizing the performance.
- Developed and modified Business Objects Universes, classes, subclasses, objects, created filters, predefined conditions, universe connections, exported to BOE XI
- Developed complex reports, sub-reports with multiple data sources using crystal, exported them to info view.
- Restructured ETL packages with optimized queries and proper transformations for faster data loading.
- Generated parameterized, cascading parameterized, drill down, and drill through reports.
- Delivered on-demand reports in different rendering formats with standard and data driven subscriptions.
- Optimized embedded queries or stored procedures that generate reports.
- Deployed SSIS packages from the development server to production server utilizing project deployment model.
- Configured database server on the cloud for required users per business requirement.
- Worked with the azure team for loading dimension tables, and loading fact tables in Microsoft Azure environment.
- Migrated SQL 2012 on premise databases on cloud utilizing SQL Server Azure (PaaS).
Environment: SQL Server 2012, SSIS, SSRS, SSMS, SSDT, MS Visio, Erwin, TFS, SQL Azure Database, Azure Storages, Tableau.
SQL BI Developer
Confidential, Redwood City, CA
Responsibilities:
- Collaborated with the design architect and business analyst to outline business requirements in JRD meetings.
- Participated in JAD meetings and documented functional requirements of the project.
- Designed logical database model for OLTP utilizing ER Win.
- Data migration from existing data stores to Hadoop.
- Used Kafka and Spark for real time processing.
- Implemented business logic with the creation of DBOs such as procedures, functions, and tables.
- Developed procedures and functions with temporary objects such as temp tables, table variables, and CTEs.
- Created covering indexes on tables to avoid bookmarks, RIDs, and key lookup execution plan operators.
- Audited DML operations on tables with sensitive data utilizing DML triggers.
- Managed the ETL process (extraction, transformation, and loading to the data warehouse).
- Created SSIS packages for loading data from multiple SQL Server and flat files.
- Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
- Used various report items like tables, sub report and charts to develop the reports in SSRS.
- Retrieved incremental data utilizing CDC (change data capture) techniques.
- Implemented SSIS packages utilizing checkpoints, logs, breakpoints, and transaction options.
- Improved ETL packages with query optimizations and procedures used as sources.
- Implemented parameters to configure package properties for dynamic executions.
- Designed and developed SSAS cubes with KPIs, aggregations, calculated members, and partitions for reporting.
- Customized roles and KPIs using multi-dimensional expressions (MDX).
- Optimized cubes by assigning appropriate storage modes to partitions, improving query performance.
- Identified all columns required for generating reports in multiple tables from OLAP sources.
- Designed a user interface for dashboards with Power BI.
- Managed DBOs, SSIS packages, and reports on Team Foundation Server (TFS).
Environment: Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSIS, SSRS, SSAS, Erwin, Power BI, SharePoint, TFS, DTA, SQL Profiler
SQL/SSRS Developer
Confidential, San Diego, CA
Responsibilities:
- Gathered business requirements to facilitate the planning and implementation phases of the data warehouse.
- Analyzed historical data and extracted required data to support management decisions.
- Created stored procedures and complex queries.
- Implemented SQL profiler to find inefficient queries and deadlocks.
- Tuned SQL queries utilizing show plans and execution plan to improve performance.
- Performed data profiling of source systems and developed data mapping for data migration.
- Developed SSRS report models to create ad hoc reports utilizing report builder.
- Wrote queries for drill down reports to get required datasets for reports.
- Developed automated report subscription processes with SSRS.
- Applied conditional formatting in SSRS to highlight key areas in report data.
- Supported the logging framework to identify trends utilizing TFS.
Environment: SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, SQL Profiler, MS Visual Studio, MS Excel, TFS
SQL Server/BI Developer
Confidential
Responsibilities:
- Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
- Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2005 and ASP.Net.
- Implemented transactional replication among different servers to have high availability of the data.
- Created DDL, DML scripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.
- Created views/indexed views consisting of computed columns to facilitate easy user interface.
- Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
- Done High-Level Design of ETL using transformations in SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat files, Text Format Data).
- Developed multi-dimensional databases (MDDB), OLAP cubes and data marts using SQL Server Analysis Services (SSAS) that stored and maintained the data.
- Provided technical guidance and support to end-users by developing documentations required.
- Performed final verification procedure for SQL release to the production environment.
- Documented all database changes, followed and enforced change and release management processes.
Environment: SQL Server 2008 R 2/2008/2005/2000 , Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2003 Server, Visual Basic .Net, Query Analyzer, SQL Server Profiler.
