SUMMARY:

• To obtain a challenging position as a Sr. Data Analyst / Database Analyst / Business Analyst / BI developer, where I can utilize my skills and expertise that will enable business, add value and provide opportunities for professional growth.
• Over 10 years’ experience of SQL Server 2008/2012, Access 2007/2010 database and Data Loading and Reporting tools such as: SSIS, SSRS and Crystal Reports 2008/2011, PowerBI.
• Over 10 years’ experience in MS SQL database design, development and analysis. Be involved in the Full Software Development Life Cycle (SDLC) including analysis, design, development, documentation, deployment and system support.
• Experience as Data Analyst, Business Analyst and BI Developer. Also worked as Team Lead on different projects and assignments.
• Strong data manage and reporting experience on quantitative analysis.
• Advance knowledge in RDBMS concepts, conceptual/logical/physical data models
• Experience in all aspects of Data Warehousing including project planning, requirement gathering, data modeling, development, deployment, maintenance, and enhancements.
• Experience in large size database running on SQL Server.
• Expert in Performance Tuning and Optimization of SQL Server, SQL scripts and Stored Procedures.
• Strong analytical, problem solving and troubleshooting skills.
• Passionate about working with huge data sets and love to bring datasets together to answer business questions.
• Strong team player with great verbal, written communication and interpersonal skills.
• Ability to work independently and in large team environment.
• Quick learner, take initiator, and hard worker. Ability to learn new skills on the job and has a ‘Can Do’ attitude.

TECHNICAL SKILLS:

Database: Database Design, SQL Server 2012/2008/2005/2000 Transaction SQLOLTP, SQL Server 2012/2008/2005/2000 Reporting Services

Business Intelligence: SSIS, SSRS, SSAS

Reporting: Access 2007/2010, SSRS, Crystal Reports, PowerBI

Programming: C#, VB.Net, ASP.NET, Ajax, Windows Forms, Web Services, XML, COM/COM+, IIS, OO Design, Design Patterns

Financial Analysis: Trading data analysis/Accounting & Back office data analysis

PROFESSIONAL EXPERIENCE

Confidentia

Sr. Data Analyst/ Business Analyst / BI Developer

• Created ETL packages using SQL Server 2008 SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS).
• ETL sales data and inventory data into the ERP system and third party web based applications.
• Ad - hoc T-SQL
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010.
• Used Python with MySQL to do the market data collection

Confidential, Monterey Park, CA

Sr. Data Analyst/ Business Analyst / BI Developer

• Designed and developed ETL Logic for around 20 different IPAs Health Care databases.
• Designed and developed ETL Logic for NDC, Patient, Physician, and Hospital data
• Designed and developed SSRS reports
• Worked with Software Developer Team and involved in analysis, design, development and deployment of different new products and services. Designed and developed the conceptual, logical and physical models according to the business requirements.
• Developed the Stored Procedures, Triggers, Functions, T-SQL scripts, DTS and SSIS packages.
• Involved in analysis, design and development of Data Warehouse projects
• Involved in Performance Tuning and Optimization of Stored Procedures and SQL scripts.

Confidential, Westlake Village, CA

Sr. Data Analyst / BI Developer

• Designed and developed ETL Logic for stock trading data and OMS (Order Management System).
• Created the SQL scripts to replicate/synchronize the data from OLTP Database Server to Data Warehouse Server.
• Extracted the data from OLTP and Data Warehouse databases as per user requirements.
• Supported Data Warehouse production environment SQL Server (after hours production support) to resolve any production issues for the daily/nightly ETL jobs.
• Used Visual Source Safe (version control system) to check in and check out the database scripts, stored procedures and other code files.
• Used the Erwin Modeler and Visio to design the conceptual, logical, physical and dimensional models.
• Designed Reporting Services/Web Applications/ Windows Applications for accounting/traders report—internal application to be used by other departments to calculate the revenue/trading volume.
• Migrated SQL database objects from SQL 2000 to SQL 2005, from SQL 2005 to SQL 2008

Confidential, Westlake Village, CA

Contractor, BI Developer / SQL Database Developer

• Web site design using ASP.NET, VB.NET, ASP, HTML, Javascript and XML template designer.
• Worked on Web Content Management Project using HTML, ASP.NET, VB.NET, ASP, VBScripts, XML, COM/COM+, SQL Server.
• Designed and developed SQL 2000/Access database for the payment & invoice system/other daily routine tasks automation.
• Migrated SQL database objects from SQL 7 to SQL 2000.
• Upgraded applications from .NET 1.1 to .NET 2.0.