Data Analyst Sql Developer
Resume:
SACHIN GUPTA
Email: ******.******@*****.**.**
EXPERIENCE SUMMARY
** ***** ** ************ ********** in software systems analysis, design, and development using Microsoft Technologies.
Good exposure to each of the phases of Software Development Life Cycle (SDLC). Develop projects from stage of concept to full implementation.
17 Experience of working in Agile methodology
12 Years of experience of working with the client (end user) directly.
14 years of experience in onshore and offshore model with different geographical area.
10 years of experience of handing the team both offshore and onshore.
Knowledge of AWS Cloud infrastructure.
knowledge of Node.Js and Java.
Professional in TIBCO Active-Matrix Business Works.
Experience of application support and maintenance of on-Prem and Cloud based application and database systems.
18 years of experience in working on MS-SQL,MySQL database, writing complex Stored Procedure, Triggers, SQL queries, functions & solving complex issues related to data.
8 Years of experience working in MySQL database system on AWS Cloud, writing complex SQL queries to solve the business issues related to data.
4 years of working in Oracle SQL and Presto,postgres with powerBI.
6 years of experience in Data Migration using MS-SQL Oracle and MySQL with AWS DMS.
Knowledge about Hadoop and Big Data.
Knowledge about No-SQL db system.
10 years of experience of working in Active Batch and ETL processes.
14 Years of experience in various BI tools like SSRS, PowerBI, Spotfire, CrystalReports.
A keen analyst and team player with thorough understanding of all aspects of the SDLC from understanding client requirements through direct client interaction, translating them into technical specifications and driving their execution.
Having exposure in Python programming.
Experience of working in various defect logging tools like JIRA and Mercury Quality Centre.
Experience of working in Test automation tool like Test Complete and Selenium.
Experience of working on VS.NET 1.1/ 2.0/ 3.5/4.0, ASP.NET, C#.NET, VB.NET, Windows Form, ADO.NET, MS SQL Server 2000/ 2005/2008/2012, Web Service, WCF, LINQ, Oracle PL SQL, XML, and XSLT, XSD, AngularJs. SSRS, TIBCO BW, TIBCO Spotfire, MS-CRM, AWS, DMS. Active Bartch. Node.JS, PowerBI.
Experience of using source control tools ClearCase, VSS, Team System Foundation, Git, SVN.
Experience of working in designing ad modelling tool like UML, ERWin and Visio.
Knowledge of Manufacturing, Inventory, Aviation, HR, Payroll, and Procurement, Finance domain.
EDUCATIONAL QUALIFICATION
Master of Computer Application (MCA) from Rajiv Gandhi Prodyogiki Vishwavidhyalaya Bhopal MP 8ndia (08/01/2002-03/30/2006)
Bachelor of Computer application (BCA) from Devi Ahilya Vishwavidhyalaya Indore MP India (07/01/1999-07/18/2002)
TECHNICAL SKILLS
Operating Systems
Windows XP, Windows Server 2003-2019, Windows 7 -11
Documentation and designing Tools
Mercury Quality Center, Build Forge, Team Foundation, e-JIRA, Confluence, Share-point. ER-Win, UML, Visio, Share point, MS-Project.
Source Control Tool
ClearCase, Visual SourceSafe, system. Git, SVN.
Software Development Tool &Technologies
Visual Studio.NET, ASP.NET, XML, XSD, XSLT, LINQ, PL/SQL, C#.NET, VB.NET, ADO.NET, Enterprise Library, Windows Forms, Java, Angular JS, MVC, Entity Framework, Infragistics Grid Control, TOAD, SQL Developer, Bootstrap. DBeaver, MS-Studio. Node JS, Python.
Database
MS SQL Server, Oracle PL-SQL, MySQL, Presto.
Integration Tools
TIBCO Active-Matrix Business Works.
Reporting Tools
Crustal Report, SSRS, TIBCO Spotfire, Power BI.
Motoring Tool
Grafana, New-Relic, Splunk, Cloud Watch.
Cloud
AWS (EC2, S3, EBS, Cloud watch, DMS)
EXPERIENCE
Synechron Inc. USA Jan 2013 till the date
1. Project: Subscriber Billing
Client: Asurion
Role: Software Developer
Responsibilities:
Analysis of the requirement, architectural designing and implementation of the application.
Analysis and fixing the existing defects.
Responsible for functional and technical knowledge transfer to new team members.
Documenting system enhancements and maintaining repository.
Application development using different tools and technologies like Tibco Active Matrix, VS.Net, Java.
Developed reports using SSRS and PowerBI with Presto, Hive, MS-SQL and MySQL.
Developing alerts using Grafana and NewRelic.
Designed the architecture of Data Migration from old legacy system to new Cloud based infrastructure
Designed and developed Web based application using VS.Net.
Designed and developed the functionality processing of data file and loading them in to DB system using MSSQL.
Responsible of documentation of the application and supporting QAs.
Fixing application defects of Java application and monitoring the issue in cloud watch and Grafana.
Providing the solution to end user of their queries.
Developing functionality using MS-CRM and Tibco business works.
Environment: TIBCO Active-Matrix Business Works 5.11, Dot NET 3.5,4.0, MS SQL Server 2012, Aurora MySQL, Oracle, XML, SSRS, Spotfire, Angular Js, Java, MS-CRM, AWS, Java, Active batch, AWS-DMS, AWS-S3, MS-PowerBI, Presto, Postgres, SSIS.
Synechron Technologies Pvt. Ltd., Pune Nov’10 till Jan 2013
1. Project: Subscriber Billing
Client: Asurion
Role: Developer
Responsibilities:
Analysis of the requirement gathering and implementing the functionality.
Analysis and fixing the existing defects.
Responsible for functional and technical knowledge transfer to new team members.
Documenting system enhancements and maintaining repository.
Responsible of developing Web based application using VS.Net.
Developed reports for monitoring the day to transactions and data using SSRS.
Responsible of developing the processing of data file and loading them in to DB system using MSSQL.
Environment: TIBCO Active Matrix BusinessWorks 5.7, Dot NET 3.5, MS SQL Server 2008, XML, SSRS.
Capgemini, Mumbai Dec’07 to Oct’10
1. Project: Cross-Road, Dispatch System, Case Management & Operational Check Automation
Client : Netjets Inc., USA
Rôle: Developer
Responsibilities:
Requirement gathering, analysis, development, Unit testing, and Integration testing of new functionalities/ enhancements in the application.
Application Support and mentoring the team.
Fixed the existing defects using VB.net and Java.
Documented system enhancements, and maintained repository.
Responsible for functional and technical knowledge transfer to new team members.
Created and circulated daily-project reports and bug reports and bug fixing.
Environment: Visual Studio.NET 3.5, Windows Form, VB.net, ASP.Net, Java, WebSphere Application Server 6.0, Oracle 10g, Infragistics Grid Control, Mercury Quality Center, Mercury ClearCase 6.1
Xpanxion International, Pune May’07 to Dec’07
1. Project: Application Automation
Client: Xpanxion International
Role: Developer
Responsibilities:
Requirement gathering, analysis, unit test cases, development, and unit testing.
Wrote automated application test script.
Participated in functional and technical knowledge transfer to new team members.
Provide training to Quality Assurance engineer.
Environment: Visual Studio.NET 2.0, WINForm, C#.NET
2. Project: Digital Downloads
Client: Music Today
Role: Developer
Responsibilities:
Requirement gathering, analysis, development, Unit testing, and Integration testing of new functionality/ enhancements in the application.
Documented system enhancements, and maintained repository.
Database Design.
Writing SQL Procedure.
Environment: Visual Studio.NET 2.0, ASP.NET 2.0, ADO.NET, MS SQL Server 2005, VSS, C#.NET, FxCop
Artech Infosystem, Noida Mar’07 to May’07
1. Project: WCS UK Finance Report Application
Client: ABN AMRO Bank
Role: Developer
Responsibilities:
Responsible for issue analysis and application support.
Provided database support.
Monitoring ETL processed and updating/enhancing the existing processes
Involved in functional and technical knowledge transfer to new team members.
Wrote queries to resolve any database issue.
Analyzed the reports generated by the other systems.
Environment: Visual Studio.NET 2.0, ASP.NET, C#.NET, MS SQL Server 2000
Synise Technologies Ltd. Pune Jun’06 to Mar’07
1. Project: HRPortal
Client: Bharat Forge Ltd., Pune
Role: Developer
Responsibilities:
Requirement gathering, analysis, development, Unit testing, and Integration testing of new functionality/ enhancements in the application.
Documentation of system enhancements, and maintained repository.
Wrote queries, and created procedures and database table.
Worked on large database system of SAP.
Environment: Visual Studio.NET 2.0, ASP.NET, ADO.NET, C#.NET, Oracle 8i
2. Project: Material Ordering System
Client: Hindustan Unilever Ltd., Mumbai
Role: Developer
Responsibilities:
Participated in requirement gathering, analysis, Design development, and Unit testing.
Documented system enhancements, and maintained repository.
Writing queries, stored procedures and database table.
Environment: Visual Studio.NET 2.0, ASP.NET, ADO.NET, VB.NET, MS SQL Server 2005, Crystal Report 8.0
3. Project: MROSys
Client: India Engineering, Pune
Role: Developer
Responsibilities:
Participated in requirement gathering, analysis, Design, development, and Unit testing.
Documented system enhancements, and maintained repository.
Writing queries, Stored procedure and database table.
Created report using Crystal Report.
Environment: Visual Studio.NET 2.0, ASP.NET, ADO.NET, VB.NET, MS SQL Server 2005
IPER Business Solution, Bhopal Jun’04 to Apr’06
1. Project: ADIVO
Client: Rihana Thomos and Tony
Role: Developer
Responsibilities:
Participated in requirement gathering, analysis, unit test cases, development, and unit testing.
Wrote application automation test script.
Participated in functional and technical knowledge transfer to new team members.
Environment: Visual Studio.NET 1.1, ASP.NET 1.1, VB.NET, MySQL.
2. Project: Vision Optimizer
Client: Vision Infinity Pvt. Ltd., Bhopal
Role: Developer
Responsibilities:
Participated in requirement gathering, analysis, unit test cases, development, and unit testing.
Wrote application automation test script.
Participated in functional and technical knowledge transfer to new team members.
Writing complex stored procedure.
Environment: Visual Studio.NET 1.1, ASP.NET 1.1, C#.NET, MS SQL Server 2000
3. Project: Arushi Survey Report Generating System
Client: Arushi (NGO), Bhopal
Role: Developer
Responsibilities:
Participated in requirement gathering, analysis, unit test cases, development, and unit testing.
Wrote application automation test script.
Participated in functional and technical knowledge transfer to new team members.
Writing SQL queries.
Environment: Visual Studio 6.0, Oracle 8, Crystal Report
4. Project: Resource Monitoring System
Client: IBS Bhopal
Role: Developer
Responsibilities:
Participated in requirement gathering, analysis, unit test cases, development, and unit testing.
Wrote application automation test script.
Participated in functional and technical knowledge transfer to new team members.
Environment: Visual Studio.NET 1.1, ASP.NET 1.1, C#.NET, Oracle 8.0
5. Project: Store Inventory System
Client: Central Ground Water Board
Role: Developer
Responsibilities:
Participated in requirement gathering, analysis, unit test cases, development, and unit testing.
Wrote application automation test script.
Participated in functional and technical knowledge transfer to new team members.
Database design and writing stored procedure.
Environment: Visual Studio.NET 1.1, ASP.NET 1.1, VB.NET, Oracle 8i
Contact this candidate