OBJECTIVE

• Detail - oriented, innovative and efficient IT Specialist seeking a position to utilize my extensive knowledge and successful experience in a position offering opportunities for personal contribution and professional growth.

SUMMARY

• 13+ years of experience in the field of IT as System Analysis, Design and Development and System Administration.
• Strong abilities in Database Design, Normalization, T-SQL, PL/SQL, Store Procedure, Functions and Triggers
• Motivated self-starter who thrives on a challenge and enjoys working in a fast-paced team environment.
• Experienced in Query Optimization and performance tuning of stored procedures, functions etc
• Analyzed test results, evaluate risks, and provided recommendations to solve problem
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data model development
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) and Crystal report
• Hands on experience in developing Cube, Dimension, Snow flakes Schema for Dataware House
• Working experience on Azure technology
• Worked with business users to gather requirements of end products and provide continued user support
• Analyzed, Developed, Implemented and Integrated HRMS, Payroll, Time Attendance System and TDS System.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Provided user Training and guidance for the new products
• In depth knowledge of ERP (Movex - Intentia International), ERP flow and data Model based on AS400 and DB2.
• Provided extensive support for modules like Planning, Sales, Purchase, Manufacturing and Accounts.
• Participated in go-live project of implementation of new ERP product
• Ability to effectively and efficiently in tight deadline.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2008/2008R 2/2012/2014/2016/2017, DB2, Oracle

SQL Tools: Power BI, SSAS, SSRS, SSIS, SSMS, SSMA, SSDT, BIDS, PL/SQL, T-SQL

Development Tools: MS Visual Studio, Visual Studio .Net, Team Foundation Server, VS Code, Git

Office Tools: Microsoft Word, Excel, Power Point, Visio, Project

Web tools: HTML, CSS, VB Script, XML, JavaScript

Programming Language: C#, .Net, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Developed Reports in SSRS with different type of properties like Chart controls, filters
• Expertise in SQL - including functions, stored procedures, and views
• Hands on experience in Shell Scripting
• Generated Matrix, Parameterized/drilldown reports in SSRS and Crystal Reports
• Developed, Integrated and Deployed Payroll and TDS System, HRMS and other.
• Transferred COBOL Systems Data to SQL Server for Payroll and TDS System
• Migrated master data from MRP2 data to DB2 for new ERP
• Developing SSRS reports for Web Fleet Assistance System
• Provided effective and timely resolution of a range of end users queries
• Ensure Database performance, scalability, security and reliability.
• Design coding and naming standard for developing Store Procedures, Functional, Indexes, and Constraints
• Documenting Database processes and automation jobs.
• Designed Dashboard KPI using Power BI.
• Developed Advanced Reporting Architecture using SSAS, SSIS and SSRS.

Confidential

SQL Database Administrator

Responsibilities:

• Work with programming team on system development, implementation, testing and trouble shooting of systems.
• Provide development for new or existing database queries or modifications during the product life cycle
• Analyze the database schema involved and develop approach for accessing and updating data
• Manage and execute capacity planning, performance tuning, monitoring, troubleshooting and optimization of the databases
• Perform proactive analysis of platform data (e.g., disk utilization, system load, etc.), to predict overloads or failures and correct these problems ahead of time
• Troubleshoot database issues and perform database impact analysis for proposed changes
• Design data structures and indexing strategies
• Write high performance SQL queries and stored procedures
• Developed powershell scripts for setup automation
• Installation of new servers and upgrading existing server instances as required, Administration and Maintenance of SQL Server Instances.
• Setup High-Availability, Always-on Server as part Disaster Recovery Strategy for the Databases.
• Managing storage environments for SQL data, logs and backups including optimization, monitoring space and providing growth statistics
• Performing day to day operations like database upgrade, applying database change logs to various customer sites, Maintaining Schedule Jobs, Backup and restore databases.
• Designed Architecture for ETL Process using SSIS to and from transferring Customer Application Data to Confidential Application and vice versa.
• Developed SSIS Process for Extracting Data, Transforming and Loading from various source like ORACLE PL/SQL, Flat File, EXCEL File, DB2 etc.
• Developed Advanced Reporting cubes using SSAS also designed architecture for advanced reporting for Fleet Assistance
• Monitoring and Performance tuning, Query Optimization and tuning.
• Created general coding standards and best practices documentation
• Promote changes via established IT change control procedures.
• Assist with the maintenance of test, development and staging database environments.
• Documenting technical design templates, provided Security guidelines and considerations and Database environment
• Designing the Report development policies and standards
• Development SSRS Report, Maintenance and development of Databases.
• Coordinate with business units to perform database programming based on project requirements

Confidential

Programmer

Responsibilities:

• Developing adhoc reports Warehouse Management System as per user request.
• Providing application support and training to users.
• Understand user requirement and Implementing solution and documenting Process System.
• Documenting processes and procedure for future use.

Technologies: SAP WM, Crystal Report.

Confidential

System Analyst

Responsibilities:

• Gathering System Requirements from stake holders.
• Involved in analysis and database design of the system.
• The Scope of the system is to store the student information and generating various reports like student fee slip, student record and transcript.

Technologies: SQL Server 2005, C#, Crystal Report.

Confidential

Programmer Analyst

Responsibilities:

• Database Maintenance, Optimization, Database Recovery, and Database User Privileges on different Database objects.
• Worked with Movex Implementation Team and took part in understanding System Architecture and providing business requirement.
• Installation and Upgradation of SQL Server, Windows Server, Monitoring backup and daily job schedules.
• Windows NT 4.0 Server: User creation, privileges, monitors, backup, disk usage and system resources.
• MIS Reports Using AS/400 and Crystal Report 8.5/10.0
• Oversaw the implementation of MOVEX ERP System as a team member.
• Displayed competency in handling implementation and installation of ERP and providing Data from MRP.
• Actively involved in imparting user Training for the Procurement and Accounts Module of MOVEX.
• Support to the Procurement Department for the Functional & Technical Problem. Support for Development of New MIS Report.

Technologies: C#, SQL Server 2005, Crystal Report 10

Confidential

System Analyst

Responsibilities:

• Designed Data model, Meta data tables, Views, and Store Procedures
• The scope of the project was to develop a system for maintaining an employee Database,
• Training, and User Personal Records as well as professional Record, Employee Past History, Educational Data and others.

Technologies: C#, SQL Server 2005, Crystal Report 10

Confidential

Responsibilities:

• The developed system provides Users to take a Leave from their Authorized person and check their Leave Status Online.
• User can apply for CL, SL, and PL for the Leave Application.

Technologies: SQL Server 2005, Front End Tool, ASP .Net and VB .Net