Tamera M. Clark Email & Phone Number

Arrington, Tn

Currently specializing in Business Intelligence projects of all sizes.* Ability to convert existing reports to SSRS.* Identify performance enhancements for existing databases and stored procedures.* Converting existing objects to Microsoft technologies. * Architecture and database design solutions.Recent Projects* SCSM - SSRS reporting * SSRS migration

*Regional Mentor - SE (past Heartland Region & Mid Atlantic)Passionate community volunteer–Dedicated to PASS and the SQL Server community–Understands the value of giving his/her time and talents to helping others increase their knowledge and skills and improving the overall communityPASS ambassador–Understands PASS and its mission and represents the best of PASS to Chapters in his/her area–Works to keep PASS accountable, on track, and meeting the needs of its membersPrimary point of contact for Chapters–RM facilitates 2-way communications: resources, benefits, and news from PASS to Chapters and Chapter needs and feedback back to PASS–RM knows who to contact at PASS, at the local/regional Microsoft office, area sponsors, etc. if Chapters need something or have questions*Nomination Committee (NomCom) 2013Members of the NomCom get a behind-the-scene experience with the Board of Directors election process, using their knowledge and previous volunteer experience with PASS to review applications for candidacy of the Board according to process and criteria outlined by the Board of Directors. Once complete, the NomCom then presents a list of recommended candidates to the Board of Directors, which then approves the final slate.*Nashville SQL User Group-Leadership Team*Nashville Business Intelligence User Group-Founder*SQLSaturday #363 Nashville Jan 2015-Event Chair*SQLSaturday #272 Nashville Jan 2014-Event Chair *Women in Technology (WIT)Chapter member*Community Speaker-Presenting at SQLSaturday events across the nation.

Greater Nashville Area, Tn

Gather requirements from business stakeholders, end users, and other technical teams in order to create data flow diagrams, technical specs, design documents and data dictionaries.Working closely with .NET developers and understand their service calls to create database objects in support of end user applications and back-end processes. -----Assist, support, troubleshoot and validate that .NET calls and database objects are functioning as desired. Use XML as both Stored Procedure inputs and outputs, validate XSDs and parse XML that has been stored in the database. Database development in a mission critical environment with 100+ SQL Servers and 50,000+stored procedures with current 0 deployment defects. Create database objects, normalize tables, maintain referential integrity and ensure that stored procedures are efficient while following industry/company design conventions.Follow Change and Release management requirements in order to deploy database objects to integration, testing and production tiers. Assist analysis team in identifying entities, attributes and relationships. Develop complex ad-hoc queries and stored procedures to analyze data and provide solution recommendations. Develop business reports for various business functions using SSRS. -----Create lookup reports to empower SQA engineers by providing access to data for troubleshooting and validation.-----Create ad-hoc reports for finance and business users to validate, troubleshoot and preform status lookups across several diverse data sets & applications.Recommend and create quality checks to assist the business in maintaining data quality and integrity.Experience with Transparent Data Encryption and column-based encryption.Responsible for troubleshooting production performance issues and creating valid recommendations for fixing by using DMVs.

Nashville Tn

Responsible for defining and interpreting data usage and meaning across the organization.-----Creating standards and documents for data dictionaries, report request and functional specifications. Onboarding, training and mentoring of new staff from entry level (transitional, college interns) to senior level/delivery managers.-----Teaching basic database concepts; functionality, normalization, administration to advanced SQL training provided for entire team.-----Providing an onboarding session on how ETL,BI, Data Warehousing, Data Engineer, Data Access, DBAs, and Data Analyst all relate and function as a team. -----Design and implement onboarding process, peer review process and implement code repository including naming conventions and coding standards.Corporate implementation of SSRS 2008 R2. -----Assist in creating and managing user access, roles, and policies. -----Develop and deliver internal training to over 200 people including delivering online only sessions for our foreign entities. -----Train, coach and provide query optimization for resource intensive reports.

Supported usage analysis of key services by creating centralized, custom reports using SQL Server Reporting Services.-----Gather requirements and businesses processes to facilitate query and report creation across the organization. -----Analyzed existing data & data sources on SQL Server 2000, 2005, and Oracle-----Developed reports using SQL Server Reporting Services 2005/2008.-----Managed Permissions & Access within SSRS.-----Assisted administrators with SSRS configurations and latest upgrade.-----Developed SQL queries to create datasets for reports from various cross-platform data sources.-----Assist co-workers with SQL query creation, report creation and troubleshooting.Work with subject matter experts and customers to gather user requirements, use cases, process, interaction, and/or data models to help clarify the design of the system. -----Create screenshots style documentation for developers to work from. Write documentation such as workflows, business process, technical requirements, functional specs, training and support documentation as needed.Assisted in the development and ongoing growth of our Change Management, CMDB, and Outage Notification processes. Evaluate new and emerging technologies that benefit the university’s teaching and learning mission by thoroughly researching, rigorously assessing, and objectively recommending means of analysis. This includes writing end-to-end documentation. Manage architecture and implementation of HP (formerly Mercury) Loadrunner, QTP and Quality Center for central information technology organization.Coordinate and execute performance testing for implementation of enterprise course management system (Blackboard Vista 4.x).Contributed heavily in performance testing of SAP (financial, campus management and GUI) to ensure stability for timely go live. Continually seek out, learn, and apply new technologies and processes rapidly, adapt to changing and time-sensitive priorities.

Served as Administrative Assistant to the Director of Development and the Director of Alumni Relations for the School of Technology. Compiled data and prepared confidential reports on donors, alumni and corporate partners. Edited and recommend enhancements to the formal gift process. Planned and coordinated annual alumni events and development events as well as oversaw the completions. Maintained knowledge of up-to-date development procedures and information technology to enhance the development process.Created correspondence for development activities, stewardship and gift acknowledgement programs. Designed and took to press invitations and promotional materials used for events. Prepared, wrote and edited content for newsletters and annual report. Also worked closely with Purdue Printing Services and outside printing companies to meet printing needs.-----Developed Microsoft Access database to efficiently process giving reports into personal correspondence for donors. Planed and coordinated social and engagement events for the school, working with many diverse groups inside and out of the campus community. Worked closely with the University Events Management office, Technology staff, Purdue News Services and Purdue Marketing Communications, and vendors to design, develop, and staff informational displays and booths at university events and exhibits.

Ariba ORMS Implementation (E-Commerce Application)Support the Ariba ORMS project team. Ariba, a web-based procurement system utilizes a variety of technologies, including XML, Java and Oracle. Leaned a great deal about these technologies while providing clerical support to the project team. Additionally provided end user support to Purdue staff. Support and assisted the Ariba System Administrator. Educated suppliers on how the Ariba order works. Troubleshot user and system issues and resolved help desk calls. Trained users to perform a variety of tasks in Ariba. Evaluated, tested and documented all user reported issues.Assisted in quality assessment and system testing activities by developing test plans, scripts and test execution.Analyzed various errors and reporting logs to isolate problems and look for possible solutions.