Imej profil abhiavsagar
@abhiavsagar
Penanda India Ghaziabad, India
Ahli semenjak 1 Mac 2008
0 Cadangan

abhiavsagar

Dalam Talian Luar Talian
Abhinav Sagar +91-9650028166 PROFILE Technical Analyst with 7+ year experience in problem-solving, leadership, implementation and development of complex software systems. Successfully managed projects on various technical platforms and in different functional domains. • Worked for both Development and Maintenance software projects. • Domains: Finance, Inventory control, Human resources, Service. • Successfully managed onsite-offshore model for various projects. PROFESSIONAL SUMMARY - BI DEVELOPER: • Over 7 years of SQL Server Development experience in SQL Server 2000/2005/2008 R2 with an emphasis on design, development, enhancement, and automation, tuning and optimizing databases for high Availability, Performance and Security. • Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profiler • Experience in supporting web based, mission critical applications including Logical and Physical Database Design, Development, Performance Tuning and Change Management • Experience in using Audit functions and extensively used exception handling for catching and reporting errors • Experience in data warehousing including business intelligence tools- DTS, SSIS and SSRS. • Very Good Experience in BI Development (SSRS, SSIS) • Extensive knowledge and experience in developing scripts using T-SQL for querying against databases • Expertise in implementing business logic using Triggers, Views and Stored Procedures. • Proficient at Performance Tuning with a solid knowledge of Optimizing Code • Experience in data normalization and de-normalization. • Experience with SQL Server Security and SQL Server Auditing. • Very Strong on tools such as Visio, TFS and have full understanding of the Software Development Life Cycle. • Working knowledge of .Net Framework 3.5 (VB.NET and C#.NET), IIS Web Server. • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player TECHNICAL EXPERIENCE: Languages T-SQL, PL/SQL, C#, HTML RDBMS MS SQL Server 2000/2005/2008/2012, MS Access Database Tools SSRS, SSIS, SSAS, DTS, BCP, Business Intelligence Studio, Query Analyzer, SQL Server profiler, Enterprise Manager Operating Systems Windows 98/2000/XP/NT/Vista, Windows 2000/2003/2008 Advanced Servers Architecture Relational DBMS, Client-Server Architecture, OLTP, OLAP Version control Tools TFS, Visual Source Safe Other Tools Reporting Services, Crystal Reports, Microsoft Visual Studio 2003/2005/2008 PROJECT EXPERIENCE: Project Title: WTRIS Retirement plans Client: Wilmington Trust Duration: Jul- 2013 to till date Position: Technical Analyst Roles and Responsibilities: Wilmington Trust Fiduciary Services Company provides quality trust and investment services for all types of qualified and non-qualified retirement plans. We are developing applications that will take care of all business need of client as state through processing. • Feasibility study and Proof of Concept (POC) Implementations of the User Stories • Creating technical specification documents for the User Stories • Data Analysis and Parsing • Database designing and development • Writing business logics through complex stored procedures, creating tables and indexes • Designing & creating SSIS packages • Designing & developing SSRS Reports • Deployment & Scheduling SSIS Packages • Deployment & Scheduling SSRS Reports • Troubleshooting peer's work in case of issues • Unit testing • Presenting live demos of the application to the business • Knowledge transitions to the other team members Technology: SQL Server 2008 R2, T-SQL, SSIS, SSRS, .Net, MVC, Jason Project Title: Kenexa Recruitment tool Client: Kenexa Brassring Duration: Jan- 2013 to Jun-2013 Position: Senior Software Engineer Roles and Responsibilities: Implementation of HR recruitment tool Kenexa with existing company recruiting module. • Feasibility study and Proof of Concept (POC) Implementations • Creating technical specification documents • Data Analysis and Parsing • Database designing and development • Writing business logics through complex stored procedures, creating tables and indexes. • Designing & creating SSIS packages. • Troubleshooting peer's work in case of issues • Unit testing • Knowledge transitions to the other team members Technology: SQL Server 2008 R2, T-SQL, SSIS, SSRS, .Net Project Title: Deployment Allowance tool Client: HCL Duration: Nov- 2011 to Dec-2012 Position: Senior Software Engineer Roles and Responsibilities: Developed a tool Deployment Allowance for company resource pool management. • Data Analysis and Parsing • Database designing and development • Writing business logics through complex stored procedures, creating tables and indexes • Troubleshooting peer's work in case of issues • Unit testing • Knowledge transitions to the other team members Technology: SQL Server 2008 R2, T-SQL, .Net Project Title: SWS-AM (Inventory Module) Client: Sumitomo Wiring Systems Ltd., Japan Duration: Mar- 2011 to Oct-2011 Position: Software Engineer Roles and Responsibilities: ERP system for Automobile industry. Developed module to automate the inventory management of industry. • Data Analysis and Parsing • Database designing and development • Writing business logics through complex stored procedures, creating tables and indexes • Troubleshooting peer's work in case of issues • Unit testing • Knowledge transitions to the other team members Technology: SQL Server 2008 R2, T-SQL, .Net Project Title: Barista LavAzza Website Client: Barista, India Duration: Aug- 2010 to Feb-2011 Position: Team Lead Roles and Responsibilities: Developed dynamic web application, Facebook application and CMS of the website. • Requirement Elicitation and feasibility study of the project • Defining and monitoring project scope and timelines • Segregating roles and responsibilities of the team and allocating tasks • Application Architecture Designing • Creating functional specification documents • Creating technical specification documents • Database designing and development • Writing business logics through complex stored procedures, creating tables and indexes • Troubleshooting peer's work in case of issues • Reviewing project process • Presenting live demos of the application to the business • Knowledge transitions to the other team members Technology: C#, ASP .NET 3.5, Sql-Server-2008 Project Title: Whirlpool India Client: Whirlpool India Pvt. Ltd. Duration: Mar- 2009 to Feb-2011 Position: Team Lead Roles and Responsibilities: Developed marketing web site as well as HR Portal with different application regarding HRA of Whirlpool India. • Requirement Elicitation and feasibility study of the project • Defining and monitoring project scope and timelines • Segregating roles and responsibilities of the team and allocating tasks • Application Architecture Designing • Creating functional specification documents • Creating technical specification documents • Database designing and development • Writing business logics through complex stored procedures, creating tables and indexes • Troubleshooting peer's work in case of issues • Reviewing project process • Presenting live demos of the application to the business • Knowledge transitions to the other team members Technology: C#, ASP .NET, Sql-Server-2005 Project Title: Call center Sales Automation Client: Sarthak Duration: Apr- 2008 to Nov-2008 Position: Developer Roles and Responsibilities: Sales automation (SA) is a Web application that automates business tasks such, sales processing, and tracking of customer interactions, as well as analyzing sales forecasts and performance. • Database development • Application architecture design • Coding. Technology: C#, ASP .NET 2.0, PL-SQL PROFESSIONAL QUALIFICATION: • Completed Masters in Computer Application (M.C.A) in 2007 from Jaypee Institute of Information Technology University, Noida. • Completed Bachelor of Computer Application (B.C.A) in 2003 from Academy of Business Management, Ghaziabad affiliated to CCS University.
$7 USD/hr
0 ulasan
0.0
  • N/AKerja Diselesai
  • N/AMengikut Bajet
  • N/ATepat Pada Masa
  • N/AKadar Ulang Upah

Portfolios

Ulasan Terkini

Tiada ulasan.

Pengesahan

  • Facebook Disambung
  • Freelancer Keutamaan
  • Bayaran Disahkan
  • Telefon Disahkan
  • Identiti Disahkan
  • E-mel Disahkan

Cari Freelancer yang serupa