• Involve in complete Software Development Lifecycle (SDLC).
• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Used ASP.Net MVC 4 to create Bus Purchase process for Transportation Module and maintain Vehicle Inventories.
• Worked on UI and business logic layer for their Core, Transportation, Facilities and Staff systems to process and manage complex data management.
• Created a working model for Facilities module to maintain public school facilities data and historical identification of each school facilities and track its condition over time.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Performed data conversion from flat file into a normalized database structure.
• Used ASP.Net MVC 4 framework to supervise ETL and report viewing and scheduling.
• Involved in Data analysis of few modules with the BAs.
• Create complex stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 R2.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Created Cross-Tabs, Drill-down and Sub-Reports using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc. in SSRS.
• Adhere to department, organization and industry guidelines, standards, policies and procedures.
• Involving in client-specific modifications.
Technical Environment:
ASP.NET, C#, MVC 4, Entity Framework 5.0, Microsoft SQL Server 2005/2008 R2, Visual Studio 2013, T-SQL, SQL Server Reporting Services, Team Foundation Service.