We provide IT Staff Augmentation Services!

Bi Developer Resume

SUMMARY

  • 5+ years of IT experience in database design and development in Microsoft SQL Server Suite of Products.
  • Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2008/2012/2014/2016/2017 .
  • Excellent understanding of data warehousing and ETL processes.
  • Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
  • Experience in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures and triggers.
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Experience in Extraction, Transformation and loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files, XML and Azure SQL using SSIS.
  • Experience on performing Data loads to Staging, Fact tables, Dimension, Data warehouse and Data marts.
  • Experience in Debugging, Error logging, Error Handling and Production support for SSIS.
  • Hands on experience in designing reports using SQL Server Reporting Services (SSRS).
  • Experience of creating SSAS cubes (tabular model); knowledge of dimensional data modeling and manipulation.
  • Efficient in creating complex joins and sub - queries involving multiple tables.
  • Experience with Tableau, Business Objects and Power BI creating reports and dashboard.
  • Experience working on Unix environment and Unix commands.
  • Experience working on C# scripting for ETL automation.
  • Experience on data cleansing for ETL & reporting processes.
  • Good knowledge of System Development Life Cycle (SDLC).
  • Good Team player with the ability to lead, manage and work independently in a time sensitive environment along with excellent communication, presentation, interpersonal and time management skills.

TECHNICAL SKILLS

Database: MS SQL Server 2008/2012/2014/2016/2017 , Oracle 12/11g/10g/9i/8i, Vertica, Teradata, Netezza, Azure SQL

Operating Systems: Windows XP/ Windows Vista, Windows Server 2003/2008/9x /2010, Red Hat Linux

BI Tools: BIDS (2008/2008R2), SSIS 2010/2012/2017 , SSRS, SSAS, Business Objects, Tableau, OBIEE, PowerBI, SharePoint 2013

Application: C/C++, C#, Java, HTML, CSS, Java Script, XML, XSLT, PHP, ASP.Net, VB.NET, Powershell, UNIX, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

  • Requirement gathering and documentation for ETL of all the CTD groups for integration into BOR data warehouse.
  • Development of SSIS packages for extracting, cleansing, transforming and loading of data into target tables.
  • Developed SSIS packages to load data from flat files into BOR data warehouse; used various transformations such as lookup, derived column, aggregate, data conversion, etc.
  • Extensive use of For Loop and For-Each-Loop containers; Use of conditional split, union all, merge, multicast, pivot, unpivot transformation;
  • Experience in SSIS script task and data flow task using T-SQL and C #.
  • Developed SQL scripts as per necessity for ETL process; worked on SQL functions, triggers and indexes.
  • SSIS packages performance tuning using counters, error handling, event handling, re-running of failed packages using checkpoints.
  • Improvement in package performance by configuring the component properties such as MaxConcurrentExecutables, Default Buffer Size, Delay Validation etc.
  • Enhancement of existing SSIS packages as per requirement; Performance tuning of SSIS packages.
  • Maintained log information in text files for tracking errors and package execution status. Created configurations, checkpoints and breakpoints.
  • Worked on generating reports and dashboards in Power BI from multiple data source.
  • Used various sources such as Excel, Web, SQL Server etc to pull data into Power BI and performed data cleansing.
  • Generated various DAX scripts; Worked on generating various measures and measure branching.
  • Worked with offshore team in supporting ETL processes as per necessary.
  • On call generating reports and supporting ETL process.

Environment: MS SQL Server 2017, Visual Studio 2016, Oracle 12.2, BO 14.2, C#, JIRA, Netezza, Power BI, Unix, Informatica, Toad 9.6

Confidential

BI Developer

Responsibilities:

  • Worked with source system developers, technical experts, business owners and users to identify data sources for defining data extraction methodologies.
  • Requirement gathering from customers for automating ETL process, documented, analyzed and implemented the business logic.
  • Developed SSIS packages to automate and supplement the ETL process in creating the dashboard.
  • SSIS development was done between various data sources; Adobe Cloud to Vertica, Mercury to Vertica, Email to Vertica, Vertica to SQL Server, SQL Server to SQL Server, Teradata to Vertica.
  • Enhancement of existing SSIS packages as per team’s and customer’s requirement.
  • Performance tuning of SSIS packages.
  • Developed SQL scripts as per necessity for ETL process.
  • Migration of SSIS code from SQL Server 2008 to 2012.
  • Developed various SQL joins between multiple tables for report generation.
  • Documentation, Code review & ETL training to the team and offshore resources.
  • Developed SQL scripts for data validation; checking duplicates, null values, truncated values, data aggregation.
  • Developed dashboard reports using Tableau & PowerBI.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending
  • Installation and configuration of PowerBI; DAX functions.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Support producing daily dashboard report; it included both ETL process & Reporting.
  • On call on generating daily report and sending it to the customers.
  • Coordinated with offshore team to generate and maintain daily dashboard report.

Environment: MS SQL Server 20012/2014, BIDS, Visual Studio 2012, Vertica, BO, Tableau, PowerBI, PowerShell, C#

Confidential, Fremont CA

BI Developer/SQL Developer

Responsibilities:

  • Collected business requirements from users and documented it; worked with Business Analyst, users and developers on daily basis.
  • Designed best practices document for ETL and Reporting systems; Understanding of BRD and STTM documents.
  • Extracted data from flat files, Oracle, DB2 using SSIS applying all the business rules prior to loading them into SQL Server staging and final target tables in Data Warehouse.
  • Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
  • Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems.
  • ETL support to the team, fix the issue, if not raised the issue to the concerned parties.
  • Developed SQL scripts as per necessity for ETL process; Worked on SQL joins, functions and triggers.
  • Worked with offshore team in navigating ETL issues and fixing those issues.
  • Worked on generating reports in Business Objects; Validation of data in the universe and creating reports.
  • Documented the ETL process and the day-to-day issues, shared with the team; On call support on ETL, when necessary.
  • Created test cases, test plans. Test scripts, System Integration and UAT plan effectively to deliver a quality product.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Designed SSIS Packages for ETL into SQL Server from different environments for the SSAS cubes.
  • Developed new SSAS cubes for reporting purposes from SQL data warehouse.
  • Performed code reviews.
  • Provided production support and maintained production support issues log.

Environment: MS SQL Server 20010/2011, SSAS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server, Query Analyzer, MS- Visual Studio 2005, BO, Tableau

Confidential

SSIS/MS SQL Server Developer

Responsibilities:

  • Developed T-SQL (DDL, DML) queries for creating tables and joins.
  • Performance tuning of SQL codes as per requirements.
  • Developed Stored Procedures, User-defined Functions, Triggers and Views.
  • Created SQL script for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files.
  • Monitored and trouble shoot SQL Server Agent jobs.
  • Raising JIRRA tickets on ETL and SQL errors, issues; Working with developers to fix the issue.
  • Installation and configuration of SQL server 2008.
  • ETL support to the team, fix the issue, if not raised the issue to the concerned parties.
  • Maintenance of errors logs of SSIS packages; Documentation of errors and raised JIRRA to developers.
  • Involved in offshore meetings, gathered requirements and documentation of ETL processes and reporting.
  • Directly worked with manager in establishing daily team meetings and interacting with other teams and business users.
  • Developed scripts using macros on Excel and automated daily data load.
  • Help the team to document various day-to-day activities performed daily and creating weekly status report to be submitted to upper hierarchy on weekly basis.

Hire Now