Lead Big Data Bi Engg/architech Resume
Emeryville, CA
EXPERIENCE SUMMARY:
- Around 10 years of experience in Database programming, System Analysis, Design, Development & Support of SQL on various domains like Loans, Financial and Health and Equipped with excellent communication and interpersonal skills and has in - depth understanding of Trade life cycle and Trade settlement process
- Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, Table Variables
- Experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers and strong RDBMS concepts using SQL Server, T-SQL.
- Expert in Transact-SQL (DDL, DML).
- Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
- Export Data from various sources, Bulk Insert, BCP and DTS/SSIS Packages.
- Hands on migrating DTS Packages to SSIS packages.
- Experience in pulling data from DB2 to SQL Server using Informatica.
- Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, and fact and dimension tables in SSAS
- Good experience in Designing Aggregations and pre-calculating the same in SSAS.
- Actively involved in Processing Cubes, adding KPIs and Calculated Members.
- Extensive experience in Optimizing Cubes .Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
- Uses Power shell to Load batch file comes from client to HDFS System.
- Proficient in maintenance and optimization of Database and Server.
- Using performance monitor/profiler to solve deadlock/long running queries
- Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server).
- Experience in logical and physical data modeling using ER Studio and Microsoft Visio.
- Thorough understanding of Kimball’s’ theory, KPI’S, SQL 2008 Architecture.
TECHNICAL SKILLS:
RDBMS/ NO SQL: MS SQL Server 2005/2008/2012/2014/2016, Oracle 10g, Netazza, Vertica, HBase
Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Replication, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), Lite Speed, DBeaver.
Reporting Tools: SQL Server Reporting Services(SSRS), Crystal Report, Tableau 9.0/9.1/10.0, Microstartegy, Cognos
ETL Tools: SQL Server Integration Services(SSIS), Data Transformation Services(DTS), BCP, SQL Server Analysis Service(SSAS), SQL Server Reporting Services(SSRS)/ Business Object/ OBIEE, Informatica, Micro Statergy
Languages: C, C++, T-SQL, PL/SQL
Web Technologies: Web Services, XML, HTML
Operating System: Windows NT/2000/2003/XP, Vista, 7
Applications: MS-Office suite, MS Visual Studio 2005/2008/2010
Protocols: HTTP, TCP/IP, FTP
PROFESSIONAL EXPERIENCE:
Confidential, Emeryville, CA
Lead Big Data BI Engg /Architech
Responsibilities:
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
- Implemented database standards and naming convention for the database objects.
- Established data granularity standards, designed and built star and snowflake dimensional models
- Hands on experience in Vertica SQL Analytics, Good knowledge on Vertica platform Architecture
- Experience in Pinpointing longest running queries, troubleshooting performance issues and optimize query performance
- Knowledge about Workload Analyzer, Database Designer, Creating and populating Vertica database
- Designed and developed Big Data analytics platform for processing customer viewing preferences and social media comments using Scala, Hadoop, Spark and Pig.
- Integrated Hadoop into traditional ETL, accelerating the extraction, transformation, and loading of massive structured and unstructured data.
- Experience in Loading data, backing up, restoring and recovery into Vertica database
- Designed Star Schema modeling creating Facts, Dimensions, Measures and Cubes.
- Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and SharePoint server.
- Designed Aggregations and pre-calculating in SSAS .
- Analyzed the data for the billing and maintenance department.
- Analyzed and solved numerous data and software performance issues in the Utility reconciliation system. This included the development of complex SQL to both identify and fix data issues in the existing database
- Created SSRS reports using OLTP and OLAP data sources.
- Uses Power shell to Load batch file comes from client to HDFS System.
- Create dashboard using Tableau for reporting.
- Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
- Analyzed and solved numerous data and software performance issues in the reconciliation system. This included the development of complex SQL to both identify and fix data issues in the existing database
Confidential, San Francisco, CA
Sr. SQL BI Developer /Architech
Responsibilities:
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
- Implemented database standards and naming convention for the database objects.
- Established data granularity standards, designed and built star and snowflake dimensional models
- Identify and map fields to ensure proper data flow to the tables.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications. and Fine \tuned SQL Queries for maximum efficiency and performance
- Create Backups and replication per transaction for different distributor and subscriber Server such as physical or Virtual server
- Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
- .Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Generated context filters and data source filters while handling huge volume of data.
- Built dashboards for measures with forecast, trend line and reference lines.
- Published Workbooks by creating user filters so that only appropriate teams can view it
Confidential, Concord, CA
Sr. SQL BI Developer
Responsibilities:
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
- Used Erwin for data modeling.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Implemented database standards and naming convention for the database objects. established data granularity standards, designed and built star and snowflake dimensional models
- Developed SSIS Packages to extract, transform and load (ETL) data into the data warehouse database from heterogeneous databases/data sources
- Designed Star Schema modeling creating Facts, Dimensions, Measures and Cubes in SSAS.
- Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and SharePoint server.
- Designed Aggregations and pre-calculating in SSAS.
- Analyzed the data for the billing and maintenance department.
- Analyzed and solved numerous data and software performance issues in the Utility reconciliation system. This included the development of complex SQL to both identify and fix data issues in the existing database
- Created SSRS reports using OLTP and OLAP data sources.
- Designing the Partition of the cube for the increasing the performance
- Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and Multidimensional Expressions (MDX) queries.
- Provide face to face training for creating their own style of reports to developer using OLAP cube.
Confidential, Los Angeles, CA
Sr. SQL BI Developer
Responsibilities:
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Implemented database standards and naming convention for the database objects. established data granularity standards, designed and built star and snowflake dimensional models
- Developed SSIS Packages to extract, transform and load (ETL) data into the data warehouse database from heterogeneous databases/data sources
- Designed Star Schema modeling creating Facts, Dimensions, Measures and Cubes in SSAS.
- Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and SharePoint server.
- Designed Aggregations and pre-calculating in SSAS.
- Experience in Installation, Configuration, and Administration of MOSS and Maintenance of Microsoft SharePoint based solutions.
- Created and accessed stored procedures using ASP.NET to insert, update and delete data.
- Involved in writing code on ADO.NET to communicate with database and ASP.NET Pages
- Analyzed and solved numerous data and software performance issues in the bank reconciliation system. This included the development of complex SQL to both identify and fix data issues in the existing database
- Created SSRS reports using OLTP and OLAP data sources.
- Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and Multidimensional Expressions
Confidential
Data developer
Responsibilities:
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Create the web pages using ASP.net and create application for Inventory Mannagment System
- Implemented database standards and naming convention for the database objects. established data granularity standards, designed and built star and snowflake dimensional models.
Confidential
Data developer
Responsibilities:
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data
- Create the web pages using ASP.net and create application for Sales Management System
- Implemented database standards and naming convention for the database objects.