Summary

• Around 9 Years of IT Experience, which includes expertise in all phases of the software development lifecycle.
• Background includes experience in the use of ASP.NET, C , VB.NET, ADO.NET, HTML, XHTML, AJAX, jQuery, JAVASCRIPT, CSS, VB, C, C , COBOL, JAVA and STRUTS Framework using MVC Architecture.
• Exposure to various stages of Software Development Life cycle SDLC such as System Analysis, Data Modeling, client relationships/negotiations, gathering business requirements, project scheduling, development DEV , test UAT , build/release, and production support PROD environments.
• Technical Expertise in designing 3-Tier, N-Layered architecture with Reusable Component oriented design and have core knowledge in Object Oriented analysis and design OOAD .
• Strong Experience in writing and implementing T-SQL Queries DDL, DML, DCL, TCL , developing reports using SQL Reporting Services and Crystal Reports, version control using MS Visual Source Safe VSS , Dimensions and Clear Case.
• Extensive experience in Extracting, Transforming and Loading ETL using SSIS, DTS Import/Export Data, Bulk Insert and DTS Packages
• Expert knowledge in Using Microsoft Integration Services SSIS Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks
• Expertise in Monitoring and Troubleshooting and resolving the SQL Server Performance issues.
• Experience with Normalization of relational databases and data warehouses
• Have good understanding of complex data sets and skilled at data analysis, data cleansing etc.
• Experience in design, deployment and management of SSRS reports
• Knowledge on SSAS concepts Cube, Schema, Dimension table, Fact table
• Experience in writing test cases, performing system and unit testing besides trouble shooting.
• Performing Bug tracking, resolving issues, clearing defects and making enhancements as per any changes in the user requirements.
• Good knowledge on the Software design patterns
• Possess good communication, presentation and team playing skills.
• Have excellent domain knowledge in telecom, banking domain and SPED process.
• Have excellent analytical, Logical and innovative knowledge to provide the best software solutions.

Technical Skill set

• .NET Framework: ASP.NET, C , VB.NET, ADO.NET, AJAX, Web Services, LINQ
• Web Technologies: IIS, XML, XSD, XSLT, Tomcat
• Programming Languages: C, C , Visual Basic 6.0, JAVA
• Databases: SQL SERVER 2000/2005/2008, Oracle 9i, DB2, MS-Access
• Scripting/Markup languages: JavaScript, VB Script, jQuery, JSP, HTML, DHTML
• Development Tools: Visual Studio 2010/2008/2005/002, SSRS, SSIS/DTS, SSAS, SharePoint, Quick base, Microsoft Office, Visio, Toad, Iron Speed Designer
• Source Control: Visual Source Safe VSS , CVS, Dimensions, Clear Case
• Operating Systems: MS Windows 2003/XP/NT/2000/9x, MS DOS, UNIX

Project Experience

Confidential

The Interim Resource Management Tool is designed to support the CIO, BIOs and TECs and Business Development Technology Confidential Business Office by increasing transparency and communication of resource supply and project demand. The system will forecast resource supply and demand and a full financial forecast. This will allow the CIO and BIO leads to plan internal resources more efficiently and negotiate with outside resources at the B DT level.

Responsibilities:

• Developed Change Request documents and use case diagrams
• Prepared process flow diagram to explain the forecasting process
• Did code enhancements using Iron Speed Designer and Visual Studio 2008
• Involved in making changes to existing Code-behind files and Classes using C
• Increased code re-usability by creating User controls and Classes
• Incorporated client side validation using JavaScript
• Server side validation is implemented using asp.net validation controls and scripts
• Created additional tables, views, indexes, stored procedures and functions in SQL Server 2008
• Extensively involved in fine tuning stored procedures and other database objects to improve performance
• Designed, Developed and Automated SSIS packages ETL to run as scheduled jobs
• Troubleshooting failed SQL jobs
• Enabling tracing in sql server and collecting trace data to identify the slow running stored procedures and queries
• Ran the SQL jobs that loads data from the external systems on demand
• Created additional forecast reports in both SSRS and Panorama

Role: Application Developer

Projects:

Confidential is dc government Online Application that helps DC Residents to apply for DC Higher Education Grant Programs DCTAG, DCLEAP and DC Adoption.The DC OneApp system contains 3 modules, the Confidential online application for students OAS , the Institutional Management System IMS , and the SEO Application Intake system. The entire system is designed to simplify and enhance the application intake process from student entry online, front desk log-in for walk-ins, or mail-in application through Invoice submission by colleges and payment by disbursement analysts.

Responsibilities:

• Did code enhancements using asp.net and C
• Used Visual Studio as the IDE for development of new asp.net web pages
• Involved in making changes to the business logic and data access components
• Involved in the development of re-usable code using User controls and Classes
• Designed the master pages in Visual Studio 2005
• Included client side validation for the newly added controls in the forms using JavaScript
• Optimized existing JavaScript code
• Did some bug fixes in both the web application and backend database
• Made changes to the database design for the existing application
• Created and managed schema objects such as tables, views, cursors, indexes, stored procedures, triggers and functions
• Used Statistics to improve SQL query performance
• Creation of SSIS packages ETL , scheduling and running them as SQL jobs and troubleshooting the failed jobs
• Optimized the SQL code for performance, Improved the performance of the table joins by implementing index scans where ever required
• Generation of some additional reports for HEF department using SSRS and crystal reports
• Resolving disputes in payments by providing customized report

Confidential is a system where all the special education data of DCPS, charters and Non pub are maintained and processed. This project involves the migration of special education data from the legacy special education data system and interfaces with the new system. The data migration includes migrating data from both the legacy special education system i.e., Encore and data captured in spreadsheets provided by the public charter schools that don't use the legacy system

Responsibilities:

• Involved in Requirement Analysis, logging Issues and gathering Business Requirements and developed Functional Design and Technical Design documents
• Involved in Database design, Data mapping, logical data modeling and preparing ERD diagrams
• Created and maintained SQL Server database tables, views, indexes, stored procedures and jobs to support the SEDS system
• Generated Data Cleansing reports using Crystal Reports in Visual Studio
• Wrote complex T-SQL Statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity
• Migrating the Student Data Special Ed from old system SQL Server 2000 Excel Spreadsheets to new system SQL Server 2005
• Developed DTS packages for the creation of daily feed student demographic data and upload to the new system
• Wrote SQL views and stored procedures to create the daily feed
• Designing, Developing and Deploying various ETL packages SSIS
• Effectively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery
• Involved in documenting the Data migration process in Interface Control Document
• Migrated SQL Server 2000 DTS packages into SSIS SQL Server 2005
• Created, Deployed and Managed Reports through SQL Server Reporting Services SSRS
• Effectively used Microsoft Business Intelligence Development Studio for creating ETL packages and Reports
• Developed a quick base application

Confidential is an Auditing and Reporting Application developed in order to assist with the requirements on the Blackman Jones Consent Decree. This tool is used to audit for the accuracy and consistency of the student data in DCPS District of Columbia Public Schools among the various systems used to store the student information. Also CR.NET is used to generate some of the reports.

Responsibilities:

• Was involved in the Requirements gathering and Analysis and documenting the requirements into Business Requirements Document and Detailed Design documents for the BJRS Audit Application
• Involved in Framework, Application and Database Design.
• Prepared use case and ERD diagrams
• Used MVC Model View Controller design pattern to develop the application
• Designed presentation layer for web pages using ASP.Net, CSS and Visual Studio tools
• Used JavaScript for client side validations
• Involved in Business and Data layer development using C .Net and ADO.Net
• Involved in the development of re-usable code using User controls and Classes
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter for data access and manipulation
• Involved in Data modeling to develop the database design
• Created Stored Procedures, Functions, Views, Triggers, Temp tables in SQL server 2000
• Involved in full SDLC implementation of project
• Used Crystal Reports for building Reports

Confidential

Role: Programmer