EDUCATION
IGNOU Delhi
Master of Computer Application (2004)
Advance Diploma in Computer Application (2003)
Post Graduate Diploma in Computer Application (2002)
BRAB University
BSC Chemistry (with Hons) 2000
Certifications
EXPERIENCE
7 + years with ASP.Net 1.0, 2.0, 3.5, WCF,WPF, C#, Vb.net, SQL Server 2000, 2005, 2008, XML, SSIS 2005 / 2008, SSAS 2005/2008,SSRS 2005/2008, Remoting, Web services, SOA and OOPS based implementation in multiple roles.
Royal Bank of Scotland| TSI Leasing and Lending | Camelot Gurgaon, India
Software Designer as Technical lead 2009----------
Working with Leasing and Lending team on driving new technology based POC’S helping to re design and re architect different application’s which will further help leasing and lending management operations team of RBS UK to get right information at right team increasing ROI.
• Leading and Supporting Camelot (Reporting solution build in ASP.Net + SQL server) team on more complex UI and SQL Server based issues. The team uses Scrum model of software delivery to deliver business and QA related Changes in the form of Monthly releases.
• Worked with Camelot team to Re Architect the import process for Camelot initially build on BCP and window services using .net to use SSIS in parallel and sequential mode, automating the schema and variable mapping to make the complete solution deployable. The tool is capable of pulling even the Data file of size + 4GB at much faster Rows\Seconds than any other ETL.
• Working as the technical lead for implementing SSRS across different project’s across my department, as the department led initiative to replace the current reporting solution with SSRS.
• Working with Loft architects in designing and developing LOFT level common lending operations ODS and Ware House.
• Working on designing common capacity planning tool using SSAS, SSIS, WCF, WPF, WMI and SSRS for the Microsoft based production server’s across different team.
• Initiated technology and business knowledge sharing by writing white papers in different areas such as New Features of SQL server 2008, Using perfmon, WPF and smart dashboard, SSIS 2008 and CDC comparing on how the new technology can be implemented in to Camelot and other projects further.
Microsoft India R&D| RXD | MPS | Geneva Data ware House Hyderabad, India
Sr Software Development Engineer in Lead role 2008 – 2009
Worked with MPS Geneva team for the re-engineering and new capability development efforts mostly but not limited to API, Session and ETL module of Geneva that resulted in a remarkable annual savings of time and money.
• Achieved 60% reduction in release timelines for Geneva Data warehouse by automating the release cycle and SE based processes by architecting and Implementing PNP using ASP.NET,C#, MDDA, SMO, SSIS Runtime, Data Dude,.
• Collaborated with different COEs and MS Streams for adopting our newly implemented methodologies, and release automation product, to help in their release process improvement’s, effectively decreasing cost and increasing ROI.
• Redesigned and enhanced new API (Stored Procs and Web Service) models for GENEVA (ODS for Marketing Platform and Services) serving more than 20 Microsoft marketing application and hosting 1 TB + of Data.
• Architected designed and lead the team in new technology improvements for Geneva using latest SQL Server 2008 to Implement CDC functionality, Sandboxing and securing Geneva API, Improving Geneva Interface to provide more data consistency and speed up data movement by giving user the capability for Delta pull in a fast and reliable manner.
• Actively Involved with PM and other stakeholders on providing effective project timelines and resource estimation to help in correct vendor resource utilization.
• Analyzed complex business requirements and developed high level and low level technical specifications and overall project architecture in order to reduce the learning curve for the development team using Visio with UML as basic Data Modeling tool.
• Prepared and presented weekly Status report for the task assigned to me and my team.
• Got actively involved in setting up processes for GENEVA SE Team and outsourcing it to vendor team.
• Bug bashing of SQL Server 2010 CTP (Kilimanjaro).
American Express (onsite contract) Employee of Satyam Computer Services LTD Gurgaon, India
Senior Software Engineer in consultant Role 2006 – 2008
• Actively participated in Fresh application design and implementation using SOA and OOPS based approach in ASP.Net and SQL Server.
• Worked on Change Request handling, code & Documentation review, Production support and release Co-ordination between the team seating in US and India.
• Writing TDD and HLD as well as assisting Analyst in BRD based reviews and documentation.
• Carrier Counseling and interview preparation, for Sataym candidates to get selected, at one or the other clients of Satyam in Dot Net and SQL Based initiatives.
• The above initiative helped Satyam to place several associates at different client location such as AMEX, RBS and Fidelity in Gurgaon, NCR region.
• Suggested and implemented several process improvements at American Express Risk MIS department to decrease overall project cost which helped in building a Brand name for Satyam, helping win more projects.
TARAHaat Information and Marketing Services LTD Delhi, India
Senior Software Development Engineer in a Lead and Researcher role 2005-2006
• Lead 4 - 6 member team to design, develop, manage and maintain different ICT based applications (TARAAkshar, TARA Net, ASK the Expert); build on n-tier, distributed architecture using ASP.net,SQL Server.
• Designed and implemented architecture for multi lingual and multi encoding system.(Search engines, Font & encoding conversion, Phonetic Transliterations)
• Designed and developed Architecture for SPSDA (A distributed synchronization, based solution for small organization). Currently synchronizes data through XML using FTP and two way handshake protocol.
• Spends months in the rural area of Bundelkhand, Jhansi, Orcha (India) researching user needs and reaction on our product developed for them (Ask the Expert).
• Analyzing user psychology, attention and easiness while using ASK the Expert and other TARAHaat developed product, and later re designing UI and application’s considering the usage behavior of our product in their own locale language using pictorial implementation helping more people in rural area to join hands with Tarahaat product.
• As a result TARAAkshar has made + 50000 adult literates and the generic engine of ask the expert have helped TARAHaat implement different type of rural project by simply changing the UI.
Vectorage Technologies (www.vectorage.co.in) Delhi, India
Asst Programmer/Developer 2003-2005
• Developed and maintained master update modules in P.I.M.S build in ASP.Net ,SQL and C#
• Build Reports and update Modules to display works and sub works allocation, work completion, under progress etc in WIS.
• Worked on VECTA a CMS Framework build by Vectorage to develop Knowledge based website
Computer/Programming/Trainings
1. Good hands on experience in working as a solution provider for application either in build or maintenance phase with SSIS (dynamic and static packages, scripting), SQL Server (2008, 2005, 2000) (CDC, Change Tracking, Mirroring, Log Shipping, Index Management, Backup & restore, SAN Mirroring, Mount, Unmount, Publication based DB & Replication, Cluster’s installation and management, Profiler, Resource governor ), DW, SAN, ASP.NET (Web Services, TCPIP, JavaScript, Ajax, HTML, Asp.net application design, development and deployment), SSAS, SSRS.
2. Core expertise in building scalable web based enterprise solutions and designing large Databases.
3. Attended Gold of the Desert Trainings at Microsoft. (This is a Project Management Training)
4. Attended Smart Hiring Training at Microsoft
5. Attended various Technical trainings related to .net, SQL, and various other technologies.
6. Provided several training on SQL server 2008, SSIS, SSRS at Microsoft and RBS.
Reward & Recognition
1. Received Reward & certificate at RBS on implementing Generic ETL solution using SSIS, .NET, GZIP
and Remoting to Handel File size of more than 4GB with non uniform columns.
2. One of My Initiative PNP Suite (ASP.Net, SSIS, Ajax, and SQL Server SMO) at Microsoft was noticed by Microsoft research team and a product is built on it.
3. Several Ideas and suggestions given in one of my Paper on “How Microsoft can reach to its next billion customer” at Microsoft was appreciated by many of the top shots of Microsoft and it has been added in to “Bill G think week” (Bill G think week is an Initiative by Bill Gates (Chairman Microsoft) to Encourage new Ideas and Innovation. ) Most of the paper is uploaded by Microsoft Research team and other departments from Microsoft R&D including IT.
4. Received S rating in VBU Banking at Satyam overall M rating (Consider getting recognized among 46,000 associate within a year.)
5. Received several Pat on Back award from Satyam for outstanding performance with AMEX.
6. Came several time in Organization news in Development Alternatives and TARAHaat for my excellent work on Rural ICT.
Sunday, March 7, 2010
Subscribe to:
Posts (Atom)