PROFESSIONAL SUMMARY:

• Overall 9+ years of experience as Database Engineer/Business Intelligence and Analyst, Technical Product Manager, Technical Project Manager, Technical Agile Product Owner, Business Analyst, QA & Automation, Build, Devops.
• Involved in depth of all phases of project life cycle, SDLC and STLC from requirement analysis, design, coding, testing to release deployment.
• Extensive hands - on experience in Database development in both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS).
• Hands on Experience in DTS/SQL server integration services (SSIS) Packages (XML Configuration, Parent Package & Environment Variables, Registry Entry) Developing, Deploying, Scheduling, Troubleshooting and Monitoring) of ETL processes across different servers.
• Highly skilled in data migration of data from Excel, Flat File, Sybase, Oracle to MS SQL Server using tools SQL Server Integration Services (SSIS), BULK INSERT, BCP and Replication between SQL Server (heterogeneous/homogenous).
• Proficient in monitoring SQL Server Performance and performance tuning using SQL Profiler (Dead Locks/Long running queries), Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard and Windows Performance Monitor.
• Design and architecting Web Servers as PAAS model in Microsoft Azure cloud Environment.
• Experience in creating jobs, SQL Mail Agent, Alerts, operators and schedule SSIS and DTS Packages.
• Expertise in writing good standard T-SQL queries, stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
• Hands on experience working with Python scripting for data processing and automation.
• Deploying compiled code to Azure Servers using PowerShell and automation.
• Expert in Managing software development teams in highly driven Agile frameworks especially Scrum and Kanban.
• Experience in managing QA team locally and offshore.
• Experience in release management, versioning, tagging and deployment of builds in JIRA, Github and Jenkins for development, QA, staging and production environments.
• Proven ability to work effectively in a team environment and capable of learning new technology and adapt to a new environment quickly.
• Capable of delivering the outputs and fixing support issues in short timelines.
• Experience in databases MS SQL Server, MongoDb, MySQL, MariaDb, SQLite and Oracle databases.
• Experience in IDE tools like Pycharm, Studio 3T/MongoChef, Eclipse, IntelliJ Idea, Splunk, Tableau, SSMS, SSIS, SSRS and other database related tools.
• Experience in Linux Development Environment and basic Linux commands.
• Exceptionally quick learner, able to learn, master and use new techniques and technologies in short order.
• Good team member and passionate about learning new technologies.

TECHNICAL SKILLS:

Database: MS SQL Server, MongoDb, MySQL, SQLite, Oracle

Database Tools: SSMS, SSIS, SSRS, Tableau, Toad, MySql Workbench, DBeaver

Programming: C#, Python, Java, Java Script

Programming Tools: Pycharm, Android Studio, Eclipse, IntelliJ Idea

Project Management Tools: JIRA, Pivotal, Google Docs, Testlink etc

CI & Version Control: Jenkins, Git, Source Tree, Gitlab, Github and Subversion

Automation Tools: Selenium WebDriver & Grid, Appium, Xamarin s Calabash Cucumber, Android s Espresso, AndroidJUnitRunner, TestNg

Devops tools: AWS, GCP, Azure, Docker

Operating Systems: Mac OS X, Ubuntu, Android, iOS, VMware and Windows

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Senior Database Engineer

Responsibilities:

• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008, 2012 and 2016.
• Designed Highly Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Automated SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.
• Designed packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow Tasks.
• Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different sources into Company format.
• Upgraded SQL Server version from 2012 & on-prem along with Azure VM.
• Hands-on experience working with web & database automation.
• Developed Python scripts for data processing and automation.
• Designing, deploying EC2 instances in AWS for Database and Web servers.
• Architected PAAS in AWS and Azure Cloud environments.
• Created several SSIS packages using SSIS 2008, 2012 and 2016 for processing the data from several text and Excel files, Created CSV extracts using SSIS.
• Expert in designing ETL data flows using SSIS and creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics.
• Modified Stored Procedures and complex T-SQL queries to improve query execution process.
• Monitored Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Implemented partitioning on large table to get the performance.
• Tuned stored procedures by using execution plans.
• Performance analysis and production support for very large (VLDB) in OLTP, OLAP Database.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
• Created Logins for the users and manage their permissions.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Confidential, Newark, NJ

Database Engineer

Responsibilities:

• Successfully Upgraded most of the SQL Server from SQL 2000/2005 SQL Server 2008.
• Extensively used VMware for Virtual environment.
• Installed, configured, and maintained SQL Fail over clustering to provide server high availability solution for six different environments.
• Created DTS and SSIS packages to Extract and Load data on SQL Server from diverse source (flat file, excel, xml and oracle).
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
• Data analysis with AWS analysis services and generating reports with Tableau.
• Involved in securing the SQL Server environment and setting up the user permissions.
• Interacted with VP and Director of Engineering for various new feature implementations within the confined time boundaries.
• Collecting data from server side and client side.
• Maintained code with Git, Source Tree and Github in AWS.
• Managed bugs in JIRA tickets, interacted with QA team and resolved them in time.

Confidential, Palo Alto, CA

SQL Server DBA /Developer

Responsibilities:

• Responsible for Query Optimization, Performance Tuning, System Monitoring.
• Modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Developed SSIS Packages to transfer the data between SQL server database and files.
• Wrote Stored Procedures, Triggers, user defined Functions UDF for Application Developers.
• Monitored SQL Error Logs, Schedule tasks, database activity.
• Involved in Configuring the Log shipping to create the Standby server.
• Managed offshore Testing team and updated the teams with the current issues and blockers.
• Handling Code Reviews of peer’s Code.
• Debugged and tested the application on device.

Confidential, Sunnyvale, CA

QA Manager

Responsibilities:

• QA Experience working in an Agile, fast paced development atmosphere.
• Writing Test Plan, Test Execution, Bug tracking and Maintaining whole QA process for new features.
• Automation testing of usage and monitoring web app for mobile phones user statistics with selenium.
• Managing offshore team for testing and assigning them test cases for various new features and modules.
• Managed all the Sprints for QA and accomplished them before deadlines.
• Working with all developers in team to analyze use cases of the different features and modules in the framework.
• Testing third party Android apps and interacting with Confidential ’s third party apps partners and updating and maintaining the apps releases for the final releases of Confidential products both Smartphones and Tablets.
• Taking and analyzing logs and assigning corresponding JIRA issues to the developers.
• Experience with Confidential ’s controlled profile framework on Android such as personal and encrypted work profile.
• Experience with controlled apps installation and verification of installed certificates.
• White box testing of Confidential ’s different API’s integrated into Android.
• Trained customer support team with Confidential specific apps GoToMeeting and GoToAssist to solve customer issues for end user testing.

Confidential, Redwood City, CA

Mobile QA Tester

Responsibilities:

• Writing and Executing Test cases for Android 2.3/3.0 (Ginger Bread) Testing.
• Daily interactions and meetings with developers and team leads of other teams for new builds.
• Games testing on the device with games from companies like Electronics Arts, Gameloft, Accolade etc.
• Interacted with third party games vendors to keep up with the development and integration of games into the product.
• Involved in trainings from vendor regarding their product features integrated into the main products of Sony.
• Stress and Performance Testing with Monkey Test Automation tool of Android.
• Power testing of Cell Phone Handsets and Network testing with Agilent Tools.
• Stability Automation Testing with BRAT Tool.
• Taking logs for various errors and issues and analyze them with ADB, DDMS, QXDM etc.

Confidential, Sunnyvale, CA

Mobile QA Tester

Responsibilities:

• Testing on mobile operating systems ANDROID & BREW on handsets as sanity, feature and regression testing.
• Involved in designing and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies.
• Worked with the Developers and the Test Lead to verify the Test Cases.
• Performed Development Integration, Functional testing, Performance testing and System testing on Android builds.
• Develop test strategies and test plans to test at low level and system level.
• Network Testing of CDMA messaging (mms, sms, ems) activities on 3G(1xEV) network of Verizon and 1x network of MetroPCS and most currently on EV-DO RevA.
• Using Confidential and Qualcomm tools like Test Central, Radiocomm, QXDM, QPST, QCAT, RSDLite, RaptorLite, Raptor Memory Tracker, PEK studio, ADB, DDMS etc.
• Configuring devices and taking logs with adb (Android Debug Bridge) & QXDM (Qualcomm eXtensible Diagnostic Monitor), then analyzing & reporting the logs.
• Testing the connectivity of Android and its applications through 802.11 WLAN’s.
• Testing of various Bluetooth devices with different Bluetooth profiles with the firmware.
• Automated smoke testing of android phones with embedded scripts and with RaptorLite tool.
• Tracking and reporting of Bugs and issues according to defined test plans and strategies.