SUMMARY:

• Hard - working Software Engineer with a flair for creating elegant solutions in the least amount of time.
• 10+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server applications.
• Involved in all the stages of Software Development Life Cycle involving Analysis, Design, Implementation & Development, Testing, Maintenance of various Web-Based and Desktop applications in C#.net, ASP.Net and ADO.Net
• Applied domain driven methodology for application development in C#, and ASP.Net, Visual Studio 2010/2012 and MVC 4.0 framework
• Strong technical knowledge in MS SQL Server development including Integration Services, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases, Troubleshooting.
• Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization, Proficient in creating Transact-SQL (DDL, DML, DCL and TCL), Indexes, Views, Table Variables, Complex Stored Procedures, User and System defined functions.
• Experienced in creating indexed views, complex stored procedures, triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Expert database designer, fluent in all aspects of database development, including design, normalization and optimization.
• Adept in installation, upgrade, troubleshooting and configuration of MS SQL Server 2008/2005.
• Experience in HTML, DHTML, CSS, JavaScript, Ajax, JQuery, XML/SOAP, Web Services, IIS, VBA

PROFESSIONAL EXPERIENCE:

Full Stack Developer

Confidential, Auburn Hills

• Full stack web developer responsible for end-to-end web app development and real data engineering.
• Prototyped an average of 5 new product features in six months.
• Coordinated core server product development and data feed to 10+ client sites, ensuring compatibility and security.
• Build own BI portal for financial data sensitive reports.
• Develop data connections through SSIS packages on various schedules.

Senior Systems Analyst

Confidential - Auburn Hills MI

• Lead developer of a web-based license management tool.
• Drove best practice implementation across multiple departments. Decreased costs by 35%.
• Boosted user experience scores by 55% over company-wide previous best.
• Serve as a technological resource the Management Reporting, Application Support, and .NET Developer teams
• Actively developed custom interactive web portal using Visual Basic, SQL scripts, and SQL. Extracting data from many sources, including SQL Server, outlook mails, MS Excel, and flat files.
• Regularly generated default and custom SQL reports for clients.
• Implemented and released developed software, ensuring a smooth and successful transition, while maintaining the stability and integrity of the application.
• In addition to my regular development duties, I coordinated offshore development resources associated with the project delivery, including:
• Participating in front-end status meetings with clients to give and receive project updates, understand current priorities, resolve project issues, and prepare for future projects.
• Conducting regular status meetings with team members to measure team progress and make plan adjustments as necessary.
• Gathering solution requirements, creating functional and detailed design documents, and delivering to offshore team.
• Overseeing quality of team output to final release, including technical design documents, pre-release testing, release documentation, and post-release bug fix management.
• Conducted pre-release testing to insure quality and verify completion against requirements.
• Provided periodic updates to executive sponsors, highlighting milestones and addressing any issues which may cause delays.

Application& Architecture Analyst

Confidential - Auburn Hills MI

• Web based portal that served material information centrally to whole engineering. Developed using .NET C# Framework 4 and SQL 2012.
• Developed algorithms to convert data from various engineering applications sources to SQL format.
• Developed custom database maintenance scripts for performing database Integrity checks, updating database statistics, re-indexing, nightly full backups and transaction log backups. This involves database maintenance on both production and development sites.
• Deployed and packaged the application in production environment.
• Developed portal for publishing reports and sharing models among group using C# Framework 4.
• Managed and coordinate user access using LDAP.

Systems Analyst

Confidential

• Convert thick client written in JAVA to 3 tiers with back end in SQL 2005.
• Developed backup restore scripts for SQL Server as needed.
• Upgraded SQL Server databases to latest version 2005 from SQL server 2000.
• Involved in database maintenance plan and Implemented replication.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in Performance tuning and Query Optimization.
• Managed and coordinate with remote user for change request and optimization of application.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• In-depth working knowledge of ODBC.
• Created many complex stored procedures/functions and used them to generate reports on the fly.

Associate Systems Analyst

Confidential

• Designed and developed the system using VB.NET, SOAP to integrate different environment.
• Use SAS Compare PcCharge-XML to Everest-Recordset and display any mismatch at either end, with any additional entry. And at the end match the amount.
• Managing large output files as XML for transferring data to SQL.
• Automate procedure to run comparison analysis.
• Maintained both development and production servers in sync, and implemented backup policies for databases.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Implemented SQL Server Log Shipping on the Development Server.
• Created documentation for error resolving fixtures.

Environment: MS SQL Server 2005, T-SQL, XML, HTML, Web Services, Visual Studio 2008