We provide IT Staff Augmentation Services!

Data Warehouse Resume

5.00/5 (Submit Your Rating)

North, CarolinA

SUMMARY/EXPERIENCE:

  • More than 15 years of experience in IT industry in Tiered Windows, Web and Mobile Application Development.
  • Confidential Certified Professional.
  • Working as Technical Product In charge at Confidential Connected Services
  • Over 12 years of work experience with.NET Technologies
  • Expertise in architecture, design and development of applications using .Net Framework (Visual C#, VB.Net, ASP.Net, Silverlight, ADO.Net and .Net Security), Angular JS, .NET Composite Controls, Object Orient Analysis, XML, ASP and Design (OOAD), Entity Framework, SPA.
  • Developed and implemented SOAP and XML Web Services for scalable middleware business logic
  • Excellent hands on experience in developing Windows applications, Web applications and Web Services using ASP.NET, C# and ADO.NET.
  • Strong understanding of OOP and Design Patterns.
  • Extensively worked on .Net Security, Middle Tier Development, Integration and OOPS.
  • Extensive experience and understanding of MS Message Queue and BizTalk Server.
  • Configured Internet Information Server (IIS), COM+ and Confidential Message Queuing.
  • Used MSSQL Server Database Development in writing Store Procedures, Cursors, Triggers, Views, Indexes and Constraints.
  • Implemented development methodology based on SEI CMM, RUP and Agile methods.
  • Worked extensively on SQL Server Reporting Services (SSRS)
  • Working experience on Service Oriented Architecture (SOA).
  • Experience in Designing, Developing, Documenting and Testing of ETL Jobs and Mappings in Server Jobs in Data Stage to populate tables in Data warehouse and Data marts.
  • Experience in Data analysis, Data modeling concepts, Database design and Data migration.
  • Expert in integration testing, implementation, maintenance and performance tuning.
  • Experienced in Unit test, Functional test, Integration test, UAT and Regression testing.
  • Proficient in schedule estimation, resource estimation, project management and tracking.
  • Broad knowledge of all stages of software development, including design, architecture, programming, testing, implementation and support of distributed applications.
  • Involved actively in complete programming life cycle (Object - oriented analysis, business requirement analysis, architectural design, development, testing, and documentation) in business environment. Well versed with SDLC’s Analysis and Design using Software Engineering and Design Patterns.
  • Defined coding and development standards and implemented design and code review procedures throughout the project lifecycle.
  • Proven ability to work in unison with staff, volunteers, and board of directors.
  • Great team player, highly motivated, adaptive, quick learner with excellent interpersonal, technical and communication skills.
  • Goal-oriented individual with strong leadership capabilities.

TECHNICAL EXPERTISE:

DevelopmentLanguage/Tools/Platforms/

Environment: ASP.NET, Web Services, SOAP, Security, ASP, COM, Windows Services, ActiveX DLLs, IIS and Web User controls, Entity Framework, Linq, ASP.Net, Visual C#, VB.Net, OLE/COM DCOM and .NET Remoting, Visual C++, XML, VB, T - SQL, PL/SQL, VB Script and Java Script, Silverlight, DotNetNuke, Java (core), Swing, FXCop, NUnit

WCF, Enterprise App Blocks, COM, COM+, Ajax, XML, XPath, Mule, Oracle Service Bus, Oracle BPM, JMS, Active MQ, MSMQRDBMS

MS SQL Server, Oracle, MS Access, MySQL

Scripting & Markup Languages: JavaScript, HTML, DHTML, VBScript, XML (DOM), Shell Scipts, Python, Groovy, PHP, Jquery

Operating Systems: Windows, Unix

Middleware/ Libraries: Web Services, COM, COM+

Tools: Visual Studio .NET, Crystal Reports, ER Win, Visual Source Safe, Visio, TOAD, Alfresco, JIRA, DataStage, Oracle Data Integrator, JIRA

Server’s: BIZ talk Server, MS Message Queuing, Confidential Office SharePoint Server, IIS, WSS, Apache, Tomcat

PROFESSIONAL EXPERIENCE

Confidential

Mountain View, CA

Responsibilities:

  • Responsible for generating roadmaps for subsystems in accordance with product enhancements, technical design and plan development while interacting with the client and business users.
  • Drive solution architecture, technical design and development strategies for enterprise product implementations.
  • Project Full Cycle Ownership (Requirements, Architecture, Coding, Deployment, Support)
  • Assess and evaluate technology tradeoffs. Select technologies to architect product roadmaps.
  • Design architecture for various different components and validate tools. Participate in architectural meetings and analyze all technical requirements for Dot NET applications.
  • Establish architectural methodology of all deliverables. Review infrastructure for any issues and recommend solutions. Monitor application architecture and ensure appropriate implementation of all solutions.

Technologies Used NET 4.5, C#, VB.NET, ASP.NET, Angular JS, IIS, Sql Server, DB2, JDK 1.5x, MySQL 5.x, Tomcat 6.x, Apache Active MQ, Spring 2.5, Struts 2x, Web Services (JAX-WS),XML. Fuslogvw.exe, MDbg.exe, WinDbg.exe, Caspol.exe, Ilasm.exe, Ildasm.exe, Regasm.exe, Regsvcs.exe, Winres.exe, Wincv.exe,Tlbimp.exe,Jenkins, Nuget, Artifactory, GIT, TFS, SonarQube, Confidential .

Confidential

Responsibilities:

  • Responsible for generating requirements, technical design and deployment documents while interacting with the client and business users.
  • Coordinated in application development to be compatible with hand held devices for online verification of the status of the document submitted to the county.
  • Responsible for architecting solution for the Automation project.
  • Responsible for Designing & structuring the data model for the application.
  • Heavily involved in developing and implementing web parts, event handlers, custom master pages, and workflows
  • Involved in Designing, specifying, and configuring infrastructure for production, testing, and development environments
  • Responsible for coordinating the development of the Integration module involving third party web services.
  • Responsible for developing the Queuing mechanism for the Batch Job of the application.
  • Coordinated with Off-shore development and testing team.

Confidential, Illinois

Responsibilities:

  • Designed new Web Forms for incorporating new features in the application. Integrated single sign on for the Application. Used Confidential Application Block for Data Access and Exception Handling
  • Involved in restructuring the data model. Involved in migrating the old data into the new data model
  • Acted as a Agile Mentor for one of the modules. Experienced in the use of agile approaches
  • Heavily involved in using .Net Nuke in the applications Content Management. Involved in using .Net Nuke for creating, deploying and managing web applications.
  • Gathered Requirement’s from the functional experts and worked on functional specifications and made sure that the issue/function is completely embedded or provided an alternative solution to the problem.
  • Performed code reviews to implement performance and coding conventions guidelines.
  • Actively involved in DBA activities.
  • Actively involved in Installation and administration of small server farms and stand alone MOSS web sites. Created Silverlight business applications, with .Net RIA Services for data access;
  • Developed portal and content management application using a custom site definition, custom web parts and custom feature’s development.
  • Implemented custom workflow forms using InfoPath. The technologies used were Confidential Office SharePoint Server 2007, ASP.Net the SharePoint Object model and MS Office 2007.
  • Developed Windows services which internally uses .NET remoting and has a well wrapped within exception handling components.
  • Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts. Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into

Data Warehouse

Confidential, North Carolina

Responsibilities:

  • Actively involved in code fixing and code debugging of the various components.
  • Used the Debug tools to debug the applications/components. Such as Win DBG, VSPerfClrEnv, VSInstr.exe, VSPerCmd.exe, VSPerfMon.exe, VSPerfReport.ext, Process Explorer, ICMP Protocols, Test simulators, Code walkthrough.
  • Developed test harness framework which can be customized to be used for testing various .NET components.
  • Developed reports using the Reporting services of Sql Server 2005 with filtering for both Static and Dynamic Reports. Integrated LDAP User Authentication for the Application.
  • Used Confidential Data Access Block and Exception Management Application Block.
  • Involved in DBA activities such as regular data backup, checking the database logs, updating the database scripts as per the project needs.
  • Deployed and customized collaborative and publishing site collections, sites, web parts, document libraries, lists, and views in SharePoint.
  • Set up permission levels and permissions for individual users, SharePoint and Active Directory groups, libraries, and lists as SharePoint Administrator.
  • Used third party controls such as infragistics, Grid and various other controls.
  • Set up and provided day-to-day end-user support through email, desktop, and telephone support in a highly collaborative team environment
  • Developed various stored procedures in Oracle for the application.

We'd love your feedback!