Business Intelligence Architect Resume
Atlanta, GA
SUMMARY
- Over 13+ years of IT experience and 11+ years of SQL Server experience in architecting, designing, developing and implementing DataWarehouse solutions, 11+ years of Microsoft BI Technologies experience and 6+ years of experience in Leading/Managing teams.
- Worked on Microsoft’s IaaS and PaaS platforms - Azure SQL Data Warehouse, Data Management Gateway connector, Azure Data Lake, Blob storage, Azure DB & Data Factory.
- Experience working in a Hadoop with Hive, Pig, Oozie & Tez engine in Azure HDInsight.
- Experience in application designing and data modeling using ERWIN, logical and physical designing of DBs. Strong understanding of star schema, Snowflake schema and HOLAP, ROLAP, MOLAP concepts and understanding of Data Mining algorithms. Full implementation knowledge of Kimball Methodologies.
- Working knowledge of Cloudera Hadoop Eco-system.Used Hbase, Impala, Hive, Pig in the HDFS System
- Excellent working knowledge on PowerPivot, PowerBI, Visualizations in PowerBI and PowerPivot Sharepoint Integration.
- Managed the implementation of many REST APIs such as Facebook, Twitter, Adobe, Google - especially Analytics APIs
- Expert working knowledge on SSIS, SSAS and SSRS 2008, 2008R2 and 2012.
- Implemented Multi-Dimensional and Tabular Cubes. In SSAS created Partitions, Report Actions, Different types of Dims and Measures,
- In SSRS, implemented Dashboards/Reports with KPIs, Parameterized Drill Through Reports, Paramterized reports using MDX with different types of sources such as Cubes, RDMBS etc.
- Expertise in PL/SQL or T-SQL, stored procedures and packages, triggers, Indexes /constraints, views
- High expertise in Performance Tuning & Optimization at all levels - Server, object, query or network level.
- Implemented TDE security of SQL server
- Working Experience in designing and implementing Data Warehouse/ Datamart models using SSIS, SSRS and SSAS
- Strong Customer-service skills and ability to resolve challenging user issues, able to express ideas and concepts in an open and positive manner.
- Excellent logical and analytical approach to problem solving and conducting domain analysis.
- Good team spirit and organized working habits with a willingness to learn new concepts and very good team player, enthusiastic to explore new things.
- Masters Degree in IT with a major in Data Warehousing and Mining.
TECHNICAL SKILLS
Databases: MS Access, Oracle, SQL Server 2012, 2014, 2016,2017
Programming Languages: C, C++, JAVA, SQL Server Data Tools, JSON, XML, XMLA,ASP, MDX, DAX querying
Operating System: Windows Server 2003, 2008, 2012.
Reporting Tools: Excel, PowerPoint, PowerView, SSRS, Performance Point, Tableau, PowerBI
Data Warehousing Tools: Informatica, Erwin, SQL BI 2012, 2014, 2016
Others: SSIS 2012,2014, 2016 SQL Server Data Tools, Master Data Services, Data Quality Services, Azure, Data Lake, Azure SQL DW, SSAS, Impala, Hadoop, HDFS system
PROFESSIONAL EXPERIENCE
Confidential - Atlanta, GA
Business Intelligence Architect
Responsibilities:
- Fully responsible for the architecture of all ETL processes, data management and data quality management for about 20+ clients data made available to end users for Reporting
- Worked in Azure Cloud environment with IaaS and PaaS for building scalable solutions.
- Implemented POCs in Azure SQL Datawarehouse. Displayed how Elastic computing and moving to PaaS saved money.
- Used Polybase & Data Mngmnt Gateway to move data between on-Prem & Cloud DBs.
- Analyzed the billing structure, capabilities and performance of SQL DB Azure services.
- Implemented multiple On Premise Tabular Models with Dimensions and Meausres, calculated measures and used PowerBI tools on these models to help end users produce Visual representations.
- Used DAX on Tabular models and MDX on existing Multi-dimensional models for reports.
- Introduced and successfully implemented the Agile scrum methodologies for projects.
- Worked extensively with Business users, Data Analysts, external Clients on all stages of a project including requirement gathering, setting up security for external client to access LIFT data, QA, DB design and development and DB security (TDE).
- Designed & Developed a framework for retail clients for consistency & reusability across all clients which included Address standardization & validity, deduping of customers, etc.
- Extensively used and mentored the use of all SSIS components, including data flow and Control Flow transformations for data transformation and cleansing (Fuzzy, Lookup, Derived Cols, FTP, script task, merge join to name a few).
- Designed and Implemented SSAS solution to store data in Multidimensional format.
- Excellent working knowledge of all BI SQL Server 2012, 2014 features and components.
Environment: SQL Server 2012, 2014, 16 SQL Server Data Tools, Windows Server 2003, MDX, SSAS, DAX, Windows server 2008, 2012, Visual Studio 2010, PPS, Power Pivot, Scrum Master, Erwin, Azure SQL DW, Azure SQL DB, Blob Storage.
Confidential - Charlotte, NC
Business Intelligence Architect
Responsibilities:
- Implemented multiple End to End BI Solution to satisfy the needs of Nuclear Reporting.
- Worked extensively with Business users along with Requirement Analysts to understand the requirements.
- Designed the datamart and data flow structure from OLTP source to OLAP destination.
- Designed and developed ETL data flow and structures using SSIS to load data from OLTP source to datamart.
- Extensively used SSIS data flow transformations for data transformation and cleansing.
- Extensively used SSIS Control Flow transformations to direct the flow of process.
- Mentored/Lead SSRS report writers in designing SSRS reports and background SQL
- Designed and Implemented SSAS solution to store data in Multidimensional format.
- Written parameterized MDX queries as source for SSRS reports.
- Created Online Dashboards with Cube as source and Performance Point as Front End.
- Used Agile/Scrum methodologies for BI solution development.
- Excellent working knowledge of ETL and query optimization in T-SQL and SSIS.
Environment: SQL Server 2012, Windows Server 2003, Windows server 2008, 2012, Visual Studio 2010, PPS, Power Pivot, Scrum Master, Erwin.
Confidential - Charlottesville, VA
Business Intelligence Architect
Responsibilities:
- Project lead on DTS to SSIS migration with 100+ packages.
- Expert working level knowledge on SSAS tools for designing, creating and maintaining Financial, Marketing, Demand Planning and other BI solutions.
- Expert working knowledge on SSIS to perform ETL from sources like SQL Server 05/08, Dbase, Access, flat files, Oracle etc. into the Data Warehouse in SQL Server 08 and 2012.
- Built End to End BI Solution. Performed ETL from OLTP to OLAP Systems, designed and loaded data warehouse, designed SSAS solution from scratch and built cube and wrote MDX queries to create automated SSRS reports.
- Excellent working knowledge of ETL and query optimization in T-SQL and SSIS.
- Built both Excel and SSRS reports using both T-SQL and MDX Querying.
- Built SSRS dashboards for financial data, returns data etc.
- Worked on BI integration with Sharepoint2010,Excel Services, PowerPivot, PowerView.
- Use indexing, profiler traces, table statistics, analysis of query execution plan and other methods to identify and improve poorly performing queries.
Environment: Sql Server 2005, 2008, 2008 R2,2012, Windows Server 2003, Visual Studio 2005, 2008, 2010, TFS, Windows server 2008, 2012 and SQL BI 2008, 2012.
Confidential
Database Application Specialist
Responsibilities:
- Designing, developing and maintaining multiple databases for various systems supporting college financial, fund raising and academic domains.
- Created and built strategy for Institute’s third party database systems, and set the standards for programming, security and operations areas.
- Involved in design and specification of hardware & storage architecture used to support database platforms.
- Involved in all phases of database operations: Backup/restore, Monitoring, Security, Capacity planning, Performance analysis and tuning, Infrastructure planning and implementation, ETL and archive routines
- Extensively worked on PL/SQL, stored procedures, views, users & roles, security, database maintenance plans, backup and restore and replication on SQL Server.
- Provided user support and on in house projects and third party applications such as Microcall, IDWorks - ID printing machine, QuikPay - online payment system and others.
- Provided occasional web based solutions and support.
Environment: Sql Server 2005, VS2005, Windows NT, MS access 2003, ColdFusion MX 6.0, DreamWeaver MX 2004
Confidential - PA
Web Developer
Responsibilities:
- Designing, developing and maintaining RCC, Confidential website, web forms and applications, and databases for student’s online logins.
- Designed and implemented workflow processes
- Extensively worked on SQL Server back end.
- Created Stored procedures, triggers and functions to support the web front end system.
- Created, maintained and modified new and existing schema designs to insert new functionalities or manage existing functionalities on the website.
- Worked on a one-on-one basis with students and co-workers for .
- Developed an application for online inventory management. Modules include, maintaining records on all hardware and software, reporting and providing status on each item.
Environment: DreamWeaver, Cold Fusion MX 5.0, MS Access, Sql Server 2000.