SUMMARY:

• Currently working as Sr. Apps Developer - Robotic Process Automation - Automating various Business Process using UiPath.
• Sr. IT Database Analyst, Developing SSIS packages, SSRS reports, T-SQL, Stored Procedures in SQL closely working with IT Architect, Business Stakeholders via Agile Methodologies.
• Worked as Technical Consultant within a HR Software Implementation Services Team. Responsible for various backend related tasks including data maintenance, data imports and exports using SSIS packages, custom reports via SQL Stored Procedure, custom eforms, T-SQL statements for various custom data extraction, project scoping and estimation.
• Leadership skills as a Product Engineer within a HR Software Product Engineering Team as needed at the time of product upgrade specifically teaching other team members on how to perform legacy field migration in preparation for product upgrade. Extensive knowledge on Migration Process.
• Cross Product Training while working both as Implementation Engineer and as Implementation Associate.
• Experience in performing System testing, User Acceptance testing, End User testing, Functional testing, Integration Testing, GUI, Automation, Database testing with QA cycle - from testing, defect logging and verification of fixed bugs.
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments. Identifying business needs and providing support to development team to formulate functional design and specifications. Understanding of cross-platform cross-browser compatibility issues and code optimization.
• At ease using Mac OS, Windows and UNIX operating systems
• Flexible in a team-oriented environment and contribute effectively as a problem-solver/ resolution for the any issues in the implementation team. Attend meetings with business team and ability to prioritize tasks along with effective communication, project management and problem solving skills.
• Can lead and motivate geographically dispersed online teams.
• Excellent communication, analytical, interpersonal, problem solving, and presentation skills.
• Experience in Datawarehouse Projects - SSIS, SSRS, MS Visual Studio, TFS

TECHNICAL SKILLS:

Languages: C++, C#, Java, XML, XSLT, JavaScript, HTML, CSS, SQL, Transact-SQL, PL/SQL

Software: Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)

Graphics: Homesite, DreamWeaver, Adobe Acrobat, Photoshop

Databases: SQL SERVER 2005/2008/2014, ACCESS DB.

BI Tools: SSRS, SSIS, Power BI, MS Visual Studio 2013

RPA Tool: Uipath

Source Code Management Tool: Team Foundation Server

Integration Tool: Redgate

Application: MS Office, MS Outlook, MS OneNote

Project Tracking Tool: JIRA, Salesforce

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Apps Developer

Responsibilities:

• Projects Handled using Agile Technology - working closely with Product owner, Scrum Master and Scrum Team Members
• Provide leadership and technical expertise to a team of analyst as it relates processes automations and productivity
• Keep the project manager informed of the overall status of the solution
• Conduct code and process reviews to ensure the highest level of quality
• An ability to create automation architecture and solution proposals
• An ability to develop RPA prototypes and Proofs of Concept
• Report Generation for Robot Activity.

Confidential

Sr. IT Database Analyst

Responsibilities:

• Projects Handled using Agile Technology - working closely with Product owner, Scrum Master and Scrum Team Members
• Data Load via SSIS package. Currently Involved in CRM and Mulesoft Data for the company
• Handling various Business Related Reports - HR Report, Executive Dashboard Report via SSRS.
• Writing Optimized SQL Stored Procedure for various types of Reports and Data Load
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions in SQL Server

Confidential

Technical Consultant

Responsibilities:

• Understand Requirement, Analyzing Systems and Source Databases. Writing Complex Queries, Stored Procedures, and Optimizing custom reports; debug existing stored procedures. Designing of Parameterize Reports with conditional formatting, sorting, running totals, variables, collections/arrays, groups, group selection, and summary reports
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures.
• Have created Datamart to pull large set of Data. Optimized Custom Report to pull data from created Datamart.
• Testing and Performance Tuning of reports in order to reduce the execution time required for generating these reports and thereby improving the overall speed of execution and performance of the reports
• Analysis of existing process to enhance the process, standards, and procedures.
• Validated technical designs created by IT developers against functional specifications.
• Manage other issues together with the customer in related business areas and functions, facilitate and follow-up needed IT work.
• Responsible for making the team to have complete understanding about the system and client requirements
• Analyzing the critical problem and providing the appropriate solutions to the team members.
• Maintain Project Proceedings/Updates in JIRA

Confidential

Product Engineer

Responsibilities:

• Coordinated all upgrades and support work on existing applications
• Coordinated with client customization.
• Define and analyze functional business requirements with customers and testing process for the project.
• Planned and worked intensively together with the customer as needed to secure successful support/maintenance and further development of the applications.
• Assist the development team in analyzing, translating, and documenting technical requirements.
• Perform technical problem detection and problem resolution.
• Lead meetings, drive discovery, and manage project timelines and customer expectations.

Confidential

Implementation Engineer

Responsibilities:

• Quickly applied my expertise in learning how to process eforms, reports, and troubleshooting the career site template issues. Good Understanding of the database and applied logic and patience to study a problem and arrive at a resolution. Created reports using various tables, views and T-SQL
• Experience in using Business Intelligence tool SSIS. Developed SSIS packages to populate data from various data sources.
• Handled lengthier projects along with day-to-day assignments and planned projects with exemplary time management. Coordinated with client customization.
• Define and analyze functional business requirements with customers and testing process for the project. Planned and worked intensively together with the customer as needed to secure successful support/maintenance and further development of the applications.

Confidential

Web Developer/Programmer

Responsibilities:

• Develop and document supporting business process information for purposes of decision-making, consistency, and alignment.
• Updated and maintained websites using HomeSite, DreamWeaver
• Coded HTML, CSS and Javascript for various microsites
• Provided IT support for staff members
• Understanding of HTML, image formats, browser capabilities and back-end integration issues