OBJECTIVE

• Seeking Business Intelligence SSIS/SSAS/SSRS/POWERBI Architect/Developer position for a progressive company open for relocation; Desire to build client satisfaction using both emerging technologies and proven methods in innovative ways

SUMMARY

• More than 10 years of experience in IT
• Expert in transforming Data - > Information -> Knowledge - > Business Decisions
• Strong desire in learning new technologies and methodologies
• Proficient with Talend and Informatica
• Proficient with MS BI stack including Analysis Services, Integration Services, Reporting Services
• Strong Hadoop Ecosystem Architect experience (HDP, CDH(Cloudera))
• 10 years development experience across all phases of the SDLC (systems development life cycle) from project initiation to post-implementation
• Extensive data warehouse and OLAP/Cube, Tabular Model/Cube design experience using Kimball Method Best Practices.
• Extensive Dashboard design using Power BI and Tableau
• Exceptional problem solving and team skills

TECHNICAL SKILLS

ETL Tools: Microsoft Integration Service(SSIS), Talend(6.1.1), Informatica

Reporting Tools: SSRS,Power BI,Tableau, Congos, Crystal Report, Business Object

Strong Hadoop Architect and Developing experience with: HDP(Hortonworks) and CDH(Cloudera)

Experience in: HDFS, ZooKeeper, Ambari, Hive, Pig, Map Reduce, Spark, Flume, Sqoop, HBASE

Experience in: ELK(Elastic Search, Logstash, Kibana), Solr, Splunk

Other Business Intelligence Tools: SQL Server Analysis Services (Both Multidimensional Model and Tabular Model) 2016, 2008 R2, Reporting Service (SSRS) 2008 R2, DTS (SQL2000)

Programming/web: JAVA, VB.Net, C#.Net & ASP.Net, SQL, MDX, DAX, HTML, XHTML, XML, Web Services

Database: SQL Server 2012 & 2008 (design & development), Oracle, Teradata, General knowledge with MySQL, and Oracle.

Networking: TCP/IP, MS Exchange 2003, SMTP, DNS, FTP, HTTP/s

Other Tools: SharePoint, Visual Source Safe, MS Project, MS Office, Quality center

OS: Windows 2000, XP, 2003, Vista, Linux and MAC OS X.

PROFESSIONAL EXPERIENCE

Confidential

Senior Business Intelligence Developer

Responsibilities:

• Performance Tuning on existing SSIS ETL packages, SSAS cube
• Redesign existing cube, Design New calculated members, KPI using MDX
• Redesigned the ETL Frame work for SSIS packages
• Developed First Financial Tabular Model SSAS Cube, Using DAX to develop calculated member, KPI security
• Using Power BI developed financial Dashboard sourcing from Financial Tabular model
• Designed and Developed the BI Archive Project for 140 dimensions and 50 fact tables
• Designed Dashboard, Reports using SSRS
• Data Warehouse design, Data modeling using Kimball
• Built tabular model for Labor and Finance Cube
• Design all Calculated member, KPI, Function in Cube
• Database Design, Store Procedure Design as needed

Confidential

Senior Data Warehouse Developer

Responsibilities:

• Designed and Developed the Data Mart for Confidential
• Designed and Developed the First SSAS Cube for Confidential
• Using SSRS to design report for service department
• Multiple ETL Design based on customer request(Talend)
• Using Excel Pivot table to design Dashboard for sales and service
• Lead offshore SSAS Team, conduct weekly meeting, Assign work load
• Design ETL Framework, Templates for the company
• Design all Calculated member, KPI, Function in Cube

Confidential

ETL Consultant

Responsibilities:

• Provide Architect level Consultant for BI solution
• Design ETL Framework, Templates for the company
• Redesign the fact and dimension loading package for data mart
• Design the SSIS Package to replace core biztalk server security functionality
• SSAS Cube Design and Writing complex mdx query for calculated member, KPI etc.
• Using SSRS to design reports based on business request
• Leverage Share point, performance point to design Dashboard, Publish SSRS report to share point and integrate reports with Dashboard
• Performance Tuning the existing Cubes
• Data Warehouse design, Data modeling using Kimball
• Built the first tabular model for the company and create excel report on top of the model using SQL SEVER 2012
• Redesign Hermes system 2.0 using the latest technology
• Perform DBA duty when needed, Performance Tuning, backup restore BI related database
• Database Design, Store Procedure Design as needed

Confidential

Business Intelligence Consultant

Responsibilities:

• Second phase Data warehouse implementation
• Create Power Pivot solution which include adding new attributes into power pivot and creating new calculated member using DAX
• Customer Profile Dashboard Design using 2010 performance point/ share point, include contents like KPI, Score Card, Reports etc
• Using SSRS create different reports and integrated with sharepoint dashboard
• Created new Sales Order detail fact table and Sales order detail cube
• Redesign and optimize the existing Cube which include creating a new proper time dimension, create hierarchy in time dimension, performance tuning etc
• Created Pivot table solution by adding new calculate member into Cube, and design pivot report using 2010 excel
• Built new calculated members, KPI in existing cube using MDX
• Performance Tuning the existing cube, re-architect the existing SSAS server using latest synchronization technology
• Established SSAS security in the cube using dynamic fact table
• Created SSAS store procedure to achieve different functionalities in the cube
• Store Procedure, Function Design as needed
• Perform DBA function when as needed, backup restore BI related database, Performance Tuning

Confidential

Business Intelligence Consultant

Responsibilities:

• Work as Lead Consultant, Collect Requirement from the Business User, assign work to off shore team member
• Provide BI Architect Level Consultant
• Building SSIS Framework using best practice
• Merge HUB 4.0 with HUB 4.1 into HUB 5.0
• Provide mentor and training to the Junior team member
• Work with the business user, Optimize the UC MGA ETL packages, add new features like Roll back
• Combine regular Logging with meta data Logging into one consolidated view
• Support Recon project in multiple phase, optimize old ETL solution, provide support to the business team

Confidential

Business Intelligence Developer

Responsibilities:

• Gather requirements. Analyze related business processes to identify Dimensions, attributes, hierarchies and relationships.
• Work with DBA to identify, profile and extract sources data from multiple systems
• Data Warehouse design based on business requirement, SSIS loading Data warehouse, SSAS cube analysis
• Using SSRS make multiple reports for Job Usage and RDB Usage
• Using document map, sub report, Tool tip, action, etc different technology building complex reports based on customer requirement
• Building web part, deploy SSRS report to share point server
• Import solution from production, and make dimension or measure group changes on cube
• SSIS package design, incremental extract and load, slowly changing dimension load, using multiple lookup to load fact table
• Performance tuning existing store procedures, using execution plan etc
• Using SSAS to design cube solution from data mart, define relationship for existing dimension attributes, using named query to replace existing tables and view
• Optimize existing SSIS package by redesign the control flow and data flow, or adjust the buffer size or max rows for existing data flow
• Building Dashboard, KPI, Filters, Score Card through Share Point/ Performance Point 2010 (MDX)
• Implement Cube security using SSAS Store procedure
• Performance Tuning the existing Cube using usage based optimization
• Optimize the existing SSAS architecture using process and query analysis server methodology

Confidential

Business Intelligence Developer

Responsibilities:

• Implement Business intelligence Solutions using SSIS, SSAS, SSRS
• Gather require Document, working with business user, identify dimension, attributes, hierarchies and relationships
• Based on Business Require document, Writing Technique Require Document, which will clarify data mart relationship, ETL process, Measures group etc
• Data Mart design and implementation, Database modeling, Design Fact and Dimension tables
• ETL Design, incremental extracting, Dimension and Fact Loading, Error handling design for ETL
• Dimension hierarchy, Attribute relationship, Drill through action design
• Cube design, using MDX design measure group, calculated member, time intelligence YTD, MTD, WTD function design
• Using Proclarity define KPI and released to share point 2007
• Debug for the existing Cube, which involved bring production cube to local solution, fix then release back to production
• Work with DBA to identify, profile and extract sources data from different system
• Design and develop reporting solutions base on customer request, including drill-down, drill-thorough and subscriptions

Confidential

Developer (Application and Database)

Responsibilities:

• Database development (SQL Server 2000)
• Developed Functions, View, Stored procedures and DML triggers
• Participated in database upgrading from SQL 7 to 2000
• Used different tools to perform data transformation, and building reports

Confidential

Senior QA Analyst

Responsibilities:

• Used SQL perform data validation check
• Developed test scenarios and test scripts based on requirements and design documents.
• Involved in querying and updating records and validated database records as expected.
• Worked with user to define user acceptance test cases. Involved in UAT testing (User Acceptance Testing) and implementation.
• Updated test cases designed from use-case analysis to Test Director.
• Managed Test Cases, Automated Test Scripts, Test Inputs and Test Suites in Test Director.
• Used Test Director to track bugs.
• Troubleshot and identified application problems by analyzing codes and test results, worked closely with developers in isolating and reproducing defects

Confidential

Big Data ETL Architect

Responsibilities:

• Helped client companies set up Hadoop eco system, Built ETL to load data into Hadoop(Talend), Built query and Front end dashboard to visualize Hadoop data
• Designed and developed technical specifications using Hadoop technology.
• Migrated all log files generated from various sources to HDFS for further processing using Flume.
• Using Sqoop to transfer data between Hadoop system and traditional database
• Written MapReduce tasks and PIG scripts to process data in HDFS.
• Created Hive tables to store the processed results in a tabular format and create dashboard for tabular model.
• Monitored Hadoop scripts which take the input from HDFS and load the data into Hive.
• Experimented Apache Spark for better performance.
• Experience in ELK(ElasticSearch, Logstash, Kibana), Solr, Banana

Confidential

Business Intelligence Developer

Responsibilities:

• Data Extract, Transform, Loading using Microsoft SSIS and Talend tool
• Dimensional Model database design for First Confidential data warehouse
• ETL Package design for dimension table and fact table
• SSAS Cube Design for Confidential
• Dashboard Design using Excel through SSAS database