- Designed a pilot model to predict any new update in hyperlocal market for customers.- Build data server for the organization to house customers’ data, to be utilized by multiple front-end applications.- Build algorithm and predictive analysis for visualizing and analyzing live customer data feed based off geographic locations.- Runs SQL queries to work with ad-hoc data extraction for business and customers.- Data mining and validation after every refresh from the data vendors- Creating data visualization using Tableau and Python.- Back up organization’s data into Data Warehouse and Data Marts on AWS/ cloud network.- Enhancing Relational Database structure by indexing and partitioning to increase query efficiency.- Investigate and conduct studies on forecasts, demand, and capital of data facilitating clustering analysis for multiple customers.- Building machine learning algorithms to drive the shift in market demands, making our product sustainable in fast paced data industry.- Working closely with engineering and analytical team to implement as well improve the real time predictive reporting for customers- Work on researching, analyzing, and building KPI metrices as per the technical requirements gathered via client’s use case as well as industrial enhancements- Created Alpha-Beta (A/B) testing to understand clients’ requirements and update data validation accordingly- Generated statistical visualization reports for internal teams to understand our nationwide data coverage resulting in customer retention programs and marketing campaigns.

- Help in establishing and creating data connectivity for customers, by directly interacting with clients.- Build, test, document and maintain customized APIs for the customers’ usage. - Runs SQL queries to work with ad-hoc data extraction for business and customers.- Perform monthly and daily checks on data refresh from vendors using SQL server.- Creating a dashboard for senior organization management to visualize real time and historical data charts and reports to determine data accuracy and organizational penetration.- Create data metrics and reports for client consumption, trend set up and result projection.

- Manually executed test cases for a financial application.- Worked in agile environment as part of scrum team, participated in scrum ceremonies and provided inputs during refinement sessions. - Learned and got hands-on in BDD test approach using Spec flow.- Automated test cases using Selenium with C#.- Developed and ran data queries using SQL to extract testing data.- Ran jobs in Jenkins to evaluate automated test cases in regression phase.- Used BitBucket, SourceTree, and GIT to upload code in team repo.

- Developed an understanding of marketing environment including data, tag flow and internal business rules that transform data.- Analyzed customer preferences and trends and provided business insights for email and merchandise departments using Tableau.- Provided multi-channel E-commerce business intelligence reports using advanced SQL queries.- Developed numerous ad-hoc queries and reports to collect and present information per requester feedback.

- Did data modeling for the application using Dimensional Data Modeling, Star Schema and Snowflake Modeling.- Acted as Scrum Master for Agile team.- Maintained Project workflow using Jira as project management tool.- Modified Rest API for connectivity establishment.- Generated and exported Report per client needs.- Worked on Django, ASP.Net, .SSMS and SQLite3.- Worked as Database administrator by running SQL queries, monitoring and maintaining DB performance.- Developed and managed dashboards for IT therapists to track various client projects. - Segmented clients as per requirements using Data Mining concepts like clustering analysis and decision tree using R.

- Strategized test automation effort with Automation architect.- Developed a framework for enabling test automation of various IVR applications using Cyara, which helped reduce 50% of manual effort.- Researched on market leader Empirix’s Hammer Call Master tool for IVR Automation, led to client implementation. - Created Macros using VB Scripting to fetch application logs. Expanded their usage to create stakeholder reports to evaluate the application performance.- Reports visualization in form of charts, graph for management.- Worked on MS SQL (proficient in writing queries to pull data/reports), Cognos, IBM Netezza for implementing database solution.

- Manually executed IVR applications as per the requirement docs provided by Business Analyst.- Raised defects on Defect management tool used by team.- Learned about the automation tool used by team for IVR testing.- Helped in migrating 30+ applications from one platform to another.