Randy Lee Email & Phone Number

Richmond, Virginia, United States

Richmond, Va

Wrote and executed DDL to create and maintain tables and stored procedures.Wrote and executed DML scripts to insert and modify data.Developed SSIS packages to move and transform data.

Glen Allen, Va

SQL Server security setup/maintenance...ensured users had appropriate server-level access and database-level roles and permissions.Wrote and executed DDL to create and maintain tables, views, stored procedures, indexes, constraints, functions.Performance tuning...created and analyzed profiles and execution plans to trace potential performance issues, made adjustments to queries to improve performance.Created and maintained data models using Visual Studio.Created and executed complex adhoc DML queries to read and/or modify data, deliveredrecords/results to end users in CSV or Excel format.Performed database backups and restores.Set up replication across OLTP and backend servers...created publications andsubscriptions, set up replication security, created snapshots, monitored replicationprogress using replication monitor.Developed reports using SSRS (Visual Studio 2008)...used Report Designer (BusinessIntelligence Development Studio), created .rdl files, deployed to report server, createdand managed report subscriptions.Provided support for code releases through TFS source control, builds, deploys.Served in a 24x7 on-call production support capacity.Managed MongoDB instances...installed clusters of MongoDB instances on Linuxmachines, setup security, created replica sets.Queried and updated MongoDB collections to maintain data and retrieve large sets ofdata for reporting and analysis.

Glen Allen, Va

Production support, troubleshooting, interfacing between engineers and users, queuing development tasks (bug fixes, enhancements, etc.) for the engineers.

Glen Allen, Va

Organization makes life easier.Life is challenging. In the rush of activity, our stuff ends up everywhere, and eventually, it can overwhelm us. It's hard to know where things should go or how to keep them there.Whether it's a garage, closet, attic, kitchen, office, shed, or living room, Organize Guys loves that challenge!Serving the Metropolitan Richmond area, Organize Guys helps make sense of your space and your stuff.Get rid of the clutter. Maximize your space. Manage your stuff.

Glen Allen, Va

Provided technical clarity and expertise to the sales and candidate placement (delivery) process for all Java/J2EE opportunities, servicing over 40 Apex branches nationwide. Helped define and develop various responsibilities and processes for the role. Mentored two other Delivery Analysts when they joined Apex.Qualified over 200 Java openings with clients around the country as a technical business analyst, increasing fill ratio from 15% to 40%. Met with clients in person as well as over teleconference. Spoke with hiring managers and technical leads, gathered requirements, discussed their needs and their environment. Used technical experience to translate, distill, clarify, and document client requirements. Communicated requirements to Apex account managers and a team of Java specialty recruiters. Provided technical guidance and mentoring to Java specialty recruiters. Held regular training sessions on Java and other technologies, tools, and general application development concepts and processes. Developed a web-based tool that provided specialty recruiters with a quick-reference set of Java and other screening questions/answers. Provided perspective on relationship building, the IT marketplace, and how to navigate their career. Identified inefficiencies and opportunities for optimization in team process and activity tracking. Envisioned, designed, developed, tested, deployed, and supported a PHP/MySQL web application to streamline team process and provide a centralized point of data entry and reporting. This tool became foundational to day-to-day team process, as well as a source of record for reporting to EVPs and other Apex senior management.Technically screened candidates for positions. Developed screening questions and process to evaluate candidates' abilities, real work experience, and fit for position. Prepared candidates for interview process.

Glen Allen, Va

Developed, tested, and executed a backend Java batch job process to migrate data from multiple tables in an existing Oracle database to a new Oracle database, provisioning hundreds of thousands of users with unique single-sign-on IDs.

Glen Allen, Va

Designed Informatica ETL interfaces as part of the Circuit City Merchandising Systems Transformation (MST) initiative. Responsible for interface requirements gathering/analysis, ETL design/review, business reporting requirements gathering/analysis, and report design.

Glen Allen, Va

Created/developed internal application to enable smooth transition for new hires and build CapTech internal relationships. Envisioned idea, achieved buy-in from management, wrote, tested, and deployed code.

Glen Allen, Va

Designed and developed multi-tier financial applications in support of solicitation setup processes used for Capital One's 50-million-customer credit card base.Modified and enhanced a critical internal J2EE application used for solicitation setup. Utilized Agile, Scrum, and XP methodologies - 3-week iterations, daily stand-ups, JAD sessions, and retrospectives. Developed and supported Oracle database for large solicitation setup application. Wrote and executed effective and consistent SQL and PL/SQL code, provided data analysis for other systems and teams. Development efforts facilitated the implementation of a $500 million project.Created and reviewed technical design documents for multiple projects using UML design standards - use case, class, and sequence diagrams. Design work contributed to the success of four projects. Responded to production incidents involving the major applications supporting account setup. Worked with production support team to identify problems and solutions, resolving all production incidents with high level of customer satisfaction.Analyzed and initiated implementation of internal tool (Lotus Sametime) for real-time communication within the department. Resulted in increased efficiency and productivity.Demonstrated initiative by assuming the responsibility of Document Manager for team of 30 associates. Using LiveLink, created consistent process and consolidated location for team documentation, increasing team productivity.Identified, submitted, and tracked defects and opportunities for enhancement in applications.Identified functional defects and usability enhancements in the corporate intranet and www.capitalone.com websites. Resulted in improved quality and user experience.Led implementation of a defect-tracking tool (TeamTrack). Negotiated and designed with the vendor, installed and configured the tool, trained and supported users.

Purdy, Mo

Handled staffing of over 500 paid and volunteer staff at a camp for special needs children. Established a plan and process for hiring, training and retaining quality paid staff and volunteers. Managed and led training for staff, ensuring they were supported before and during their time at camp.