SUMMARY:

• Extensive data centric application development and architect experience of using ASP.Net 4.0, NET languages and the .NET libraries, VB6, SQL Server, MS BIDS, LINQ, with team leadership and mentoring experience. Expertise in writing SQL procedures, Database Designing, performance tuning, optimization, SQL profiler, perfMon, Functions, Triggers, and Performance Tuning.
• As a System Analyst, Senior Software Engineer and software developer on Object oriented (OOPS) design and development, database programming, web programming and GUI development using C#, ASP.NET, AJAX, HTML, SQL Server, Oracle, Visual Source Safe.
• Proven experience in project and team leading with minimal defect delivery. Equally comfortable working independently as well as in a team environment
• Excellent written, communication, interpersonal skills.
• Good Knowledge in designing, coding and manual testing with Demonstrated record of high performance standards, including attention to schedules, deadlines, budgets and quality work.
• Innovative, self - motivated, with proven analytical abilities and organizational skills.
• Experience writing functional/technical documents e.g. specifications, design, unit test, release doc etc. Translated complicated enterprise specific business rules and procedures into appropriate business logic components such as code libraries, stored procedures and security models

TECHNICAL SKILLS:

Databases: SQL SERVER 2008/2012/2014, MS-Access, Oracle, DB2 and MY SQL

Core Programming: VB6, C#, VB.Net, SQL, HTML, JavaScript, XML,SOAP & T- SQL

Operating System: Windows 2008/2012 R2 Advanced Server, NT & Windows 9x, Linux

Tools: SQL profiler, PerfMon,Backup Utility, TOAD, SQL-Oracle Developer, PL-SQL Developer

Technologies and Frameworks: .Net Framework (3.5,4.0,4.5),LINQ, ADO.Net, SSRS, SSIS,SSAS

PROFESSIONAL EXPERIENCE:

Confidential, Florham Park, NJ

Sr. BIDS/Database Architect/Developer

Responsibilities:

• Analysis function and non-functional requirement.
• Working on enrollment module which allows user to enter personal detail, health and drug related information using C# and client side web technologies like JavaScript and jQuery.
• Plan, design and implement application database code objects, such as stored procedures and views.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different database.
• Integrated and transformed data from different data sources like Oracle, DB2, Excel and Flat Files to SQL Server 2208 using OLE DB connection providers by creating various SSIS packages.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement &using the TOP operator to limit the select statement in certain queries.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Confidential, New York, NY

Sr. BIDS/Database Architect/Developer/Team Lead

Responsibilities:

• Develop data-cubes and trend company KPI’s. Redesigned database driven asp.net web application.
• Prepare software requirement documentation by analyzing and validating functional and non -functional requirements.
• Hands-on development manager involved with development, system architecture, technology strategy, hiring, mentoring and performance appraisals.
• Worked on optimization SQL Server performance, monitoring, and queries tuning using Microsoft tools performance Monitor.
• Except in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Collaborated with internal and external users to determine requirements and negotiated with stakeholders to resolve conflicting system needs.
• Redesigned the application data model to support multiple platforms, resulting in greater efficiency, versatility and interoperability.
• Designed and implemented business layer and data access layer using C# 4.0 advance features such as Delegate, Entity Framework. LINQ.
• Translated solution by understanding and elaborating on high level business requirements.
• Prepare use cases and design models, conceptual design, analysis, development and testing following agile methodology.

Confidential, Jersey City, New Jersey

Sr. SQL Architect/Developer

Responsibilities:

• Use Team Foundation Server for maintaining code repository. Team plain tool usage to customize the process for the individual implementations of agile software development practices.
• Develop projects using C#, SQL, JavaScript and jQuery, CSS, HTML, and LINQ.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database and Defined constraints, rules, indexes and views based on business requirements. Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.

Confidential, Newark, New Jersey

Sr. BIDS/Database Architect/Developer/Team Lead

Responsibilities:

• Designed and deployed SSIS packages, Multi-Dimensional OLAP CUBE implementing performance tuning.
• Responsible for architecting and developing core using C#, SQL, JavaScript and jQuery, CSS, HTML, LINQ.
• Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.
• Highly proficient in using T SQL for developing complex stored procedures, Triggers, Index, Views, User Functions, SQL Joints, Relational Database Systems following Data Integrity and normalization.
• Provided full lifecycle development and support for custom application and user interface (UI) design from initial requirements gathering to testing and implementation.
• Organized events, developed cases, wrote rules, prepared data monitors and dashboards.
• Responsible for all phases with Data Warehouse development including data modelling, analysis, design, development, testing and documentation.
• Created ER diagram, database design and demonstrated business process modelling and requirement definition into it.
• Implemented OLAP cube and connecting using Excel PowerPivot.

Confidential, Parsippany, New Jersey

Sr. Database Developer

Responsibilities:

• Worked on database driven ASP.Net based application using C# 4.0, CSS, HTML LINQ and SQL Server 2008
• Extensive use of threading to pre-fetch data in anticipation of the user’s next move.
• Developed Reports for Financial Application using SQL Server Reporting Services (SSRS).
• Database design, stored procedure development, SSIS development, reporting services development Generated.
• Reports as Users Requirements using SQL Server Reporting Services (Report Builder 3.0).

Confidential

.Net/SQL Architect/Team Lead/Developer (Permanent)

Responsibilities:

• Collaborated with client, end users and developers and ensured technical requirements are thorough using standard tools and modeling techniques.
• Mentor internal developers and prepared and organized for end users.
• Established solid working relations with open communications with customer and business via meetings and interviews.
• Developed a data capture application (C#/ VB.Net, asp.net, LINQ) for health care project to enable them to capture and centrally store information from Foundation Trusts about the hospitals within those trusts that provide services.