SUMMARY

• 11 years data analysis and report experience
• 8 years MS SQL server, Oracle, Business Intelligence development (data ETL, mapping, package configuration, analysis service and reporting) and data modeling experience using MS SQL server SSIS, SSAS, SSRS, MS SharePoint, Tableau, ERwin Data Modeler, Power BI and Crystal reports.
• Solid SQL skills: create tables, database query, using operators, data sorting, data restructuring, alias, various table joins (inner, outer, cross, self), using subqueries and multiple queries, using index, performance tuning, using view and synonyms, T - SQL, SQLPlus, PL/SQL, cursor, stored procedure, trigger, dynamic SQL, MDX, XML.
• Using source control TFS (team foundation service), and familiar to Agile project management system.
• Professional experience of most advanced Oracle, MS SQL Database server installation and configuration. Installation and configuration of virtual machine VMware and Window Servers.
• Oracle DBA experience: user account setup, system privileges, database security.
• Full knowledge on finance: read financial report, understand key statistic data.
• Highly collaborative team player with great verbal, written communication and interpersonal skills
• Proven ability to prioritize and complete multiple tasks, capacity to approach problems effectively and creatively
• Self-motivated and driven quick learner and hard worker. Willing to take responsibilities
• Superior analytical skills to think through complex, multidimensional problem and propose solutions

TECHNICAL SKILLS

Database: Oracle, MS SQL server, SSIS, SSAS, ERwin, MySQL

Reporting: SSRS, MS SharePoint, Tableau, Crystal Reports, Pyramid Analytics

Languages: SQL/T-SQL, SQLPlus, Perl, R, MDX, XML

Operation system: Windows, VMware, Window servers, Unix/Linux.

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NYC

Sr. SQL/Business Intelligence Developer

Responsibilities:

• Fulfill the tickets/tasks assigned and create reports, including debugging SSIS packages, modifying the configuration files, automation/testing the packages in various environments (DEV, UAT and PROD), and deploying the packages.
• Design database, create tables and views.
• Drafted the technical documentation file.
• Perform data analysis with Power Pivot model and generate reports.
• Using Power BI Designer to make various dashboard reports.

Confidential, Hoboken, NJ

SQL/Business Intelligence Developer

Responsibilities:

• Fully responsible for company’s data migration from various sources (Sftp, e-mail in .txt or .xls) into database using ETL tools (BCP, Bulk insert and data import/export Wizard) and SSIS packages. Deal with big data. Debug technical issues, optimize package process and improve ETL efficiency.
• Designed SSIS packages and setup scheduled jobs to automatically update database tables on daily basis.
• Wrote complex SQL queries and stored procedures to extract and edit data from database according to business logic to make comprehensive and precise reports daily and monthly. Distributed the reports to senior managers and other collaborative teams.
• Performed verification and QC of reports from different sources. Designed QC reports using screenshots or Excel spreadsheet. Deploy the QC reports to Sharepoint server.
• Completed all the projects assigned within deadline and with good quality.

Confidential, Monroe, CT

SQL/Business Intelligence Developer

Responsibilities:

• Responsible for the company’s new SellThru Data Warehouse construction. Worked with sales department to establish data warehouse dimension tables and fact-tables e.g. DimMaterial, DimCustomers, DimStores, DimTime, DimRep, Productsales, etc.
• Set-up multiple primary keys and foreign keys to establish relational databases.
• Designed SSIS packages and scheduled jobs to regularly and automatically update dimension tables and daily load sales data from EDI-852, SAP and SKU data source.
• Performed routine maintenance for company main data warehouse. Used SSRS to generate reports for sales department and deployed to company Sharepoint server.
• Had regular conference meetings with senior directors and presented progress reports weekly.

Confidential

SQL/BI Developer and Data Analyst

Responsibilities:

• Managed one project about new generation sequencing by supervising, coordinating and trouble - shooting project operation
• Performed data ETL from various data source, file types. Designed and optimized SSIS packages.
• Designed and constructed data warehouse, star-schema, cubes, and dimension hierarchy. Analyzed data using data modeling (Erwin) and data mining (data tree, cluster) tools.
• Generated reports using report service tools (SSRS).
• Developed and successfully coordinated project plans incorporating all lifecycle phases inclusive of all efforts in matrix environment with teams from various institutions meeting senior management objectives.
• Provided weekly progress reporting to senior director via Power Point presentations. Tracked issues, resolutions and results feedback.
• Collaborated with DBA to ensure system performance and project running.

Confidential, New Haven, CT

Project Manager / Data Analyst

Responsibilities:

• Led and conducted an NIH project for pharmacometric research and analysis system. Won 1 million funding from federal government.
• Developed project plans, outstanding issues lists for resolution, and managed change control for time lines.
• Collecting raw data from front-end research settings, transformed and loaded data into database.
• Statistic and modeling analysis of dataset using analysis tools to discover new working strategies and improve business process.
• Monitoring and preparing reports on practice growth and productivity. Presented results on international conference. .