SUMMARY

• Power BI Developer wif more than 7 years of experience in teh design, development and maintenance of Business Intelligence applications, Business Analytics and operations
• Expertise in profiling source systems and writing data mapping documents for teh ETL process
• Proficient in teh creation of reports and dashboards to support business decisions using Power BI, BI Publisher, Tableau and SSRS
• Proven experience in various banking, finance and healthcare projects
• Strong analytical, interpersonal, customer service, leadership and decision - making skills

TECHNICAL SKILLS

Development Tools: BIDS, SSDT, SSMS, T-SQL, Oracle, MDX, DAX

Database Programming: T-SQL, Oracle, MDX, DAX

SDLC: Agile, Scrum, Waterfall, and Spiral

Could Technologies: Azure SQL, Azure Data Warehouses, ADF, Azure Storage(BLOB, Tables, Queues, and File Share), SharePoint

Integration and Analysis Services: SSIS, SSAS

Databases: SQL Server 2016/2014/2012/2008/ R2, Oracle HCM

Reporting Tools: SSRS, Power BI Desktop, BI Publisher, Tableau, ServiceNow

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential, San Antonio, TX

Responsibilities:

• Translated business needs and requirements from JRD sessions to technical and functional specifications/documentation
• Crafted and built data system dat serves as teh backbone for transformation project data management and analytics capabilities
• Developed and executed SQL queries and conducted analysis for data preparation
• Worked closely wif internal and external business partners for business intelligence solutions; from gathering requirements, to preparing data, to building reports and dashboards in Power BI Desktop, to demonstrating functionalities and insights capabilities wif end users
• Designed and delivered wireframes and visual frameworks for high executive reports and dashboards wifin teh enterprise
• Developed visual reports, dashboards and KPI scorecards using Power BI Desktop.
• Connected to a wide variety of data sources, imported data, and transformed data in Power BI Desktop for Business Intelligence
• Created complex advanced level calculated measures, columns, and tables on teh dataset in Power BI
• Administered data security by utilizing teh application security layer models in Power BI, creating row level security in Power BI Desktop and assigning them to business groups and users in Power BI Service premium dedicated workspace
• Integrated data coming from diverse sources in different formats and in dual connection mode as a composite model wifin Power BI
• Took on all technical challenges associated wif teh Power BI platform such as working wif large datasets and managing streaming data
• Presented/demonstrated data analytics insights through reports and visualizations
• Wrote efficient complex DAX calculations and M-code programming in Power BI Desktop
• Optimized query performance by modifying embedded queries and altering stored procedures
• Improved Power BI report running performance and report refresh performance by implementing some of teh best practices
• Created Power BI App and content packs as a method of sharing dashboards and reports wif users across teh enterprise
• Configure dataset settings wif regards to gateways, refreshes, parameters, subscriptions, and alerts in Power BI Service
• Created letters, reports wif BI Publisher and Oracle HCM

Environment: Power BI Desktop, Power BI Service, SQL Server 2016, SSIS, Oracle HCM, BI Publisher, SSMS, T-SQL, SQL Profiler, DTA, SharePoint, ServiceNow, Azure SQL

BI Developer

Confidential, Orange County, CA

Responsibilities:

• Gatheird business requirements through end-user collaboration through JRD and JAD meetings
• Documented business logics, and requirements and worked closely wif teh solutions architect, project managers, developers to design data model, reports, dashboards to answer leaders’ questions
• Successfully enhanced and implemented pre-existing logical and physical databases
• Worked wif IT and business partners to resolve production issues dat may arise
• Worked in conjunction wif teh Data Warehouse team to develop solutions and support organization-wide reporting, and data analysis and alternative practices
• Wrote complex reports in SSRS, Power BI and shared dashboards and reports wif user groups as per their roles in teh organization.
• Troubleshot bugs, maintained teh existing reports, and optimized them based on user requirements
• Created complex SQL statement structures wif joins, sub queries, and correlated sub queries
• Wrote custom T-SQL stored procedures and indexes to improve performance and preserve referential integrity
• Designed and optimized dynamic SQL batches to perform bulk operations in teh OLTP environment
• Migrated SSIS packages from development to production environments wif package configurations
• Implemented SSIS projects monitoring framework in terms of its performance and debugging capabilities
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Implemented TFS for version control and change management of BI solution for cross-functional communications
• Automated teh ETL process wif SSIS package execution schedules utilizing jobs
• Developed a number of SSAS cube objects such as KPIs, calculated measures and named sets.
• Medical Cost Personal Dataset Research: utilized data mining methods, linear regression, regression tree and clustering algorithms in R, using statistics to provide validated predictions of medical costs among different groups of people

Environment: Power BI, SQL Server 2016, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, TFS, Tableau, SQL Profiler, DTA, MS Azure, R, SharePoint, Azure SQL, Azure Data Factory

Data Analyst

Confidential

Responsibilities:

• Promoted to SME as a leader of 20 team members
• Extracted data from large databases using SQL and created teh dashboard to provide market insights wif analysis
• Used Tableau to visualize teh data for reporting and make teh decisions according to teh defined policies and procedures resulting in highest team performance among 9 markets (Thai, Malaysia, Indonesia, China, Korea and Japan).
• Conducted data analysis to make business recommendations for clients such as name policy, market trends, improving 98% accuracy of name changing policy
• Presented teh results, findings for different levels of management
• Imported, exported and manipulated large data sets in multi-million-row databases under tight deadlines
• Wrote efficient scripts to extract required data in SQL using complex joins, aggregation, nested subqueries, stored procedures, Dynamic SQL, triggers and cursors
• Partnered wif cross-functional teams to realize data relationships through proper threading
• Utilize teh internal communication platform of FB @workplace to enhance teh team collaboration and work initiative

Environment: SQL Server 2012, Tableau, SSMS, MS Excel, MS Office, SharePoint