We provide IT Staff Augmentation Services!

Bi Developer Resume

4.00/5 (Submit Your Rating)

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.

We'd love your feedback!