We provide IT Staff Augmentation Services!

Senior Data Warehouse Developer Resume

4.00/5 (Submit Your Rating)

Berkshore, CA

SUMMARY

  • Having 10 years of experience in Database Design, Development, Testing and Production Environments as a BI Developer.
  • Strong experience with Data Warehouse modeling of ER, 3NF, and Dimensional Star Schemas models for BI reporting.
  • Development skills withAzure Data Lake,Azure Data Factory and Azure Databricks.
  • Experience in developing solutions withSnowflake Cloud platform and Mulesoft Anypoint Studio.
  • Strong experience in multiple Data Warehouse concepts (Kimbal, Inmon, Hybrid, Data Vault).
  • Experienced in the full life cycle (SDLC) of Data Warehouse - design and implementation, and ETL development and support.
  • Strong experience of designing Star Schema and created Fact and Dimension tables for the Data Warehouse using Erwin, MS Visio and ER/Studio.
  • Proficient in ETL processes for Data Conversion using Integration Services (SSIS).
  • Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server 2000, Oracle Database, Excel and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server 2005/2008 R2/2012.
  • Experienced in implementing Slowly Changing Dimension wizard and Check Sum Transformation to load data into slowly changing dimensions in Data Warehouse.
  • Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • Expert in scheduling jobs, SSIS Packages and sending Alerts using SQL Mail.
  • Experience in creating SSIS package and project parameters and deploying in SSIS Catalog Server.
  • Experience in creating SSAS Tabular Models off the data warehouse and built Pivot Table templates for the end users
  • Experience in Creating SSAS OLAP CUBES and migrating DTS Packages from .
  • Experience inMicrosoft Visual C#in script component of SSIS.
  • Good experience in development of T-SQL scripts, SSIS, SSRS, Stored, Procedures, Triggers, Functions and Views for business logic implementation.
  • Good knowledge of development using databases like Oracle10g on windows 2000/2003 using SQL, PL/SQL, Stored Procedures, Database Triggers, SQL * Plus, Toad.
  • Experience in creating reports in various formats like Table format and Matrix format using SQL Server Reporting services (SSRS 2005/2008/2012 ).
  • Experience in deploying created reports in various sources like Web Browser, XML and PDF.
  • Experience in creating ad-hoc reports by using Report Builder in SQL Server Reporting Services (SSRS.
  • Experience in designing, developing and consumption of WCF services using C#.
  • Expeirence in creating Windows and form based applications using C# .
  • Experience in Windows Powershell scripting.
  • Experience with data analysis, data profiling, and data mapping.
  • Experience in working with Source Gear Vault for the development and administration of projects.
  • Experience as a developer and administrator in SharePoint services (Moss 2007)
  • Experience of working on integration of InfoPath 2007 with SharePoint portal.
  • Experience of developing of custom web parts, Features, Event Handlers.
  • Excellent knowledge & experience of SharePoint/MOSS Server, Search Server, Windows SharePoint Services, IIS, SQL Server, InfoPath 2007and SharePoint Designer 2007.
  • Knowledge of using the Stored Procedures, Functions and Triggers at Data Base level and imported them in Informatica for ETL.
  • Experience working within Agile development techniques
  • Self-Motivated with good verbal and written communication skills.

TECHNICAL SKILLS

Database: Oracle 10g/11g, MS SQL Server 2012,2008, 2005, 2000, 7.0, Microsoft Access

Database Tools: PL SQL developer, T-SQL, Enterprise manager, Query Analyzer, SQL Agent, SQLTrace,Erwin, Performance Monitor

Data Modeling Tools: Microsoft Visio, DB Designer, Front Page, Erwin

Web Server: IIS 5 and 6

Reporting Tools: SQL Server Reporting Services (2012,2008 and 2005), Crystal Reports

Analytical Software: SSAS Tabular

Languages: Powershell,C#, WCF, C++, Visual Basic, Python,Dataweave

Other Tools: Microsoft Visual Studio 2005/2010/2013 , VMware,Microsoft Office, Mulesoft Anypoint Studio

Operating Systems: Windows 2000 & 2003 Advanced Server, Windows NT/95/98/2000/XP/Vista/7, UNIX, Linux, MS DOS, Mac OS X.

PROFESSIONAL EXPERIENCE

Confidential - Berkshore,CA

Senior Data Warehouse Developer

Responsibilities:

  • Responsible for creating ETL to load the data from EDW (Data Vault 2.0) To Datamart/Infomart
  • Responsible for Data profiling, validation and cleansing of the data.
  • Resposible for creating Data Vault 2.0 mapping and modeling.
  • Created DWH dimensional modeling using Star Schema and Snowflake schema methodolologies.
  • Worked with BI developers to deliver reporting objects (Fact, Dimensions tables as well as business views) to deliver insightful reporting.
  • Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.

Confidential - Columbus,OH

Senior Data Warehouse Developer

Responsibilities:

  • Responsible for leading development of several projects and worked in collabration with team and business users.
  • Implemented activities like Lookup, Get Metadata and data flow transformations to incrementally load the data in Azure Blob Storage from Salesforce and Azure SQL Server.
  • Created the end to end pipeline in Azure Data Factory to incrementally load the data from Salesforce to Azure SQL Server and finally into Snowflake cloud platform.
  • Created the dynamic stored procedure in Snowflake cloud platform which takes input parameters and update the entities .
  • Created the python script in Azure DataBricks to call stored procedure in Snowflake cloud platform.
  • Created the dynamic workflow in Mulesoft Anypoint Studio in order to incrementally load the data into Azure Blob Storage from Azure SQL database and finally into Snowflake cloud platform.
  • Created the snowpipes in Snowflake cloud platform in order to load the data in entities from the external stage tables.
  • Developed the SSIS Deployment Utility in powershell for deployment of packages to different SSIS catalog servers.
  • Implemented regular expressions in python to find different text patterns from large collection of files.
  • Implemented dimensional model (logical and physical) in the existing architecture .
  • Implemented Data Vault Modeling and created the SSIS packages to load the delta records in Data Warehouse tables from MS CRM applications.
  • Developed SSIS packages for data migration to MS CRM using SSIS/COZYROC and Web Service Integration.
  • Responsible for creating the Windows Powershell scripts to query the data from Active Directory and Entitlements Managements System (EMS) and load into staging tables.
  • Built SSIS packages to perform extraction,transformation and load (ETL) data into the DWH.
  • Worked on creating the Change Data Capture (CDC) on Transactional system and created SSIS packages to load the Data in Audit Tables.
  • Developed an end to end data warehouse solutions with custom ETL Framework and built the design using Kimball’s Method with several facts and dimensions.
  • Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
  • Created SSIS packages to clean and load data to data warehouse and to transfer data between OLTP and OLAP databases.
  • Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Created reports using SQL Server Reporting Services (SSRS) from OLTP and OLAP data sources and deployed on report Server.
  • Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS.
  • Tested Cognos reports to check whether they are generated as per the company standards.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Developed Windows based application in C#, which checks the data in the excel file and indicate the error data.Finally used excel as a source to load into the OLTP database.
  • Prepared the completedata mappingfor all the migrated jobs using SSIS.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
  • Involved in designing cubes inSSASenvironment using Snowflake and Star Schemas.

Environment: SQL BI Suite (SSAS, SSIS, SSRS), Azure SQL Server, Azure Storage Explorer, Azure Databricks,Python 3,Snowflake Cloud,Mulesoft Anypoint Studio 7.7,Windows Powershell, Visual Studio 2008/2012/2013 , .NET Framework 3.5/4.0, SQL Server 2008 R2/2012/2013,Oracle 11g/10g, ASP.NET, C#,MS Team Foundation Server 2010,COZYROC

Confidential - Toledo,OH

BI Developer/ Report Writer

Responsibilities:

  • Responsible for leading development of project and worked in collabration with team and business users
  • Experience in bulding and deploying SSRS Report Models with the help of Visual Studio 2008.
  • Built SSIS package to extract the data from Oracle database and SFTP to remote server.
  • Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by doing logging and worked on package configuration.
  • Created SSIS Packages to convert oracle CLOB datatypes to text and load them into database.
  • Applied various data transformations like Merge, Aggregate, Sort, Multicasting,Lookup, Conditional Split and Derived column.
  • Experience in deploying the SSIS packages to stage and production environments and creating SQL server agent jobs for scheduling .
  • Developed ASP.NET applications and wrote business logic code in C# code behind files to read data from database stored procedures.
  • Used C# and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies.
  • Developed Windows based application in C#, which displays the data in data grid and enable the users to load the data into the SQL database.
  • Created printed report functionality in ASP.NET application with the help of report viewer control.
  • Developed and scheduled reports in Cognos 10.1 Report Studio.

Environment: SQL BI Suite (SSAS, SSIS, SSRS),Cognos10.1, Visual Studio Professional 2010,Visual Studio 2008, .NET Framework 3.5/4.0, SQL Server 2008 Enterprise Edition,Oracle 11g/10g,Toad v11, ASP.NET, C#,MS Team Foundation Server 2010

Confidential - Columbus,OH

SQL BI/.Net Developer

Responsibilities:

  • Responsible for leading development of project and worked in collabration with team and business users
  • Reposonsible for creating .NET application which consumes WCF web services to fetch and load the data into Staging tables.
  • Built SSIS package to perform extraction,transformation and load (ETL), the data into OLTP data warehouse.
  • Responsible for testing and modifying the existing SSIS packages.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
  • Built the SSIS package to e-mail the generated SSRS reports in PDF format to business users.
  • Experience in deploying the SSIS packages to stage and production environments and creating SQL server agent jobs for scheduling .
  • Generated reports in various formats like Table and Matrix using Reporting services (SSRS 2008).
  • Install and configure report server and generated the report models for user interactions.
  • Involved in the creation of subscription (file share) of SSRS reports on report server.
  • Built the windows form application in C# (Subscription Editor),to edit the report subscription parameters.
  • Experience in bulding and deploying SSRS Report Models with the help of Visual Studio 2008.
  • Experience in deploying the SSRS reports to stage and production environments with the help of TFS 2010.
  • Responsible for giving the business and end users the training for Report Builder 3.0.
  • Used Microsoft Visio and ERWIN for Logical and Physical database Modeling.
  • Involved in the optimization of PL-SQL queries.
  • Created technical documentation on existing ETL application and SSIS packages.

Environment: SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio Professional 2010,Visual Studio 2008, .NET Framework 3.5/4.0, SQL Server 2008 Enterprise Edition,Oracle 11g/10g, ASP.NET, C#,MS Team Foundation Server 2010

Confidential - Westerville,OH

SQL Developer (BI Developer)

Responsibilities:

  • Designed SSISPackages to extract data from various OLTP Sources like Oracle, Text Files, XML (Extensible Markup Language) Files, Excel and MS Access 2007 to Data Warehouse System (SQL Server).
  • Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by doing logging and worked on package configuration to run package on different server.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
  • Applied various data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
  • Responsible for creating stored procedures to pair down the databases.
  • Generated reports in various formats like Table format and Matrix format using SQL Server Reporting services (SSRS 2005/2008).
  • Responsible for creating the dashboard reports for TFS 2010 by querying and analyzing the OLAP cube for TFS warehouse.
  • Responsible for the development for various dashboard reports for the database environment.
  • Responsible for creating the dashboard reports for displaying the performance metrics of all servers.
  • Responsible for stylish design layout likePie charts,GraphsandLinked Reports (SSRS).
  • Configure the report server and generated the Report models for user interactions.
  • Involved in designingMatrix Reportsand alsoCascaded Parameterized Reports (SSRS)
  • Involved in migration of reports from SSRS .
  • Experience in deploying the SSRS reports to Development Server with the help of TFS 2010.
  • Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
  • Optimized queries by looking at Execution Plan for better tuning of the database.
  • Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
  • Provided documentation for all kinds of reports, DTS and SSIS packages.
  • Involved in designing and Developent of SOA services using Web Services/ WCF.
  • Built WCF web services and consumed them for mass mailing application for custom interfacing with partners.
  • Wrote business logic code in C# code behind files to read data from database stored procedures.
  • Used C# and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies.

Environment: SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio Team System 2008,Visual Studio 2005, .NET Framework 3.5, SQL Server 2008 Enterprise Edition,Oracle 10g, ASP.NET, C#,,Source Gear Vault 5.0.1,MS Team Foundation Server 2010

Confidential, Robbinsville,NJ

SQL Developer (SSRS/SSIS)

Responsibilities:

  • Responsible for report generation using SSRS based on business requirements.
  • Create drill down and parameterized reports using SQL server reporting services (SSRS).
  • Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using MS SSRS for the end user requirements.
  • Responsible for stylish design layout likePie charts,GraphsandLinked Reports (SSRS)
  • Involved in designingMatrix Reportsand alsoCascaded Parameterized Reports (SSRS)
  • Involved in design and deployment ofReport Modelsfor generatingAd-Hocreports as per the client requirements.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • CreatedReport SubscriptionusingSSRS 2005/2008.
  • Configure the report server and generated the report models for user interactions.
  • Experience in deploying created reports in various sources like Web browser, XML and PDF.
  • Created reports to retrieve data using Stored Procedures dat accept parameters.
  • Experience in building reports through Report Builder.
  • Developed reports in MSSQL Serverenvironment using MS SSRS 2008 in Business Intelligence Development Studio (BIDS).
  • Created complex reports with the help of Telerik reporting Q2 controls .
  • Responsible for Monitoring and Tuning Reports build in SSRS and Telerik.
  • Designed SSISPackages to extract data from various OLTP Sources like Text Files, XML (Extensible Markup Language) Files, Excel and MS Access 2007 to Data Warehouse System (SQL Server).
  • Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by doing logging and worked on package configuration to run package on different server.
  • Responsible for creating stored procedures and user-defined functions, and ability to create well-architected databases from scratch.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
  • Design the UI RIA for Silverlight applications using Microsoft Expression Blend.
  • Applied the jQuery Datepicker object to create calendar pop-ups. Adjusted calendar display and date range by setting the buttonImage, minDate, maxDate, numberOfMonths, and showOn properties.
  • Developed the data access layer class using C# which is reusable for data transactions of entire project. Extensively used ADO.NET objects like Dataset, Data Adapter, Data Reader, Command, Data Table and Data Relation objects
  • Responsible for maintaing the different releases of the versions using the Version control tool “MS TFS” and “Source Gear Vault”.
  • Responsible for Branching and merging different versions of code.
  • Responsible for maintaining the database for different releases.
  • Resposible for creating and maintaining UAT and Staging environement in the server.
  • Prepare, package and test deployment packages destined for the production environment in accordance with company practices
  • Build and Deploy web application on Staging and production servers.
  • Responsible for creating build flow process from Dev -> QA-> UAT-> Production environments.
  • Created documentation for producing the efficient method of building and deploying application for the development, sandbox and production environment.
  • Responsible for preparing technical documentation for defects and orders change.

Environment: SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio Team System 2008,Visual Studio 2005, .NET Framework 3.5, SQL Server 2008 Enterprise Edition,MS Server 2003, ASP.NET, C#,,Source Gear Vault 5.0.1,MS Team Foundation Server,Telerik reporting Q2 2009

Confidential - Edison,NJ

SSIS/SSRS/ASP.NET Developer

Responsibilities:

  • SSIS development and troubleshooting/bug fixing on staging SQL Server 2005 platform
  • Developed and implemented a standard, configurable, custom logging function within SSIS to allow detailed logging of pipeline row counts, container execution durations and container errors.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Experience in building reports through Report Builder and Report Designer.
  • Created SSRS Reports using Report Parameters, Debugging Parameter Issues Matrix Reports and Charts, Drop-Down Parameters, Multi-Valued Parameters.
  • Experience in creating reports on SQL Server Reporting Services 2005.
  • Involved in Migration of SQL Server 2000 Reporting Services to SSRS 2005.
  • Experience on creating Drilldown reports from Analysis Services cubes.
  • Involved in design and deployment ofReport Modelsfor generatingAd-Hocreports as per the client requirements.
  • Involved in Planning, Defining and Designing data based on the business requirement and provided documentation.
  • Involved in gathering data, reviewing and documenting it for further reference.
  • Involved in designing and Implementinon of N-Tier Application Architecture.
  • Database designs, and a standardised manner of coding stored procedures to include headers, comments, version information as well as good object naming and T-SQL formatting practices.
  • Used dataset, data reader, data view to read data using ADO.Net objects.
  • Web Form design and coding using Master Pages, Server controls, Cascading Style sheet, JavaScript, HTML
  • Wrote business logic code in C# code behind files to read data from database stored procedures.
  • Used C# and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies.
  • Designed and developed the database and wrote stored procedures for SQL Server 2005.
  • Update ASP.NET Pages, UserControls, C# Classes, SQL Databases, CSS, and JavaScript.
  • Was responsible for managing project documentation and for Visual Source Safe administration.

Environment: Microsoft Visual Studio 2008, .NET Framework 3.5, SSIS,SSRS,DTS, SQL Server 2005, ASP.NET, C#,, ADO.NET, CSS, HTML, SQL Server 2005,Visual Source Safe 6.0.

We'd love your feedback!