Objective

Dynamic information technology professional focused on learning and developing strategies to execute Application Development/Support initiatives for 8 Years. Results oriented individual with demonstrated business acumen through communication, execution, and relationship building.

Technologies

• Application Development Tools: ASP.NET, C .NET, Jscript.NET, XML Web services, SOAP, WCF, RESTful Services, ASP.NET Web API, JSON, AJAX, JavaScript, JQuery, AngularJS, HTML5, CSS3.
• RDBMS Platforms: Microsoft SQL Server 2000/2005/2008, Oracle 10g/11g PL SQL.
• Tools: Visual Studio 2008/2010, IIS 6.0/7.0/7.5, ASP.NET Failed Request Trace, .Net reflector, TFS, PL/SQL, MS SQL, TOAD, WINDBG, DebugDiag, Wireshark, Fiddler, firebug, PerfMon, Mercury Quality Center, SVN, ServiceNow, JIRA, Informatica ETL, Cognos Reporting.
• Operating Systems: Windows Servers 2003/2008/R2, UNIX

Experience Summary

• 8 years of Analysis, Designing, Developing, Trouble-shooting, Implementing and supporting of web application, windows based client-server, Data warehouse, ETL, Reporting, Data Migrations Systems Integrations project experience.
• Experience on full software development life cycle SDLC starting from collecting business/functional specifications, user requirements analysis, confirming the design decisions regarding data, process, interfaces, reviewing/audit the code and documenting the entire life cycle.
• Hands on Experience with .NET, C , MVC, LINQ, WCF, RESTful ASP.NET Web API, XML, JSON, JQuery, AngularJS, HTML5, CSS3, SOA, PL SQL, MS SQL.
• Good understanding of .Net Web applications, Windows based client-server, data warehouse architecture, .Net and JavaScript design patterns. Strong trouble shooting skills on various production issues L3/L4 .
• Analytical/programming skills, objected-oriented design skills and programming skills in .Net technologies, PL/SQL Oracle 9i, 10g 11g , T-SQL SQL Server 2000/2005 , ETL, Reports, Data Migration.
• Knowledge on Hadoop framework, distributed computing way of processing data, develop MR Programs, NoSQL database.
• 5 years of experience working based on IS Validation procedures in Regulated environment GxP, cGMP, CFR Part 11 Auditing at Amgen.
• Good team player with excellent communication and interpersonal skills.
• Experience in ITIL Methodologies Change Management, Incident Management, Problem Management
• Ability to organize direct cross-functional teams to address and solve technical and business issues.
• Able to coordinate / lead multiple tasks under the project with competing priorities.

Professional Experience

Confidential

Senior .Net Programmer Analyst - Desktop Framework

• Desktop Framework Confidential is a seamless, client-side integration framework for all line-of-business and productivity applications at Confidential. Confidential delivers a highly configurable desktop container which integrates UI applications. The purpose of Confidential is to provide a one consolidated desktop solution which provides placeholder to have many applications like web pages, web applications, windows applications and 3rd applications used in various desktop platforms in Merrill at one place, provides easy navigation for over 1500 applications, facilitate event/context bus features to share/communicate data between these discrete applications.
• Integration is fully configuration driven through local XML files, is independent of the technologies used to create applications. All applications, regardless of the underlying technology, integrate with Confidential and not with each other.
• Navigation hierarchy can be tied to user role, entitlements, and/or provisioning processes
• Facilitates data sharing locally, avoiding expensive server round-trips
• Provides a place to plug-in data formatting and translation services to accommodate specific application requirements
• Full publish-subscribe pub/sub mechanism for event delivery allows for complete data/application abstraction
• Facilitate saving user preferences of layouts, favorites, Hotkeys of various applications within the container through Confidential webservices.

Responsibilities:

• Analyze, Debug, Enhance Desktop Framework Objects and Wealth Management workstation Confidential
• Debugged till root cause on various chronic .net exceptions and stability issues reported on Desktop Framework, prioritize and provided code fixes.
• Development support/design guidance for application teams to get integrates to Desktop Framework.
• Developed tools required for support activities Logs parser tool, User preferences extraction tool, automation scripts helping troubleshoot complex production issues.
• Strong experience on troubleshooting L3/L4 production issues on Confidential /Desktop Framework based on windows forms, multi-threading, WCF, ActiveX COM components environment, event driven development pub/sub pattern and integration to various systems.
• Experience in troubleshooting/analyzing production issues on various kinds of architecture - Windows based Desktop application, web applications, web services, Database, ETL, Network F5 , Storage, Unix environment Using various techniques like Application system logs, IIS logs, ASP.NET trace, Fiddler, wire shark, IE11 F12 debugger, Database profiler and Windows process dumps analysis.

Environment: C , ASP.Net, LINQ, WCF, Multithreading, XML, ActiveX COM.

Confidential

Technical Lead - .Net, SumTotal LMS Upgrade Implementation, Programmer Analyst.

• Responsible to lead requirements analysis, design, production deployment execution and handover of technology and processes for various applications at Amgen.
• Tech Lead for Confidential LMS 3.0 SumTotal LMS 8.2 SP4 Upgrade project -implementation of LMS 3.0 Upgrade .Net application deployment, Infrastructure setup, Application IQ, SumTotal deliverables validations and Global Drawing Management System client applications for business at Confidential.
• Data Migration projects on SumTotal LMS, developed Oracle PL SQL scripts, Data validation scripts, PL SQL Bulk load. Strong understanding of database concepts indexes, PL SQL queries, Business logic through stored procedures, and other database objects.
• Experience working on Data Mart ETL Development, Business Analysis, Infrastructure Implementation for SumTotal LMS, Testing, Reports testing. Good Documentation Practices on Functional Specs, Design, Release, Defect tracking, IQ, OQ, Validation Plan, Test Plan in Mercury Quality Center and Requirement Traceability Matrix.
• Troubleshooting and L3 Production support experience on wide variety of systems like LMS, Enterprise document management EDM , LMES, LIMS, Informatica ETL, LMS DataMart, Health care compliance applications, GDMS, ETL processes for Corporate Functions at Amgen.
• Experience in troubleshooting issues on Infrastructure side Middleware, SOA Manager, F5, SSO, Network, ActiveDirectory, Netapp Storage, Unix, System Monitoring techniques , Database Oracle init file configurations, SQL Trace, Profiler, Oracle AWR reports, Oracle Stackpack reports, Execution plans analysis on performance tuning.
• Test/Analysis and Presentation of the new features of the product.
• Providing client requirements on customizations to vendor, documenting functional specification, responding to the queries on functionality and validating the deliverables from vendor SumTotal .
• Setting up the entire new Infrastructure at IBM data centers - includes 15 web servers, 7 databases, Siteminder configuration, F5 load balancer configurations, Enabling access of the for External business partners. Worked with Database, Netapp Storage, windows, F5, Siteminder, LDAP admins.
• Web/DB Server and application configurations based on Requirement specification on the Amgen LMS.
• Authoring Installation Qualifications scripts in HP quality center and leading the upgrade implementation of the system till go-live.
• Thorough analysis and performed test of each issue reported in the older system. I have worked with team and vendor to get around 200 issues fixed to bring the upgraded system at most quality.
• Assessment of performance test results of the newly build environment and worked with Vendor and DBA in performance tuning of the environment.
• Played a key role in setting up various elements of Infrastructure from IBM and to wade through many ambiguous processes and slow bureaucracies to get all tasks completed by the Infrastructure administrators Webservers, Database, UNIX, Storage, Siteminder, F5, Monitoring
• Assisted and coordinated with other work streams like BI, Test and provided value based decisions to the project team.
• Advocate client positions throughout the life cycle of the project, and make value-based decisions
• Also developed web modules on HealthCare Compliance reports system based on .Net MVC3, C , JavaScript, JQuery and MS SQL TSQL stored procedures, database objects development .

Confidential

Onsite lead - ETL development, Oracle PL SQL Development.

• Responsible for Solutions delivery to customer as Onsite Technical Lead, coordination with offshore teams, post-release support, weekly status calls and working with team as per customer expectations.
• Gathered requirements from business analysts for designing and development of the system.
• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup Connected and Unconnected , Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Extensively used the capabilities of PowerCenter such as File List, pmcmd, Target Load Order, Constraint based Loading, Concurrent Lookup Caches etc.
• Develop Logical and Physical data models using Erwin as per requirements, discuss in workshop sessions with clients on the schema tables.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Created several Procedures, Materialized views, Functions, Triggers and Packages to implement the functionality in PL/SQL.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used shortcuts Global/Local to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used the Workflow manager to create workflows, worklets and sessions.
• Created post-session and pre-session shell scripts and mail-notifications.
• Used debugger to test the mapping and fixed the bugs.
• Extensively involved in identifying performance bottlenecks in targets, sources, mappings, and sessions and successfully tuned them for maximum performance using best practices.
• Created Cron jobs to schedule sessions and workflows on Linux.

Confidential

.Net Programmer :

• Responsible for Design, development, deployment of WCF web services for B2B System Integration project.
• Hands on experience working on ASP.NET 4.0 WCF, XML web services, SOAP, SOA Manager and Windows 2008 Server IIS 7.5 Configuration, System Manager Configurations, IIS logs, Event logs, failed requests tracing in IIS .
• Implemented a good logging feature using ASP.NET Tracing on troubleshooting issues of any requests coming along inbound/outbound messages.
• SumTotal LMS includes native web services that provide an API for querying and updating data in the LMS database. A custom web service, LMSWrapper, has been designed and developed by Amgen for exchanging data with AEPS Amgen Account Entitlement Provisioning System . The LMSWrapper web service invokes methods from the following LMS native web services.
• LMSWrapper exposes web service methods that are called by an ITIM adapter. These methods support the following LMS functions:
• User account creation and modification. LMS user account attributes are stored in LMS user profile tables. Other attributes are persisted in LMS by adding and removing users to LMS organizations and jobs.
• User accounts - creation, suspend, and restore. This feature controls the ability of an active user to login to LMS.
• User training assignments for business process and IT roles. Users are added or removed from training assignment orgs based upon their role assignments in RMT.
• User training completions for IT roles. Users are added or removed from training.
• Workforce data is published in real time from SAP and PAMS Partner Account Management System to the AEPS identity store. AEPS pushes the needed workforce data to Amgen LMS in real time.
• Workforce data is published in real time from SAP to the Shared Repository. Employees' job codes and states of residence are required by LMS and are not available in the Confidential identity store.
• Role associations are pushed in real time from RMT Role Management Tool to the Confidential identify store. Confidential pushes the role associations to LMS in real time, which LMS persists as organization memberships. Confidential also requests role associations org memberships from LMS for reconciliation

Environment: Microsoft .Net Technology , Oracle 11g, SumTotal LMS 8.2 Product Windows 2008 R2 web servers, IIS 7.5, Oracle 10g, 11g, ASP.Net, F5 Network configurations, SumTotal LMS 8.2 Product web services.

Tools: Visual Studio 2008, ASP.NET 4.0, ADO.NET, AJAX, C .NET, WCF, JSON, XML, Sql Server 2005, XML Web Services, Tortoise SVN, PLSQL Developer, TOAD, SumTotal LMS 8.2 SP4 Product.

Confidential

LMS Application Developer

• Development and test customizations on critical modules of the LMS application from Professional Services department in Confidential for various customer requirements.
• Hands on development on ASP, C , ASP.NET, JavaScript, Jscript.Net, MS SQL T-SQL, PL-SQL.
• Functional specifications Analysis according to business requirement. GAP analysis.
• Design, development and testing of customization to deliver customization patch/hot fix in highly challenging environment Professional Services Department.
• Under-go code review process and due fill in the development check list before check-in the code to customer source code configuration management system.
• Demonstrating the customizations to customer on streaming sessions.
• Handling any issues reported on the deliverable in specified timelines.
• Raising necessary flags during project execution with in tough timelines, competing priorities based on the number of customization queued up on different modules on the LMS product for various customers.
• Hands on experience on all versions of SumTotal LMS products like TotalLMS 7.1, 7.2, 7.5, 7.6, 8.0 Data Migration Tools
• Involved with estimation for a few projects and analysis of new modules.
• Provide mentorship and technical guidance to junior software engineers.
• Customizing Data Migration tools, testing and troubleshooting complex issues in large data migration processes on customer environments.

Environment: ASP, ASP.Net, JScript.Net, C .Net, VB, XML, Oracle 9i 10g, SQL Server 2000/2005, Java, Java Script, IIS 6.0

Skill/Tools: MS Visual studio 2005, MS SQL Query Analyzer, PL SQL, Tortoise SVN

Confidential

LMS Application Developer

Description: Report manager is an integrated solution for Confidential product suite. Report manager provides various customizable reports based on Confidential database star schema . It has an integrated ETL solution with source system SumTotal LMS .

• Development and test customizations on LMS Report Manager to make changes to ETL process and star schema relational database schema of LMS Reporting System.
• Hands on experience on Database PL SQL, T-SQL, Report development, Start-Schema.
• Functional specifications Analysis according to business requirement of LMS Reporting.
• Development, Unit testing and QA Process on complex LMS Reporting deliverables.
• Developed complex reports for many of the customers..
• Knowledge on Reporting business functionality and expectations.
• Making changes to existing OLAP database schema like adding additional dimensions, facts based on reporting business requirements.
• Ownership in making good design, unit test results, test cases, release notes documentation.
• Post-production support and customizations patches development in Professional services.
• Process oriented and Documentation experience in highly competitive environment in Professional Services department of SumTotal Systems.

Skills/Tools: Microsoft MS SQL Server 2000, Microsoft DTS, SumTotal Learning Management systems, T-SQL, ETL Development, Datawarehouse concepts.