PROFESSIONAL SUMMARY:

• Over 6 years of experience in engineering products, design, development, databases, Analytics and testing in various software applications and databases.
• Extensive experience in data analysis, pattern & trend identification, visualization of data insights.
• Knowledge of all phases of Software Development Life cycles such as Waterfall, Agile methodologies.
• Good knowledge on Cloud and Virtualization environments such as AWS, Google Cloud Engine
• Hands on experience in RDBMS and NoSQL databases.
• Performeddata analysisanddata profilingusingSQLon various sources systems including SQL Server.
• Experience in codingSQL, PL/SQLusing Procedures, Triggers and Packages.
• Good understanding ofRelational Database Design,Data Warehouse/OLAP conceptsand methodologies.
• Knowledge in Business Intelligence and Analytical tools likePower BI, Tableau and MS Excel.
• Extensively performed data analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g.
• Good knowledge of Agile Methodology of Project Management.
• Experience in creating functional/technical specifications, data design documents based on teh requirements.
• Active and quick learner of new technologies, Process and team oriented, independent player.
• Ability to write clear, well - documented, well-commented and efficient code and reports.

TECHNICAL SKILLS:

Databases: MSSQL, Oracle 11g, MySQL, Hive, PostgreSQL

Analytics: Power BI, Advanced MS Excel, Tableau, Jupyter Notebook

Cloud Technologies: AWS (EC2, S3), G Cloud (Compute engine)

Programming: HTML5, CSS, JavaScript, python, PL/SQL

Framework/Library: Angular v2, ReactJS, NodeJS

Methodologies: Agile (Scrum, Kanban) and Waterfall

Version Control Tools: GitHub and BitBucket, Git, SVN and Mercurial

IDE and Tools: Eclipse, Atom, Visual studio code, putty, Postman

Monitoring Tools: Nagios, Splunk, ELK

Web/Application Servers: Apache Tomcat, XAMPP

Bug Reporting Tools: QC and JIRA

Operating Systems: Windows, LINUX (CentOS, Ubuntu), Mac OS X

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Data Engineer/Database Analyst

Responsibilities:

• Responsible and involved in Data Extraction, cleansing, analysis, developing a model.
• Converting data into meaningful insights for determining cost and revenue leakages for each customer.
• Solved complexity of identifying devices, by streamlining teh device names and models master database.
• Utilized MySQL, Python (pandas and numpy), Excel, visual studio code and Power BI for Visualization.
• Reduced 90% manual effort by creating store procedures in teh disconnected customers revenue data.
• Responsible for Data extraction, transformation and loading as well as working on CSV/XML/JSON formats.
• Learning about enterprise database models, ETL process, CRM, ERP portals.
• Analyze and generate accurate financial and analytical reports.
• Developing store procedures, views, complex queries for finding missing devices.
• Proposing solutions to improve teh model and accuracy of teh results.
• Developed a single page web to display (Angular JS, PHP, Mysql) to display teh disconnected customer list.

Environment: MySQL, WorkBench, Oracle, Toad SQL Assistant, Advanced MS Excel, Power BI, Node JS, Visual Studio Code, Jupyter Notebook.

Confidential, Kennesaw, GA

Software Engineer

Responsibilities:

• Developed a walkie-talkie integration prototype to our application using Python 3.3 and RESTful API’s.
• Streamlined teh onshore-offshore development process and worked closely wif teh scrum master to estimate effort of new features of Angular JS and mobile platforms.
• Solved false alerts and identified root causes and occurrences.
• Managed and owned, autantication services to production, staging environments in AWS EC2, PostgreSQL.
• Prepared user requirements and analysis, design and programming support.
• Explored ibeacons and Eddystone technologies for providing cost-effective solutions.
• Utilized various protocols and technologies such as MQTT, BLE (bluez & android), HTTP, Zigbee (z-stack) and Mesh.
• Designed and engineered on-premise to off-premise CI/CD docker pipelines (integration and deployment) wif ECS, Glue, Lambda and ELK, Spark data bricks, firehouse and kinesis stream.
• Involved in migration of legacy system in AWS cloud - EC2 instance wif auto-scaling options.
• Explored teh server traffic using redis cache management system to reduce load.
• Verified latest code availability in Bitbucket repositories on daily basis.
• Operated mobile application trail runs in AWS DeviceFarm.
• UAT on web and mobile applications for IOT products.
• Customer support wif ZERO downtime.
• Managed weekly status call wif offshore team and driving to complete teh weekly accomplishments.
• Acquired knowledge on IOT devices, BLE technologies, iBeacons, MQTT, Load Balancers.
• Familiarity in Cisco Meraki systems and experimenting teh integration wif AlertPoint system.

Environment: Google cloud, AWS, PgAdmin 4, Visual Studio code, Atom, JIRA, Data bricks, Python, Angular JS, HTML5, MQTT, Postman, node.js, FileZila.

Confidential, Richmond, VA

System Analyst Intern

Responsibilities:

• Improved teh process of data validation by automated scripts using VB Macro.
• Validated data migration in legacy systems along wif new database architecture.
• Performed Enterprise level conversion, Integration and system testing and validated end to end platform.
• Captured and logged issues on production environment in QC.
• Worked on complete end to end application development along wif validation.
• Analyzed teh issue root causes using 5 Whys and fishbone diagrams.

Environment: MS Excel, Quality center, Mainframe.

Confidential

Programmer Analyst

Responsibilities:

• Well acquainted wif software development life cycle methodologies.
• Debugged and updated existing codes for developing efficient and robust codes.
• Written store procedures, triggers using Oracle SQL for data transformations.
• Built test cases and performed unit tests on teh modules developed.
• Managed back-end support and databases on weekly basis.
• Involved in teh support and enhancements of dis production after Go-Live.
• Prepared project reports and delivery presentation to clients.
• Solved defects in timely manner using QC and ALM.

Environment: Eclipse, Oracle 10g and 11g, Toad 11, QC 10.0 and ALM 11.0, Bugzilla.