Project Data
Resume:
Tanuja S Doijad
Cary, NC
**********@*****.***
Experience Summary
• Over 10 years experience in Information Technology
• Skilled and experienced Programmer Analyst with strong Database skills in
SQL Server, Application Development and Reporting.
• Experience working in roles with increasing responsibility.
• Experience includes technical analysis, Data analysis and project
management.
• Experience working with internal and external clients on short term and long
term projects
• Experience in all project related tasks that include requirements gathering,
Data Analysis, Design, Development, QA and support
• Strong ability to work independently or in a team, under minimal direction
and supervision to deliver projects within specified timelines
• Utilize and modify standard applications and tools to manage educational
assessment data.
• Create custom software solutions in consultation with client and project
managers.
• Ensure proper collection and validation of data from student tests and
transform it into deliverables such as student, school, district, and state reports.
Generate ancillary materials (header sheets, barcode labels, etc.) to facilitate
test delivery, administration, and return.
• Participate in process improvement and project documentation.
• Maintain commitment to meeting/exceeding client expectations, strict
timelines, and the highest standards of security and confidentiality
• Lead a team of Programmer & QA staff to design, develop, test and deliver
IT solutions to meet customer requirements.
• Formulate, debug and performance tune SQL queries to meet the Data
requirements of Projects.
Technical Skills
• Database: SQL Server 2000, 2005 and 2008. MS Access
• Reporting: Crystal Reports, SQL Reporting Services
• Programming: Visual Basic 6.0, ASP.net, C, Cold Fusion, Java
• Tools: Visual SourceSafe, Visual Studio, MS Excel, MS Word, MS Project, Pdf
Maker
Education
• B.S. Industrial Electronics & Communication Engineering
Bhartiya Vidyapeeth, University of Poona, Pune, India, 1994
• Diploma in Computer Applications
Datamatics, Inc., Pune, India, 1995
Professional Experience - Measurement Inc
Team Lead (2010-Present)
Projects: Folio (Learning Express)
Tasks & Responsibilities
• Lead role in analyzing the viability of 3rd party website purchased by MI and used by
Schools across many states to monitor Student progress reports
- Analyze and understand complex database schema and processes
- Identify the cause of the issues on the website before, during and after Production -release
- Provide ongoing support and expertise in resolving production issues
Team Lead (2006 to Present)
Projects: Alabama Science Assessment (2000 – Present); Michigan Educational Assessment
Program (2008); Alabama Direct Assessment of Writing (2006-2009)
Tasks & Responsibilities
• Gather project requirements from client and translate to project specifications
• Plan, design, and implement application database code objects, such as stored
procedures, functions, triggers and views.
• Conduct Data Analysis and lead the development of complex student score reports
• Train and mentor new team members on specific modules of the project.
• Track Project progress and make required adjustments to deliver project on schedule
• Work closely with client during the development, testing and delivery phases to ensure
project meets the client requirements.
• Lead in setting up of processes to ensure data quality
• Formulate complex queries, stored procedures and do performance tuning
• Provide design and technical lead in developing complex reports in Crystal
• Provide technical leadership in improving service provided, cost savings and delivering
benefits to the business.
Lead Programmer (2004 to 2008)
Projects: Ohio Test of English Language Acquisition (2005-2006); CCSSO English Language
Development Assessment, K-12 (2004-2008)
Tasks & Responsibilities
• Set up the project from scratch ( all the cycles of the project)
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and
extraction.
• Implement procedures and processes for data cleanup
• Create reports in crystal and excel as per client requirement
• Set up DTS jobs to transfer data from flat files, Excel spreadsheets to and from SQL Serve
• Incorporate security controls on the SQL Database for restricted access.
• Design and create Report templates, bar graphs and pie charts based on the test score
data.
• Develop processes to facilitate import and normalization, including data file for
counterparties.
Programmer Analyst (2001 – 2003)
Projects: New Jersey High School Proficiency Assessment (2001-2002); New
York Regents Examinations, Illinois Local District Scoring, Sinai Akiba, Connecticut Mastery Test
(2002-2003)
Tasks & Responsibilities
• Import and analyze student data
• Work as part of a team to on assigned project modules
• Module development (coding) in Visual Basic.
• Set up Project code in Visual Source Safe to comply with code changes and version
releases.
• Develop SQL queries and stored procedures required for purpose of Reporting, Data
Analysis, & Extraction.
• Perform operational tasks comprising data load, maintenance, data analysis and problem
resolution.
REFERENCES Available upon request
Contact this candidate