SUMMARY

• A professional with experience working as Database Administrator/Manager Operations/Manager Technical/Dy. Manager.
• Experienced with Business Engineer with 10+ years in Project Management (PMO), Business Analysis, Data Management, Database Architecture, Reporting and Requirements gathering and documentation.
• Worked with the Sales, Purchasing and Accounting departments on data dump and reporting needs to improve business processes.
• Exceptional problem solving and sound decision making capabilities, recognized by associates for quality of data, alternative solutions, accurate, decision making.
• Development and management of detailed project plans to include, resources, tasks, requirements, milestones, and review points.
• Strong database management and integration experience. Worked on analyzing data warehousing needs, identifying relational databases and data modeling.
• Strong experience working across the whole software development life cycle and researching new products, business processes and required systems integration or modifications.
• Experience with various defect tracking tools: SolarWinds and JIRA.
• Good understanding of Oracle/SQL Server Database Management, Integration, Analysis, ETL,T - SQL and Reporting.
• Good understanding of Excel, MS Project, Data Analysis, writing Complex SQL queries.
• Experience with various business process improvement, Production and Project monitoring, in testing and production environment.
• Worked as a member of a multi-disciplined, cross-functional and collaborative team environment.
• Enjoyment in working in a deadline-oriented environment
• Authorized to work in the US for any employer

TECHNICAL SKILLS

Applications & Languages: Microsoft Office, HTML, Web Server(IIS),Tableau, JavaScript, Perl/Python scripts, Oracle Database, Oracle Report builder, SQL Server Database, SQL Server Data Tools, ETL, MS Access Database, MySQL, SQL Data Loader, ODBC,TCP/IP,TNS,SFTP,PL/SQL,SAP MM/PP Modules, GERS Retail ERP Module.

Operating Systems: Windows Server 7-12, UNIX, MAC 0S, Windows XP

PROFESSIONAL EXPERIENCE

Confidential, Hicksville, NY

Senior Database Administrator

Responsibilities:

• Hands-on experience in Oracle Database Administration and SQL Programming
• Responsible for writing business requirement documents, developed functional requirement specifications and system requirement specifications
• Administering databases on Linux, Sun Solaris, and Windows platforms.
• Responsible for extensive interaction with IT and Client Services to gather the data necessary to conduct the analysis
• Providing business and analytical expertise in defining business/functional specifications for system enhancements
• Experience in Installation, Configuration, and Administration of Oracle 11g/10g 9i database on Windows advanced servers.
• Helping maintain a vast array of SQL Server agent jobs and associated scripts
• Database Security, Creating Users, and Granting Roles & Privileges to users, extending the database storage capacity and optimizing the performances.
• Good experience in SQL Tuning and Query Optimization. Installation, migration and upgrade of oracle report builders/report queue manager.
• Setting up regularly scheduled, automated report generation processes, spreadsheets, and graphs
• Ftp’ing Vendors SKUs pricing data file and updating in Production environment
• 7+ years of experience with SQL queries and query performance tuning
• Monthly Sales, Inventory and Purchasing reports generation after restoring database (RMAN) from production to reporting database.
• Working with users to gather, refine, and document reporting requirements with regard to new development, enhancements, or modification of existing functionality Scheduled and managed jobs using CRONTAB, Windows, scheduler, Report Queue manager
• Managing 24x7 Production Databases and reporting system
• Over 5 years of experience as Database Administration and development with MS SQL Server technology using SQL Server 2005/2008/2012
• Extensive hands-on experience with MSSQL Server upgrades/migrations.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server BIDS (SSIS &SSRS).
• Hands on experience in designing stored procedures, triggers, functions, views using Transact-SQL (T-SQL) Programming.
• Extensive experience with Backing Up, Restoring and Moving of Databases.
• Configuring SQL Server Agent Jobs. Designing Database Security.
• Experience in creating Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
• Developing reports, and processes to continuously monitor data quality and integrity
• Experience in SQL database design, architecture, data modeling using Erwin, Data Warehousing and analysis skills, ETL tool with Microsoft Technologies like SSIS/SSRS.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Experience in Migrating Databases from SQL Server 2005 to SQL server 2008 .
• Experience in PowerShell, T-SQL writing automation scripts in SQL Server.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Configuring SSRS, Generating Reports using SSRS.
• Managing Functional testing, End to End Testing and Regression Testing, assisted business users in performing UAT
• Knowledge of client connectivity TNS/TCP/IP packages including ODBC, OLEDB.
• Gathering business requirements, analyzed, documented and created tables/SSIS packages for Applications for generating purchase orders, inventory counting and items price signs generations.
• Strong organizational skills, time management, problem-solving, prioritization, goal setting, leadership and motivation, negotiation, interpersonal relations, verbal/written communications.
• Ability to manage multiple priorities effectively. Fast learner. Highly motivated, result oriented, creative, and work well under pressure.

Confidential, New Hyde Park, NY

Manager Operations

Responsibilities:

• Production, Planning, scheduling in CD/DVD manufacturing Plant. Designing of production reporting and streamlining of various processes such as Printing, Packaging, and shipping.
• Managing teams of customer service staff, Production supervisors and engineers. Responsible for improvements of company's production by better machine and manpower utilization by using data analysis and Reporting Tools.
• Production cost reduction by 25-30% with the help of data analysis and reporting.
• Documented Business requirement, explaining Current Workflow and Business Process
• Retrieved Data using SQL and performed data analysis
• Develop and maintain operating procedures and documentation

Confidential, Hicksville, NY

Manager Technical

Responsibilities:

• Translated business concept into functional requirements.
• Worked with various departments and end users to identify, document, and communicate standard business processes as they related to the database and business processes
• Developed and Maintained SQL*Plus, and PL/SQL including analysis and design
• Writing SQL Queries, Stored procedures, Triggers and table maintenance
• Design and development of various reports and forms for order entering, Production data entering
• Created and analyzed various Reports on daily /weekly/ quarterly basis using applications Oracle reports, MS Excel, Access, File-Maker Pro and Peachtree applications.
• Worked with project team for creation of web applications and testing.
• Coordination with clients, users and management to resolve any report format, modification issues.
• Responsible for projects completion as per deadlines.
• Software installation / upgrading / modification and maintenance.
• Query and mine large data sets to discover transaction patterns, examine financial data and filter for targeted information.
• Design data entry screens, perform data quality control, develop database reports user interfaces, and normalize relational data.

Environment: Oracle 9i/8i, Designer 9i/6i, Developer 9i/6i, Windows Technical Skills: Operating Systems: Windows NT, UNIX, MS DOS. Languages: C++, SQL, PL/SQL,HTML,JAVA GUIs: Developer 2000, Visual Basic6.0, Oracle RDBMS Forms/Reports. Databases: Oracle 9i, MS-Access, RDBMS, File-Maker Pro Packages: ERP SAP R/3 MM Module, MS Office, Peachtree.

Confidential

Dy. Manager

Responsibilities:

• Joined as an Management Trainee and worked in various departments in Confidential, an integrated Plant with latest Technology. Worked for Plant lighting maintenance and reduced Power consumption by 10-15% by installing auto timers and Photoelectric sensors
• AC/DC high voltage Motors maintenance, control and operations of various high speed DC drives and Automation with PLC control drives.
• Experience with Gas Heating Furnace PLC automation for Wire Rod Mill Operations.
• Worked as shift In-Charge: Responsible for maintenance, repair and troubleshooting any issues with PLCs, AC/DC drives, Pneumatic control equipments, Proximity Sensors,Pressor sensors, SCADA system etc.
• Supervised staff of 10-12 employees and contractors. Worked closely with SAP R/3 MM and Plant Maintenance Module implementation including custom reporting using ABAP/4.