SUMMARY

• Sr. Applications/Systems Engineer with over (6) six years of experience with primary skills in SQL and C# programming, encompassing analysis, design, development, deployment, testing and support of various applications
• Expert in Object Oriented design and development in both the backend and frontend using Microsoft SQL server and Microsoft Visual Studio technologies
• Proficient in full System Development Life Cycle (SDLC) and agile methodologies of development process
• In - depth knowledge of T-SQL, ASP.NET, C#, SSIS, SSRS, OLAP and BI suite
• Proficient in CSS, JavaScript, jQuery, HTML, XM, and Ajax
• Strong experience in the SQL server database development and efficient data manipulation including complex T-SQL programming, creating complex Stored Procedures, Views, Functions, Indexes, Triggers, Tables, User Defined Data Types and other SQL Joins and statements
• Excellent in ETL implementation using SSIS control flow containers: For Loop, For Each Loop and Sequence and using Script Task, Conditional Split, Derived Column, Data Conversion, Merge, OLEDB/ADONET Task, Lookup, Execute SQL and File System in SSIS
• Solid ETL, data modeling and Dimensional Modeling skills with experience developing data movement, data cleaning and data integrity processes for the purposes of loading decision support applications utilizing DTS packages, C#, and T-SQL
• Expert in migrating big data from Oracle to MS SQL server and importing data from excel and flat file to populate in Web-based applications by creating methods in C# using SSIS
• Expert in creating reports according to the business requirements and application platforms using SSRS
• Excellent interpersonalskills,strong team-work spirit, quick-learning ability, motivated troubleshooting and problem solver with strong analytical skills and able to work to tight deadlines

TECHNICAL SKILLS

Relational Databases: MS SQL server 2005/2008/2012 , Oracle 11g, MS Access, Teradata

Programming Languages: SQL, T-SQL, PL/SQL, C#, VB

.NET Technologies: ASP.NET Framework 4.0/4.5, Web Forms, Win Forms, Console

Web Technologies: ASP, Telerik, CSS, HTML, XML, JavaScript, jQuery, Ajax

Data Warehousing & BI: SQL server, Business Intelligence Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS)

Development Tools: SQL server 2008/2012, Visual Studio 2010/2012, Team Foundation Server 2010/2012

PROFESSIONAL EXPERIENCE

SQL/.Net Application Developer

Confidential, San Antonio, TX

Responsibilities:

• Involved in the complete System Development Life Cycle using agile methodology with daily scrums and application lifecycle management (ALM) tool
• Designed and developed Websites in ASP.NET framework 4.5
• Developed various class libraries for data processing, interfaces, dynamic and re-usable customized components using ASP.NET/C#
• Created event driven Web forms using ASP and Telerik controls, developed the code-behind files in C# and developed JavaScript and jQuery for client side processing
• Developed CSS for user interface uniformity throughout the application
• Designed and developed database objects including Tables, Stored Procedures, Views, user defined functions, defaults, constraints and Indexes in SQL to interact with the front end application and handle the complex business rules
• Designed and developed the email notification methods which were used as a standard design for other applications
• Create a series of Stored Procedures to migrate data between different applications by analyzing their workflow and dataflow
• Designed reporting database for the existing applications and created SSIS packages to synchronize data between the application server and reporting server
• Develop dynamic scripts to copy objects and data between different environments like DEV, UAT and Prod
• Developed dynamic SSIS framework for the teams to capture and track all of the job status
• Assigned tasks to the junior developers, provided guidance and code reviews to ensure compliance with development standards
• Extensively use Reporting Service2010 to configure and manage the SSRS reports
• Worked on defects submitted by the testing teams and deployed applications as needed

Environment: Microsoft Visual Studio 2012, Telerik, Team Foundation server 2010, SQL server 2005/2008R2/2012, BCP, DNS, Oracle 11g, SQL Server Integration Services (SSIS) 2008/2012, Microsoft SQL Reporting Services (SSRS) 2008/2012, Application Lifecycle Management (ALM), ASP.Net, C#, HTML, CSS, JavaScript, jQuery, Ajax, XML

Sr. Applications Systems Engineer

Confidential, Washington, DC

Responsibilities:

• Worked with the project teams to review the business and functional requirements
• Evaluated the existing applications and platforms and provided recommendations for the system enhancements by conducting gap analysis and identified the feasible alternative solutions
• Created and presented user interface design and prototypes to the business stakeholders and gathered their feedback to determine optimum functionality requirements to meet the business needs
• Created technical design specifications and provided technical consultant in the project planning process with customers, business analyst, architect and testing team
• Reviewed data flow and redesigned the SQL server database for OTP applications
• Wrote queries, Stored Procedures, Functions etc. in the SQL server 2012 for backend processing
• Designed and developed class libraries and interfaces to construct business logic using VB.NET
• Developed controls and Web forms using ASP.NET, HTML, CSS, jQuery and JavaScript

Environment: Microsoft Visual Studio 2010, Team Foundation Server 2010, SQL Server 2012, ASP.Net, Visual Basic, HTML, CSS, JavaScript, jQuery, Ajax

Applications Systems Engineer

Confidential, San Antonio, TX

Responsibilities:

• Worked closely with businesses to review the business and functional requirements, performed analysis of requirements and design regarding input, output and the processing needs
• Designed and developed Windows forms and console applications in C#
• Designed and developed Websites on the ASP.NET framework through agile/Scrum development methodologies
• Created ASP.NET Web forms, Web user controls and class libraries for business and data access logic using C# and ASP.NET
• Developed Web pages using ASP.NET and Telerik controls
• Wrote JavaScript and jQuery for client side processing
• Created Tables, Views, Stored Procedures, user defined Functions, constraints etc., in SQL server
• Wrote T-SQL statements for retrieval of data and facilitated performance tuning of T-SQL queries and Stored Procedures
• Designed SSIS packages to transfer data crossing different platforms and automated updating Tables
• Handled ETL operations to support the incremental, historical data loads and transformations using SSIS
• Created reporting database and developed SSIS packages with script tasks in C# to copy data from the application database
• Re-wrote SAS codes into SQL and created SSIS packages and SSRS reports to automate the tasks
• Coded and created reporting for the business in response to their ad hoc requests and migrated applications in SSRS and upload in to as well
• Re-wrote and converted access and crystal reports into SSRS reporting; configured and deployed different reports in the servers
• Created and implemented SSRS reports to support the Web-based applications
• Deployed application on test and production server
• Performed application testing, troubleshooting and fixed the bugs and errors
• Provided performance/code reviews and optimization
• Provided root cause analysis in production and support for a variety of SSIS jobs, SSRS reports, and desktop and Web applications
• Participated in server migration and production moves
• Conferred with the users to gain understanding of the needed changes or modifications of the existing applications and worked on enhancements to the existing applications

Environment: Microsoft Visual Studio 2010, Telerik, Team Foundation Server 2010, SQL Server 2005/2008R2/2012, Oracle 11g, Teradata, SQL Server Integration Services (SSIS) 2008/2012, Microsoft SQL Reporting Services (SSRS) 2008/2012, ASP.Net, C#, HTML, CSS, JavaScript, jQuery, Ajax, Crystal, Access, SAS 9.3

SQL/BI Developer

Confidential, Washington, DC

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user training
• Participated in logical design of database incorporating business logic and user requirements
• Created and developed Stored Procedures and Triggers to handle the complex business rules, history data and audit analysis
• Designed dynamic DTS and SSIS packages to transfer data crossing different platforms, validated data during transferring and archived data files for different DBMS
• Created packages using DTS and SSIS for data Extraction from flat files and excel files to the SQL server using ETL Tool and C#
• Developed Parameterized, Drill Down and Drill Through Reports and implemented various reporting features such as Chart Control, Interactive Sorting, Expressions and wrote custom functions
• Used SSRS subscriptions to schedule the automatic delivery of the SSRS reports
• Involved in Performance tuning of ETL Transformations, data validations and Stored Procedures
• Generated database monitoring and data validation reports in SSRS
• Involved in Report writing according to the business requirements using SSRS and Crystal Reports
• Designed Cubes, star schema and data models for data warehousing applications
• Developed reports from where the data was extracted from SSAS cubes in SSRS
• Used report manager to create folder structures, modify data sources and controlled access to the report services resources
• Optimized query performance by creating Indexes
• Moved static data from various text files to the SQL server 2012 database, using BCP Import and Export and Bulk Insert
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and Stored Procedures
• Provided support to the application developers on the application database
• Configured and deployed different reports in the servers using SQL server 2012 Reporting Services

Environment: MS SQL Server 2005/2012, Enterprise Manager, Management Studio, Integration Services, Reporting Services, SSRS, DTS, Data Modeling, Analysis Services, T-SQL, DB2, ETL, SQL Profiler, SQL Server Agent, Data Ware Housing, BCP, and Microsoft Visual Studio

SQL Server Developer

Confidential, San Antonio, TX

Responsibilities:

• Gathered the functional requirements and business requirements and wrote technical specifications for building the Global Enterprise data warehouse
• Worked closely with the developers, end users in designing and created the Global Enterprise data warehouse by using OLAP
• Created database objects like Tables, Views, Stored Procedures and Indexes etc.
• Wrote various Stored Procedures for the purpose of application development
• Created SSIS packages to import and export data from the excel spreadsheets and flat files
• Created packages and scheduled jobs to perform filtering operations and import data on a weekly basis
• Transformed data from various data sources using OLEDB and ADONET connection and file manager by creating SSIS packages for different tasks
• Responsible for database creation, database tuning, performance planning and database administration
• Performed some DBA tasks which included checking the job fails and troubleshooting the issues
• Worked as an IT production support technician, to help the end users in solving production problems
• Involved in planning and administration of data migration and performance tuning to achieve cost efficiency and effectiveness of the system
• Worked directly with the business teams to resolve issues and perform special requests such as reports and communicated the changes to the application
• Prepared the detailed project layout, analyzed the existing technology involved and documented the work performed

Environment: SQL server 2005 Enterprise Edition, SQL Server Integration Services (SSIS)