Resume of

Nilaya Rastogi

**** ******* ***** **., ************,IN

adh36k@r.postjobfree.com

Ph: 317-***-****

Summary of Qualifications

Experience of 10+ yrs in Information Technology as Developer, Module Lead and Onsite Lead.

Experience in Production Support and Maintenance project as the Onsite Lead. Have thorough knowledge of Incident, Problem and Change Management.

Worked in Microsoft Visual Studio .Net ( ASP.net, C#. net, VB.Net) 2.0, 3.5, 4.0} as .Net Developer/Module Lead

Worked extensively on building Restful Web APIs.

Good experience of working with SSIS to create batch jobs

Worked extensively with SSRS for reporting purposes and helping with dashboard facilities for business and the higher management.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Analyzes data models, data relationships and dependencies for greater optimization.

Experience with Domain Driven Design, Dependency injection and Unit of work implementation.

Comprehensive experience with SQL Server Database concepts, designs, and project implementations

Involved in developing Web Based applications using technologies like .Net, JavaScript, HTML

Expertise in project scope definition based on gathered Business Requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions

Utilized ASP.NET, VB.Net, C# and created Web forms, User controls, custom controls, web services

Developed distributed applications using .Net and Web Services.

Worked with Product Managers to evolve understanding of product needs and translate into product specifications, then translating specifications into working systems components

Designed and Developed n-tier (including business and data tier) applications. Well versed with Back end, Middle tier, Front end and GUI.

Good knowledge of databases like SQL Server, Oracle and MS Access

Excellent Communication skills, hardworking, highly enthusiastic and good problem solving abilities

Ability to learn and implement different languages and complete projects in the given timeframe

Proficient in developing and executing Test cases, test plans, performing functional, usability, stress testing and UAT

Experience with automated testing and/or test harnesses

Provide innovative solutions to push the boundaries of technical constraints.

Work with the Offshore lead's to establish a collaborative environment between technology and the other disciplines

Worked on Agile methodology and phases of SDLC

Responsible for knowledge transfer and grooming of (offshore) technical team members

Identifies new opportunities and ideas for the project - which can be proposed to clients for future enhancements

Assist Business Development and project teams in scoping and estimating project work for medium to small sized projects, may present at pitches to clients

Technical Knowledge

Open Systems Technology: C# .NET, Visual Studio 2005/2008/2010/2015, Crystal Reports, SSIS, SSRS 2008/2012, Restful Web Services

Web Technologies: HTML, ASP .NET

Database(s): SQL Server 2005/2008/2015, PL/SQL, Oracle 10i, MS Access

Operating Systems: Windows XP, Win-2000 / 2K3/2K8, Win 7

Scripting Language: Java Script, VB Script, JQuery

Packages: MS Project, MS Office

Software Tools: MS Word, MS Excel, NS Access, MS Visio (user), Team Foundation Server, VSS, Visual Source Safe, SVN

Professional Experience

July 2019 – Till date

Client: Indiana Family and Social Services Administration

Position: Senior Consultant

Project Location: Indianapolis, IN

Platform: Visual Studio 2010/2015, Informatica, IBM Infosphere DataStage 8.5, SQL Server Management Studio, Cognos BI tool, Oracle SQL Developer, Teradata V15, Teradata SQL Assistant, Sql Server 2017, SSRS 2017

Project: FSSA Division of Family Resources (DFR) and Social Services Data Warehouse (SSDW).

Project Description: The project involves building and maintaining a data warehouse in Teradata to house the data in an historical manner from CaMSS, which is actually a transactional data processing system in SQL Server.

The data in the new Data Warehouse will then be used to generate various monthly, quarterly and annual reports for the Federal and the State Governments.

As a Senior Consultant, my role involves discussions with the Business Partners and Owners of the transactional system (CAMSS) to understand how the data needs to be formatted, cleansed and saved in the new Data Warehouse. All the Analysis, Data Migration and ETL and Report development is done through the Agile and Waterfall methodology.

Responsibilities:

As the Senior Consultant, I am responsible for the below listed responsibilities:

Work closely with the Business Partners and the Owners of the transactional database to understand the database relationship and how the data is currently stored and updated.

Work on the initial analysis and the design phase of the new Data Warehouse

Work with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data

Develop ETL packages in Informatica for the import data from the Case Management for Social Services (CaMSS) internal system to the new DWH.

Develop mapping / sessions / workflows

Analyze performance issues, conduct ETL performance tuning, troubleshooting, perform RCA and provide resolutions for immediate fix and also recommend/build long term solutions to resolve the root cause

Works with the business to develop requirements and establish project objectives;

Communicates with business users to ensure satisfaction with delivered projects/products;

Work closely with the business partners to understand the data to be presented on the reports

Creating complex T-Sql queries to generate reports for the DA using stored procedures, temp tables, views, and functions.

Assisting the team with performance tuning of ETL processes and SQL queries

Create automated reports on Cognos to generate monthly, quarterly and annual reports.

Assist with future plans, business changes, policy changes, management decisions and expectations that impact the project;

Provide expertise and guidance to support the development of reporting and analytical solutions;

Document specific requirements for data integration, including file format, fields, etc.

Implement, maintain and enhance SSIS ETL packages for fulfilling data quality, availability, data freshness and performance requirements, working with the business users to understand the business requirements to be fulfilled by the data, assessing requirements for completeness and accuracy.

Perform tests and validate all data flows and prepare all SSIS ETL processes according to business requirements and incorporate all business requirements into all design specifications. Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all SSIS ETL packages.

Ensure that the projects and development activities are completed timely and accurately while following the System Development Life Cycle (SDLC)

Proactively monitors all Federal and State rules and regulations to assess the potential impact on processes and deliverables;

Help and guide the team to understand processes, best practices, and strategies for existing and future BI solutions

Review documentation of database workflows, requirements, policies, and procedures as they relate to Business Intelligence Reporting.

Develop solutions for Production reports originating from the Data Warehouse to be used by the business for ongoing analytical and operational needs.

Supporting the data warehouse in identifying and revising reporting requirements, processing confidential data and information according to guidelines.

Validate data from the multiple systems used and ensure the integrity and accuracy of the data/analysis being reported.

August 2018 – June 2019

Client: Bureau of Motor Vehicles

Position: Senior Application Developer

Project Location: Indianapolis, IN

Platform: Visual Studio 2010/2015, C#, ASP.Net 4.6.1, VB.Net, Sql Server 2015, SSRS 2008/2012, Restful Web Services

Skills: Domain Driven Design, Dependency Injection

Project: Galaxy Web Service Development

Project Description: The project involved building new Restful Web APIs, using OOPS concepts and following Domain Driven design. The APIs were built on ASP.Net 4.6.1 framework.

The legacy web applications and Soap services were converted to the new Restful microservices. The new Services helping complete the Business transactions BMV provides such as New Title and Registration of vehicle, generating Duplicate Title/Registration, Registration Renewal etc.

The project also involved building SSRS reports and dashboards for the business partners and the higher management. Designed and developed stored procedures, queries and views necessary to support SSRS reports. Analyzes data models, data relationships and dependencies for greater optimization. Also, worked on building SSIS batch jobs.

As a Senior Developer, my role involves discussions with the Business Analysts and Application Architect to understand the business requirements. All the new development is done through the Agile methodology

The new development and enhancement work is assigned in form of User Stories having appropriate Priority and complexity assigned to them. The project also involves developing and testing SQL procedures for fetching and updating data in the Stars database.

Responsibilities:

As the Senior Developer, I am responsible for the below listed responsibilities:

Working closely with the architect to come up with the architecture for the new development

Developing new Rest APIs following Domain Driven Design.

Work extensively on SSRS to create reports and forms.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Analyzes data models, data relationships and dependencies for greater optimization.

Scheduled and managed daily/weekly/monthly reports on business transactions.

Work on Dependency Injection and Unit of Work.

Working in Test driven development environment by writing thorough Unit Tests after the API design is complete.

Knowledge management for all existing applications for client.

Interacting with Business teams for gathering requirements

Work with Project Manager to ensure project plan is maintained and project milestones are being met.

February 2016 – December 2016

Client: Bureau of Motor Vehicles

Position: Senior Application Developer

Project Location: Indianapolis, IN

Platform: Visual Studio 2010/2015, C#, ASP.Net 4.5, VB.Net, Sql Server 2008, SSRS 2008, Soap WebServices, Crystal Reports

Project: Stars and MyBMV Application Development and Enhancement

Project Description: Stars and MyBMV are complex applications written in VB.Net having SQL Server as the backend. Through these applications the BMV takes care of various processes like Titling, Vehicle Registration, Renewals, Amendments, Driver History maintenance etc.

The above listed processes are very elaborate and depend on a lot of business rules. All the business logic is handled through the VB code and 1000+ Stored Pro. The Applications use Crystal Reports and SSRS for extensive reporting purposes.

The project also involved building SSRS reports and dashboards for the business partners and the higher management. Designed and developed stored procedures, queries and views necessary to support SSRS reports. Analyzes data models, data relationships and dependencies for greater optimization. Also, worked on building SSIS batch jobs.

As a Senior Developer, my role involves discussions with the Business Analysts and Application Architect to understand the business requirements. All the new development and enhancement of the applications, webservices and reports is done through the Agile methodology

The new development and enhancement work is assigned in form of User Stories having appropriate Priority and complexity assigned to them. The project also involves developing and testing SQL procedures for fetching and updating data in the Stars database.

Responsibilities:

As the Senior Developer, I am responsible for the below listed responsibilities:

Work with the Business partners and Business analysts understand functional specifications.

Involved in development and enhancement of the Stars and the MyBMV application

Work extensively on SSRS and Crystal to create reports and forms.

Analyze, modify and create new stored procedures.

Work on code changes and Unit testing.

Work on System Testing and Implementation for the application.

Knowledge management for all existing applications for client.

Worked on VB.NET 4.5, SSIS jobs and SSRS/Crystal reports.

Interacting with Business teams for gathering requirements

Working on the Deployment of the application

Work with Project Manager to ensure project plan is maintained and project milestones are being met.

Worked on Problem tickets and did Root Cause Analysis for recurring issues either at Application level or at Data level.

Creating Root Cause Analysis documents and suggesting the required amendment or enhancement for the fix.

August 2014 – October 2015

Client: Indiana State Department of Health

Position: Senior Software Developer

Project Location: Indianapolis, IN

Platform: Oracle, VB.Net, JQuery, Cognos

Tools: Visual Studio 2012, Oracle SQL Developer, TOAD, MS Access

Project: Newborn Screening, MCH

Project Description: The Maternal and Child Health (MCH) IT Department develops and supports applications that help supporting the Indiana State Newborn Screening Program. The mission of the NBS Program is to ensure that every baby born in the State of Indiana receives state-mandated screening, and infants with abnormal results receive appropriate confirmatory testing and treatment, and their family receives genetic counselling.

The applications supported provide a centralized, web-based location for data entry and management. It improves access to population-based, integrated, real-time data (including newborn screening results) for birthing facilities, health care providers, and NBS Program personnel. Data saved in the Oracle database will also be used to enhance current standards of care for children diagnosed with newborn screening conditions.

The project involves development of new application modules in VB.net, JavaScript as front end and Oracle database as the backend. It also requires generating reports and creating new Stored Procedures for pulling up data from the Oracle database.

The responsibilities also involve supporting and maintaining the existing applications. The issues are tracked, prioritized and adhered to through the Incident Management system.

Responsibilities:

Being the Administrator and the Developer of the tool, I had the below list of responsibilities:

Work with Client and the Business Team to understand functional specifications.

Providing appropriate roles and rights to the users to access the applications appropriately

Worked on Change Requests to implement any functionality change in the tool suggested by the Clients. Create Analysis and Design documentation.

Work on code changes and Unit testing.

Complete development tasks as per the specification and direction given by the Dev Lead

Work on System Testing and Implementation for the application.

Resolving all tickets (Incident, Problem and Change tickets)

Monitoring the daily inflow of Tickets. Working on permanent solutions so that the ticket count could be controlled.

Knowledge management for all development done for client.

Worked on VB.NET and JQuery to create new modules of the applications.

Creating Stored Procedure and Queries to access and pull up data from the database.

Create automated reports on Cognos to generate monthly, quarterly and annual reports.

Interacting with Business teams for gathering requirements

Working on the Deployment of the application

Dealing with business and customers

Work with Project Manager to ensure project plan is maintained and project milestones are being met.

January 2014 – May 2014

Client: Revone Companies

Position: Application Developer

Project Location: Indianapolis, IN

Platform: Visual Studio 2012, C#, ASP.Net, Artiva

Project: Artiva Administration and Development

Project Description: Artiva is a tool created by Ontario Systems. It is used in the Hospitals, Health Care Centers and by Medical vendors to manage the billing and the collection side of the medical expenses.

The project involves development and enhancement in Artiva to handle end to end business processes. Various Web Portals and WebServices were also developed in ASP.Net and integrated with the tool.

Responsibilities:

Being the Administrator and the Developer of the tool, I had the below list of responsibilities:

Work with Client and the Business Team to understand functional specifications.

Providing 24*7 Production Support to the users, ensuring they can work efficiently and smoothly without causing hindrance in business.

Worked on Change Requests to implement any functionality change in the tool suggested by the Clients. Create Analysis and Design documentation.

Work on code changes and Unit testing.

Work on System Testing and Implementation for the application.

Resolving all tickets (Incident, Problem and Change tickets) within the defined Service Level Agreements and process guidelines.

Monitoring the daily inflow of Tickets. Working on permanent solutions so that the ticket count could be controlled.

Knowledge management for all development done for client.

Worked on C#.NET to Support front end of the System.

Interacting with Business teams for gathering requirements

Working on the Deployment of the application

Dealing with business and customers

Work with Project Manager to ensure project plan is maintained and project milestones are being met.

October 2010 - December 2013

Employer: Tata Consultancy Services Limited

Client: Humana Health Insurance

Position: Application Developer

Project Location: Louisville, KY

Platform: Visual Studio 2008, C#, ASP.Net 3.5, VB.Net, Sql Server 2008, SSIS, SSRS, WebServices, Informatica

Project: Shared Data Repository and Shared Data Services Production Support and Management

Project Description: Shared Data Repository is a complex database that stores all Member data. This data is created, updated and accessed through a set of .Net services (Shared Data Services), SSIS packages and batch Jobs, and is appropriately displayed over the internet to the Health Providers, Pharmacies and Patients.

This was a 24*7 Production Support project. It primarily involved ensuring the Database was up and running and the services and the processes being used by the users and other consumer applications ran smoothly and efficiently in Production. Also, the data was being picked up correctly by the .Net services and was correctly being displayed on the Web for the end users and other consumer applications.

The Applications used SSRS for extensive reporting purposes. The work also consisted of development and enhancement of SSRS reports. There were reports which enlisted Benefits included in a Humana product, Brand and Generic drugs covered for a Customer, Claim requests for a Coverage Member etc. These reports were used by the Business Users and other Application consumers like Pharmacists, Health Providers.

The work was assigned in form of Change Requests and Trouble Tickets. All issues needed to be resolved within the SLA defined as per their severity and in accordance with the Incident and Problem Management guidelines.

It consisted of tackling issues happening at User level, Group Level and Enterprise Level. The problems consisted of both data and performance issues.

The project also involved developing and testing SQL procedures for the maintenance and improvement of the SDR data.

Responsibilities:

Being the Onsite Lead of a team responsible for Production Support, Maintenance/Enhancement, Configuration, I had the below listed responsibilities:

Work with Client and the Development Team to understand functional specifications.

Providing 24*7 Production Support to the SDR Database and the Applications and the Batch jobs sitting on top of it, ensuring they run efficiently and smoothly without causing hindrance in business.

Worked on Change Requests to implement any functionality change in the Applications suggested by the business team. Create Analysis and Design documentation for any modifications to existing web based ASP.NET and VB.NET applications.

Worked on Incident Tickets to fix bugs in application and data analysis of reports.

Worked on Problem tickets and did Root Cause Analysis for recurring issues either at Application level or at Data level.

Creating Root Cause Analysis documents and suggesting the required amendment or enhancement for the fix.

Worked extensively on SSRS to create inbuilt reports in the Applications whose execution was either triggered or scheduled.

Develop mapping / sessions / workflows

Analyze performance issues, conduct ETL performance tuning, troubleshooting, perform RCA and provide resolutions for immediate fix and also recommend/build long term solutions to resolve the root cause

Analyze, modify and create new stored procedures.

Work on code changes and Unit testing.

Work on System Testing and Implementation for the application.

Involved in the building up and grooming of the Offshore Team. Knowledge Transfer of the applications and procedures to the new joiners.

Resolving all tickets (Incident, Problem and Change tickets) within the defined Service Level Agreements and process guidelines.

Monitoring the daily inflow of Tickets. Working on permanent solutions so that the ticket count could be controlled.

Involved in daily monitoring of reports, fixed errors reported during the time.

Form validation including business logic validations for data entered by the user.

Knowledge management for all existing applications for client.

Worked on C#.NET 3.5, SSIS jobs and SSRS reports to Support front end of the System.

Creating complex scripts to fix the data in the database and improve customer experience and in parallel working on permanent solutions and fixes to be done in the Applications.

Interacting with Business teams for gathering requirements

Working on the Deployment of the application

Dealing with business and customers

Work with Project Manager to ensure project plan is maintained and project milestones are being met.

Collaborate with team members and support/mentor other development team members.

Jun 2008 – Sept 2010

Employer: Tata Consultancy Services Limited

Client: Humana

Project Location: New Delhi, India

Position: Developer

Platform: Visual Studio 2005, C#, TFS 2005, ASP.Net 2.0, Sql Server 2005, SSRS,Web Services

Project: E-Pharmacy Development Project

Project Description: E-Pharmacy as name describes is pharmacy over the net. EPharmacy Project was responsible for creation of 60+ applications and moving them to Production after the required System testing and UAT. These Applications enabled health providers, pharmacies and patients to appropriately and securely prescribe drugs, monitor their dispensing, and securely access and share patient’s information. EPharmacy is basically divided in three modules-Web, Data and Rightsource.

The Applications used SSRS for extensive reporting purposes. The work also consisted of development and enhancement of SSRS reports. There were reports which enlisted most recent Retail and Mail prices of the Drugs, list of Brand and Generic drugs available under each type of Coverages etc. These reports were used by the Business Users and other Application consumers like Pharmacists, Health Providers.

Applications are in XSLT and ASP.Net 2.0 with backend as SQL Server 2005.ePharmacy involves the maintenance and development of new applications as per the client’s requirement.

Responsibilities:

Work with Client to understand functional specifications.

Estimating the effort involved in fulfilling the requirements.

Development of various modules in accordance with Agile Methodology

Analyze, modify and create new stored procedures.

Worked extensively on SSRS to create inbuilt reports in the Applications whose execution was either triggered or scheduled.

Create Analysis and Design documentation for any modifications to existing web based ASP.NET application.

Work on code changes and Unit testing.

Built queries to extract data result from the SQL Server database which fed the application.

Work on System Testing and Implementation for the application.

Involved in the Knowledge Transfer of the new applications within project.

Member of a team responsible for Application Development and Enhancement.

Worked on Incident Tickets to fix bug in application and data analysis of reports in the initial phase. And then gradually grooming the Support team to take responsibility of the same.

Involved in daily monitoring of reports, fixed errors reported during the time.

Form validation including business logic validations for data entered by the user.

Knowledge management for all existing applications for client.

Worked on C#.NET to develop the logic (code behind).

Interacting with Clients for gathering requirements

Working on the Deployment of the application

Employer: Tata Consultancy Services

Client: Eli Lilly & Company

Jan 2008 – Jun 2008

Position: Team Member

Platform: Remedy V5.2, Oracle 10i

Project: Remedy 3 Tier Support

Project Description:

Remedy is a Tracking tool. The project involved providing Technical support to all the end users of the tool.

Responsibilities:

Work on Change and Trouble tickets.

Analyze, modify and create new stored procedures.

Working with the Onsite counterparts.

Member of a team responsible for Development, Production Support, Maintenance/Enhancement, Configuration.

Form validation including business logic validations for data entered by the user.

Knowledge management for all existing applications for client.

Dealing with business and customers

Certification

Microsoft SQL Server 2005 : Maintenance and Implementation (070 431)

Introduction to Oracle 9i (1Z0 007)

Educational Qualification

Masters in Computer Applications, Thapar University, India

Contact this candidate