Sql Server Developer

Mukhia, Roshita

**** ****** ***, ** *******, CA *4530 acd4ka@r.postjobfree.com http://www.linkedin.com/in/roshita 773-***-****

Highly motivated and confident in software development, business requirements, product ownership.

Now looking for new challenges which can utilize my existing skills and experience to enhance product

value and benefit.

SUMMARY OF EXPERIENCE

10 years of custom software product development experience involving requirement analysis, product design and

•

reengineering, user experience improvement, product ownership, project management and delivery.

Member of Software Committee to evaluate the software functionality and benefits for approval and prioritization.

•

Provide technical documentation for development team and user manuals, presentations and trainings for clients and

•

users.

WORK EXPERIENCE

Career Education Corporation Jan 2013 – Till Date

Senior Software Developer

Currently working as senior developer and product owner for LCMS (Learning Content Management System).

Reduced the development environment set up time by 90% by migrating existing LCMS SharePoint application to

•

.NET application.

Continuously improving the performance, usability and speed by refactoring code and redesigning the existing

•

features in LCMS.

Enhanced LCMS as one stop shop to create adaptive learning courses, assignments connecting to external vendor

•

through web service and completely removed the multiple manual steps by 95%.

Developed the stored procedures for complex business reports of Wow Castle project and increased the security and

•

performance by reducing server side manipulations.

Environment/Tools:

• .NET C#, JavaScript, JQuery, HTML, CSS, WCF, XML, WCF, SharePoint, MS SQL, TFS, MS Visio

Comcast Spotlight March 2009 – Jan 2013

Application Developer

Product owner of custom in-house software products responsible for design, development and timely enhancement releases.

Automated the comparison of DTV markets and networks across the entire Comcast Spotlight to support I+ business

•

strategy to reach more right consumers. Received the GEM (Going Extra Mile) award for this.

Proposed and designed ART (Access Request Tool for user and admin) to submit access request and approval

•

process, renewal reminder and automatic expiry if no renewal to follow the standards of software compliance.

Centralized the data warehouse site information by designing and developing Spotlight IT database and application

•

having important information such as point of contact for site, server information, outages, work logs, equipment

etc. Admin can update information about these sites.

Controlled the access to SQL Server by 95% by designing and developing the xml driven Query Report Tool so that

•

only database team have access to SQL Server.

o User site where users can execute queries, submit access to execute query.

Admin site where database team can add new queries by business categories and division, execute the

o

reports and see the logs of queries executed by user or time.

Developed the Ticket Survey System to send the automatic survey email whose tickets has been recently closed.

•

Controlled the direct access to company Active Directory by 95% by developing the distribution list finder tool

•

where employees can find the right distribution list depending on target audience.

Environment/Tools:

• .NET C#, JavaScript, HTML, CSS, WCF, XML, MS SQL, Oracle, SSIS Package, Visual SourceSafe, MS Project,

MS Visio

Progressive Insurance Company May 2004 – Feb 2009

IT Application Analyst/Programmer II

Hired as IT Intern – Masters and then hired as full time after graduation. Worked in various teams like tools and framework,

transaction team, data warehouse and software configuration and management team.

Product owner for Policy Explorer tool that helps developers and testers to create and test policy in development and

•

different test environments.

Enhanced DAF (Data Access Layer) for front end application to connect to database system.

•

Designed and developed the web application for business team to see various information about Progressive agents

•

and execute reports.

Automated the application packaging and deployment procedure and removed the manual steps by 50%.

•

Automated migration tracking process by designing and developing the web tool to track the migration of

•

application, data, tools from Ohio data warehouse to Colorado data warehouse.

Environment/Tools:

• .NET C#, JavaScript, HTML, CSS, XML, MS SQL Server, TFS, MS Visio

Bowling Green State University Aug 2003 – Dec 2004

IT Consultant, Assistant Web Developer, Market Research Assistant

Worked as part time employee in Continuing and Extended Education department, Jerome Library and FLAAR during my

Masters study in Bowling Green State University.

Designed and developed the backend database system and the front end website for students to participate in online

•

discussion forum, submit assignments, grade assignments.

Assisted in enhancement of library websites.

•

Compared performances between different image processing software in machines with same and different hardware

•

configuration and created reports for them.

Environment/Tools:

• PHP, Action Script, HTML, CSS, XML, JavaScript My SQL, Adobe Photoshop, Adobe Illustrator, Adobe InDesign

QUALIFICATION

Master of Science, Bowling Green State University, Bowling Green Ohio. Major in Computer Science.

•

Bachelors of Engineering, Kathmandu University, Dhulikhel, Nepal. Major in Computer Engineering.

•

High School, St. Xavier’s School, Kathmandu, Nepal. Major in Pure Science (Physics and Mathematics)

•

AFFILIATION

IEEE Chicago Section PACE – Volunteer

•

Contact this candidate