Objective :

Highly motivated, detail oriented, focused, energetic candidate with 4 years of IT experience seeking a position as Data Analyst using my skills in Crystal Reports, SSRS, SSIS, SSAS using SQL Server 2005/2008 andMS ACCESS, EXCEL.

SQL Server SSAS-SSIS-SSRS 2005 / 2008 (Business Intelligence development)

• Good Knowledge of data warehousing, schemas, OLTP and OLAP.
• Planning, staging, optimizing and deploying ETL solution.
• Reporting tools SSRS, Crystal Reports, Access, Excel, Visio.

SQL Server 2005 / 2008 Implementation and Maintenance

• T-sql, stored procedure, schemas, joins, DDL, DML.
• Create logical/physical databases, tables, views, indexes, query optimization.

PROFESSIONAL EXPERIENCE :

Confidential,CA. June 2011 to Sept 2011

Data Analyst / Developer

• Worked on integration project team for Clinical Trials and Internal Review Board.
• Created custom reports using iReports and Crystal Reports X. Created forms and workflows according to the specification and delivered it in timely manner by setting up priorities. Notified management if there is any delays in the scheduled date for enhancement delivery.
• Business requirement gathering and training the end user thru meetings.
• Performed backend testing on enhancement codes, release notes and checked if the users/ business requirements were met.
• Performed UAT in the QA before transferring it to production and troubleshooting.
• Paid attention to details and worked independently as well as in a team to complete the project. Adhere to the company\'s privacy policy (HIPPA) thru out the project.

Confidential,Los Angeles, CA May 2002 to Oct 2009
Data Analyst / Developer ( June 2006- Oct 2009)

• Extracted data from data warehouse and different data sources. Fixed data issues and clean data as necessary. Transformed it to fit operational needs and loaded it into target database (ETL). Summarized data into a meaningful graphical way. Performed analysis and recommendations.
• Generated ad-hoc reports as well as daily, weekly and monthly reports using SSRS. Published on the company intranet. Imported data into EXCEL as a pivot tables and charts as necessary for data analysis. Updated reports when requirement changed or data changed.
• Executed reports on demand. Configured and scheduled cached reports and snapshot reports for delivery . Created standard and data driven subscriptions .
• SQL query analysis and optimization to fix errors. Write stored procedures, triggers.
• Routinely managed and updated data in databases as needed. Recommended corrective actions, standard procedures and documentation.
• Served as a team member on projects while supporting day-to-day activities. Assisted with data related issues and training as needed.
• Demonstrated ability to priorities work, solve problems independently and responded in a timely manner to data requests to ensure daily, weekly and monthly deadlines.
• Maintained high degree of business functional knowledge and willingness to learn new technology.

PROJECTS :

Integration Service (SSIS) and Analysis Service (SSAS) projects

• Created data sources, data source views and event handlers to complete ETL processes.
• Configured control flow, variables, constraints to refine packages.
• Implemented transformations Configured and implemented logging to view errors, warnings and events generated by data flow.
• Incorporated custom debugging and error handling in the packages to control failure .
• Implemented checkpoints and transactions for manageability and reliability of the package
• Created and modified cubes , dimensions, defined relationships and hierarchies, sorted and grouped dimension attributes. Refined company’s OLAP cube by modifying and formatting measures and measure groups and designed aggregations.
• Created calculated members, KPIs, drill through action..

Quality Data Analyst ( May 2002 to May 2006)

• Developed, implemented and co-ordinated action plans and quality improvement strategies with supervisors and managers.
• Participated in special projects. Analyzed the nature and cause of errors to identify areas needed improvements in the department.
• Analyzed data, provided the technical review and assisted QA in document revisions.
• Performed in-process and raw material testing , release and stability assays according to Standard Operating Procedures (SOP).
• Project lead for the validation and development of new assays. Trained junior associates I, II.
• Trouble-shoot internal and external customer complaints with assay performance according to work instructions.
• Demonstrated a positive and professional attitude towards workplace, co-workers and company policies.

TIMELINE of EDUCATION and EXPERIENCE :

June 2011 to Sept 2011
Confidential, Pasadena, CA
Data Analyst / Developer
Reason for leaving- contract

June 2010 to April 2011
Attended New Horizon Computer Learning Center and completed MCITP BI Certificate.

November 2009 to May 2010
Seeking new employment (after lay off).

May 2002 to October 2009
Confidential,Los Angeles, CA.
Quality Associate to Data Analyst / Developer
Reason for leaving –plant closed.

Bachelor of Science in Physics