SUMMARY:

• Excellent working data analysis and documentation experience, using R, Python, SQL and Hadoop.
• Experiences in software development life cycle (SDLC), prototype and supported production environment in business.
• Strong knowledge in enterprise database, data warehouse and data mate solutions.
• Experiences in ETL and CRM operations using different business intelligence tools.
• An effective collaborator with others and leadership skills developed through multiple project across different domains.
• Enthusiastic technical consultant who can easily adapt to new environment and maximize business opportunities.

TECHNICAL SKILLS:

Database: MS SQL Server, T - SQL, MySQL, Hadoop, Access, MS Dynamic

Business Intelligence: SSIS, SSRS, Tableau 9, Salesforce

Statistical: R, SAS, Python, Excel (VBA)

Programming: JAVA, Linux, C#

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

CRM Data Analyst

Responsibilities:

• Identify, understood and document business requirements for new reporting solutions
• Perform filter and “clean” current CRM data and use ETL tools to load the data into destination database
• Review data elements with the Business Owner to ensure requirements were completed
• Provide definitions, lineages and valid values for critical data assets within the area
• Interpret CRM data, analyze results and provide ongoing CRM reports
• Research and acquire data from primary or secondary data sources and maintain Microsoft dynamic database systems
• Identify where the elements was located and understood the transformation logic as to how the element was created
• Conduct data analysis in support of critical data elements to be reported for reporting
• Initial test of the data element to discover and identified whether the data was aligned to the required Business Rules and where potential data issues existed
• Proactive Data Quality and monitored ongoing quality of data assets

Confidential, Columbia, MD

Data Analyst

Responsibilities:

• Collected and assembled customer energy data from SQL Server, mined data with SQL query and improved new energy model which resulted in energy cost decreased by13%, stepping down 4% to 5% annually
• Pre-processed data, routinely used advanced Excel Add-in ‘Server’ functions and pivot tables to generate spreadsheets describing utility of different types of families for last 6 months to drive decisions
• Used various analytical tools to analyze target real estate property data and create a comprehensive dashboard
• Analyzed target project data and implement procedures to support development teams and help them make a decision
• Effectively identify errors and issues involving target data flow discrepancies, following up with recommendations to improve decision accuracy
• Involved to work with troubleshooting the stored procedures, functions, views, triggers etc. & part to be increasing the performance tuning.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases

Confidential, Pasadena, MD

Data Analyst

Responsibilities:

• Participated in requirements meetings to understand the requirements from the business people
• Created and Modified tables, views, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE)
• Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default
• Performed Development Integration, System Integration, End to End and User Acceptance Testing for the data services
• Designed, coded, tested and debugging business logic for software Applications
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan and Index tuning advisor
• Performed ETL, data profiling, data quality and clean ups for SSIS packages
• Created SSIS packages to populate data from various data sources
• Created package with different data sources (SQL Server, Oracle, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)

Confidential, Cleveland, OH

Financial Data Analyst

Responsibilities:

• Developed stock portfolio strategies and investment policy, increased 10% of total return of investment fund
• Responsible for maintaining the integrity of the Stock MySQL database and reporting any issues to the database architect
• Used Excel Access managing and mining financial data from the SQL database that was used in several significant presentations
• Assisted in offering support to other personnel who were required to access and analyze the stock fund data from SQL database
• Created weekly evaluating financial report (NPV, IRR, discount cash flow, and ROI) which is implications of new products, and investments from MorningStar and Bloomberg, applied data into model
• Identified ‘significant’ stock and produced weekly stock report with recommendation insights using weekly charts and tables
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity
• Developed SQL scripts to Insert/Update and Delete data in database tables and created Stored Procedures and User Defined functions
• Worked in Grouping, Summing, totaling, Case Limits, Common Table expressions
• Wrote SQL scripts to manipulate data for data loads and extracts
• Manipulated, cleansed & processed data using Excel, Access and MySQL
• Analyzed raw data, drawing conclusions & developing recommendations
• Data entry, data auditing, creating data reports & monitoring all data for accuracy

Confidential

Financial Data Analyst

Responsibilities:

• Assisted in creating and presenting informational reports for management based on Financial SQL data
• Assisted in creating quarterly statement with stock investment group and prepared financial data report for manager decision and exhibition
• Called on to help make changes to the SQL database that would prevent data corruption
• Built a valuable new decision model by applying excel suits for analysis requirement and stock value estimate, and brought 10% increase of return
• Created financial analysis of corporate financial statements and tax filings to establish normative profiles across 50 companies in the U.S. as a client support tool for market, investment, and strategic business decisions