We provide IT Staff Augmentation Services!

Dwbi Architect Resume

4.00 Rating

Mclean Va, UsA

SUMMARY:

  • Microsoft Business Intellience and Datawarehousing Specialist
  • Over 15 years of experience on Data warehouse and Business Intelligence with MS SQL server development across Investment Banking, Private Banking, US Mortgage Industry and Telecom Industry domains.
  • Expert in handing Datawareshouse, Multi Dimesional data and writing MDX queries.
  • Expert in writing SSIS packages to clean and load data to data warehouse.
  • Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
  • Expert in writing SSIS package to transfer data between OLTP and OLAP databases.
  • Expert in writing SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregates, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Expert in creating in SQL Server Analysis Services (SSAS) OLAP Cubes. Implemented Snow Flakes Schema and Star Schema.
  • Expert in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
  • Expert in Design, deployment, and maintenance of various SSRS Reports in SQL Server 2012,2008 and 2005
  • Proficient in working with Big Data JSON format with SSIS packages for data transformations.
  • Experienced on database management activities such as scrubbing, metadata index and table creation.
  • Big Data Analytics using Tableau (Create charts, graphs, infographics, dashboards, interactive graphics, and other types of data visualizations that are innovative, striking, and that convey the most important aspects of data).
  • Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Big Data: JSON, HDFS, Hadoop, Cassandra, MangoDB

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SQL BIDS, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2015/2012/2008/2005/2000, Oracle, MS - Access

Language: T-SQL,VB 6.0, VBA, PL/SQL, MDX, C#

Operating System: Windows XP/NT/2000,Windows Server 2003

ETL Tools: SQL Server Integration Services(SSIS),DTS

Reporting Tools: SQL server Reporting Services(SSRS), Tableau, Crystal Reports, Architecture Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

DWBI Architect

Responsibilities:

  • Design and monitor construction of an enterprise data warehouse, working with a team of engineers.
  • Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports, Sharepoint 2013 PowerView & PowerPivot.
  • Design and monitor construction of OLAP or Symantic Layer based on business needs for advanced analytics
  • Design and monitor construction of Enterprise Transformation Language (ETL) processes.
  • Establish and implement standards and strategies for master data management, lifecycle, and data quality.
  • Explain and teach business intelligence and data warehouse concepts throughout the company.
  • Define best practices and standards for the data modeling process.
  • Creation and maintenance of the logical and physical data models for the production and Business Intelligence data warehouse and data marts.
  • Participate in data design walk-throughs to communicate data warehouse and Data Mart table designs to ETL developers.
  • Develop prototype views and reports of the data, and work with business users both internal and external to refine their requirements.
  • Identify critical integration issues and develop corrective solutions.
  • Communicate with team members to assess progress of deliverables.
  • Maintenance and Administration of the database platforms.
  • Performance Tuning of existing data structures.
  • Administration and Monitoring of data protection needs as they relate to the database platforms and solutions.

Confidential

Business Intelligence Architect

Responsibilities:
  • Designed SSIS packages for uploading historical and daily transactional data
  • Upload Staging to Main table: Upload staging table to main tables and use all master tables to update the main tables.
  • Data Cleaning: Implement business logics to clean data as per system requirements.
  • Wrote MDX expressions to create name sets and calculated members.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.
  • Created dynamic cube partitioning for customized data as per client's requirement.
  • Created SSRS reports using MDX queries for reporting financial matrices.
  • Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.
  • Deployment of SSIS packages.

Confidential

DWBI Architect

Responsibilities:
  • Created SSIS packages for uploading historical and daily transactional data.
  • Created SSIS package for automating dynamic cube partitioning by using C# code.
  • Designed and created cube for FY15-16 reporting.
  • Created dynamic cube partitioning for last 2 years data as per current date.
  • Created SSRS reports using MDX queries for reporting financial matrices.
  • Data Cleaning: Implement business logics to clean data as per system requirements.
  • Upload Staging to Main table: Upload staging table to main tables and use all master tables to update the main tables.
  • Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.
  • Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
  • Converted existing BO reports to tableau dashboards
  • Deployment of SSIS packages using following methodology: Create SSIS Configuration file(dtsConfig) containing database connection and package variable inputs. Create environment variables containing physical path for configuration files. Deploy SSIS packages on file system and use windows scheduler to schedule the package run.

Confidential

DWBI Architect

Responsibilities:
  • Automated mobile application data feed for Twitter.com.
  • Twitter had changed its data format from XML to JSON format (Big Data). It had also created an authentication model for enhanced data security. I had created an SSIS package and embedded C# code in the script task editior in order to authenticate and extract twitter data and finally upload data to Sql table for mobile application.
  • Responsible for managing SQL and BI development requirements for Onsite and Offshore Polaris team.
  • Built Tableau dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Worked on projects with Confidential team on SSAS, SSIS and Big Data requirements for various clients.
  • Created SSIS packages for uploading historical and daily files with the following work flow.
  • Upload csv files to staging table: Iterate through the defined base folder including subfolders to upload all input csv files.
  • Created reports for various clients using MDX for data extraction and SSIS for excel reports generation.
  • Data Cleaning: Implement business logics to clean data as per system requirements.
  • Upload Staging to Main table: Upload statging table to main tables and use all master tables to update the main tables.
  • Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.
  • Deployment of SSIS packages using following methodology
  • Create SSIS Configuration file(dtsConfig) containing database connection and packag variable inputs.
  • Create environment variables containing physical path for configuration files.
  • Deploy SSIS packages on file system and use windows scheduler to schedule the package run.

Confidential

DWBI Architect

Responsibilities:
  • Created SSIS packages for uploading historical and daily files with the following work flow
  • Upload csv files to staging table: Iterate through the defined base folder including subfolders to upload all input csv files.
  • Master Table Entry: Update the Master tables with any new values existing in the input files for various category ID's such as Product, Trader, Trade, Source etc.
  • Data Cleaning: Implement business logics to clean data as per system requirements.
  • Upload Staging to Main table: Upload statging table to main tables and use all master tables to update the main tables.
  • Create custom SSIS Custom logging by capturing various events using vb.net in Script Task editor.
  • Deployment of SSIS packages.

Confidential

DWBI Architect

Responsibilities:
  • Working on architecture, database design and enhancements for RBS private banking data warehouse.
  • Responsible for all activities related to the design and development of enterprise wide data analysis and reporting solutions.
  • Translate high-level requirements from the customer into effective BI solutions Integrating complex data from disparate sources into a data warehouse and applying strong analytical skills to develop existing business reports with high level of complexity, thus reducing the time to generate these reports manually to complete automation.
  • Created KPI Objects in line with Requirement Docs.
  • Wrote MDX expressions to create name sets and calculated members.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Responsible for all ETL operations including client feeds, warehouse loads, and data extraction.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Created daily snapshot SSRS report using MDX for the senior management.

Confidential

Business Intelligence Developer

Responsibilities:

  • Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM).
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Created KPI Objects in line with Requirement Docs.
  • Wrote MDX expressions to create name sets and calculated members.
  • Creating and managing HR feed system for the entire organization and the subsidiaries by using SSIS package from Oracle Identity Management(OIM), SAP, Oracle and SQL sources.
  • Assist in analysis/reporting of data collected from our security tools with direction on interpreting what is detected and observed.
  • Create and update SSIS jobs on Autosys in UAT, DEV and Production environment.
  • Monitoring ssis jobs on Autosys. Investigating the cause and fix for any job failure.
  • Creating and scheduling SSIS package for hourly, daily, weekly and monthly data feed and report requirements.
  • Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Collaborating with global teams in UK, USA and Singapore for monitoring, maintaining and creating SSIS packages.

Confidential

Senior Business Analyst

Responsibilities:

  • Responsible for all ETL operations within the Finance department including client feeds, warehouse loads, and data extraction.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Using MDX created calculated members for customized calculated measures.
  • Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
  • Documented all database objects, procedures, views, functions & packages for future references.
  • Performed all QA testing and match results for different environments.
  • Created Indexes (Clustered & Non Clustered) to reduce data retrieval time.
  • Created Triggers to implement business control.
  • Fine tuned SQL queries to improve query performance and to reduce runtime.
  • Write Adhoc queries for Business analysts to extract required daily data.
  • Weekly receive .txt and Excel files to update the tables in DB.
  • Extract data from database and export to Excel files for DA to categories the data.
  • Upload files in Database through weekly run packages in SSIS.
  • Create Packages in SSIS to push the data from one DB to Other DB while working on Performance Point Project.
  • Create Custom Logging in SSIS packages.
  • Weekly Update the Dimension and Fact tables through SSIS Packages and Updated the cube in SSAS.
  • Converted client complex business logic in to database objects like stored procedures, tables, views, triggers, functions. Partitioned tables using the range.
  • Audited database user’s audits using SQL profiler and costumed stored procedures\packages.
  • Created Report Snapshots to improve the performance of SSRS.
  • Developed expressions to calculate values at run time in SSRS 2005.
  • Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
  • Created custom-tailored database backup/restore scripts for full, Differential and Transactional backups and scheduled jobs for DBA automation task. Also restored of databases to the different hardware Windows servers configuration using export and import utility.
  • Created Drill down and Drill through reports using Crystal Reports.
  • Performance tuning to optimize SQL queries using query analyzer.
  • Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
  • Researched archiving processes to catalogue and index massive data archiving needs.
  • Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Created SSIS packages and used Analysis Services processing task to update the cube with current data.

Environment: (SQL Server 2005, T-SQL, ETL, C#, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2008)

Confidential

Senior Analyst

Responsibilities:

  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Participated in developing logical model and implemented requirements on SQL Server 2008.
  • Developed Stored Procedures, Functions (UDF), Views & Triggers to enforce the business rules.
  • Created Indexes (Clustered & Non Clustered) to reduce data retrieval time.
  • Created Triggers to implement business control.
  • Fine tuned SQL queries to improve query performance and to reduce runtime.
  • Automated backup (Full & Differential) processes for disaster management.
  • Ran DBCC consistency checks, and fixing data corruption in application databases.
  • Reorganized database structures as needed, automate procedures at regular intervals.
  • Created and maintained all types of Backups and recovery strategies and set up jobs.
  • Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
  • Optimized long running Stored Procedures & queries for effective data retrieval.
  • Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Oracle etc.
  • Developed SSIS packages to produce details and summarized reports on a daily basis.
  • Created SSIS packages using Conditional Split, Data Conversion, Fuzzy Logic and C#.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Created Report model for each report in Report Server for each report to help front end user to modify the report as per their requirement.
  • Generated several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).
  • Built ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.

Environment: SQL Server 2005 (Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard, SQL Suite (SSIS, SSRS), SQL Server Business Intelligence Studio, ETL, C#, Windows XP, MS Excel, MS Access, Ms Word.)

Confidential

Senior Business Analyst

Responsibilities:

  • Responsible for quick response of SQL statement and connectivity from frontend application to the database servers.
  • Created Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
  • Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
  • Implemented Complex Logging in SSIS Packages.
  • Generated parameterized/Drilldown, Drill Through & Cascaded reports using SSRS and Crystal Reports.
  • Involved in the performance tuning and DB optimization of T-SQL queries.
  • Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
  • Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
  • Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity.
  • Configured packages event logs. Created synchronization of data across several development testing.
  • Created database segmentation and also designed the index and implemented partitioning.
  • Set up database backup and recovery strategies. Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.

Environment: (Windows NT/2000, MS SQL Server 2000, ETL, SSIS, SSRS, Crystal Reports, T-SQL, DTS, MS Vista, MS Excel, MS Access, MS Word.

We'd love your feedback!