Chaitanya Appala

  • Ashburn VA

Work History

Work History
Sep 2014 - Feb 2015

MS SQL Server Developer/Analyst

Altruista Health

           Involved in development of care management solutions for health plans and providers. Developed and delivered software tools, data analytics and support services that help streamline clinical and administrative processes, improve patient outcomes and reduce avoidable healthcare costs.


Responsibilities:

• Imported and Extracted data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
• Developed Complex Queries using different SQL joins and T-SQL Queries.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Developed Windows form application using C#.Net and SQL Server to extract the patient demographics.
• Working experience on Medicare/Medicaid/QNXT environment.
• Developed programs using C#.Net, Business Objects and Entity spaces according to the business logic provided by the clients.
• Involved in discussions with the clients to understand the project requirements.
• Involved in complete Software development life cycle (SDLC) of the project including Analysis, design, develop, deployment, test, implement and production.

Environment:

               MS SQL Server, T-SQL, SQL Server Management Studio, Visual Studio, Business Objects, Entity Spaces, Business Intelligence, SSRS, SSIS

Sep 2012 - Aug 2013

Sql Server Developer

Narolis Technologies-Bangalore, INDIA

                Implemented advanced search capabilities to search the stored images using content-based image retrieval on a large image data set database. This application is developed using C#.Net to retrieve the images stored in SQL Server database.

Responsibilities:

• Developed Database objects and applications using T-SQL
• Created Joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing Triggers, Stored Procedures, and Data manipulation.
• Extensively used SSRS to Export / Import data from existing database to live database.
• Developed the fresh reports in SSRS
• Created Cubes in SQL Server Analysis Services(SSAS)
• Designed Indexes on the tables in order to ensure good performance during data retrievals
• Developed Database Triggers for keeping the Audit Logs.
• Supported Production and Development databases
• Documented all processes and Dataflow involved in the database using Microsoft Visual Studio.

Environment:

              MS SQL Server, T-SQL, SQL Server Management Studio, Visual Studio, Business Intelligence Development Studio, Report Builder.

Aug 2011 - Sep 2012

Junior Sql Server Developer

Narolis Technologies-Bangalore, INDIA

                       Implemented UMS to integrate student, faculty and administrative activities. Using this system, Students can submit the assignment work and attend the classes on-line using on-line video capabilities. 

Responsibilities:

• Involved in writing SQL Stored Procedures to access data from MS Access
• Developed SQL queries to check the database
• Wrote SQL Stored Procedures to implement Business logic
• Created of Triggers, Stored Procedures, Tables, Indexes, Rules
• Imported and Exported data (Migration) from different sources other than SQL server using Import/Export wizard (ETL).
• Created SSIS packages using different tasks and transformations and moved data from various sources to appropriate destinations.
• Extracted data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
• Coordinate with clients as needed for on-going system support and troubleshooting

Environment:

             MS SQL Server, SQL Server Management Studio, Visual Studio, Business Intelligence Development Studio, MS Access, MS Excel.

Education

Education
2013 - 2014

Master's in Computer Science

University Of Central Missouri,MO,USA
2008 - 2012

Bachelor's in Computer Science

Jawaharlal Nehru Technological University,INDIA

Skills

Skills

MS SQL Server

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

VISUAL STUDIO

Data Base

Certifications

Certifications
2014 - Present

Microsoft Certified Solutions Associate

Micorosft

Microsoft Certified Developer in SQL Server

2014 - Present

Microsoft Technology Associate 

Microsoft 

Microsoft Technology Associate in Database Administration