Experience

Anthem

• Sr. BI Developer

  • Dec 2013 - Present

  • Develop and modify ETL packages using SQL Server Integration Services (SSIS) to extract data from a database, transform it, and output to multiple different formats such as flat file and Excel, upload them using SFTP or a shared drive as well as download data from different resources and load them daily/weekly/monthly to a database in order to create and maintain a centralized data warehouse.• Design and develop complex stored procedures, views, and functions using T-SQL• Perform… • Develop and modify ETL packages using SQL Server Integration Services (SSIS) to extract data from a database, transform it, and output to multiple different formats such as flat file and Excel, upload them using SFTP or a shared drive as well as download data from different resources and load them daily/weekly/monthly to a database in order to create and maintain a centralized data warehouse.• Design and develop complex stored procedures, views, and functions using T-SQL• Perform batch processing of data within the database via complex stored procedures and views.• Optimize the performance of queries with modifications in T-SQL, normalized tables, established joins and create indexes whenever necessary• Design and implement different type of SSRS reports including cross-tab, conditional, drill-down, sub reports, multiple cascading parameters, expressions and functions.• Ensure data integrity in report output and timely deliverables• Work on improving performance issues in stored procedures, reports and automated processes• Responsible for generating regulatory submission reports to regulatory agencies (state and federal) Show more Show less



Swiss Watch International

• Business Intelligence Analyst

  • Apr 2013 - Dec 2013

  Extract existing data to manipulate/calculate/format into presentable reports, charts and graphsWrangle data from multiple sources including sales, inventory, product, and customer databases to create integrated views that can be used to drive decision makingWork with several large and complex SQL databaseWork directly with the board members, COO and directors to determine and meet their reporting and analytical needsPerform ad hoc analytical requestsMaintain up-to-date… Extract existing data to manipulate/calculate/format into presentable reports, charts and graphsWrangle data from multiple sources including sales, inventory, product, and customer databases to create integrated views that can be used to drive decision makingWork with several large and complex SQL databaseWork directly with the board members, COO and directors to determine and meet their reporting and analytical needsPerform ad hoc analytical requestsMaintain up-to-date knowledge of industry trends and products. Show more Show less



Marubeni Business Machines America

• Sales Analyst

  • Apr 2009 - Apr 2013

  Responsible for data management and produce reports in MS ExcelGenerate sales reports (monthly, quarterly, annually) by unit and sales revenue categorized by customers and modelsAnalyze historical trend and develop forecast vs. actual reports to assist the management for setting business targetsConduct analysis and make recommendations to sales team for their daily and corporate-driven targeting effortsGenerate product purchase costs and profit reportsAssist Accounting… Responsible for data management and produce reports in MS ExcelGenerate sales reports (monthly, quarterly, annually) by unit and sales revenue categorized by customers and modelsAnalyze historical trend and develop forecast vs. actual reports to assist the management for setting business targetsConduct analysis and make recommendations to sales team for their daily and corporate-driven targeting effortsGenerate product purchase costs and profit reportsAssist Accounting Department by providing customer balance summary reportsDesign and provide ad-hoc reportsUpdate and manage product information Show more Show less



Dell

• Sales and Marketing Analyst

  • May 2003 - Aug 2007

  Responsible for data management and produced reports in MS Access and ExcelGenerated sales representatives’ performance reports by daily, weekly, monthly and annuallyReported daily sales reports by unit, sales revenue, margin and profit by target vs. actualConducted analysis for sales representatives’ activity and their sales record to make recommendations to the manager for their performance meetingsAnalyzed and reported sales trend for published advertisement categorizes… Responsible for data management and produced reports in MS Access and ExcelGenerated sales representatives’ performance reports by daily, weekly, monthly and annuallyReported daily sales reports by unit, sales revenue, margin and profit by target vs. actualConducted analysis for sales representatives’ activity and their sales record to make recommendations to the manager for their performance meetingsAnalyzed and reported sales trend for published advertisement categorizes Designed and performed ad-hoc reports Show more Show less