We provide IT Staff Augmentation Services!

Applications Systems Analyst Ii Resume

North, CarolinA

SUMMARY

  • 10+ years’ experience in Analysis, Design, Development, Testing, Maintenance and Security compliance testing of Windows Based, Web based, Client/Server N - tier Architecture based on Microsoft .NET technologies and SQL Server.
  • Extensive experience in Web Development and Application Development using C#, ASP.NET 4.x, .NET Core, XML, XHTML, XSLT, Web Services, MVC 5, Red Gate.
  • Expertise in Object Oriented Design Methodologies and SDLC Practices like Agile, Kanban, SCRUM, Waterfall.
  • Expert knowledge of enterprise application development technologies using .NET framework in the areas of performance, security, scalability and extensibility.
  • Designed and documented REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy.
  • Experience in Windows Server Management using WSUS
  • Experience in hosting applications on IIS, Docker and Apache, Azure DevOps
  • Hands on experience in SQL Server and Oracle database development in writing Stored Procedures, Triggers, Views, Indexes Constraints and User Defined Functions.
  • Experience in SQL Server 2016, T-SQL, PL/SQL, Oracle NoSQL Database, Infinity DB, Redis, MongoDB, DB2 and SSIS.
  • Experience with ETL tools (Informatica power center and Oracle Data integrator, AZURE Data factory and SQL Server SSIS)
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
  • Design and develop Rest APIs/ or web-service consuming clients for data push/pull for both upstream and downstream applications
  • Solid RDBMS operational knowledge with outstanding SQL skills.
  • Experience using cloud technologies such as AWS S3, EC2, RDS etc.
  • Experience with Design and development of Tableau visualization solutions.
  • Expertise in: Information Risk Management, ISO 27001/27002 , SOX, CObIT, PCI DSS, HIPAA, NIST, GLBA, Security Incident Response Programs, Global Project Lifecycle Management, Contingency Plans & Business Resumption, IT Audit & Compliance Management, Security Tools, Processes & Policies, IT Governance & Best Practices, Information Privacy & Online Safety, Vendor Management
  • Experience in Security Risk Assessment and Auditing using Tenable and Fortify.
  • Performing security health checks on server hardware and software applications.
  • In-depth knowledge of Access Data FTK and MPE+ Tools, EnCase Forensic Tool and testing applications for security vulnerabilities using Penetration testing, session hijacking etc., and testing networks by setting up Honeypots.
  • Experience in designing and developing reports using Crystal Reports and SSRS.
  • Worked on search engine optimization for improving the volume and quality of traffic to websites.
  • Worked on web site designs, menus, content management systems, URLs that are easy to optimize.
  • Experience in developing graphs like Class, Sequence and Use Case diagrams utilizing Rational Rose using UML and Visio
  • Proven ability to work as a team player as well as an individual. Excellent Interpersonal and Communication skills coupled with strong technical and problem-solving capabilities.
  • Proven record of working in both small and big teams under stringent time constraints and ability to deliver on time.
  • Good analytical and problem-solving skills. Ability to quickly adapt to new environments and learn new Technologies.

TECHNICAL SKILLS

Databases: MS Access, Oracle 8i/9i/10g/11g, SQL Server 2008/2012/2016/2017 , Affinity, Infinity DB, DB2, Oracle No SQL

Languages: C#.NET, SQL, PL/SQL, T-SQL.

Development Testing Tools: ASP 3.0, ASP.NET, ADO, ADO.NET, MVC 3/4/4.5/5, MVVM, WPF, HTML 4/5, CSS 2/3, XML, XSL, XSLT, Azure, Java Script, WebAPI, jQuery, AJAX, AngularJS1.3/1.4, WebServices(WSDL/SOAP).

Hosting Tools: IIS 5.0/ 6.0/7.0, Azure DevOps

Reporting Tools: Crystal Reports 8.0, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

ETL Tools: Informatica, Azure Data Factory, SSIS, Dremio Data lake

Operating Systems: Windows 98/2000/XP/7/8/10, Windows Server 2016.

Version Controls: Visual Source Safe 6.0, Team Foundation Server (TFS), and Tortoise SVN, Git, Azure

Methodologies: SDLC, Kanban, Scrumban, Agile Development, Waterfall

Documentation and Tracking: Microsoft Office Suite, JIRA, Jenkins, CVS, Redgate

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

Applications Systems Analyst II

Responsibilities:

  • Maintenance and support of web-based application for North Carolina Department of Health and Human Resources for electronically registering birth and death information (EBRS).
  • Designed and implemented user interfaces, screen layouts using C#, ASP.NET, HTML5, HTTP Handlers, Jquery, CSS3 and KnockOut UI controls.
  • Upgraded the application from .NET 2.0 to .NET 4.6
  • Integrated the system to use single sign on(SAML) through NCID login monitored by ITS.
  • Developed new interfaces for processing adoptions and legal amendments.
  • Solved several issues with birth registration module, fetal death registrations and issuance module related to billing the RODs and expedite requests to State vital records office.
  • Created new birth certificate templates for Voter Id, Veterans and Released inmates from prison using XML, HTML, DHTML, CSS, XML, JavaScript and JQuery
  • Worked on new changes to birth registration and certificate issuance to accommodate new same-sex marriage law. Analyzing how it will affect the existing systems, cost and time estimates for amendments to SB 29.
  • Created SQL Server jobs that connect and sync birth and death information to EVVE database (Federal database that collects and maintains data) every month.
  • Migrated the applications and its components from 2003 servers to new cloud VMs with Windows Server 2012.
  • Created a Dashboard VR Reports tool for generating billing and statistical reports using WinForms, C# and Visual Studio 2015 with Telerik library to support end users using SSRS.
  • Gathered requirements and wrote technical and function requirements to develop a death registration linking system. Developing a webservice to link the birth and death registration system and developing application to match the death records with birth records.
  • Developed a reporting tool called VR tools for generating on-demand reports for Department of Health Statistics using SSRS and Visual Studio 2013.
  • Wrote functional and technical requirements and created data work flows
  • Designed and developed a cross-platform application to link NC Mental health facilities, Medicaid and NC Fast data servers using C#, ASP.NET, SQL, MVC, MVVM.
  • Developed and enhanced modules & interfaces using PL/SQL stored procedures, functions, packages, and triggers.
  • Involved in providing Unit Test for each of the tasks and perform code review for the team.
  • Created PL/SQL Packages and functions to call from the web services.
  • Involved in parsing JSON and XML files to obtain data to be used by the content Manager and Download Manager.
  • Used HTML5, CSS3 to build responsive mobile to web layouts. These are layouts that can be used both on the web and mobile devices.
  • Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create object itself.
  • Solving data issues and report issues in Affinity Database.
  • Maintaining Affinity and Clintegrity Servers
  • Writing and Modifying stored procedures, Triggers, and User-defined functions in PL/SQL to carry out database operations.
  • Used LINQ to XML and LINQ to Objects for retrieving the data efficiently and just in Time manner.
  • Developed various reports by pulling data from various sources using SQL Server Reporting Services (SSRS).
  • Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions.
  • Migrated applications from Windows Server 2016 to AWS Cloud servers.
  • Developed a web application and database for converting physical food stamps into a credit card-based system. Application went live in 100 counties in November 2018 without any issues. This application can also be used in mobile devices.
  • Developed application using ASP.NET MVC4 framework, HTML5, AngularJS, CSS3, C#, JAVASCRIPT, JQUERY.
  • Successfully designed and implemented XML API dealer information, order processing with ASP.NET Web API / REST Services (secured over https).
  • Written stored procedures, triggers using T-SQL for data access from SQL Server 2008 R2 when applicable. create, manage SQL Server Azure Databases.
  • The developed module which deals with validating the user, changing passwords and searching of information depending upon the priority of user in the site using ASP.NET.
  • Designed and created Data warehouse and all related extraction, transformation and load of data functions using Azure Data Factory, Data Integrator and SQL Server SSIS.
  • Used Cascading Style Sheets (CSS) and JavaScript.
  • Generated reports using the SQL Server Reporting Services (SSRS).
  • Designed and developed business components and data components using C# and ADO.NET.
  • Developed an Interface with NCFAST to check for eligibility for WIC program using Web Forms using ASP.NET, C#, XML, XSLT.
  • Deliver data as a service solution using Dremio Datalake to aid analysts and developers to collaborate for diverse analytical use cases.
  • Responsible for monitoring ETL, data availability, data quality and coordinating a response (using Pager Duty) when SLAs are not being met.
  • Used Azure Data Factory to integrate Data loads.
  • Used SSRS to generate reports and NCHS extracts.
  • Support and maintenance of an application for Targeted housing. This application monitors the standards of housing institutions and to keep malpractice in check. It will also allow NC citizens to apply for housing online.
  • Wrote functional and technical requirements and created data work flows and worked on reporting and UI for the website.

Environment: .NET Framework 4.6, Visual Studio 2015/2017, C#, ASP.NET, WPF, MVC 4/5, SQL Server 2012/2015/2017 , SQL Developer, TFS 2015, HTML5, CSS, CSS3, Angular, Winforms, XML, XSLT, IIS 7.5/8.0 Web server, Crystal Reports, SSRS, T-SQL, Pl/SQL, JavaScript, Red Gate, Firebug, TortoiseSVN, JIRA, Sharepoint, Jenkins, Affinity, Clintegrity, IIS, Infinity DB, Azure Data Factory, .Net Core

Confidential, Madison, South Dakota

Software Engineer

Responsibilities:

  • Developed a windows-based application for students to access course information based on professor name and availability and to register for courses directly.
  • Involved in Requirement Analysis, Low Level Design, Coding and Integration.
  • Implemented the object-oriented programming concepts in C#, Web Forms and ASP.Net.
  • Developed the user interface using C# .NET and designed UI using CSS3, HTML5, and JavaScript.
  • Involved in developing front end using MVC 4.0, JavaScript, HTML5, and CSS.
  • Responsible for developing the reusable Components on UI(Views) by developing the Partial Views, View starts, and reusable components for implementing the business rules with C# and OOPS Concepts.
  • Involved in the Design of the Application using ASP.Net, WCF, Entity Framework, Linq to SQL.
  • Design, develop and implement WCF and Web application which consume SQL Server as backend.
  • Developed .NET web application using JavaScript, ASP.NET MVC 5, C#, Visual Studio 2010/2013.
  • Expertise in Winforms applications, ASP.NET, XML, ADO.NET and TFS.
  • SSIS was used to import data from other universities in the South Dakota Regents Board and to deploy SSIS packages and reports to Servers.
  • Developed web inventory management software for clients using Django, Python, Eclipse, HTML5, CSS3.

Environment: C#, Visual Studio 2010/2013, WCF, ASP.Net, MVC 4.0, SQL server 2008/12, ADO.Net Entity Framework, Oracle R12/11G, SSRS, HTML5, Automation Testing, ODATA Services, CSS3, JQuery, JavaScript, Python, Agile Scrum Methodologies, TFS

Confidential, Sioux Falls, South Dakota

Database Security Analyst/Designer

Responsibilities:

  • I have helped gathering and analyzing the Security requirements of EROS and developed BYOD (Bring your own device) policy for employees and scientists who need to access information from offshore.
  • Went through the total project development life cycle and have a clear understanding of various tiers as the project was a multi-tier application.
  • Coordinated with various groups of the client to gather business and system requirements
  • Used SQL Data Adapters & Datasets extensively for database activity.
  • Used Data Transformation Services (DTS)/ SQL Server Integration Services (MS-SSIS) to create and test DTS packages using source, destination and data transformation (ETL) blocks and implemented custom Event handling along with periodic scheduling of SSIS packages to implement the interface.
  • Developed stored procedures, views and triggers for data manipulation, ensuring set up relations includes indexing, constraints, and foreign keys.
  • Contribute to the development and execution of unit, system, integration, stress and user acceptance testing.
  • Involved in implementing the security and authentication and providing user permissions for different types of users.
  • Used JavaScript and jQuery to perform client-side validations
  • Used SSRS for designing reports.

Environment: SQL Server 2008, LINQ, Entity Framework, JavaScript, Telerik Server Controls, jQuery Mobile, Oracle, SSIS, SSRS, Microsoft Excel, Microsoft Word, Microsoft Power Point

Confidential

Senior Software Engineer

Responsibilities:

  • Involved in coordinating with different departments to gather the requirements.
  • Participated in meetings to understand the requirements and provided them with different the solutions.
  • Participated in Transforming business/functional requirements to technical requirements.
  • Experience in developing n-tiered client-server applications.
  • Designed and implemented user interfaces, screen layouts using WPF (Windows Presentation Foundation), HTML and JavaScript.
  • Business Layer components were developed in C#.
  • ADO.NET been used for data access from SQL Server 2012, Oracle.
  • Created WCF (Windows Communication Foundation) services for retrieving data from Mainframes and UNIX.
  • Experience using MVVM pattern.
  • Experience in developing User controls, Custom controls.
  • Extensive Experience using Repeaters, GridView, DataList, DetailsView, FormView for web application.
  • Experience Developing Master Pages,User Controls, Custom Controls.
  • Experience using Infragistrics.
  • Created custom and standard reports using Crystal Reports and SSRS based on report complexity.
  • Experience in wirting SQL, PL/SQL, Stored procedures, Functions.
  • Experience using Regular Expressions.
  • XML has been used for Data Transformation and Parsing
  • Developed SQL Server Stored Procedures and functions for accessing the Database.
  • Developed a tool using Windows Applications for importing data from Excel Sheet to SQL
  • Monitored and maintained the application in post implementation phase.

Environment: .NET Framework 2.0/3.0/3.5, ASP.NET, VB.NET, JavaScript, C#.NET, ADO.Net, Tortoise SVN, HTML, XML, CSS, Visual Studio 2008/2010, JavaScript, MS Access 2007, DHTML, SQL Server 2008/2012, Oracle 10g, MS Visio, AJAX, WCF Services, Visual Source Safe, Team server foundation

Confidential

Associate Software Engineer

Responsibilities:

  • Involved in coordinating with different departments to gather the requirements.
  • Participated in meetings to understand the requirements and provided them with different the solutions.
  • Participated in Transforming business/functional requirements to technical requirements.
  • Participated in full SOFTWARE DEVELOPMENT LIFE CYCLE (SDLC).
  • Involved in developing applications for UI Layer, Business Layer and data layer.
  • Designed and implemented user interfaces, screen layouts using ASP.NET Web user controls, Ajax, HTML, DHTML, JavaScript, JQuery, CSS, Flash and XML/XSLT.
  • Designed and implemented user interfaces, screen layouts using C#, VB.NET, C++, ASP.NET, Classic ASP, and PHP.
  • Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation using LINQ, SQL Server 2008 and Oracle.
  • Experience in writing scripts for moving data from Oracle to Sql server 2008.
  • XML has been used for Data Transformation and Parsing.
  • Experience on testing the application on different browsers and making it compatible on all the browsers.
  • Developed windows application for PDF Automation, Word Automation, and Excel Automation.
  • Experience on working on Master Pages, User control, Custom control.
  • Experience in Authenticate and grant administrator privileges, authenticate standard users, Delegation of privileges depending on role base.
  • Experience using MS Access, SQL Server Reporting Services 2008, SQL Server Integration Services 2008 and SQL-Server 2005/2008 with Stored Procedures, Views, Triggers, Functions, DTS and Crystal report 11.0.
  • Experience using Active Directory and LDAP for role-based authentication.
  • Experience in developing groups in Active Directory.
  • Created services using Windows Communication Foundation, Web Service for data exchange.
  • Developed desktop application in order to upload and download files from the application.
  • Developed User Services, Identity Management modules and actively involved in creating electronic patient allergy and medical history management systems.
  • Involved in embedding flash swf, on asp.net page and communicating flash to asp.net page.
  • Experience using CVS.
  • Experience working with HIPAA and HL-7 messaging guidelines while developing the tools.
  • Monitored and maintained the application in post implementation phase.

Environment: Visual Studio 2010, .NET Framework 3.5, ASP.NET, MVC 3, C#.NET, Entity Framework, Team Foundation Server, WCF, MS Access 2007/2010, SSRS, SSIS, SQL Server 2008, Oracle, Automation Testing, Silverlight, AJAX, Java script, Html, CSS, JQuery, HL 7

Hire Now