●Worked closely with business stakeholders to perform business analysis and gathered specifications and requirements for Business Intelligence and reporting project needs●Measured, optimized and streamlined existing ETL processes to enhance the productivity and usability●Provided analytical and programming support for research and business intelligence activities, including UCSD student data extraction, preparation , analysis and validation ●Designed and monitored ETL processes for extraction of student data (ISIS) and other data from the campus data warehouse or other off campus systems utilizing IBM SPSS statistics and Microsoft SQL and DB2 SQL ●Collected and prepared various research data such as Admission, Enrollment, Registration, Grades, Student Profile, Retention and Graduation rate analysis reporting to variety of UCSD internal and external users●Provided longitudinal and term specific databases to UCOP for conducting variety of surveys (e.g. YFCY, TFS, CSS, UCUES and so on) ●Supported systematic research, and evaluation studies on the institutional impact and effectiveness of Student Affairs and other campus programs and practices on student development and outcomes for Athlete, Financial Aid, Study Abroad program and so on●Analyzed student data beginning with pre-enrollment characteristics, assessment of student development, perceptions, and satisfaction with the undergraduate experience ●Measured the trends in student characteristics, behavior, attitudes, satisfaction, retention and graduation, and describes the implications of these trends●Provided Student Affairs in particular and the campus-community in general, with information that supports institutional planning, policy formulation and administrative decision making●Created and maintained local data files and databases populated from numerous sources, including campus data warehouse, UCOP system wide files and National Student Clearinghouse

●Conducted business analysis and provided feasible options and resolutions to meet business needs●Upgraded the legacy systems and optimized the existing processes to enhance productivity for Budget and Real Estate office ● Migrated databases from SQL 2000 to SQL 2008 and refactored queries , views, triggers and functions● Upgraded in house .Net applications from legacy .Net to .Net 4.0+● Migrated .Net applications from Microsoft IIS 6 to IIS 7 and configured IIS 7 web server to resolve compatibility and version issues● Designed, developed and tested in house data driven applications for various departments such as Real Estate, HR, Imprints and Fleet using MS ASP.Net and SQL 2008 server● Developed and enhanced EH&S department in house Java web and Oracle database application such as MUA (records the equipment and machines used by medical facilities at UCSD), CSUA (records chemical and substance used by the labs at UCSD) using Eclipse Juno and Aqua Data Studio● Worked closely with various departments from VCRMP to address business issues and identify the business needs and recommend short and long term solution● Applied Scrum and Agile development methodology to deliver business solution as required● Identified and exported Strategic Lease/Property Information Management System (SLIM) data from Fox Pro database to a MS SQL 2005 database. The export process included an analysis of the data to remove inconsistencies caused by either file corruption or data entry errors● Created and performed data modeling and database normalization in MS SQL● Maintained MS SQL databases on the newly activated web server to house the data from Real Estate Lease Management (RELM). Maintenance of the database entailed frequent backups of the data to ensure a quick recovery in the event of a disaster. Additionally monitored and tuned the database for performance to deliver results as quickly as possible to the user by shrinking files or rebuilding or reorganizing indexes

● Performed business analysis to identify the current issues and recommended short and long term solutions● Performed and managed files and data backup to meet disaster recovery plan● Identified and evaluated business needs and coordinated resource to meet user requirements● Performed in house applications design, development and test using Microsoft ASP.Net and SQL technology● Performed MS Access and SQL databases integration and migration● Documented specification, requirements, user cases, data dictionary, ERD and Object Oriented diagrams● Maintained and supported Window 2000 client-server environment and backup system● Provided helpdesk assistance for Tribal employees with software and hardware issues● Worked as project lead for designing and developing various data driven applications

● Designed, implemented, and tested database applications using Oracle PL/SQL● Performed issues analysis and recommended solutions● Gathered and documented business requirements and specifications

● Helped and tutored college students with their C++ programming homework and projects

● Designed databases using Microsoft Access● Provided technical assistance for King County employees with Microsoft Office, Internet and E-mail skills● Assisted WAN/LAN administrators in the resolution of network/desktop issues as assigned