Sql Server .Net
Resume:
Tanu Chaturvedi
SUMMARY:
• **.* years of extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Analysis, Design, Development, Testing, Maintenance and Enhancement in variety of technological platforms with special emphasis on .Net Frame work and Business Intelligence applications.
• Extensive work experience with Asp.net, C#, Classic ASP, VB Script, ASP.net MVC, Web services, Wireframe Mockups, SoapUI, Balsamiq, SSRS, Datasets, Build Processes, LoadRunner, QTP, Testing and Installation Experience.
• In depth experience in .Net Technologies.
• Design, development, implementation and optimization of large enterprise wide applications for RBS, Citizens Financial Group, Datamatics Ltd, Nuclear Power Corporation LTD.
• Experience in re-architecture, refactoring, code cleanup, and redesign.
• Experience in various databases MS SQL Server 2000/2005, Oracle, and MS-Access.
• Extensive experience in tuning SQL, identifying bottlenecks and resolving to improve performance in various levels namely Sources, Targets, Mappings and Sessions Integrated .Net.
• Extensively used Reporting Tools like SQLReporting services, SSRS, PowerPivots
• Extensively worked on XML and XSLT
• Experienced with OOP, design patterns, Win Forms, WebForms, UI design understanding and experience.
• Full Life Cycle Development experience with exceptional analytical and problem solving skills. Ability to manage and deliver results on multiple tasks by effectively managing time and priority constrains. Able to work within a team environment as well as independently.
• Expertise with HTML 5, CSS, JavaScript, Ajax, XML, XSL.
• Thorough understanding and experience designing and querying database tables, stored procedures, functions and triggers in Oracle and SQL Server.
• Deep expertise in migrating legacy Microsoft and non-Microsoft based applications to the .Net environment.
• Experience in Interacting with Business/IT customers
• Used UML to design working with Sequence diagrams, Component Diagrams, Class Diagrams, Action Diagrams etc.
• Expertise in preparing Technical documentation and presentations
TECHNICAL SKILLS:
Operating Systems : MS-DOS, Windows 95/98/2000/XP/7, Windows 2003/2008 server
Database : SQLServer2000/2005, 2008, 2012, MS Access
Language : C, C++, VC++, .NET, C#, vb (2.0, 4.0, 4.5), MVC
Middleware : .NET Serviced Components
Web technologies : JavaScript, XML,XSLT, Classic ASP and ASP.NET, Jquery, CRM
Technologies : Web services, Datasets,
Reporting Tools : SQL Server Reporting Services (SSRS), PowerPivot
Utility Tools : Visual Studio 2008/2010, 2012
Design Tools : Microsoft Visio, ER Win and Rational Rose, UML
Source Control : VSS, TFS
Testing Tools : QTP, LoadRunner
Build Tools : TFS
BI tools DTS, OLAP
Web Servers : IIS 6.0, 7.0
Portal Software : SharePoint(2007, 2013)
IT Security Services : DataCertificates, Microsoft Security, Active Directory
Deployment Tools : Release Management
EDUCATION:
• Bachelor of Information Sciences (Delhi University).
CERTIFICATIONS Exams:
• Microsoft Certified Technology Certified (MCTS, Exam 70-526)
PROFESSIONAL EXPERIENCE:
Company: Arrowstreet Capital Ltd., Inc (Boston, MA)
Position: Associate, Applications Development
Duration: October 2014 - Current
Description: Implemented 6 compliance regulatory projects that enabled users in regulatory reporting for European Market Infrastructure Regulation (EMIR), 13F regulatory filings with SEC gov, changing administrator for certain accounts for daily and monthly files, automated European Short Filing system. That’s a daily filing that was done manually by the users. Designing and implementing a system that would allow business users to have a one stop shop for all regulatory filings.
Responsibilities:
• Part of the Technology Review Group (TRG). This group consists of senior software developers from various teams. They meet periodically to assess latest technologies and how to implement them in the projects.
• Design and develop systems that ensure business products are regulatory compliant and facilitate user’s deliverables, saving time and effort.
• Implement changes required by various filing agencies and inter-team projects that impact users.
Environment: Visual Studio 2010, 2013, .NET 3.5, 4.5, SQL Server 2008, SQL Server 2012, ASC job monitors, asc job control panel, asc ad hoc job launcher, NServiceBus MSMQ, Release Management Tool, TFS, sharepoint, SSRS, Resharper, RedGate.
Company: Commonwealth of Massachusetts (Boston, MA)
Position: Technical Lead
Duration: April 2013 – October 2014
Description: Being part of the OSD (Operational Services Division)’s IT, I was involved in developing the very first Intranet for the agency. The initial Intranet contained 4 major groups: Official landing page for OSD-Intranet, MIS Intranet, HR Intranet, Legal Intranet. Currently we are working towards including more units, like SSLs, TOM (Training and Marketing Outreach). In addition I was involved in maintaining a lot of existing applications. co-ordinating among vendors and units. I also developed multiple applications to improve in house processes, run reports from warehouse to support Sourcing Leads, maintain dts jobs and support agency users in tickets using wide range of technologies.
Responsibilities:
Developed or maintained number of applications:
• Developed and maintained Intranet for the Operational Services Division (OSD). There was no Agency wide Intranet. Designed, conceptualized from scratch. Migrated content from many units’ site into a single look and feel through Sharepoint 2013.
• There was no HR site for this agency. Developed an HR site with all the contents, slideshows, dropdown menus etc using Ajax, javascript and .Net.
• Developed a licensing tracking and renewal application in MVC 4.0.
• Maintained SOMWBA application and lead the effort with outside vendor to implement changes and updates to the existing code in C#, .net 4.5.
• Responsible for setting up the yearly database for MASSBuys Expo and maintained and changed code for registration, exhibition and vendor modules for the application.
• Maintained existing applications and responsible for being the bridge between unit users and third party vendors from who these applications were purchased. Applications supported under this are Fleetwave, UFR, TeamMate, MIS site, SOMWBA.
• Designing the new MASSBuys site which has intranet and internet components in C#, .NET.
• Worked on PowerPivot, SQL Server, slicers to run extensive reports for datawarehouse, compass system and the new e-procurement system(CommBuys).
• Redesigned and enhanced legacy MIS application. Added contents, updated content, built out multiple subsites: BCP, Phone Listings (internal directory), Informational Videos, Cyber Securtity, Policies and Procedures, Technical Support Matrix, Find Information. Tool used: .net1.1.
• Ran and improved DTS jobs that were responsible to import data from CIW. (commonwealth information warehouse).
• Participated on WIG initiative. (Wildly Important goals based 4DX – 4 disciplines of execution). Increased the traffic to our sites by 500% under this initiative.
Environment: Visual Studio 2010, 2003, 2012, ASP.Net 1.1, 4.5, MVC 4.0, Ajax, SQL Server 2008, Sql Server 2000, Sql Server 2012, JavaScript, XML, Windows 7, IIS 7.0., Visio, HTML 5, Sharepoint 2013, Enterprise Manager, TeamMate auditing tool, SDE tickets (BMC tool- Trackitt).
Company: Partners and HealthCare (Charlestown, MA)
Position: Application Architect
Duration: Dec 3, 2012 –March 2013
Description: Charge Entry Reporting System (CERS) is an intra-practice Web Application to support outpatient and inpatient visit scheduling and charges for each practice. It allows therapists to charge the patients for their services. Access to the application is regulated on role and user accessing the application. Application required to implement ISD9 standards along with CCI edits and K modifiers.
Responsibilities:
• Created and modified user controls and aspx pages using AJAX control, web services,C#, javascript, ASP.NET.
• Create data scripts to insert data.
• Created and modified tables, stored procedures, triggers, views and index.
• Provided support to the deployed system till stabilized.
• Trouble shooting complex problem involving understanding customer data and business practices.
• Identify improvement areas in current technical architecture
• Participated in building the business layer components and coding.
• Performing Unit Testing and Integration Testing
• Involved in developing integration services
Environment: Visual Studio 2010,ASP.Net, Ajax, SQL Server 2008, JavaScript, XML,XSD, XSLT, MyGen,, Fiddler, Windows 7, IIS 7.0., UML (Sequence Diagrams, Activity Diagrams, Class Diagrams), HTML 5, Wireframe
Company: Citizens Financial Group (RBS) (Boston, MA)
Position: Sr. Software Developer/ Application Architect (Officer)
Duration: May 2007 – November 30, 2012
Description: CRMDashboard ORA is the enterprise integrated system of record definitive source for Loan Customers including Standards and Procedures, Risk Assessments and Reporting in Risk Architecture management space. ORA application allows the bank to rate customers and their obligations to assess risk in lending out money. Access Control feature allows or prohibits user/lender access to the system and different parts of the application. In addition, there are a number of reports that report compliance with various banking industry standards. Application implements standards like Basel II, CCAR and other FED requirements.
Responsibilities:
• Involved in writing user controls, web services, using AJAX control, C#, javascript, Datasets, ASP.NET.
• Involved in designing and developing databases, feeds, DTS packages, SQL Procedures, Triggers, Views.
• Involved in maintaining data consistencies across the different data platforms.
• Involved in writing data scripts to clean data
• Helped users to connect to our database via ODBC connections and import and link our tables to MS Access.
• Building Security Authorization, Intra-Application Links and other application modules using ASP.NET MVC, JavaScript, HTML 5, CSS.
• Designed and implemented security modules to get data for users using Active Directory, authenticating application user.
• Co-ordinated inter-team Requirements and design efforts to implement real estate and zipcode modules.
• Drove projects for requirements gathering, designing and implementing sub-applications in the web.
• Led team of 3 to 4 members.
• Supported the help desk by being on Production Support.
• Was the Build Master, responsible for co-ordinating code of 20 team members and deploying it through testing servers and PROD.
• Co-ordinated DR dry runs and code freeze.
• Currently BCP contact in the team. Responsible in setting up and testing alternate site for our business process.
• Responsible for disaster recovery runs.
Environment: VS.Net 2008/ 2010,ASP.Net, Ajax, SQL Server 2008, Oracle, SQL Reporting services, T-SQL, JavaScript, XML,XSD, XSLT, Winforms, Balsamiq, QTP, LoadRunner, Windows XP Professional, IIS 6.0, Datasets, Active Directory, UML (Sequence Diagrams, Activity Diagrams, Class Diagrams, Component Diagrams)
Company: LogicPlusPlus Ltd
Position: Sr. Applications Developer
Duration: Sept 2006 – Dec 2006
Description:
MHM is a windows application that enabled monitoring health of huge machines such as turbines, nuclear reactors. It provides extensive list of features for monitoring the trend of health monitors fed into the system. Structure performance metrics were calculated and allowed system to monitor changing parameters through reports that could be sliced and diced and represent the health graphically.
Responsibilities:
• Coordinating and team management. Assisting new support engineers, and team member’s on troubleshooting techniques, processes and application knowledge, working closely with the clients.
• Trouble shooting complex problem involving strict SLA implications and understanding customer data and business practices.
• Reproducing and performing in-depth analysis of customer issues, determine causes, workarounds and long term solutions.
• Provided support to the deployed system till stabilized.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Identify improvement areas in current technical architecture
• Performing Integration Testing, QC/UAT/Production Testing and Performance Testing
• Building Windows Application with ASP.NET, C# JavaScript, HTML 5, XHTML, CSS
Environment: Visual Studio 2005, (C#.NET 2.0), ASP.Net, Winforms, Web services, SQL Server 2005 T-SQL, JavaScript, SSRS, XML, XSLT, Windows 2003 Server
Company: Datamatics Ltd. Mumbai, India
(Lexis Nexis) Dayton, Ohio, Thomson Dialog Boston, MA
Position: Software Developer
Date: Jun 2004 –Sept 2006
Description:
This electronic workflow system provides a mechanism for defining the fields that make up a news form (including constraints where applicable) and a way to map out the process so that the news form passes without delay from approver to approver and to the Lexis Nexis user. The system includes features well beyond replicating a paper process. During the course of a workflow XML files in different formats were read and produced in the standard format for the online news. The system also includes a portal interface, the “News” page, that presents each user with their news queue.
Responsibilities:
• Analyzing the requirement and involved in implanting the templates for the news..
• Participated in implementing the business layer components and coding.
• Involved in implementing the system using VC++, XML.
• Involved in writing the logic to read and parse different XML documents.
• Performing Unit Testing and Integration Testing
Environment: VC++, MFC, XML, XSLT.
Company: Nuclear Power Corporation India Ltd (NPCIL), Mumbai, India
Position: Software Consultant
Date: Jun 2003 – Jun 2004
Description
MIMIC display panels were created to capture and display the signals coming from nuclear power plants. These signals were transmitted using TCP/IP protocol from the fields and inserted into files. System interpreted these signals to ensure the valves were operating in coolant. System alerted warning signals if any valves were opened, cracked, coolant was low etc.
Contact this candidate