We provide IT Staff Augmentation Services!

It Consultant Resume

Indianapolis, IN

SUMMARY:

  • Experienced Senior Analyst Programmer with expertise in .NET, web development technologies, database, backend functions and stored procedures.
  • Experience in financial reports development using SSIS, SSRS, Crystal Reports 8.5, XI and complex SQL queries MS - SQL Server 2005, 2008.
  • Involved in requirements gathering, analysis, design, prototype, development, process and work flow diagrams using MS Visio.
  • Provided project cost estimates, created project plans using MS project, worked as team lead for onshore and offshore teams.
  • Good working knowledge with .NET, C#, ASP NET web pages, MVC technologies, Visual Studio 2008, 2010, 2012 windows based environments. Experience in C++, Java.
  • Working knowledge of dimensional data modeling, star schema design, big data and Hadoop. Good understanding of reporting solutions on SSRS, SSIS packages.
  • Experience in development of applications using Oracle Forms 6i, Oracle Reports, and UNIX shell scripts, Perl scripts.
  • Project experience includes the supporting Claims application, data conversion from COBOL on mainframes to Oracle.
  • Good working knowledge of Team Foundation Server (TFS)

TECHNICAL PROFILE:

Operating System: Windows, UNIX, Linux platforms

Databases: MS-SQL Server 2000, 2005, 2008, Oracle 10 g, Oracle 8.x, Oracle 7.3x, Oracle Forms 4.5, Forms 6.0, Oracle Reports, Business Objects Universe, SSIS, SSRS reports, big data and Hadoop

Languages/Tools/Cloud Technologies/GUI: SQL, PL/SQL, MySQL, Perl, Visual Basic, C#, .NET, HTML, CSS, Microsoft Visual Studio 2008, 2010, 2012, Java, Servlets, JSP, JSON, AngularJS, jQuery, java script, AWS.

Open Source: 4.5, Jakarta -tomcat 5.5.9, Apache-ant 1.6.5, UML, Oracle E-business suite SQL Navigator 5.5, Source Safe 6.0, Genesys Interactive Intelligence tools, Icelib API Unix Shell Script (Korn shell, C-shell)

MS Office Tools: MS-Word, MS-Project, MS-Excel, MS- PowerPoint, MS-Access, MS-Visio, office 365

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

IT Consultant

Environment: Windows, MS-SQL Server 2016, C#, .NET 4.0, 4.5, Visual Studio 2017, HP ALM Application Lifecycle management tool, Agile mythology.

Responsibilities:

  • Used latest .Net technologies such as ASP .Net core, Razor, .Net Frameworks, ADO .Net, LINQ, Nuget, JQuery, MVC design pattern, REST/SOAP based Interfaces for developing the applications.
  • Created Rest/Soap based web services using .Net technologies, Interfaces were consumed and used with in CPS Revenue cycle management application.
  • Created MVC web application using Asp .Net core, worked on Interfaces, Razor pages. Users have an ability to view/update patient details through the web application.
  • Created database objects, multiple stored procedures using SQL Server 2016, invoked stored procedures within web services calls and web application as needed.
  • Created project design documents, process flow, work flow diagrams as per projects requirements.
  • Worked on Agile methodology sprints, participated in daily standup meetings, worked closely with Scrum master/project manager, updated all project status on daily basis.
  • Performed testing for interfaces using Application Lifecycle management tool (HP ALM) as part of CPS Revenue cycle management integration project.
  • Used GIT/TFS for source code control and project related documents.
  • Coordinated with project team members and successfully implemented CPS Revenue cycle management integration process, Roche Patient Services Create Customer web application.
  • Working knowledge on Amazon Web Services (AWS).

Confidential, Indianapolis, IN

IT Consultant

Environment: Windows, MS-SQL Server, C#, .NET 3.5, 4.0, ADO .NET, SOAP, Web Services, Visual Studio 2012, Agile mythology.

Responsibilities:

  • Modified existing ME Tracker application as per new artificial intelligence project requirements.
  • Created new web service application with multiple web service calls and consumed with in ME Tracker application.
  • Created multiple stored procedures using SQL Server 2012, invoked stored procedures within web services calls.
  • Worked on Agile methodology sprints, participated in daily standup meetings, updated smartcards and posted on web portal.
  • Performed unit, Integration testing, end to end smoke testing for all components ME Tracker, web service applications.
  • Coordinated with multiple teams, successfully implemented artificial intelligence project using .Net technologies.
  • Working knowledge of XML, RESTful, Web Services, Service Oriented Architecture
  • Used TFS for source code control and project related documents.

Confidential, Indianapolis, IN

Consultant

Responsibilities:

  • Worked as part time realtor from
  • Worked on multiple real estate software tools and technologies.

Confidential, IN

Sr. Systems Support Engineer/Sr. Software Developer

Environment: Windows XP, Power shell, SSRS, SSIS Packages, MS-SQL Server, C#, .NET 3.5, 4.0, ADO .NET, SOAP, Web Services, Visual Studio 2012, IceLib API, IVR Handlers, ININ tools and technologies

Responsibilities:

  • Designed, coded, debug, test, document and maintained low to moderately complex internally developed applications using C# .NET, ININ tools and API IceLib.
  • Provided project estimates, Translated requirements, analysis into a systems design for a medium-to-large scale projects.
  • Ensured on optimal decisions have been made regarding analysis, design, and implementation of all projects.
  • Provided data analysis, extracted call recording data from multiple servers as per business requirements.
  • Worked on seven business lines residing on seven servers. Analyzed and extracted ININ call recording data using complex SQL queries from multiple SQL server databases.
  • Developed multiple applications using C# .NET, ASP .NET, ININ tools and Icelib API for Voice network team.
  • Created PowerShell scripts, automation processes to load Lync, ININ call data on weekly schedule.
  • Worked on multiple ININ servers, SQL server databases and generated reports, data analysis as per business requests. Involved in developing ASP.NET, WCF and Web services using .NET Technologies.
  • Created multiple web applications using ASP .NET MVC for Voice Network team, used latest technologies such as .NET frameworks, Ajax, JSON, AngularJS, jQuery, java script while developing the web applications, also provided options to user’s to listen and download to call recording WAV files.
  • Created SQL Server database, functions, stored procedures, migrated and loaded around hundred and sixty five million records into newly created database.
  • Created multiple windows forms applications using C#, .NET that Interacted with Icelib API and custom coded as per business needs for Voice Network department.
  • SSRS reports were created for multiple departments as needed by business users. Complex SQL queries were written and reports were automated using power shell scripts. SQL Server database was used to extract data and generate CSV files for further use within and other departments.
  • Used TFS for source code control and project related documents.

Confidential, Indianapolis, IN

Sr. Application Developer

Environment: Windows XP, MS-SQL Server, Oracle 8i, 9, Visual Basic 6.0, VB .NET, Visual Studio 2005

Responsibilities:

  • Designed, developed and maintain existing applications using Visual basic 6.0.
  • Trouble shoot, fix existing production issues on OSS/CSP systems using visual basic 6.0 and VB .NET applications.
  • Modified and maintained existing Expedited order system using VB .NET, SQL Server.
  • Modified existing Key Labels application, data dynamics reports and added additional order details under each barcode labels for further processing with in the order processing department.
  • Created, project estimates, project plan, requirement, design documents, process flow, work flow diagrams as required for projects.
  • Documented all critical production issues and performed user acceptance testing before moving the changes to the production environment.
  • Support and develop projects such as Order Management, Operator Efficiency projects using VB .NET and Oracle.
  • Worked on Jewelry data ware house (JDW) for college and high school departments.
  • Good working knowledge of BI and Data Warehousing principles.
  • Created SSRS reports as needed by business users for College division.
  • Designed, developed Informatica objects, data mapping, performance tuning, ETL process using multiple data sources. Strong in SQL and data analysis.

Confidential, Indianapolis, IN

IT Consultant

Environment: Windows XP, MS-SQL Server, Oracle 10, Access, Crystal Reports, C#, .NET, Visual Studio 2010

Responsibilities:

  • Designed, developed applications using Oracle 10g.
  • Responsible for Call Center data validations for multitude scenarios.
  • Migrated Access application to Oracle 10g.Created/modified existing call reports as requested by call center department.
  • Actively developed back-end processes involving stored procedures, packages using Oracle PL/SQL.
  • Coordinated with other teams (Phoenix team) in successful completion of Hard Phone and soft phone VOIP projects.
  • Tested /written several test plans for different hard phone and soft phone VOIP call center projects.
  • Created operational documents, process-flow diagrams, solution documents, test cases.
  • Built prototypes as proof of concept for migration projects before formal development.
  • Documented the critical work-flow processes in VISIO and developed ER diagrams.

Confidential, Indianapolis, IN

Application Developer Analyst

Environment: Unix, Linux, Windows XP, MS-SQL Server, Oracle 10, Korn Shell Scripts, Visual Basic 6.0, Crystal Reports 8.5, XI, .NET

Responsibilities:

  • Designed, developed and successfully completed projects for FHLBI.
  • Developed and deployed financial reports using SQL server 2000 and Crystal reports 8.5 for Treasury, Credit departments.
  • Developed and completed the background job log project for Networking department, Liquidity reports for Treasury Department Collateral Audit project for Credit department and migrated the old Focus technology processes using Oracle packages/procedures.
  • Actively involved in developing back-end processes, writing procedures, packages, triggers using Oracle PL/SQL.
  • Created and executed successfully the PL/SQL packages/procedures, Korn shell scripts
  • Created the requirements, design and solution documents, test cases and built prototypes.
  • Developed and successfully launched the business critical financial reports using different reporting tools.
  • Maintained and supported existing processes while developing new enhancements for improved performance.
  • Designed and created the databases along with schema maintenance and support where needed.
  • Documented the critical work-flow processes in VISIO and developed ER diagrams.
  • Supported and developed Visual Basic GUI applications using VB 6.0. Provided multiple reporting options for
  • Credit users through VB applications.
  • Supporting and maintained ASP .NET applications developed by third party vendors and applied patches as required.
  • Creating metrics reports for Credit department as per project requirements.

Confidential, Indianapolis, IN

Systems Analyst & Senior Systems Analyst

Environment: Unix, Windows XP, Oracle 10, Oracle Reports 10g, Korn Shell Scripts, Perl Scripts, Designer

Responsibilities:

  • As project lead, designed / developed prototypes and successfully completed the projects with external vendors.
  • Designed and developed all necessary documents such as context, requirements and design documents as part of product development.
  • Actively involved in using SDLC methodologies for medi-span data product development.
  • Actively involved in back-end processes, writing procedures, packages, triggers using PL/SQL.
  • Involved in development of applications using Oracle 10g and GUI development.
  • Developed several forms/ reports using Oracle forms 6i and Oracle reports.
  • Written several PL/SQL procedures, Korn shell scripts as part of builds processing for various products.
  • Written Perl scripts for parsing the data and population into the MDDB system.
  • Worked on Designer to create tables, the Entity Relationship Diagrams and Process Flow Chart, triggers.
  • Also, written several test plans as part of product unit/integration testing.

Hire Now