OBJECTIVE:

Database Analyst /Business Analyst/ Reporting Engineer

• Master of Computer Science with experience of Oracle SQL, SQL Server 2008, Access 2007 database, data loading and Reporting tools such as SSIS,SSAS,SSRS and Crystal Report 2008 experience
• Professional experience of most advanced Oracle 11g Database server installation, user account setup, SQL, sqlplus, SQL*Loader, load variety of data into Oracle database tables
• Professional experience on load variety of large volume data files into SQL Server 2008 database tables, migrate Oracle tables into SQL Server 2008 databases and generate Report with SSRS.
• Experience on high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
• Robust MS Access and Excel skill with Pivot tables.
• Experience of generating report with Crystal Reports from Oracle database, SQL Server 2008 and MS Access databases
• Database Analyze using advanced SQL queries to generate Matrix Report and Report with parameter to using SSRS from data warehouse
• Ability to prioritize and complete multiple tasks and detail oriented
• Proven capability to approach problems effectively and creatively in complex environment
• Quick learner, take initiator, and hard worker. Willing to take responsibilities

Database: Oracle 11g, SQL Server 2008, Access 2007,SQL, sqlplus, sqlcmd,SQL*Loader
Languages: SQLScript, T-SQL,PL/SQL
MS Office: Word, Excel, PowerPoint

• Oracle 11g, SQL Server 2008, SSIS, SSAS, SSRS, Crystal Report

• Successfully downloaded and installed Oracle 11g into database server
• Configured Oracle parameter file to adjust the memory usage
• Oracle 11g SQL single row and group functions, multi table joins, subqueries and advanced SQL queries
• Extracted data from Oracle 11g database tables into flat data files and excel sheet
• Loaded data from flat data file and excel sheet into Oracle database tables
• Generated varieties kind of business reports use Oracle sqlplus and excel
• Successfully downloaded and installed SQL Server 2008 into database server.
• Configured SQL Server 2008 parameter files to adjust the memory usage and file size.
• Create many database tables with many constraints including primary key, foreign key, unique, check and not null.
• SQL query use SQL Server 2008 Single row and group functions, multi table joins, subqueries and set options.
• Extracted data from SQL Server2008 database tables into flat data files and excel sheet.
• Loaded data from flat data files into SQL Server 2008 database tables using bcp, bulk insert, or table export, import.
• Generated all sorts Reports use advanced SQL and SSRS with multi-table join, group functions, subqueries and set operations.
• Employed SSIS Designer to create Microsoft SQL Server Integration Services package to extracted data from a flat file, reformat the data and insert the reformatted data into a fact table.
• Generated variety of business reports using SQL Server 2008, SQL Query, SSRS, Crystal Report 2008 and Excel 2010Pivot table.

SELECTED ACHEVEMENTS on Business Intelligence
SQL Server Integration Services (SSIS)

• Using the Control Flow and the Data Flow
• Solving Common SSIS Scenario
• Loading Dimension Table Data and Loading a Fact Table Data
• Deploying SSIS Packages

SQL Server Analysis Services (SSAS)

• Configuring a Data Source and Data Source View
• Using the Cube Wizard
• Editing Dimension and Editing Cube
• Adding New Dimensions and Measure Groups
• Using Data Mining Algorithms
• Administering the SSAS Instance

SQL Server Reporting Services (SSRS)

• Using Report Wizard
• Building a Matrix Report
• Building a Report with Parameter
• Building Reports on Cube
• Building a Dashboard
• Deploying and Administering SSRS

SharePoint

• Deploying and Using Reporting Services in SharePoint 2010
• Building PerformancePoint Dashboards in SharePoint 2010
• Deploying and Using Excel Services
• Deploying and Using PowerPivot in SharePoint
• Managing SharePoint Business Intelligence

PROFESSIONAL EXPERIENCE:

Database Analyst , Confidential, 2008--present

• Responsible for designing and developing custom programming applications.
• Create tables based on the client requirements, loading data and pursue data cleansing and auditing.
• Design data flow and extra data from a SQL Server database, transform the data and then load into different database or flat file.
• Upload the weblog files into different database and analyze the weblog data.
• Create a mining structure to predict business need in the future.
• Generated variety of business reports using different tools.

Research Assistant, Confidential, 2000-2004

• Maintain the research database, update and upgrade it from time and ensure safe storage of medical image data.
• Designing and developing project specific SAS programs like producing analysis datasets, graphics and reports
• Generated report using Excel
• Assisted Biostatisticians in creating database infrastructure, analyzing datasets and reports.
• Independently developed many T-SQL procedures, analyze data in the destination table using advance SQL group functions, sub-queries. Used SSRS generate business report.

Software Engineer, Confidential,1994-2000

• Handled the tasks of designing, developing and maintaining databases
• Responsible for identifying and procuring database software tools for efficient database development and usage
• Assigned the tasks of developing structural designs of various databases based upon logical data models
• Determined user requirements as well as sets up and tests computer databases
• Prepared, oversaw and coordinated database and application designs
• Worked closely with system users to make sure that the information system strategies meets with the program requirements
• Ensure client satisfaction through completion of project within schedule.

• B.S., Computer Science
• M.S., Software Engineer
• Certificate course of Management Information System